If a formula references cell A1 and is copied down one row and to the right one column,the new formula will reflect B2 if the cell reference is a(n)________ reference.
A) absolute
B) relative
C) mixed
D) constant

Question

Quizplus · Accepted Answer

In a relative reference, the reference will change relative to the location where it is copied. So, if a formula references cell A1 and is copied down one row and to the right one column, the new formula will reflect B2, which is one row down and one column to the right of A1.

If a Formula References Cell A1 and Is Copied Down