Computer Science, asked by virushp9848, 9 months ago

How is a mixed cell address different from relative and absolute cell addresses?

Answers

Answered by pranabmondal1972pm
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