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 needs to use a lookup function to find an exact match of an inventory item, so she will set the range_lookup value to _______ .
A) EXACT
B) 1
C) TRUE
D) FALSE

Question

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 needs to use a lookup function to find an exact match of an inventory item, so she will set the range_lookup value to _______ .
A) EXACT
B) 1
C) TRUE
D) FALSE

Quizplus · Accepted Answer

Setting the range_lookup value to FALSE will find an exact match of the item in the lookup table. Setting it to TRUE or EXACT could result in a partial match or an error if no exact match is found. Choosing 1 is not a valid option for range_lookup value.

Case 3-2 Susan Is in Charge of the Inventory Reports for Her