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 designs a worksheet with the inventory number, description, quantity, unit cost, reorder point and value. To find values in tables of data, and insert them in another location in the worksheet such as cells or in formulas, she will use ________.
A) Max function
B) Lookup function
C) CountA function
D) Sum function

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 designs a worksheet with the inventory number, description, quantity, unit cost, reorder point and value.  To find values in tables of data, and insert them in another location in the worksheet such as cells or in formulas, she will use ________.
A) Max function
B) Lookup function
C) CountA function
D) Sum function

Quizplus · Accepted Answer

The Lookup function is designed to find specific values in tables of data and insert them into another location in the worksheet. The other functions listed do not have this specific capability.

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