Susan Is in Charge of the Inventory Reports for Her

question 91

Multiple Choice

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

Profits

The financial gain obtained when the amount earned from a business activity exceeds the expenses, costs, and taxes involved in sustaining the activity.

Oil Future Contract

A legal agreement to buy or sell a specific amount of crude oil at a predetermined price at a specified time in the future.

Spot Price

The existing cost at which an asset is available for immediate purchase or sale.

Profit/Loss

The financial result of business operations or investment activities, calculated as the difference between revenues and the costs associated with generating those revenues.