Microsoft Office Tutorials and References
In Depth Information
Excel displays Option buttons in a workbook while you are working on it to indicate
that you can complete an operation using automatic features such as AutoCorrect,
Auto Fill, error checking, and others. For example, the Auto Fill Options button shown
in Figure 2 – 13 appears after a i ll operation, such as dragging the i ll handle. When an
error occurs in a formula in a cell, Excel displays the Trace Error button next to the
cell and identii es the cell with the error by placing a green triangle in the upper left
of the cell.
Table 2 – 4 summarizes the Option buttons available in Excel. When one of these
buttons appears on your worksheet, click the button arrow to produce the list of options
for modifying the operation or to obtain additional information.
The Paste Options
The Paste Options button
performing copy and paste
operations, the button
allows you great freedom
in specifying what it is
you want to paste. For
example, you could choose
to paste an exact copy of
what you copied, including
the cell contents and
formatting. You also could
copy just formulas, just
formatting, just the cell
values, a combination of
these options, or a picture
of what you copied.
Table 2 – 4 Options Buttons in Excel
Auto Fill Options
Gives options for how to i ll cells following a i ll operation,
such as dragging the i ll handle.
Undoes an automatic correction, stops future automatic
corrections of this type, or causes Excel to display the
AutoCorrect Options dialog box.
Lists formatting options following an insertion of cells, rows,
Specii es how moved or pasted items should appear (for
example, with original formatting, without formatting, or
with different formatting).
Lists error-checking options following the assignment of an
invalid formula to a cell.
To Determine Totals Using the Sum Button
Selecting a Range
You can select a range
using the keyboard. Press
the F8 key and then use
the arrow keys to select
the desired range. After
you are i nished, make sure
to press the F8 key to turn
off the selection process
or you will continue to
The next step is to determine the totals in row 13 for the hours worked in column D,
gross pay in column F, federal tax in column G, state tax in column H, and net pay in column
I. To determine the total hours worked in column D, the values in the range D4 through
D12 must be summed. To do so, enter the function =sum(d4:d12) in cell D13 or select cell
D13, click the Sum button (Home tab | Editing group), and then press the enter key. Recall
that a function is a prewritten formula that is built into Excel. Similar SUM functions can
be used in cells F13, G13, H13, and I13 to total gross pay, federal tax, state tax, and net pay,
respectively. The following steps determine totals in cell D13 and the range F13:I13.
Select cell to contain the sum, cell D13 in this case. Click the Sum button (Home tab |
Editing group) to sum the contents of the range D4:D12 in cell D13 and then click the
Enter box to display a total in the selected cell.
Select the range to contain the sums, range F13:I13 in this case. Click the Sum button
(Home tab | Editing group) to display totals in the selected range (Figure 2 – 14).