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
.