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

question 31

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

---

Definitions:

Negative Information

Unfavorable data or news that might impact perceptions or decisions adversely.

Hidden Negative

A subtle or concealed aspect that can have adverse effects, often overlooked initially.

Sentence

A sentence is a set of words that contains a subject and predicate, expressing a complete thought or statement.

Salutations

Greetings or expressions of goodwill, often used at the beginning of a letter or conversation.