Microsoft Office Tutorials and References

In Depth Information

**Apply a Function**

EXCEL

chapter
11

Working with Formulas and Functions

The Function Arguments dialog

box appears.

7
Select the cells for each argument

required by the function.

7

If you select a cell or range of cells

directly in the worksheet, Excel

automatically adds the references

to the argument.

8

You can also type a range or cell

address (or range or cell name)

into the various text boxes.

The dialog box displays additional

information about the function

here.

8
When you finish constructing the

arguments, click
OK.

●

●

Excel displays the function results

in the cell.

●

The function appears in the

Formula bar.

Can I edit a function?

Yes. To edit a function,

click the cell containing

the function that you

want to edit; then click

the
Insert Function

button in the Formulas

tab. Excel displays the

function’s Function

Arguments dialog box, where you can make

changes to the cell references or values as

needed.

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

access Excel’s help files to

find out more about the

function. The function help includes an example of

the function being used and tips about how to use

the function.

=SUM(C5:C10)

197