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:

Winner-Take-All Markets

Markets in which the top performers are able to capture a very large share of the rewards, and the rest are left with very little.

Substitution Effect

The economic understanding that as prices rise or incomes decrease, consumers will replace more expensive items with less costly alternatives.

Income Effect

The Income Effect refers to the change in an individual's or economy's income and how that change will affect the quantity demanded of a good or service.

Substitution Effect

the component of the total effect of a price change on consumption that results from the consumer substituting the good that has become relatively cheaper for the good that has become relatively more expensive.