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:

Persecuted Protestants

Individuals or groups following Protestant Christianity who faced oppression, harassment, or violence because of their religious beliefs, historically and in various contexts worldwide.

Amsterdam

The capital city of the Netherlands, known for its historic canals, cultural heritage, museum district, and liberal attitudes.

Seventeenth Century

The century that spanned from January 1, 1601, to December 31, 1700, notable for significant cultural and political developments.

Henry Hudson

A 17th-century explorer who is best known for his explorations of present-day Canada and parts of the northeastern United States, including the river that now bears his name.