Using the Auto Calculate Feature

Few Excel users notice that when they select a range of cells that contain values, the status bar displays the sum of those values, as shown in Figure 6.6. This feature provides you with a quick total of any values in the worksheet without your having to use a calculator.

Figure 6.6. Excel displays the sum of selected values.

graphics/06fig06.jpg

Even fewer Excel users realize that they can change the mathematical operation Excel performs on those values. Right-click the sum to display a context menu of available operations, as shown in Figure 6.7, and then click the desired operation.

Figure 6.7. You can change the operation Excel performs on the values.

graphics/06fig07.jpg



Absolute Beginner's Guide to Microsoft Office Excel 2003
Absolute Beginners Guide to Microsoft Office Excel 2003
ISBN: 0789729415
EAN: 2147483647
Year: 2002
Pages: 189

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net