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 2013 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
Q68: Susan is in charge of the inventory
Q69: Ellen is a recent college graduate. She
Q70: Using the AutoFill Options button,the Fill Without
Q71: If the VLOOKUP function cannot find the
Q72: One way to perform a _ is
Q74: In the formula =IF(A1=B1,C1,C2),the result will be
Q75: The fill handle copies _.
A)content only
B)formats only
C)content
Q76: =IF(G22= "x ",SUM(H22:J22), " ")with display _
Q77: Susan is in charge of the inventory
Q78: Ellen is a recent college graduate. She
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents