Question

in the Identify the all references below address: A 12​

Answer 1

Answer:

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.

Answer 2

Answer:

There are three types of cell references Relative, Absolute and Mixed .

In Relative Cell Reference, the row and column references can change when we copy the formula to another cell.

In Absolute Cell Reference, the row and column references do not change when we copy a formula because the reference points to a fixed cell address.

In Mixed Cell Reference, if the row reference is relative , the column reference will be absolute or vice versa.