Question

mention the two ways of entering a cell reference in 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:

Explanation: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 tothe 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