Microsoft Office Tutorials and References
In Depth Information
Entering Formulas
5
Tap or click cell I4
to select cell I4 to
prepare to enter the
next formula.
Type = (equal
sign) and then tap or
click cell E4 to begin
the formula and add
a cell reference to
the formula.
Type –( (minus
sign followed by an
open parenthesis)
and then tap or
click cell F4 to add a
subtraction operator,
open parenthesis,
and cell reference to
the formula.
Type + (plus sign)
and then tap or click
cell G4 to add an
addition operator
and cell reference to
the formula.
Type ) (close parenthesis) to complete the formula (Figure 2 – 11).
Tap or click the Enter box in the formula bar to enter the formula.
formula assigned
to cell I4
net pay gure
calculated and
displayed in
cell I4
Figure 2 – 11
To Copy Formulas Using the Fill Handle
The ve formulas for Michael Carl in cells E4, F4, G4, H4, and I4 now are
complete. The next step is to copy them to the range E5:I12. When performing
copying operations in Excel, the source area is the cell, or range, from which data or
formulas are being copied. When a range is used as a source, it sometimes is called
the source range. The destination area is the cell, or range, to which data or formulas
are being copied. When a range is used as a destination, it sometimes is called the
destination range. Recall from Chapter 1 that the fill handle is a small black square in
the lower-right corner of the active cell or active range. The following steps copy the
formulas using the fill handle.
1
Select the source range, E4:I4 in this case, activate the fill handle, drag the fill handle
down through cell I12, and then continue to hold your nger or the mouse button to
select the destination range.
2
Lift your nger or release the mouse button to copy the formulas to the destination
range (Figure 2 – 12).
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 that the new
formulas contain references corresponding to the new location and perform 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 .
 
Search JabSto ::




Custom Search