Microsoft Office Tutorials and References
In Depth Information
Finding the Correct Function
Figure 2-2:
The
AutoSum
button
offers quick
access to
basic
functions and
the Insert
Function
dialog box.
Finding the Correct Function
The first step to using a function is finding the one you need! Even when you
do know the one you need, you may not remember all the arguments it takes.
You can find a function in the Insert Function dialog box in two ways:
Search: Type one or more keywords or a phrase into the Search for a
function box. Then click the Go button.
•Ifamatchismade,theOrselectacategorydrop-downlistdisplays
Recommended, and the Select a function box displays a list of the
functions that match your search.
•Ifnomatchismade,theOrselectacategorydrop-downlistdisplays
Most Recently Used functions, and the most recently used functions
appear in the Select a function dialog box. The Search for a function
displays a message to rephrase the text entered for the search.
Browse: Click the Or select a category down arrow and from the
dropdown list, select All, or select an actual function category. When an
actual category is selected, the Select a function box updates to just the
relevant functions. You can look through the list to find the function you
want. Alternatively, if you know the category, you can select it on the
Formulas Ribbon.
Table 2-1 lists the categories in the Or select a category drop-down list.
Finding the function you need is different from knowing which function you
need. Excel is great at giving you the functions, but you do need to know
what to ask for.
Search JabSto ::




Custom Search