When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?
A) Cell references are not affected.
B) The user must insert new cell references.
C) The user is prompted to enter new cell references.
D) Cell references are automatically adjusted.

Question

Quizplus · Accepted Answer

Cell references are automatically adjusted when cells or rows are inserted or deleted in an Excel worksheet. This ensures that formulas and functions referencing those cells continue to work correctly.

When Cells or Rows Are Inserted or Deleted in an Excel