Comparison

Tool

Best Used For

Goal Seek

Find one input needed for a desired result

Data Table

Compare many input values

Scenario Manager

Compare complete sets of assumptions

Example

Question: What price gives ₹50,000 profit?

→ Goal Seek

Question: What happens to profit at prices ₹400–₹700?

→ Data Table

Question: Compare Low, Normal and High Sales plans.

→ Scenario Manager

Practice

For each business question, choose the appropriate What-If tool.

PreviousNext