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
Computer Science & Information Technology
You might also like to view...
Port 443 usually refers to the ________ protocol
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology
A Security Officer on a military base needs to encrypt several smart phones that will be going into the field.Which of the following encryption solutions should be deployed in this situation?
A. Elliptic curve B. One-time pad C. 3DES D. AES-256
Computer Science & Information Technology