AS IT using spreadsheets OCR part 2 cell refernces

relative or absolute cell refernces

to replicate data in spreadsheets you can copy and paste cells from cone column to another.
when formulas are replicated this way cell references can be affected depending on wether they are relative or absolute.

1 of 3

Relative references mean that the cell references move
when a formula is replicated relative cell references will change to a different reference than the original copy.
so if a formula is copied from one column to another then the column identifier will change automatically
eg the original formula may be A2+A3 but when copied to the next column it will become B2+B3
if a formula is copied from one row to another the row identifier will change automatically
eg the original formula may be A2+A3 but when copied to the next row it will become A3+A4

2 of 3

absolute referencing is when the cell reference doesn't change
this type of cell reference can be used if there is a single value that you want to appear in all formulas
absloute cells are marked by $ signs in the formula you want to be absolute for example E4/$I$12 this means the cell E4 is divided by the cell I12 but is kept as an absolute cell refernece,
an advantage of using absolute cell referencing is that if the value changesnit only needs to be changed once, as all the formulas and functions will automatically use the same value.

3 of 3