Microsoft Excel Tips
and Tricks
Get Easy Access to New AutoSum Functions
In older versions of Excel, the AutoSum feature was handy,
but limited. In Excel 2002, the AutoSum button is linked to
a longer list of formulas that you can add to your
worksheet. With this more powerful AutoSum, you can quickly
calculate the average of selected cells, find the maximum or
minimum value in a range of values, and much more.
1.
Click the cell below the column of numbers, or to the right
of the row of numbers, you want to calculate.
2.
Click the arrow next to AutoSum on the Standard
toolbar, click the formula you want to use, and then press
ENTER.
|