Explanation

Scenario Manager stores different sets of input values so that you can compare possible situations.

Go to:

Data → What-If Analysis → Scenario Manager

Example

Create three scenarios:

Scenario 1 — Low Sales

Input	Value
Quantity	80
Price	₹450
Cost	₹300

Scenario 2 — Normal Sales

Input	Value
Quantity	100
Price	₹500
Cost	₹300

Scenario 3 — High Sales

Input	Value
Quantity	150
Price	₹550
Cost	₹300

Scenario Manager can switch between these scenarios and show the resulting profit.

Practice

Create the three scenarios and compare the final profit.