AS IT using spreadsheets OCR part 2 cell refernces

part 2 of the using spreasheets revision cards about cell references.

HideShow resource information

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

Absloute referencing

  • 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

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Databases resources »