Excel 2007's Quick Data Analysis from the Status Bar

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 OptionWhat It DoesStatistical Measures OptionWhat It Does
[None]Tells Excel that you don't want it to calculate and then show a
statistic on the status bar.
MaximumFinds the largest value in the selected range
AverageFinds the mean of values in selected range.MinimumFinds the smallest value in the selected range
CountTallies the cells that hold labels, values, or formulas. Use
this when you want to count the number of cells that aren’t
empty.
SumAdds the values in the selected range
Numerical CountTallies 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