Hello there,
Relative and Absolute cell addressing refers to the way a
formula is copied, ie. when the fill handle is dragged.
Relative:
Name Jan Feb Mar Total
Bob 10 20 30 =B1+C1+D1
Ben 20 30 40 =B2+C2+D2
Betty 30 40 50 =B3+C3+D3
The cell references change as the formula is copied. When
the results is moved down so are the cells it refers to.
Absolute:
Item Price VAT
TV £500 =B2*$B$5
Video £200 =B3*$B$5
DVD £100 =B4*$B$5
VAT 17.5%
The cell reference for the Salary moves down (Relative)
but the VAT cell stays the same (Absolute), so each price
is multiplied by the same cell.
You can add the dollars by pressing F4 after clicking on
the cell in the formula bar
Hope this helps
Judith
