How do you implement a scenario manager with three scenarios and share the results?

• A. Create driver cells for each scenario; switch inputs via the manager, recalc statements, and present a comparative summary.
• B. Manually edit cells to switch scenarios without a manager.
• C. Only run a single scenario and do not compare results.
• D. Skip recalculation and rely on static output.

Answer: (A)

The main idea tested here is how to compare multiple scenarios efficiently by centralizing inputs, enabling quick switching, and presenting results in one place. Using driver cells for each scenario captures the specific inputs that define that scenario (for example, assumptions about sales growth, costs, or pricing). A scenario manager lets you switch inputs through a single control, so you can move between scenarios without manually changing many cells. When you switch, the model recalculates automatically, ensuring all outputs reflect the new assumptions. Finally, a comparative summary pulls the key results for each scenario side by side, making it easy to see how different inputs affect metrics like cash flows, NPV, and other targets. This setup is shareable because the summary page can be viewed by others in one place, and it keeps the process repeatable and less error‑prone.

The other approaches fail to offer efficient comparison or reliable outputs: editing cells by hand is tedious and prone to mistakes; running only a single scenario prevents any side‑by‑side analysis; and skipping recalculation yields stale, invalid results.