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:

Record Producers

Professionals who oversee and manage the recording process of artists, playing critical roles in the development, recording, and production of music tracks.

Budget Approval

The formal process of validating a financial plan that allocates resources for specific activities or periods.

Break-out

A significant or sudden move, often referring to stocks or products that rapidly gain attention or market share.

Rental Cars

Vehicles leased to customers for a short term, often ranging from a few hours to weeks.