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...

In a column of dollar amounts:

A) all numbers should be formatted with a $. B) only the total should be formatted with a $. C) the first and last numbers should be formatted with a $. D) none of the numbers should be formatted with a $.

Computer Science & Information Technology

Which of the following publishes, edits, modifies, organizes, deletes, and maintains content from a central interface?

A. ERP B. CMS C. GRC D. SOA

Computer Science & Information Technology

Computer systems that fall into the _________ category have a single machine instruction that controls the simultaneous execution of a number of processing elements on a lockstep basis.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

The floating-point conversion specifiers e and E display floating-point values in __________ notation.

a) elliptical b) existential c) exponential d) exportable

Computer Science & Information Technology