Scenario Manager in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of the Scenario Manager in Excel?

Scenario Manager helps you create and save different sets of input values to see how they affect your results, like testing different budgets or sales forecasts without changing your original data.

beginner

How do you add a new scenario in Scenario Manager?

You click on 'Add' in the Scenario Manager dialog, give your scenario a name, select the cells that will change, and enter the new values for those cells.

beginner

What does the 'Show' button do in Scenario Manager?

The 'Show' button applies the selected scenario's values to your worksheet so you can see the results of that scenario instantly.

intermediate

Can Scenario Manager handle multiple changing cells at once?

Yes, Scenario Manager can change multiple cells at the same time, allowing you to test complex situations with several variables changing together.

beginner

What is a practical example of using Scenario Manager?

You can use Scenario Manager to compare different business plans, like changing sales volume and price to see how profit changes without rewriting formulas or data.

What do you need to specify when creating a new scenario in Scenario Manager?

A Only the formula cells

B The changing cells and their new values

C The worksheet name

D The chart type

You must specify which cells will change and what their new values are for the scenario.

Which Excel feature allows you to switch between different sets of input values easily?

A Scenario Manager

B Pivot Table

C Conditional Formatting

D Data Validation

Scenario Manager is designed to switch between different input value sets to see different outcomes.

How many scenarios can you create in Excel's Scenario Manager?

A Only 3 scenarios

B Up to 32 scenarios

C Unlimited scenarios

D Exactly 10 scenarios

Excel allows an unlimited number of scenarios in Scenario Manager (limited only by available memory).

What happens when you click 'Show' on a scenario?

A The worksheet updates with the scenario's values

B The scenario is deleted

C A new worksheet is created

D The workbook closes

Clicking 'Show' applies the scenario's values to the worksheet so you can view the results.

Which of these is NOT a use of Scenario Manager?

A Saving multiple what-if cases

B Testing different input values

C Comparing business outcomes

D Creating charts automatically

Scenario Manager does not create charts automatically; it is used for managing input value sets.

Explain how Scenario Manager helps in decision making with an example.

Think about how changing numbers can show different outcomes without rewriting formulas.

Describe the steps to create and use a scenario in Excel's Scenario Manager.

Remember the order: add, name, select cells, enter values, then show.