Explanation

Scenario Manager allows you to compare different sets of assumptions.

For a business, you could create:

• Low Sales
• Normal Sales
• High Sales

Example

Each scenario can produce a different profit.

Steps

Data → What-If Analysis → Scenario Manager → Add

Specify the changing cells and enter scenario values.

Practice

Create three business scenarios and compare their profits.