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

  Display border: It is used to highlight the Scenario with a border.  he colour for the border is specified in
              the field to the right of this option.  he border has a title bar displaying the name of the last 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 6:   lick  O   to close the dialog box.   new Scenario is automatically activated.  epeat the steps to
                    create  another Scenario.



                                                                         6




































































                                                                       Advanced Features of Spreadsheet        167
   164   165   166   167   168   169   170   171   172   173   174