Question

Write
one difference between Relative, Absolute and
Mixed cell referencing
in Ms Excel​

Answer 1

Answer:

Absolute cell references are useful when you don't want the cell reference to change as you copy formulas. ... Mixed cell references are a bit more tricky than the absolute and relative cell references. There can be two types of mixed cell references: The row is locked while the column changes when the formula is copied.

Answer 2

Answer:

An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row. If it precedes the column or row (but not both), it's known as a mixed reference. You will use the relative (A2) and absolute ($A$2) formats in most formulas. Mixed references are used less frequently.