A scenario is a defined set of input values used to perform a what-if analysis. The Scenario Manager in Microsoft Excel enables you to create as many scenarios as you want, easily switching between the different scenarios to display the results of several what-if analyses.
When should you create a scenario instead of a data table? What types of reports can you create for scenarios? Give an example of a business situation that could best be analyzed with scenarios. 150-200 words.