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
   147   148   149   150   151   152   153   154   155   156   157