Question

Plzz........
It's urgent .....
Give the definition of relative referencing, absolute referencing and mixed referencing .
15 points......✌️✌️✌️​

Answer 1

Answer:

Relative cell reference is the default cell reference which is relative to the location of the cell. Ex - A2, Z30 etc.

Absolute cell reference in a spreadsheet that remains constant even if the shape of size of the spreadsheet is changed , or the reference is copied or moved to another cell or sheet .

An absolute cell reference is represented by the $ symbol.

Ex -$F$45, $D56 etc

Mixed cell reference is either an absolute column and a relative row or an absolute row and a relative column. When you add the $ sign before the column letter you create an absolute column or before the row number you create an absolute row.