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

Lab Assignment ‘n Activity                            I nte r - D is cip l inar y





                 Complete the following activities and tick on the circle.
                     se the Subtotal command to display the  otal Fee collected for each class.
                    lso  display  rand  otal Fee collected from all classes.

















                     sing Subtotal calculate the revenue generated from the sale of each good.

                                                 GOODS              PRICE
                                            Pen                      1000
                                            Pencil                   2000
                                            Pen                       500
                                            Pencil                   1200
                                            Pen                       500
                                            Pencil                    200



               WHAT-IF ANALYSIS

             hat-If  nalysis is the most powerful feature in spreadsheet that helps to run reverse calculations  sensitivity
            analysis and scenarios comparison.  ecision making is a crucial part of any business or  ob role.  hen we talk
            about decisions which are informed based on data  the outcome of the business or pro ect or task is always
            more in control.  hus   hat-if  nalysis is used by almost every data analyst and especially by middle to higher
            management professionals to make better  faster and more accurate decisions based on data.
             hat-If  nalysis can be done by changing the values in cells to see how those changes will affect the outcome
            of formulas on the worksheet. It includes many powerful tools to perform complex mathematical calculations
            which can help us to experiment and answer  uestions with different data  even when the data is incomplete.
            Scenario   oal Seek and Solver are the different tools of  hat-If  nalysis.


               SCENARIO

            Scenario  is  a  tool  to  test   what-if   uestions.  Scenario  is  a  set  of  values  that  spreadsheet  saves  and  can
            substitute automatically in cells on a worksheet.  ach Scenario is named and 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.
             hen the spreadsheet is printed  only the contents of the currently active Scenario are printed.  y adding a
            Scenario  arguments of a formula the new results can also be easily viewed.




                                                                       Advanced Features of Spreadsheet        165
   162   163   164   165   166   167   168   169   170   171   172