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:

Accounting Firm

A business that provides services related to the processing, measurement, and communication of financial information about economic entities.

Salaries

Payments made to employees for their services, typically expressed as an annual sum and paid at regular intervals.

Mathematics Scores

Numerical outcomes or grades obtained from assessments or tests in the field of mathematics.

High-School

An educational institution for students usually between the ages of 14 and 18, offering secondary education.