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

question 49

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

---

Definitions:

Good Faith

Good Faith involves engaging in actions or negotiations with honesty, integrity, and sincerity without any intention to deceive or defraud.

Increasing Resources

The act of adding more resources such as time, money, or manpower to a project or work environment to enhance productivity or efficiency.

Precise Rules

Clearly defined and strict guidelines or regulations that must be followed to ensure a certain outcome or maintain order.

ADR

Alternative Dispute Resolution, a range of processes and techniques to resolve disputes outside the judiciary process, including mediation and arbitration.