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

question 67

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 wants to make some changes to the worksheet to explore the impact that changing input values has on the calculated values in the worksheet. She can use  ______.

• A) Lookup Analysis
• B) What-If Analysis
• C) IF conditions
• D) nested OR conditions

---

Definitions:

Stock Price

The cost of purchasing a single share of a company's stock.

In The Money

refers to a financial term describing an option that has intrinsic value, meaning for a call option, the market price is above the strike price, and for a put option, the market price is below the strike price.

Put Option

A financial contract giving the holder the right, but not the obligation, to sell a specified amount of an underlying asset at a set price within a certain time frame.

Option Holder

An individual or entity that has the rights, but not the obligation, to buy or sell an asset at a predetermined price before or at the expiration of a contract.