Case 3-2 Susan Is in Charge of the Inventory Reports for Her

question 66

Multiple Choice

Case 3-2
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 2016 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:

Poor Nutrition

A diet lacking in necessary nutrients, resulting in health issues due to deficiencies or imbalances in food intake.

Weight Loss

The reduction of total body mass due to a decrease in body fat, muscle, or fluid.

Cancer Risk Factors

Elements that increase the likelihood of developing cancer, including genetics, lifestyle, and environmental exposure.

Chronic Diseases

Diseases that persist for a long time, usually longer than three months, such as diabetes, heart disease, and cancer.