If Formulas Located in Other Cells Reference Cells in a Deleted

question 81

Multiple Choice

If formulas located in other cells reference cells in a deleted row or column,Excel does not adjust these cell references but instead displays the ____ error message.

• A) #NULL!
• B) #DIV/0!
• C) #N/A
• D) #REF!

---

Definitions:

Upside Potential

The potential or possibility for an investment, project, or venture to increase in value or profitability.

Stars

High-growth and high-market share items or businesses that require large investments to maintain their leadership but generate substantial cash.

Substantial Penetration

Achieving a significant level of market share or influence within a particular market or among a target audience, often implying a deep understanding and effective marketing efforts.

Expanding Markets

The process of entering new geographic or demographic areas to increase a company's customer base and sales potential.