If the VLOOKUP function cannot find the lookup value, the _________ error value is displayed in the cell.

A. #VALUE
B. #N/A
C. #ERROR
D. #NULL

Answer: B

Computer Science & Information Technology

You might also like to view...

To perform a drag action, the user clicks and holds the right mouse button down over an icon

Indicate whether the statement is true or false

Computer Science & Information Technology

What is wrong with the following while loop?

while ( sum <= 1000 ) sum = sum – 30; a. The parentheses should be braces. b. Braces are required around sum = sum – 30;. c. There should be a semicolon after while ( sum <= 1000 ). d. sum = sum – 30 should be sum = sum + 30 or else the loop may never end.

Computer Science & Information Technology