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

