Question

Select the correct type of address reference.
addresses change depending on the cells you
addresses do not change if you copy them to a different cell.

Answer 1

Answer:

[ Absolute ] Addresses do not change if you copy them to a different cell.

[ Relative ] Addresses change depending on the cells you copy them to.

Answer 2

Answer:

Absolute addresses use $ signs preceding both the row and column values, whereas relative addresses do not use the $ sign. Mixed addresses use a single $ for either the row or the column value.

Explanation: