Page 72 - Code & Click - 6

To understand the use of relative referencing:

1. Prepare the worksheet as shown.

2. Type the formula = A2*A2 in cell B2 and press the Enter
key.
2
The result of the formula appears in cell B2.

3. Click cell B2 and drag its fill handle
down to cell B10.

The result of the formula appears in
cell.
4. Click each cell from B3 to B10 and
observe the formula that appears in 3
the Formula bar.

The cell references used in the formula in each cell change automatically when the formula is copied
to cells B3 to B10.

Absolute Referencing
An absolute reference is a cell reference in a worksheet that remains constant even if the formula is
copied or moved from one cell to another cell. A cell reference is made absolute by putting a Dollar
($) sign before the column letter as well as the row number of the desired cell, such as $B$4.
To understand the use of absolute referencing:
1. Prepare the worksheet as shown.
The Cell B7 contains the percentage of festival discount
offered. The absolute cell reference of cell B7 is $B$7.

2. Type the formula =C2*B2*$B$7 in cell D2 and press the Enter
key.

The result of the formula appears in cell D2.
2

3. Select cell D2 and drag its fill handle down to cell D5.

3
The discount amount on each appliance appears in cells D3 to D5.
4. Click each cell from D2 to D5 and observe the formula in the Formula bar.

70