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:

Adoption

The legal process of taking another's child into one's family, granting it the same legal rights and status as one's biological child.

Preferred Stock

A class of stock that carries with it the right to receive payment of dividends and/or the distribution of assets on the dissolution of the corporation before other classes of stock receive their payments.

Dividends

Net profits, or surplus, set aside for shareholders.

Dissolution

A change in the relation of partners caused by any partner ceasing to be associated in the carrying on of the business.