Question

c. Which type of reference does not change the cell address on
copying the formula to another cell?
options
1) Relative Reference 2) Mixed Reference 3) New
Reference 4) Absolute Reference
​

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.

Explanation:

hope it can help u