Question

Define the following with an appropriate example of each. (a) Relative referencing (b) Absolute referencing(c) Mixed referencing​

Answer 1

Explanation:

(a) In relative referencing the same formala is applied to the new cell, but the value of data in take as per the new cell address te the formula does not change, but values may change with the mange in address.

(b) Absolute referencing enables to apply formula in which the address of the cell does not get changed even if the formula is copied to the new location.

(c) in mixed referencing, one part of cell address in the new formula i.e. either row number or column name is absolute but the other part changes with the change in address .