Page 30 - 2403_Trackpad_V5.1_C6_Fb
P. 30

Periodic Assessment                           1

                                                     (Based on chapters 1 & 2)

                  1.   Define the following components of a chart:
                     a. Legend

                        ______________________________________________________________________________
                        ______________________________________________________________________________

                     b. Gridlines
                        ______________________________________________________________________________

                        ______________________________________________________________________________

                     c. Plot Area
                        ______________________________________________________________________________

                        ______________________________________________________________________________
                  2.  Identify the type of referencing used in the following:

                     a. = A2 + B2           ____________________________________________________

                     b. = $C$1 - $D$1       ____________________________________________________
                     c.  =($B3*$C3)*$E1     ____________________________________________________
                     d.  = C2 * F2          ____________________________________________________

                  3.  Look at the given chart and answer the following questions:

                                                            The Fault in our Stars














                                                    October  November  December  January  February

                     a. In which month were the sales of ‘The Fault in our Stars’ highest?           ______________
                     b. In which month were the sales of ‘The Fault in our Stars’ lowest?            ______________

                  4.  Guess! Who am I?
                     a. I help you represent data pictorially.                                       ______________

                     b. I am also known as XY plot chart.                                            ______________
                     c.  I am an operator used to do basic mathematical operations.                  ______________

                     d. I am a predefined formula in Excel.                                          ______________
                     e.  I am a sign used to start a formula.                                        ______________


                   28   Premium Edition-VI
   25   26   27   28   29   30   31   32   33   34   35