Page 220 - TP_IT_V1.0_C10_flipbpookl
P. 220

Short key  To access the Navigator
                                                                                            pane:


                                                                                                       Alt +
                                                                                                 F5 +
                                                                                                               4


              If you click on each scenario the corresponding marks of the Unit Test, Term 1 Exam and Term 2 Exam changes and on
              that basis the Total Marks will be calculated and displayed. The set of four scenarios with the corresponding set of cells
              are displayed below:





































                      USING WHAT IF ANALYSIS

              What-If analysis involves exploring how changes in input variables affect the results of a formula or model. This analysis
              can be conducted with one input variable (one-input analysis) or two input variables (two-input analysis).
              The description of each input is as follows:




                218   Trackpad Information Technology (Ver. 1.0)-X
   215   216   217   218   219   220   221   222   223   224   225