Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 45 - 2615_KEC
P. 45

    Periodic Assessment                          1

                                                      (Based on chapters A1 to A3)

                     1.  Write 'T' for true and 'F' for false.

                        a.  The Undo command in Excel allows you to reverse multiple actions.

                        b.  A formula in Excel must always start with a "+" sign.

                        c.  The Fill Handle helps to automatically enter a sequence of numbers in a column.

                        d.  A Pie Chart is the best option to compare data between different categories.

                        e.  The function =SUM(A1:A5) will multiply the values in the given range.

                     2.  Match the following:

                        a.  Absolute Reference                      i.  Used to find the total of a given range

                        b.  MAX() Function                          ii.  Displays the relationship between two variables

                        c.  Scatter Chart                          iii.  Refers to a fixed cell using $ sign

                        d.  AutoFill                               iv.  Finds the highest value in a selected range

                        e.  SUM() Function                          v.  Helps in copying patterns in a sequence

                     3.  Name the following:

                        a.                                                     _____________________________

                        b.                                                     _____________________________

                                                                                                 Periodic Assessment 1  43

| 40 41 42 43 44 45 46 47 48 49 50 |