Page 50 - TrackpadV5.1_class7
P. 50

Periodic Assessment                           1

                                                     (Based on chapters 1 to 3)

                  1.  Match the following:

                     a.  (11111)                           (i)  (10111)  2
                              2


                     b.  (23)                              (ii)  (49) 10
                            10


                     c.  (35)                             (iii)  (31)
                                                                   10
                             8
                     d.  (110001)                         (iv)  (11101) 2
                                 2

                  2.  Write the purpose of the following functions:
                     a.  IF()

                        ___________________________________________________________________

                     b.  SUM()
                        ___________________________________________________________________

                  3.  Guess! Who am I?

                     a.  I am a group of the Home tab that contains the Sort & Filter command.           __________
                     b.  I am a feature in Excel to separate unwanted data from a range of data.         __________

                     c.   I am a feature in Excel to arrange data in ascending or descending order.      __________

                     d.  I am a type of formatting that can be applied on the basis of criteria.         __________
                  4.  Match the functions with shortcut methods of doing it:

                     1.   Panning                         a.   Hold down Spacebar + Ctrl to turn your cursor into a
                                                             magnifying glass. Now drag your pen up and down to

                                                             zoom your canvas in and out.
                     2.  Changing brush size              b.   Hold down the Ctrl key to turn your cursor into an eye
                                                             dropper. Now tap the pen on the canvas, the colour that
                                                             is underneath will be picked up for you to use.

                     3.  Colour Selecting                 c.   Hold down the Spacebar key to turn your cursor into a
                                                             hand. Now drag your pen around to move the canvas
                                                             left, right, up, or down.

                     4.  Zooming in/out                   d.   Activate the Freehand Brush tool from the Toolbar. Now
                                                             hold down Shift + drag your pen left or right, your brush
                                                             size will adjust until you lift your pen.




                   48   Pro (V5.1)-VII
   45   46   47   48   49   50   51   52   53   54   55