In Excel, When You Insert or Delete Cells from a Spreadsheet

question 19

Multiple Choice

In Excel, when you insert or delete cells from a spreadsheet, ____.

• A) Excel automatically adjusts cell references to reflect new locations
• B) you have to manually adjust all formulas
• C) formulas will appear as errors
• D) None of the above. You cannot insert or delete cells from a spreadsheet.

---

Definitions:

Selling Price

The price at which a product or service is sold to the purchaser, often determined by the cost of production, market demand, and competition.

Cost

The amount of money required to purchase something or the expense associated with creating a product or service.

Mark-up

The extra sum included in the goods' selling price to cover both overhead expenses and profit.

Selling Price

The amount of money for which a product or service is sold to a customer.