Computer Applications
Explain Relative Referencing
Spreadsheet
86 Likes
Answer
In Relative Referencing, when the formula is copied to a new cell, the corresponding cell address changes with reference to the new cell address.
For example, consider the formula '=SUM(A1:A5)' in A6 for calculating the total from A1 to A5. Here the relative positions of the cells are specified. When this formula is copied to B6 or C6, it will automatically get adjusted as below:
For B6, it will become =SUM(B1:B5)
For C6, it will become =SUM(C1:C5)
Answered By
52 Likes