Multiple Choice
Case 3-2
Susan is in charge of the inventory reports for her company. She will need to find specific inventory items as well as project increases in inventory costs. To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools.
-Susan uses VLOOKUP to retrieve the return value from a vertical lookup table. When she enters the VLOOKUP function, specifying the lookup value and other criteria, the lookup value cannot be found. It displays ______ error value in the cell.
A) #####
B) #Value
C) #N/A
D) Value not found
Correct Answer:

Verified
Correct Answer:
Verified
Q4: Which function counts how many cells in
Q17: Which of the following is a Math
Q23: A constant is a value in a
Q38: The _ function returns the maximum value
Q44: The Insert Function button is in the
Q54: The numbers,text,or cell references used by the
Q71: The statement "A1 >= B1" tests
Q73: Excel functions are organized into _ categories.<br>A)8<br>B)10<br>C)11<br>D)13
Q93: _ references are seldom used other than
Q97: The <span class="ql-formula" data-value="\underline {