Microsoft Office Tutorials and References
In Depth Information
How to Make Your Formulas Function Even Better
Insert Function dialog box (shown in Figure 2-14) where you can select the
function you want to use. After you select your function, Excel opens
the Function Arguments dialog box. In this dialog box, you can specify the
function arguments. The real boon comes when you’re starting to use an
unfamiliar function or one that’s kind of complex (some of these puppies can
be hairy). You can get loads of help in completing the argument text boxes in
the Function Arguments dialog box by clicking the Help on This Function link
in the lower-left corner.
Figure 2-14:
Select the
function you
want to use
in the Insert
Function
dialog box.
The Insert Function dialog box contains three boxes: a Search for a Function
text box, an Or Select a Category drop-down list box, and a Select a Function
list box. When you open the Insert Function dialog box, Excel automatically
selects Most Recently Used as the category in the Select a Category
dropdown list box and displays the functions you usually use in the Select a
Function list box.
If your function isn’t among the most recently used, you must then select the
appropriate category of your function in the Select a Category drop-down
list box. If you don’t know the category, you must search for the function by
typing a description of its purpose in the Search for a Function text box and
then press Enter or click the Go button. For example, to locate all the Excel
functions that total values, you enter total in the Search for a Function list
box and click the Go button. Excel then displays its list of recommended
functions for calculating totals in the Select a Function list box. You can
peruse the recommended functions by selecting each one. While you select
each function in this list, the Insert Function dialog box shows you the
required arguments followed by a description, at the bottom of the dialog
box, of what the function does.
Search JabSto ::




Custom Search