Case-Based Critical Thinking Questions Case 8-3 You Have Been Using

question 30

Multiple Choice

Case-Based Critical Thinking Questions Case 8-3 You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on, suggesting that there is an easier approach to use. ​If you omit the range_lookup value from a LOOKUP function, which of the following is true?

• A)The function returns the #NAME? error value.
• B)Your function can only search the first column of the lookup table.
• C)It is considered an approximate match.
• D)It is considered an exact match.

---

Definitions:

Confound Group

A group in an experiment that introduces variability to the outcome, making it difficult to determine the effect of the treatment.

Experimental Group

In an experiment, one or more treatment groups of participants that receive the manipulation of the independent variable being investigated.

Random Assignment

Placing research participants into the conditions of an experiment in such a way that each participant has an equal chance of being assigned to any level of the independent variable.

Random Sampling

A method of sampling in which each member of a population has an equal chance of being selected to represent the whole.