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.
Answer: C
You might also like to view...
The ____ point is located at the (0,0) point on invisible X and Y axes.
a. central b. radial c. reference d. axial
A ____________________ provides the reader with a short description of the purpose of the letter.
Fill in the blank(s) with the appropriate word(s).
During the __________ phase, specific technologies are selected to support the alternatives identified and evaluated in the prior phases.
A. investigation B. implementation C. analysis D. physical design
Which of the following is responsible for installing and maintaining operating system software?
A. Program developer B. Systems analyst C. Systems programmer D. Cloud architect