Which type of cell reference adjusts automatically when copied to another cell?
A) Relative
B) Mixed
C) Absolute
D) Complex

Question

Quizplus · Accepted Answer

Relative cell references adjust automatically when copied to another cell based on their relative position to the new cell. For example, if a formula uses the cell reference A1 and is copied to a cell two columns over to the right, the formula in the new cell will automatically adjust to use the cell reference C1 instead.

Which Type of Cell Reference Adjusts Automatically When Copied to Another