Excel 2007 can tell you quite a bit about a selected range of cells just from the status bar. When you select cells that have data in them, Excel's status bar can tell you some useful information about those cells. When you right-click the status bar, Excel displays a pop-up menu that includes several statistical measures that you can make on the selected range; they’re shown in the following table:
Statistical Measures Option | What It Does | Statistical Measures Option | What It Does |
---|---|---|---|
[None] | Tells Excel that you don't want it to calculate and then show a statistic on the status bar. | Maximum | Finds the largest value in the selected range |
Average | Finds the mean of values in selected range. | Minimum | Finds the smallest value in the selected range |
Count | Tallies the cells that hold labels, values, or formulas. Use this when you want to count the number of cells that aren’t empty. | Sum | Adds the values in the selected range |
Numerical Count | Tallies the number of cells in a selected range that hold values or formulas. |
dummies
Source:http://www.dummies.com/how-to/content/excel-2007s-quick-data-analysis-from-the-status-ba.html
No comments:
Post a Comment