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:

Budget Constraint

The limitations on the goods and services available for purchase, based on the income and prices, reflecting the trade-off between different choices.

Money Income

The total amount of monetary earnings received by an individual or household, including wages, salaries, and other forms of financial income.

Budget Constraint

The limit set by available resources, defining the combination of goods or services that a consumer can afford.

Money Income

The total amount of monetary earnings received by an individual or group, including wages, salaries, bonuses, and other income.