When Cells or Rows Are Inserted or Deleted in an Excel

question 21

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.

---

Definitions:

Shipping Amount

The total volume or quantity of goods being transported from one place to another.

Orlando

A municipality located in the heart of Florida, famed for its entertainment parks such as Walt Disney World and Universal Studios.

Shipping Amount

The total volume or quantity of goods shipped or transported in a single consignment.