Question: i need help with 13/14 with understanding how to use pibot tables a. 12. Switch to the All Services worksheet. Use the Scenario Manager to

i need help with 13/14 with understanding how to use pibot tables i need help with 13/14 with understanding how to
a. 12. Switch to the All Services worksheet. Use the Scenario Manager to create a Scenario Summary report that summarizes the effect of the Current, Increase Hourly, and Contractors scenarios. Use the range C17:E17 as the result cells. 13. Switch back to the All Services worksheet. Use the Scenario Manager as follows to compare the profit per hour in each scenario: Create a Scenario PivotTable report for result cells c17:E17. b. Remove the Filter field from the Pivottable. Change the number format of the Profit_Per_Hour_Training, Profit_per_Hour_ Consulting, and Profit_per_Hour_Corporate fields (located in the Values box of the PivotTable Field List) to Currency with 2 decimal places and $ as the symbol. d. Use Personal Training as the row label value in cell B3, Consulting as the value in cell c3, and Corporate Programs as the value in cell D3. In cell A1, use Profit Per Hour as the report title. f. Format the report title just created in cell Al using the Title cell style. . Resize columns A-D to 17.00. c. e. a. 12. Switch to the All Services worksheet. Use the Scenario Manager to create a Scenario Summary report that summarizes the effect of the Current, Increase Hourly, and Contractors scenarios. Use the range C17:E17 as the result cells. 13. Switch back to the All Services worksheet. Use the Scenario Manager as follows to compare the profit per hour in each scenario: Create a Scenario PivotTable report for result cells c17:E17. b. Remove the Filter field from the Pivottable. Change the number format of the Profit_Per_Hour_Training, Profit_per_Hour_ Consulting, and Profit_per_Hour_Corporate fields (located in the Values box of the PivotTable Field List) to Currency with 2 decimal places and $ as the symbol. d. Use Personal Training as the row label value in cell B3, Consulting as the value in cell c3, and Corporate Programs as the value in cell D3. In cell A1, use Profit Per Hour as the report title. f. Format the report title just created in cell Al using the Title cell style. . Resize columns A-D to 17.00. c. e

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!