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:

Software Applications

Programs designed to perform specific tasks for users, ranging from productivity tools to entertainment or utility software.

Data Mart

A subject-oriented database that addresses a specific business line or team within an organization, and is a subset of a data warehouse.

Data Warehouses

Centralized repositories that store large amounts of integrated data from multiple sources, designed for query and analysis rather than transaction processing.

Access Database

A database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.