Microsoft Office Tutorials and References

In Depth Information

**Ways to Enter a Function into a Formula**

Excel 2007 introduced a handy feature known as Formula AutoComplete. When you type an

equal sign and the first letter of a function in a cell, Excel displays a drop-down list box of all the

functions that begin with that letter and a ScreenTip with a brief description for the function (see

Figure 4-1). You can continue typing the function to limit the list or use the arrow keys to select

the function from the list. After you select the desired function, press Tab to insert the function

and its opening parenthesis into the cell.

Figure 4-1:
When you begin to type a function, Excel lists available functions that begin with the typed

letters.

In addition to displaying function names, the Formula AutoComplete feature also lists

names and table references (see Chapter 9 for information about tables).

After you press Tab to insert the function and its opening parenthesis, Excel displays another

ScreenTip that shows the arguments for the function (see Figure 4-2). The bold argument is the

argument that you are currently entering. Arguments shown in brackets are optional. Notice that

the text in the ScreenTip contains a hyperlink for each argument that you’ve entered. Click a

hyperlink to select the corresponding argument. If that ScreenTip gets in your way, you can drag

it to a different location.

Figure 4-2:
Excel displays a list of the function’s arguments.

If you omit the closing parenthesis for a function, Excel adds it for you automatically. For

example, if you type
=SUM(A1:C12
and press Enter, Excel corrects the formula by adding the right

parenthesis.