If You Use an INDEX Formula That Refers to Ranges

question 80

Multiple Choice

If you use an INDEX formula that refers to ranges on separate worksheets, Excel displays the ____ error message.

• A) #VALUE
• B) #REF!
• C) #ERROR
• D) none of the above

---

Definitions:

Polluted Stream

A body of flowing water that is contaminated with harmful chemicals, waste, or microorganisms, affecting its quality and the health of ecosystems it supports.

Volcanic Lava

Volcanic lava is molten rock expelled by a volcano during an eruption, which solidifies as it cools, forming new rock formations.

Frequent Fires

Recurring combustion events that occur with high frequency in a particular area, significantly affecting ecosystems and human activities.

Giant Sequoia

A species of tree known for its immense size and longevity, native to the Sierra Nevada mountain range in California; it is among the largest living organisms on earth.