A(n) ____ reference identifies a cell by its location in relation to other cells and changes when a formula is moved or copied.
A) absolute
B) relative
C) template
D) vector

Question

Quizplus · Accepted Answer

A relative reference changes when a formula is moved or copied. Absolute references, on the other hand, remain the same regardless of where they are copied or moved, and use the '$' symbol to indicate this. Template and vector are not types of cell references.

A(n) ____ Reference Identifies a Cell by Its Location in Relation