Microsoft Office Tutorials and References
In Depth Information
Formula copied and pasted
shortcut button provides options
for pasting formulas and va flues
formulas pas ted
into selected range
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.
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:
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:
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.