Get premium membership and access revision papers with marking schemes, video lessons and live classes.
OR

Explain three types of cell referencing techniques.

(2m 20s)
203 Views     SHARE

The name of the column and row is preceded by a dollar sign ($), for example,$G$10. -Relative cell referencing: this is reference to the cell in a formula based on the position of the cell that contains the formula. -Mixed cell referencing: it is a combination of relative and absolute cell reference. Examples =$H18. H is absolute while 18 is relative.