Explain the process of creating and managing scenarios in Excel.
Instruction: Describe how to use Excel's Scenario Manager for performing what-if analysis.
Context: This question tests the candidate's ability to use Excel's tools for strategic decision-making, specifically focusing on the Scenario Manager feature.
Updated
Official answer available
Read the opening below, then unlock the full answer and practical guidance.
First, let me clarify what we mean by creating and managing scenarios in Excel...