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:

Behaviour

The actions or reactions of an individual or system in response to external or internal stimuli.

Balance Theory

A psychological theory proposing that individuals strive for internal consistency among their beliefs, attitudes, and opinions, forming a balanced state in interpersonal relationships.

Cognitive Consistency

The psychological concept that suggests that individuals prefer their beliefs, attitudes, and perceptions to be harmonious and consistent with each other.

Self-Perception

An individual's understanding and evaluation of their own personality, characteristics, and behaviors.