What is a scenario manager, and when do you use it?

A scenario manager stores sets of assumptions for base, downside, upside, or management cases. In banking models, many users prefer switch cells and CHOOSE formulas because they are more transparent than Excel's built-in Scenario Manager. Use scenarios when multiple assumptions must change together consistently.