When Cells or Rows Are Inserted or Deleted in an Excel

Multiple Choice

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.