Question: What are the steps in getting this done? How do I create a PivotTable by highlighting cells B10:F10? DeShawn also wants to focus on one

What are the steps in getting this done?

How do I create a PivotTable by highlighting cells B10:F10?

  1. DeShawn also wants to focus on one or two types of small-group training sessions at a time when comparing the average profit per program. Return to the New Fees worksheet and create another type of report as follows:
    1. Create a Scenario PivotTable report using the average profit per program (range B10:F10) as the result cells to compare the average profit depending on the fee changes in a PivotTable.
    2. Use New Fees PivotTable as the name of the worksheet containing the PivotTable.

Format cells B4:F6 in the New Fees PivotTable worksheet using the Accounting number format with 0 decimal places and $ as the symbol

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

Q:

\f