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:

Biosphere Reserves

Zones designed and set aside to protect biodiversity, promote sustainable development, and foster research and conservation education.

In Situ Conservation

The practice of conserving biodiversity in its natural habitat or original location, focusing on protecting the ecosystems and natural processes.

Biodiversity Hotspot

A region that is both a significant reservoir of biodiversity and is threatened with destruction.

Biodiversity Hotspot

A biogeographic region with a significant reservoir of biodiversity that is under threat from humans.