Question

choose the correct answer. a relative reference refers to a cell that is a specific distance away from the cell that contains the formula and _____. does not change when you copy its formula to another cell. changes when you copy its formula to another cell.

Explanation:

A relative reference in spreadsheet software (like Excel) changes when the formula is copied. For example, if a formula in cell A1 references B1 (a relative reference) and the formula is copied to A2, it will reference B2.

Answer:

Changes when you copy its formula to another cell.