Page 152 - IT_V1.0_Class10
P. 152
Step 6: It is optional to select or deselect different check box options in the Settings section. Following
options are there in Settings section.
Following options are there in Settings section.
Display border: It is used to highlight the Scenario with a border. The colour for the border is specified
in the field to the right of this option. The border has a title bar displaying the name of the last scenario.
Here, we have selected yellow colour for Sales 1 scenario.
Copy back: It copies the values of cells that you change into the active Scenario. If you do not select
this option, the Scenario doesn't change when you change cell values.
Copy entire sheet: It copies the entire sheet into an additional scenario sheet.
Prevent changes: It is used to prevent changes to the active scenario.
Step 7: Click OK to close the dialog box. A new scenario is automatically activated. Repeat steps 1 to 6 to
create another scenario. Once the scenario is created its value can be edited and rest of the file will
automatically updated. Multiple scenarios can be seen in drop-down list.
As seen above, 3 scenarios have been created:
1. Sales 1 - with Total sales value 3,53,90,000
2. Sales 2 - with Total sales value 7,77,80,000
3. Sales 3 - with Total sales value 81,28,000
Radha can present different sales by selecting
different scenarios. It is easier to present varied
data with the help of scenarios.
WHAT-IF ANALYSIS
What-if Analysis is a powerful feature in spreadsheets that helps run reverse calculations, sensitivity analysis,
and scenario comparisons. Decision-making is crucial in any business or job role, and informed decisions
based on data ensure better control over business outcomes. Therefore, What-if Analysis is widely used by
data analysts and middle to higher management professionals to make better, faster, and more accurate
decisions based on data. What-if Analysis can be performed by changing the values in cells to see how those
changes will affect the outcome of formulas on the sheet.
Multiple Operations
Like scenarios, Multiple Operations is a planning tool for What-if questions. In a spreadsheet, you input
a formula to compute a result, based on values stored in different cells. Then, you designate a cell range
for entering fixed values, and the Multiple Operations command will generate the results according to the
formula. Unlike Scenario, Multiple Operations tool does not present the alternative versions in the same cells
or with a drop-down list. Instead, the Multiple Operations tool creates a formula array which is a separate set
of cells that give all the alternative results for the formulas used. Although the tool is not listed among the
functions, it is really a function that acts on other functions, allowing you to calculate different results without
having to enter and run them separately.
150 Information Technology Play (Ver 1.0)-X

