Microsoft Office Tutorials and References
In Depth Information
Using On-Grid Tooltips
The following sections discuss these levels of help. However, you are sure
to find the Function Arguments dialog to be one of the best ways of getting
help.
Using On-Grid Tooltips
Using On-Grid Tooltips
In any cell, you can type an equal sign, a function name, and the opening
parenthesis. Excel displays a tooltip that shows the expected arguments. In
many cases, this tooltip is enough to guide you through the function. For ex-
ample, I can usually remember that the function for figuring out a car loan
payment is =PMT(), but I can never remember the order of the arguments. The
tooltip, as shown in Figure 10.5 , is enough to remind me that rate comes first,
followed by number of periods, and then the principal amount or present
value. Any function arguments displayed in square brackets are optional,
so in the example shown in Figure 10.5 , you know that you may not have to
enter anything for fv or type.
Figure 10.5.
Figure 10.5. The tooltip assists you in remembering the proper order for the
The tooltip assists you in remembering the proper order for the
arguments.
arguments.
As you type each comma in the function, the next argument in the tooltip lights
up in boldface. This way, you always know which argument you are entering.
Using the Function Arguments Dialog
Using the Function Arguments Dialog
When you access a function through the Function Wizard or a drop-down list,
Excel displays the Function Arguments dialog. This dialog is one of the best
features in Excel. If you ve started to type the function and have typed the
opening parenthesis, then pressing Ctrl+A or clicking the fx icon to the left
of the toolbar displays the Function Arguments dialog.
Search JabSto ::




Custom Search