Page 48 - KEC Khaitan C6 Flipbook
P. 48

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.                                                     _____________________________






                   46   Premium Edition-VI
   43   44   45   46   47   48   49   50   51   52   53