Microsoft Office Tutorials and References
In Depth Information
Working with Functions
Quickly entering a formula and function
Excel offers the AutoSum button and Quick
Analysis button for quickly entering formulas
that include a function.
Click the cell where you want the results of
your formula to appear and try these
techniques for constructing formulas with the
✓ On the Home or Formulas tab, click the
AutoSum button to total nearby cells.
✓ On the Home or Formulas tab, open the
drop-down list on the AutoSum button and
choose Sum, Average, Count Numbers,
Max, or Min. Respectively, these functions
total, average, obtain the number of, obtain
the highest value in, or obtain the lowest
value in nearby cells.
Excel takes an educated guess as to which
cells need totaling, averaging, or whatever,
and quickly enters a formula for you.
Use the Quick Analysis button to construct a
formula with the SUM , AVERAGE , or COUNT
function, or one of their variations:
1. Select the cells that will be used as
arguments by the function.
The Quick Analysis button appears.
2. Click the Quick Analysis button.
3. Choose Totals in the pop-up window.
4. Move the pointer over the various
functions and glance at your worksheet to see
the results of your formulas.
5. Select a function.
You can enter function names in lowercase. Excel converts function names
to uppercase after you click the Enter button or press Enter to complete the
formula. Entering function names in lowercase is recommended because
doing so gives you a chance to find out whether you entered a function name
correctly. If Excel doesn’t convert your function name to uppercase, you
made a typing error when you entered the function name.
Getting Excel’s help to enter a function
Besides entering a function by typing it, you can do it by way of the Function
Arguments dialog box, as shown in Figure 3-13. The beauty of using this