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 in Excel are automatically adjusted when cells or rows are inserted or deleted, maintaining the correct references in formulas.

When Cells or Rows Are Inserted or Deleted in an Excel