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

.   rite the complete procedure to use solver in OO  alc.

            .   hat is difference between relative and absolute hyperlink
            .  Mention any two operations that can be performed using Macros in a spreadsheet.      S  Sample  aper
              .  hat do you mean by  yperlinks in Spreadsheets   ive the two different types of  yperlinks that can be used in
              Spreadsheets.                                                                 S  Sample  aper
              .  nshita is preparing spreadsheet notes for her  erm  xam.  elp her to write short note on the following:
                                                                                            S  Sample  aper
             i.  Scenarios                                         ii.  Goal Seek
             iii. Solver                                           iv.  Subtotal

        B.  Application based questions:
             .   nter following data into worksheet and compute strike rate of batsman:        Cr itical   T h ink ing

                             uns Scored                                     80
                             alls Faced                                     77
                            Strike Rate                                   103.90

              he formula for strike rate is:   cell    cell
             Now find out the strike rate for following data and give them proper names and comments.
              i.   hen score is 55 and balls faced are   .
              ii.  hen score is    and balls faced are   .
              iii.  hen score is  5 and balls faced are   .
             .  Sunita is making a pro ect in spreadsheets. She wants to rename a spreadsheet as it will help her identify the
              worksheet data easily.  hich option should she use to solved her problem

        Previous Years’ Questions



           1.    colored border  with .............................  appears around a cell where changes are made in a shared worksheet.

                a   a dot in the upper left-hand corner     b   a dot in the lower left-hand corner
                c    a cross in the upper left-hand corner    d   a cross in the upper right-hand corner

          ns.   a
            2.  ............................. feature adds data arranged in a group of cells in  alc  with labels for columns and or rows.
                a    verage                                 b   Subtotal
                c     oal Seek                              d   Solver
          ns.   b
            3.  A ............................. refers to a cell or range of cells on a worksheet whose data values can be used in a formula.

                a   sheet                                   b   cell
                c    cell reference                         d   cell data
          ns.   c
            4. ............................. feature of  alc is used to test  what-if   uestions.
                a   Solver                                  b    oal Seek
                c    Scenario                               d   Styles
          ns.   c




         200       Touchpad Information Technology-X
   197   198   199   200   201   202   203   204   205   206   207