Microsoft Office Tutorials and References
In Depth Information
Entering Functions Using the Insert Function Dialog Box
8. Enter a single number into cell A1.
9. Click an empty cell where you want the result.
10. Click the Insert Function button on the Formulas Ribbon.
The Insert Function dialog box opens.
11. Select the SUM function.
SUM is in the All or Math & Trig categories, and possibly in the Recently
12. Click OK.
The Function Arguments dialog box opens. To the right of each Number
box is a small fancy button — a special Excel control sometimes called
the RefEdit. It allows you to leave the dialog box, select a cell or range
on the worksheet, and then go back into the dialog box. Whatever cell or
range you click or drag over on the worksheet is brought into the entry
box as a reference.
You can type cell and range references, named areas, and table names
directly into the Number boxes as well. The RefEdit controls are there to
use if you want to work with the mouse instead.
13. Click directly on the first RefEdit.
The dialog box shrinks so that the only thing visible is the field where
you enter data. Click on cell A1, where you had entered a number.
14. Press the Enter key.
The Function Arguments dialog box reappears.
If you don’t remember the name you used, use the RefEdit control to
select the area on the worksheet.
17. If you don’t remember the name you used, use the RefEdit control to
select the table.
values are to be found.
It does not matter if this range is part of a named area or table. Use the
RefEdit if you wish to just drag the mouse over a range of numbers. Your
screen should look similar to that in Figure 2-11.