When Cells or Rows Are Inserted or Deleted in an Excel

question 396

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:

Experience-curve Pricing

A pricing strategy that utilizes the cost savings gained from learned efficiency as production volume increases over time.

Cost-plus Pricing

A strategy for setting prices that involves adding a defined markup to the cost of each unit of a product.

Experience-curve Pricing

A pricing strategy that takes into account the reductions in unit costs as cumulative volume increases, due to gained efficiency and experience.

Experience-curve Pricing

A pricing strategy that lowers the cost of a product over time as the production processes become more efficient with experience.