Compare the average profit per program based on the scenarios as follows: Scenario Summary report using the
Fantastic news! We've Found the answer you've been seeking!
Question:
- Compare the average profit per program based on the scenarios as follows:
- Scenario Summary report using the average profit per program (range B10:F10) as the result cells to show how the average profit changes depending on the fee changes.
- Use New Fees Scenario Report as the name of the worksheet containing the report.
- 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:
- 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.
- 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.
Related Book For
Microeconomics An Intuitive Approach with Calculus
ISBN: 978-0538453257
1st edition
Authors: Thomas Nechyba
Posted Date: