Question

Write the two difference between absolute reference and mixed reference

Answer 1

absolute reference : it is used when we do not want to change the address of the cell on copying the formula to the another cell.

mixed reference: it is the combination of relative and absolute reference in this type of reference either Way Or column has to be fixed.

Answer 2

Answer:

Mixed cell references have dollar signs attached to either the letter or the number in a reference but not both (i.e., $A1 or A$1).

Absolute cell references have dollar signs attached to each letter or number in a reference (i.e., $A$1).

Hope it's helpful!