Microsoft Office Tutorials and References

In Depth Information

**Chapter 3 Using Excel Functions**

3

Using Excel

Functions

Formulas are tough enough
to enter correctly into an

Excel worksheet, which is why Excel provides built-in formulas called

functions
that you can use to quickly enter common formulas. Functions

are ready-made formulas that perform a series of operations on a specified

range of cells. For example, suppose you want to calculate the sum of the

values in the range C5:C9, as shown in Figure 3-1.

Function

Function

Results

Figure 3-1

A quick way to total a range of cells

is to use the SUM function.