Microsoft Office Tutorials and References

In Depth Information

**Introducing Functions**

Figure 1-22

Formula copied and pasted

shortcut button provides options

for pasting formulas and va
flues

formulas pas
ted

into selected
range

cell containing

copied formula

◗

5.
Click cell
and verify that the formula =F8*G8 appears in the formula bar.
H8

◗

6.
Click cell
and verify that the formula =F9*G9 appears in the formula bar.
H9

When you pasted the formulas into cells H8 and H9, Excel automatically adjusted the

formulas so that the total charges calculated for the customers in rows 8 and 9 use the

cell values from rows 8 and 9. By copying and pasting the formula, you have saved time

and avoided potential mistakes in retyping the same formula again and again.

Introducing Functions

In addition to cell references and operators, formulas can also contain functions. A

function
is a named operation that returns a value. Functions are used to simplify

formulas, reducing what might be a long formula into a compact statement. For example, to

add the values in the range A1:A10, you could enter the following long formula:

=A1+A2+A3+A4+A5+A6+A7+A8+A9+A10

Or, you could use the SUM function to calculate the sum of cell values found within a

speciﬁ ed range. In this case, the formula would appear as:

=SUM(A1:A10)

In both instances, Excel adds the values in cells A1 through A10, but the SUM

function is faster and simpler to enter and less prone to a typing error. You should always use

a function, if one is available, in place of a long, complex formula.

Excel supports more than 300 different functions from the ﬁ elds of ﬁ nance, business,

science, and engineering. Excel provides functions that work with numbers, text, and dates.

Entering a Function

Amanda wants to calculate the total number of DVDs she needs to create for her

customers. To do that, you’ll use the SUM function to add the values in the range F6:F9.