Explanation

To create a scenario:

Data → What-If Analysis → Scenario Manager → Add

Enter:

• Scenario Name
• Changing Cells
• Values for those cells

Example

Changing cells:

• Quantity
• Selling Price
• Cost per Unit

Scenario 1 — Low Sales

Scenario 2 — Normal Sales

Practice

Create the Low Sales and Normal Sales scenarios.