Microsoft Office Tutorials and References
In Depth Information
Using Other Functions
Using Other Functions
Excel comes with many functions ,
not just SUM. You have already learned about a
few of them, such as ROUND and AVERAGE.
Because there are so many, Excel groups all of its
functions into specific categories, on the theory
that this will make it easier for you to find them
when needed. For the most part, these categories
go a pretty long way in helping you quickly find
the function you are looking for. The trick is
to get to know what the categories mean, and
the best way to do that is to introduce you to the
prominent players in each category.
Buttons for each of the function categories are
located on the Formulas tab, as shown in Figure
3-13. Click one of these buttons to display a list
of functions in that category, and then select the
function you want from the list. For example,
click the Math & Trig button on the Formulas
tab and select the SQRT (square root) function.
The function is inserted into the result cell,
and the Function wizard appears to guide you
through the process of entering the appropriate
arguments for that function. After doing that,
click OK in the wizard to complete your formula.
Figure 3-13
Use the buttons on the Formulas tab
to enter any function you want.
As I introduce you to the most popular functions
in each category, I describe the arguments you
need to use. Now, you might have noticed by now
that Excel names its arguments—for example, for
the SUM function, it uses names like Number1,
Number2, and so on. In this section, I might use
a different name that I find more descriptive,
such as Range1, Range2, so don’t let the names
confuse you.
The functions you’ve used recently are
listed on the Recently Used menu. Click
the Recently Used button on the Formulas
tab, and select a function you’ve used
recently from those listed on the menu
that appears.
Use the ScreenTips
As you hover the cursor over a function
category list, a ScreenTip appears, describing the
purpose of that function. (See Figure 3-13.)
Search JabSto ::

Custom Search