Data Analysis with Microsoft Excel: Updated for Office 2007

48 Excel

Although you can type in functions directly, you may fi nd it easier to use

the commands located in the Function Library group on the Formulas tab.

These commands provide information on the parameters required for cal-

culating the function value as well as giving one-click access to online help

regarding each function.

To calculate total sales fi gures for all ten service stations:

1 Type Total in cell A13 and press Ta b.

2 Click the Math & Trig button located in the Function Library group

on the Formulas tab.

Excel displays a scroll box listing all of the Excel functions related

to mathematics and trigonometry.

3 Scroll down the scroll box and click SUM from the list as shown in

Figure 2-9.

Next, Excel displays a dialog box with the arguments for the SUM

function. Excel has already inserted the cell reference B2:B12 for

you in the fi rst argument, but if this is not the reference you want,

you can select a different one yourself. Try this now.

Figure 2-9

Accessing

Math & Trig

functions

list of Math & Trig

functions