The ________ Functions Provide Added Flexibility of Multiple Data Ranges

question 22

Multiple Choice

The ________ functions provide added flexibility of multiple data ranges that can be located throughout an Excel spreadsheet.

• A)SUM and AVERAGE
• B)VLOOKUP and HLOOKUP
• C)IF and COUNTIF
• D)MATCH and INDEX

---

Definitions:

Equilibrium Position

In the indifference curve model, the combination of two goods at which a consumer maximizes his or her utility (reaches the highest attainable indifference curve), given a limited amount to spend (a budget constraint).

Normal Good

A product whose demand increases when consumer income rises and falls when consumer income decreases.

Income Increases

Refers to a rise in the amount of money that individuals or households receive, from sources such as wages, investments, or benefits.

Indifference Map

A graphical representation of a consumer's preferences for different combinations of goods, where each curve indicates all combinations that offer the same level of satisfaction or utility.