JOIN NOW

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

Related Questions