Microsoft Office Tutorials and References
In Depth Information
Using the Insert Function Button
Top: The Insert Function dialog box lets you quickly
find the function you need. You can choose a
category that seems likely to have the functions you’re
Bottom: You can also try to search by entering
keywords in the “Search for a function” box. Either
way, when you click one of the functions in the list,
Excel presents you with a description of the function
at the bottom of the window.
• If you’re looking for a function, the easiest way to find one is to choose a
category from the “Or select a category” drop-down list. For example, when you
select the Math & Trig category, you see a list of functions with names like SIN()
and COS(), which perform basic trigonometric calculations.
• If you choose the Most Recently Used category, you’ll see a list of functions
you’ve recently picked from the ribbon or the Insert Function dialog box.
• If you’re really ambitious, you can type a couple of keywords into the “Search for
a function” text box. Next, click Go to perform the search. Excel gives you a list
of functions that match your keywords.