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 cell references
- 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
Similar ICT resources: