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
specifi 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 fi elds of fi 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.
Search JabSto ::




Custom Search