Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 50 - 2633 Trackpad Pro V5.1 Class 7
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   Premium Edition-VII

| 45 46 47 48 49 50 51 52 53 54 55 |