Question

Mention the two ways of entering a
cell reference in a formula. explain
the difference between them.​

Answer 1

Answer:

Two ways of entering a cell reference in a formula:

a. Relative reference: In this method, reference to a cell is

based on the position relative to the cell.

Example: A3=A1+A2

b. Mixed reference: In this type of reference, either row or

column is fixed by placing a dollar sign ($) before it.

Example: A3=$A1+AS2 .

The difference between the two ways becomes visible when

the formula is copied to other cells. In case of relative

reference, the cell reference automatically gets changed

whereas the fixed column or row remains unchanged in case

of mixed reference.