Question

differentiate between relative ,absolute and mixed referencing with an example.​

Answer 1

Answer:

Explanation:

Hi friend

---------------

Your answer

----------------------

★ DIFFERENCE BETWEEN MIXED AND ABSOLUTE CELL REFERENCING

-------------------------------------------------------------------------------------------------------

In Absolute Cell Referencing the cell references remain constant and does not change with change in formula position, when copied to a new position.

$ (Dollar) sign us used to make a row or column absolute.

For example => $A$1

In Mixed Cell Referencing either a column or a row is made absolute or fixed with help of $(Dollar) sign.

For example => Constant Row => C$1

=> Constant column => $C1

HOPE IT HELPS

Answer 2

Explanation:

Relative Reference -: The formula in the copied cell changes according to change in the cell pointer

Absolute Reference -: It Is specified using the$ sign along with the column and the row number of the cell

Mixed reference -:It is a combination of relative and absolute refrence