How Mixed cell address is different from relative and absolute cell address?
Answers
Answered by
1
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.
Mixed Reference. Mixed Reference is a type of Absolute reference in which either the column is made constant or the row is made constant. When we make any column or row constant then the column name or row number does not change as we copy the formula to other cell(s).
Similar questions