Microsoft Office Tutorials and References
In Depth Information
Smart Tags and Option Buttons
Table 2–4 Smart Tag and Options Buttons in Excel
Auto Fill Options
Gives options for how to ﬁ ll cells following a ﬁ ll operation, such as dragging
the ﬁ 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, or columns.
Speciﬁ es how moved or pasted items should appear (for example, with
original formatting, without formatting, or with different formatting).
Lists information options for a cell containing data recognized by Excel, such
as a stock symbol.
Lists error checking options following the assignment of an invalid formula
to a cell.
To Determine Totals Using the Sum Button
The next step is to determine the totals in row 13 for the initial cost in column F,
current value in column H, and gain/loss in column I. To determine the total initial cost
in column F, the values in the range F4 through F12 must be summed. To do so, enter the
function =sum(f4:f12) in cell F13 or select cell F13 and then click the Sum button on the
Ribbon and then press the ENTER key. Recall that a function is a prewritten formula that
is built into Excel. Similar SUM functions or the Sum button can be used in cells H13 and
I13 to determine total current value and total gain/loss, respectively.
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 ﬁ nished, make
sure to press the F8 key
to turn off the selection
or you will continue to
1 Select cell F13. Click the Sum button on the Ribbon and then click the Enter button.
2 Select the range H13:I13. Click the Sum button on the Ribbon to display the totals in row 13
as shown in Figure 2–14.
total current value
total initial cost