MS Excel : Calculate with THE FUNCTION WIZARD

MS Excel : Calculate with THE FUNCTION WIZARD

Excel Function Wizard simplifies the use of
functions You can take advantage of the wizard to
each of the Excel functions, from the sum (SUM)
function at the most complex statistical, mathematical,
Financial and engineering function. One simple but
useful function, ROUND, round the values   to
number of places you choose.

You can get to the Capacity Wizard in two different ways. One
form implies selecting a cell where the result is
appear and then click on the Insert Function button
and using the Insert Function dialog box to select a
function. Another way, which is a little faster, makes
Feel when you know the name of your function.
Start by selecting a cell for the result. Write an equal
sign (=) and the beginning of the function name. In
the list of functions that appears, double click on
function you want and then click Insert function
button.

Both methods show the Function Arguments box,
where you write the values   you want in your calculation
or click on the cells that contain the values.

1 Enter your information in the
Note: This example shows the
ROUND function, which takes two
arguments, one that indicates the
number to round and the
another indicating the number of
digits to which to round.
2 Click on the cell in which
He wants the result to appear.

3 Click the Insert Function button.
l The Insert Function dialog box
appears.
The functions.
5 Double-click the function that
want to use.

l The arguments of the function
the dialog box appears.
6 Click the cell (s) or
write the values
requested in each field.
l For this example, click on
the cell that contains the
entered value
Step 1.
l Enter the number of
decimal places to which
do you want to round ONE
negative number refers
to decimals to the
to the left of the decimal point.
7 Click OK.

The result appears in the cell.

Did you know
If you don't know what function you want
use, type a question in Find a function
field in the Insert Function dialog box. For help with
the capacity itself, click Help on this capacity in the
Function Arguments dialog box.

Caution!
Do not confuse the ROUND function with the number
ROUND formatting works by evaluating a number in a
argument and rounding it to the number of digits that
specify in the second field of the function arguments
dialog box. When formatting numbers, simplify the
appearance of the number on the worksheet, making
The easiest number to read. The underlying number is
without changes.