
Statistical Functions and Named Ranges
Microsoft Excel has an extensive set of statistical functions. These functions work well if you select and Name a Range of data.
Using Named Ranges
- Select a Range: By definition, a RANGE is a one or more cells on a spreadsheet. The cells may be adjacent or not.
- Define a Range: The Name Box is a special tool in the top left corner by the Formula bar. You can use the Name Box to Define a Range