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

Quizplus · Accepted Answer

Goal Seek is a feature in Microsoft Excel that allows the user to find the input value needed to achieve a specific goal or output value. This would be useful for Susan in automating the trial-and-error process of finding the input value needed to reach a specific inventory cost goal. Data Validation would not be applicable in this situation as it is used for controlling the type of data entered into a cell. Goal Set and If Conditional are not features in Microsoft Excel.

Susan Is in Charge of the Inventory Reports for Her