Which of the Following Can X Be in the Series

question 11

Multiple Choice

Which of the following can X be in the series of clicks to create a scenario PivotTable report: Data tab > Data Tools > X > Y > Summary button > Scenario Summary dialog box > Report type > Scenario PivotTable report > Enter cell name in Results cells box > OK?

• A) X-Consolidate,Y-Consolidate
• B) X-What-If Analysis,Y-Goal Seek
• C) X-What-If Analysis,Y-Scenario Manager
• D) X-Data Validation,Y-Data Validation

---

Definitions:

Residual Volume

The volume of air that remains in the lungs at the end of a normal exhalation.

Tidal Volume

The volume of air moved into and out of the lungs with each normal resting breath.

Vital Capacity

The maximum volume of air a person exhales after filling the lungs to the maximum extent.

Bohr Effect

Increased oxyhemoglobin dissociation due to lowered pH; occurs as carbon dioxide concentration increases.