When Solving an HLOOKUP Formula, Excel Looks Up a Value

question 28

Multiple Choice

When solving an HLOOKUP formula, Excel looks up a value by testing for a criterion across a ____.

• A) row
• B) column
• C) table
• D) worksheet

---

Definitions:

Noncompensatory Modeling

Noncompensatory Modeling is a decision-making strategy where alternatives are evaluated on key criteria, and an option is selected without making trade-offs among these criteria.

Latent Learning

Learning that remains hidden until its application becomes useful.

Creativity

The process of solving problems by combining ideas or behavior in new ways.

Stereotype Threat

The risk of confirming negative stereotypes about an individual's racial, ethnic, gender, or cultural group which can impair their performance.