How is a mixed cell address different from relative and absolute cell addresses?
Answers
Answered by
7
Answer:
Hi friends
Explanation:
To make a cell reference absolute, just add $ sign before the column number or row number or both of them: A2 = both column and row references are relative. A$2 = column reference is relative, row reference is absolute. $A$2 = both column and row references are absolute
AND
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. The column is locked while the row changes when the formula is copied.
Mark me brainiest plz
give me thanks
Similar questions