Microsoft Office Tutorials and References
In Depth Information
Entering Formulas
EX 97
Table 2–4 Smart Tag and Options Buttons in Excel
Button
Name
Auto Fill Options
Gives options for how to ﬁ ll cells following a ﬁ ll operation, such as dragging
the ﬁ ll handle
AutoCorrect
Options
Undoes an automatic correction, stops future automatic corrections of this
type, or causes Excel to display the AutoCorrect Options dialog box
Insert Options
Lists formatting options following an insertion of cells, rows, or columns
Paste Options
Speciﬁ es how moved or pasted items should appear (for example, with
original formatting, without formatting, or with different formatting)
Smart Tag
Actions
Lists information options for a cell containing data recognized by Excel, such
as a stock symbol
Trace Error
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
select ranges.
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.
Sum button
total current value
total initial cost
total gain/loss
Figure 2–14
C6161_EXC_02.4c.indd 97
C6161_EXC_02.4c.indd 97
3/6/07 3:28:22 PM
3/6/07 3:28:22 PM

Search JabSto ::

Custom Search