Microsoft Office Tutorials and References

In Depth Information

**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.

Tip

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.)