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:

Business Letter

A formal document used in professional communication that follows specific formats to convey messages between companies, clients, and other external parties.

Concerning

Causing worry, alarm, or distress; often used to describe situations or matters that merit attention due to potential negative implications.

Dateline

A line in a written document or report that gives the date and place of the writing or reporting, often seen in news articles and press releases.

Dictated

Refers to something that is spoken aloud for another person to write down or for a machine to record.