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:

Presold

A marketing strategy wherein a product or content is sold or licensed before it is actually available to the public, commonly used in the publishing and film industries.

Todd Haynes

An American film director known for his work in independent films that often explore themes of identity and sexuality.

Interracial Romance

Romantic relationships or representations thereof between people of different racial backgrounds.

The Hurt Locker

A 2008 war film directed by Kathryn Bigelow that focuses on an Explosive Ordnance Disposal team during the Iraq War, highlighting the psychological impacts of conflict.