Page 391 - Computer Software Application TP - Volume 1
P. 391
COMPUTER SOFTWARE APPLICATION - CITS
3 View Different Scenarios
So far, you have saved all of those 3 scenarios in your workbook. If you go to the Data tab and click on What-If
Analysis in Forecast Group, then choose Scenario Manager in the drop-down, you will see the same Scenario
Manager dialogue box as that is shown in the below screenshot.
The Scenario Manager dialogue box is no longer blank. Now you can view the result from each of the scenarios
by simply double-clicking on any scenario.
To view a specific scenario and its corresponding outputs, you can click on that scenario and then click
on the Show button at the bottom. For example, if we double-click on Best Case, the input values in the
Excel worksheet will change into what has been filled for Best Case, and the output value will be calculated
automatically based on the formula in cell B7. The dataset will change automatically.
376
CITS : IT & ITES - Computer Software Application - Exercise 65
