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

Question

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

Quizplus · Accepted Answer

The X in the series should be "What-If Analysis" and the Y should be "Scenario Manager" as they are the options needed to select and create a scenario PivotTable report. Option A and D do not have any relevance to creating a scenario PivotTable report. Option B has "What-If Analysis" as X but "Goal Seek" as Y, which is not applicable to creating a scenario PivotTable report.

Which of the Following Can X Be in the Series