Question

Define the following with an appropriate example for each:
(1) Relative Referencing

Answer 1

Relative Referencing :- An address or pointer that changes when the target item is moved or the relationship to it has changed. For example, in a spreadsheet, a cell with a relative reference changes its formula when copied elsewhere. Contrast with absolute references.

Answer 2

Answer:

Relative Reference: This is the normal way we write a formula or function. In excel when we copy a formula by default it will change reference automatically. For ex we have data from A1 to A10 in cell A11 when we use a function sum (Sum(A1:A10)), it will return total of values given in A1 to A10. When we copy the function given in A11 and paste it in B11 the function will be (sum(B1:B10)) that will return total of values given in B1 to B10. This is called relative reference.

Thanku