Microsoft Office Tutorials and References

In Depth Information

Calculate with

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

button.

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.

1

Type your data into the

worksheet.

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.

2

1

2

Click in the cell in which you

want the result to appear.

3

Click the Insert Function button.

The Insert Function dialog box

appears.

l

3

4

Click here and select All to list all

the functions.

5

Double-click the function you

want to use.

4

5

32