Page 151 - IT_V1.0_Class10
P. 151
21 st
Lab Assignment ‘n Activity Century #Technology Literacy
Skills
Complete the following activity and tick the circle.
Use the Subtotal command to display the total number of students in each grade
level. Also, display the grand total number of students in the entire school.
WHAT-IF SCENARIOS
Scenario is a set of cell values that can be used within your calculations in a spreadsheet. Each Scenario is
named, can be edited and formatted separately, and can be chosen from a drop-down list in the Navigator
and the title bar of the Scenario. When the spreadsheet is printed, only the contents of the currently active
Scenario are printed. By adding a Scenario, you can easily view new results for the arguments of a formula.
You can create several scenarios for any given range of cells. It is used to explore and compare various
alternatives under changing conditions. At the start of any project, this tool helps optimise the output by
predicting results based on varying inputs. This allows for selecting the best course of action. For example,
Radha is a saleswoman in a car showroom. She is asked to plan for sales for the next quarter by building
multiple scenarios under different situations.
Create a table in Calc as below and add multiple scenarios based on number of cars that she will be able to
sell for each of the car models. To create a Scenario:
Step 1: Select the cells that contain 2
the values which will change
between scenarios. To select
multiple cells, hold the Ctrl key
and then click on each cell.
Step 2: Click on Tools menu.
1
Step 3: Select Scenarios option. Create
Scenario dialog box appears on
the screen.
Step 4: Type a name for the new scenario.
This name will be displayed on 3
the title bar of the scenario on
the sheet itself. By default the name of the scenario is SheetName_Scenario_1.
Step 5: In the Comment section, you may write any comment to explain the given scenario. Here for Sales 1
we have given a comment as “Expected minimum sales with no festivities”.
Analyse Data using Scenarios and Goal Seek 149

