Microsoft Office Tutorials and References

In Depth Information

**Apply a Function**

11

CHAPTER

EXCEL

Working with Formulas and Functions

The Function Arguments dialog box

appears.

8
Select the cells for each argument

required by the function.

In the worksheet, Excel adds the

cells as the argument to the

function.

D
Additional information about the

function appears here.

9
When you finish constructing the

arguments, click
OK.

E
Excel displays the function results

in the cell.

F
The function appears in the

Formula bar.

TIPS

Can I edit a function?

Yes. Click the cell containing the function, click the

Formulas
tab, and then click the
Insert Function

button. Excel displays the functionâ€™s Function

Arguments dialog box, where you can change the

cell references or values as needed. You can also

edit directly in the cell.

How can I find help with a particular function?

Click the
Help on this function
link in either the

Insert Function or Function Arguments dialog box

to find out more about the function. The function

help includes an example of the function being

used and tips about using the function.

203