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

.  In  alc  to create the reference with the mouse:
                a    oth Spreadsheets need not be open      b   Select the cell in which the formula is going to be entered
                c    here is no need of symbol              d    ell reference is not re uired

          ns.   b
          14.  ............................. can be used in  alc to  ump to a different location from within a spreadsheet and can lead to other
              parts of the current file  to different files or even to websites.
                a    ables                                  b    oal Seek
                c    uto Sum                                d    yperlinks
          ns.   d

           5.   Statement I:   he data from the consolidation ranges and target range are saved when you save the worksheet.
               Statement II:  If you later open a worksheet in which consolidation has been defined  this data will not be available
                          again.
                 onsider above two statements  identify the correct one.
                a   Statement I is wrong                    b   Statement II is wrong
                c    oth the Statements I and II are wrong    d    oth the Statements I and II are correct

          ns.   b
            .  In Spreadsheets
                Statement I:     o consolidate by row labels or column labels  the label must be contained in the selected source ranges.
                Statement II:   he text in the labels must be identical  so that rows or columns can be accurately matched.
                Statement III:  If the row or column label does not match any that exist in the target range  it will be appended as
                          a new row or column.

                 onsider the above three statements  identify the correct one.
                a   Only Statements I and II are correct    b   Only Statements II and III are correct
                c   Only Statement II is correct            d    ll the Statements are correct

          ns.   d
            .   ohan has 5      that he wants to invest in two mutual funds for one year. Fund   is a low risk fund with
              interest rate and Fund   is a higher risk fund with     interest rate.  hich feature of spreadsheets   alc  will be
              help him to decide
                a   Solver                                  b   Subtotal
                c    inking sheets                          d   Macros
          ns.   a
          18.  .............................  is  one  of  the  functions  available  in  the  spreadsheet  to  perform  addition  of  selected
              numbers in the sheet.
          ns.  S M
            .   utosum automatically selects the values around the cells either ............................. or ............................. .
         Ans.  rowwise, columnwise

            .   iven the following Spreadsheet  write the appropriate Formula  xpression Function to be used for  a  to  e :
















         202       Touchpad Information Technology-X
   199   200   201   202   203   204   205   206   207   208   209