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 automate the trial-and-error process by allowing her to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal. She can use ______.
A) Data Validation
B) Goal Seek
C) Goal Set
D) If Conditional

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 automate the trial-and-error process by allowing her to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal. She can use ______.
A) Data Validation
B) Goal Seek
C) Goal Set
D) If Conditional

Quizplus · Accepted Answer

Goal Seek is the tool that allows Susan to set a goal for a calculated item and then automate the process of finding the input value needed to reach that goal by iterating through different values. Data Validation simply checks that input values meet certain criteria, If Conditional allows for conditional logic, and Goal Set is not a recognized Excel tool.

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