Page 97 - Computer - 6

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

3

The result of the formula appears in cell.
4. Click each cell from B3 to B10 and observe the formula that appears in 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.
The cell reference B2 and D2 change automatically, but the cell reference B7 remains same even when
the formula is copied to other cells. It is because the cell reference $B$7 is an absolute reference.

95