Displaying Calculations with AutoCalculate

You can simplify your work using a feature called AutoCalculate when you don't want to insert a formula, but you want to see the results of a simple calculation quickly. Auto-Calculate automatically displays the sum, average, maximum, minimum, or count of the selected values on the status bar. Auto-Calculate results do not appear on the worksheet when printed but are useful for giving you quick answers while you work.

Calculate a Range Automatically

graphics/one_icon.jpg Select the range of cells you want to calculate.

The sum of the selected cells appears on the status bar next to SUM=.

graphics/tow_icon.jpg

If you want to change the type of calculation AutoCalculate performs , right-click anywhere on the status bar to open the AutoCalculate sub menu.

graphics/three_icon.jpg

Click the type of calculation you want.

graphics/03inf18.jpg



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

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