Susan Is in Charge of the Inventory Reports for Her

question 92

Multiple Choice

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

---

Definitions:

Comprehend Difficult

The challenges associated with understanding complex concepts, texts, or problems.

Accessibility

The ease with which people can bring an idea into consciousness and use it in thinking.

Mere Exposure Effect

The phenomenon by which people tend to develop a preference for things merely because they are familiar with them.

Primacy Effect

The tendency to remember information at the beginning of a list or sequence better than information in the middle or at the end.