Question

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

Answer 1

Answer:

To enter a formula that contains cell references, you have two choices. You can type cell references directly, or you can point and click to cells to pick up their addresses. The most basic way to enter cell references in a formula isto just type in the references as you need them.

Answer 2

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.