Microsoft Office Tutorials and References
In Depth Information
The Paste Options button provides powerful functionality. When performing copy and paste operations, the button allows you
great freedom in specifying what it is you want to paste. You can choose from the following options:
• Paste an exact copy of what you copied, including the cell contents and formatting.
• Copy only formulas.
• Copy only formatting.
• Copy only values.
• Copy a combination of these options.
• Copy a picture of what you copied.
To Determine Totals Using the Sum Button
The next step is to determine the totals in row 13 for the hours worked in
column C, gross pay in column E, federal tax in column F, state tax in column G, and
net pay in column I. To determine the total hours worked in column C, the values in
the range C4 through C12 must be summed. To do so, enter the function =sum(c4:c12)
in cell C13 or select cell C13, tap or click the Sum button (HOME tab | Editing
group), and then press the key. Recall that a function is a prewritten formula that
is built into Excel. Similar SUM functions can be used in cells E13, F13, G13, and I13
to total gross pay, federal tax, state tax, and net pay, respectively. The following steps
determine totals in cell C13, the range E13:G13, and cell I13.
Select the cell to contain the sum, cell C13 in this case. Tap or click the Sum button
(HOME tab | Editing group) to sum the contents of the range C4:C12 in cell C13 and
then tap or click the Enter box to display a total in the selected cell.
Select the range to contain the sums, range E13:G13 in this case. Tap or click the Sum
button (HOME tab | Editing group) to display totals in the selected range.
Select the cell to contain the sum, cell I13 in this case. Tap or click the Sum button
(HOME tab | Editing group) to sum the contents of the range I4:I12 in cell I13 and then
tap or click the Enter box to display a total in the selected cell (Figure 2 – 13).
Why did I have to tap or click the Enter box?
When creating a sum for a single column, you tap or click the Enter box. If you are
calculating the sum for multiple ranges, you tap or click the Sum button.
Figure 2 – 13
Figure 2 – 13