A(n)________ allows a cell's row and column to change when copied.
A) relative reference
B) named range
C) mixed reference
D) absolute reference

Question

Quizplus · Accepted Answer

A relative reference allows a cell's row and column to change when copied. This means that the formula or reference adjusts based on its new location, which is useful when copying formulas across multiple cells or columns. Named ranges are used to assign a name to a cell or group of cells and can be used as a reference in formulas. A mixed reference is a combination of absolute and relative references, where one part is fixed and the other adjusts when copied. An absolute reference, on the other hand, does not change when copied, as the cell's row and column reference are fixed with dollar signs.

A(n)________ Allows a Cell's Row and Column to Change When