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

Quizplus · Accepted Answer

In a lookup function, setting the range_lookup value to FALSE will search for an exact match of the lookup value in the lookup array. Hence, setting the range_lookup value to FALSE will ensure that Susan can find an exact match of the inventory item she is looking for.

Susan Is in Charge of the Inventory Reports for Her