Microsoft Office Tutorials and References
In Depth Information
EX 96
Excel Chapter 2 Formulas, Functions, Formatting, and Web Queries
Drag the fi ll handle
down through the
range H5:J12 to copy
the three formulas
=D4*G4 in cell H4,
=H4-F4 in cell I4,
and =I4/F4 in cell J4
to the range H5:J12
(Figure 2–13).
current value, gain/loss,
and percent gain/loss
formulas in range H4:J4
copies to range H5:J12
How does Excel
adjust the cell
references in the
formulas in the
destination area?
Recall that when
you copy a formula,
Excel adjusts the
cell references so
the new formulas
contain references
corresponding to the
new location and
performs calculations
using the appropriate
values. Thus, if you copy downward, Excel adjusts the row portion of cell references. If you copy
across, then Excel adjusts the column portion of cell references. These cell references are called
relative cell references .
Auto Fill Options
button appears after
copying the range
H4:J4 to range H5:J12
Figure 2–13
Other Ways
1. Select source area, click
Copy button on Ribbon,
select destination area,
click Paste button on
2. Select source area,
right-click copy area,
click Copy on shortcut
menu, select destination
area, right-click paste
area, click Paste on
shortcut menu
Smart Tags and Option Buttons
Excel can identify certain actions to take on specifi c data in workbooks using smart
tags . Data labeled with smart tags includes dates, fi nancial symbols, people’s names, and
more. To use smart tags, you must turn on smart tags using the AutoCorrect Options in
the Excel Options dialog box. To change AutoCorrect options, click the Offi ce Button,
click the Excel Options button on the Offi ce Button menu, point to Proofi ng, and then
click AutoCorrect Options. Once smart tags are turned on, Excel places a small purple
triangle, called a smart tag indicator , in a cell to indicate that a smart tag is available. When
you move the insertion point over the smart tag indicator, the Smart Tag Actions button
appears. Clicking the Smart Tag Actions button arrow produces a list of actions you can
perform on the data in that specifi c cell.
In addition to smart tags, Excel also displays Options 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 fi ll operation, such as dragging
the fi ll handle. When an error occurs in a formula in a cell, Excel displays the Trace Error
button next to the cell and identifi es the cell with the error by placing a green triangle in
the upper left of the cell.
Table 2–4 summarizes the smart tag and Options 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.
C6161_EXC_02.4c.indd 96
C6161_EXC_02.4c.indd 96
3/6/07 3:28:20 PM
3/6/07 3:28:20 PM
Search JabSto ::

Custom Search