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

.   hat do you mean by   hat-If   nalysis

              ns.   hat-if analysis is a very useful feature in spreadsheets that helps to change cells values to see how those changes
                 will affect the worksheet s final outcome. One can use several different sets of values to explore all the different
                 results in one or more formulas. It helps to take decisions based on the data.  hat-if analysis is useful in many
                 situations. For example  one can predict the future values based on the given historical values
                .   hat is the use of “ ink to source data” option

              ns.   ink to source data  is an option in a spreadsheet.  hen it is selected  the values that are modified in the source
                 range are automatically and accordingly updated in the target range.

                .   hat is the use of subtotal command
              ns.   he  Subtotal  command  is  used  to  automatically  create  groups  and  apply  inbuilt  functions  like  Sum    ount
                  verage  etc.  to summarise data. For example  suppose there is a worksheet containing the list of students of a
                 school and the students belongs to four different houses. Now  if we want know how many students are there in
                 each house  we can use the Subtotal command to easily know the number of students in each house.
               5.   ow many ways to refer cells in other sheets

             Ans.  There are two ways to refer to cells in other sheets.
                      y entering the formula directly using the keyboard.
                     By using the mouse.
                 .   hat are the benefits of sharing document in  alc
              ns.  Some of the benefits of sharing documents in  alc are:
                     The document can be used by multiple users at the same time.
                      he editing or record entering process will be faster as different users can access and edit different areas of the
                   same document at the same time.
                 .   hat is the default function in function box

              ns.   he default function in the function box is  S M
                 .   xplain  Scenario
              ns.  Scenario is a tool to test  what-if    uestions. It is a set of probable values that can be substituted automatically
                 in the cells of a worksheet. One of the features of scenario is that you can create and save different groups of
                 values on a worksheet and then switch to any of these new scenarios to view different results. For example  using
                 scenario one can create a comparison chart of marks obtained by students in certain sub ects  and by changing
                 the marks in one or more sub ects  one can obtain the new average marks. One can set targets and use this tool
                 to determine how much more a student needs to score in which particular sub ect in order to meet those targets.

                 .   xplain  Multiple Operation  with the help of suitable example.
              ns.  Multiple Operations is a planning tool for  what-if    uestions  but it is different from Scenario.   multiple operation
                 combines a series of formulas with a variable and a series of values.
                   he result of each formula with each value is shown in the table.   separate set of cells give the alternative results
                 for the formulas used. For example  let s say      ompany produces toys that you sell for  s.    each  cell    .
                  ach toy costs  s.   to make  cell      in addition to which you have fixed costs of         per year  cell    .  ow
                 much profit will you make in a year if you sell a particular number of toys
                     In the sheet from the previous example  delete the contents of column  .
                      nter the following formula in  5:   5   .  ou are now calculating the annual profit per item sold. Select the
                   range   :F    thus three columns.
                     Choose Data   Multiple Operations.
                      ith the cursor in the Formulas field of the Multiple Operations dialog  select cells  5 through  5.




                                                                       Advanced Features of Spreadsheet        195
   192   193   194   195   196   197   198   199   200   201   202