A Scenario is a set of values that Excel saves and can substitute automatically in cells on a worksheet. You can create and save different groups of values on a worksheet and then switch to any of these new scenarios to view different results.
To use Scenario in MS Excel, do the following:-
1. On the Data tab, in the Forecast group, click What-If Analysis.
2. Click Scenario Manager. The Scenario Manager Dialog box appears.
3. Add a scenario by clicking on Add button. The add scenario dialog box appears.
4. Type a name of scenario and select Changing cells (A4 :A8) and click on OK.
5. Enter the corresponding value and click on OK again. Finally, your Scenario Manager should be consistent in scenario dialog box.
6. If we see the result of a scenario, select the scenario and click on the Show button. Excel will change the value of cell A4: A8) accordingly for you to see the corresponding result on the sheet.
0 Comments:
Post a Comment