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:

Evolutionary History

A chronicle of the development and changes in populations or organisms over generations.

Three-Domain System

Classification system that places all organisms into one of three large domains—Bacteria, Archaea, and Eukarya.

Archaea

A domain of single-celled microorganisms without a nucleus, distinct from bacteria and eukaryotes, often found in extreme environments.

Eukarya

One of the three domains of life, consisting of organisms with cells characterized by a nucleus enclosed within membranes.