Page 168 - IT 402 v2.0 class 10
P. 168

et s say you are working in a car showroom in the sales department.  ou are given a task to plan the sales for
        the next  uarter by building multiple scenarios and preparing a comparison of all the scenarios.

         ou make a model as below and create multiple scenarios based on number of cars that you will be able to
        sell for each of the car models.  o create a Scenario:

        Step 1:  Select the cells that contain the values which will change between scenarios.  o select multiple cells
                hold  the   trl  key and then click each cell.
        Step 2:  Click on 'Tools Menu.
        Step 3:  Select ‘Scenarios’ option.








                                                                                       2
























         reate Scenario  dialog box appears on the screen.

        Step 4:   ype a name for the new scenario.  his name will be displayed on the title bar of the scenario on the
                worksheet itself.
        Step 5:   lick on  O  button. It is also optional to select or deselect the options in the  Settings  section.
                Following options are there in  Settings  section.



                                                                                              5
                          4






















         166       Touchpad Information Technology-X
   163   164   165   166   167   168   169   170   171   172   173