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

Question

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

Quizplus · Accepted Answer

What-If Analysis in Microsoft Excel 2016 can be used to explore the impact of changing input values on calculated values in a worksheet. It includes tools such as Goal Seek, Scenario Manager, and Data Tables to perform different types of What-If analysis. Lookup Analysis, IF conditions, and nested OR conditions are not relevant to this particular task.

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