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

.   he cell reference in a spreadsheet for cell range    to F 5 is ............................. .      S  Sample  aper
                i.     .F 5                                     ii.     F 5

              iii.    :F 5                                      iv.   -F 5
            ns.   . iv    .  iv     .  i     .  iii   5.  iii    .  ii    . iv    .  iv    . iv     . ii

               11. ii   12.  iii

        B.  Fill in the blanks.

            .   ou can use ............................. to modify existing scenarios.
            2.  Click on .............................   ............................. to open navigator window.
            3.  A ............................. feature provides a target-based result and informs the user about the changes in value in the
              applied formula
            4.  A ............................. tool is used to create a formula array in OO  alc.
            5.  A ............................. refers to a cell or a range of cells on a worksheet and can be used to find the values or data that
              you want formula to calculate.

           ns.   . Navigator                   .  iew   Navigator             .  oalSeek
                4. Multiple Operations        5. cell reference

        C.  State whether these statements are true or false.
             .   ou cannot combine more than one worksheet cell data into different sheets and use the formula.

             .  S   O    is a function listed under the Mathematical category when you use the Function  i ard.
             .   he function option in consolidate dialog box allows to select the function in the destination cells.
             .   eference option allows you to select the reference from another sheet having data.
            5.   onsolidate means to combine a number of things into a single unit.

            6.  The format of OpenO ce  alc is  .oss .

          Ans.   . False    .  rue    .  rue    .  rue   5.  rue    . False

                                                        Section B
                                               (Subjective Type Questions)

        A.  Answer the following questions:
             .   hat do you mean by  ata  onsolidation   ist the steps to consolidate data.
          ns.   ata consolidation option enables a user to collect and integrate data from multiple worksheets or workbooks
              into a single worksheet. Steps to consolidate data:
                  Open the worksheets that contain the data to be consolidated.
                   lick the   ata  menu. Select   onsolidate  from the sub-menu.
                   lick the  Source  ata  ange  dialog box. Select the source range from the worksheet to be consolidated and
                then click the   dd  button.
                  Select additional ranges from different worksheets and click the   dd  button again for each selection.
                  Select the desired function  Sum   roduct  etc.  from the  Function  box according to the type of operation to be
                performed on the data.
                  Select the target cell range in which all the data are re uired to be consolidated.
                   lick the  O   button.  he data gets consolidated.




         194       Touchpad Information Technology-X
   191   192   193   194   195   196   197   198   199   200   201