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?

October 5, 2022 by 8i9x6

X-Consolidate, Y-Consolidate X-What-If Analysis, Y-Goal Seek X-What-If Analysis, Y-Scenario Manager X-Data Validation, Y-Data Validation

See Answer

X-What-If Analysis, Y-Scenario Manager