Microsoft Office Tutorials and References
In Depth Information
THE FUNCTION WIZARD
Excel’s Function Wizard simplifies the use of
functions. You can take advantage of the wizard for
every one of Excel’s functions, from the sum ( SUM )
function to the most complex statistical, mathematical,
financial, and engineering function. One simple but
useful function, ROUND , rounds off values to the
number of places you choose.
You can access the Function Wizard in two ways. One
way involves selecting a cell where the result is to
appear and then clicking the Insert Function button
and using the Insert Function dialog box to select a
function. Another way, which is a bit quicker, makes
sense when you know the name of your function.
Start by selecting a cell for the result. Type an equal
sign (=) and the beginning of the function name. In
the list of functions that appears, double-click the
function you want and then click the Insert Function
Both methods bring up the Function Arguments box,
where you type the values you want in your calculation
or click in the cells containing the values.
Type your data into the
Note: This example shows the
ROUND function, which takes two
arguments, one indicating the
number to be rounded and the
other indicating the number of
digits to which it is to be rounded.
Click in the cell in which you
want the result to appear.
Click the Insert Function button.
The Insert Function dialog box
Click here and select All to list all
Double-click the function you
want to use.