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
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