Match the Example with the Function or Feature

question 16

Multiple Choice

Match the example with the function or feature:
i. =A54
II. =$A54
III. =$A$54
IV. =SUM(A54:B97)
v. "Ohio"

• A) Function
• B) Relative reference
• C) Ensures text entry
• D) Mixed reference
• E) Absolute reference

---

Definitions:

Downward-sloping Demand Curve

A graph showing that the quantity demanded of a good or service varies inversely with its price, other things being equal.

Equilibrium Price

The price at which the quantity of a product demanded by consumers equals the quantity supplied by producers.

Consumer Surplus

The divergence between the total payment consumers are willing to make for a product or service and what they really pay.

Demand Increase

A situation where consumers are willing and able to purchase more of a product or service at each price level, often caused by changes in tastes, income, or prices of related goods.