Named Ranges That Are to Be Used as Lists of Values

question 49

Multiple Choice

Named ranges that are to be used as lists of values for data validation ________.

• A)must be in the same workbook where the validation is applied
• B)must be in the same worksheet where the validation is applied
• C)must be in a different workbook than where the validation is applied
• D)must be in a different worksheet than where the validation is applied

---

Definitions:

Marginal Expenditure

The extra expense that results from acquiring or making an additional unit of a product or service.

Monopsony Power

A situation in the marketplace where a single buyer confronts numerous sellers, granting this buyer a substantial influence over pricing.

Buyer Interaction

The dynamics and exchanges between buyers in a market, which can influence price, demand, and supply conditions.

Monopsony Power

Refers to a market situation where there is only one buyer for a particular product or service, giving that buyer significant control over prices and terms.