Question: Switch back to the All Types worksheet. Use the Scenario Manager as follows to compare the profit per hour in each scenario: a . Greate

Switch back to the All Types worksheet. Use the Scenario Manager as follows to compare the profit per hour in each scenario:
a. Greate a Scenario PivotTable report for result cells B17:D17.
b. Remove the Filter field from the PivotTable.
c. Change the Number format of the Profit_Per_Hour_Contracted_Mana, Profit_Per_Hour_Contracted_Chan, and Profit_Per_Hour_Contracted_Proc fields (located in the Values box of the PivotTable Field List) to Currency with 2 Decimal places and $ as the Symbol.
d. Use Management as the row label value in cell B3, Change as the value in cell C3, and Process as the value in cell D3.
e. In cell A1, use Profit Per Hour Contracted as the report title.
f. Format the report title using the Title cell style.
g. Resize columns A-D to 15.00.
 Switch back to the All Types worksheet. Use the Scenario Manager

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 Databases Questions!