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

ii.   nter the formula for less marks than target in     calculating the difference of obtained marks and target
                   marks using difference probability
                 iii.   olumn F will hold the marks above or below target.
                 iv.  Calculate the percentage of alternate marks obtained that get displayed in column   and column F will hold
                   the marks above or below the obtained marks.
              ns.  i.   ight click the mouse on the column header of column  . Select the   elete  olumn  option.  he contents
                   of column   get deleted.  ight click the column header of column  . Select  Insert  olumn  option.   new
                   column gets inserted.
                 ii.
                 iii.  o be filled according to user s choice.
                 iv.           5       F      5



            Unsolved Exercise


                                                         Section A
                                                (Objective Type Questions)
            A.  Multiple choice questions:
                .   hich of the following functions are available in consolidate window
                   i.  Max                                         ii.  Min
                   iii.  ount                                      iv.  ll of the above

                .   hich of the following are the different tools of  hat-if  nalysis
                 i.  Scenario                                      ii.  Goal Seek
                   iii. Solver                                     iv.  ll of these
               3.  Scenarios are tool to test .............................  uestions.       S  Sample  aper
                 i.   Auto                                         ii.  Goal Seek
                   iii.   hat-if                                   iv.  rop  own
                .   yperlink in  alc can be used
                   i.  to  ump from one sheet to another sheet.
                   ii.  to  ump from one sheet to website
                   iii. to  ump from one section to another section of same sheet
                   iv.  ll of the above

               5.  Hyperlink icon is present on ............................. .
                   i.  Format  oolbar                              ii.  Standard  oolbar
                   iii. Menu  ar                                   iv. None of these
               6.  ............................. is specifically designed to minimise or maximise the result according to a set of rules that you
                 define in a spreadsheet.                                                   S  Sample  aper

                 i.  Goal Seek                                     ii.  Scenario
                   iii.  Solver                                    iv. Subtotal
               7.  ............................. is a tool to test “what-if”  uestions.       S  Sample  aper
                   i.   Scenario                                   ii.  Solver
                   iii. Macro                                      iv.  verage





         198       Touchpad Information Technology-X
   195   196   197   198   199   200   201   202   203   204   205