Excel 2007's Quick Data Analysis from the Status Bar

Part of the Excel 2007 Data Analysis For Dummies Cheat Sheet

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.
blog comments powered by Disqus

SERIES
Excel 2007 Data Analysis For Dummies Cheat Sheet

Advertisement

Inside Dummies.com