Page 78 - TP_Modular_V2.1_Class7
P. 78

Worksheet  3

                                                     (Based on chapters 6 & 7)


                  A.  Rewrite the incorrect statements.

                     1.   Data validation means to allow the user to enter the entire range of values in a particular cell or a
                         range of cells.

                        .....................................................................................................................................................................................................
                     2.  The Pivot Table feature of Excel 2016 allows you to analyze only small amounts of data.

                        .....................................................................................................................................................................................................

                     3.  Bar Chart is used to display the quantitative magnitude of the data graphically.
                        .....................................................................................................................................................................................................

                     4.  In-built chart styles are listed under Home tab.
                        .....................................................................................................................................................................................................

                     5.  Conditional Formatting command is present under Data tab.
                        .....................................................................................................................................................................................................

                  B.  State the use and one example of each.

                     1.  Column chart               ...........................................................................................................................................
                     2.  Pie chart                  ...........................................................................................................................................

                     3.  Area chart                 ...........................................................................................................................................

                     4.  Bar chart                  ...........................................................................................................................................
                     5.  XY Scatter Plot chart      ...........................................................................................................................................


                  C.   Match the following columns:
                        Column A                             Column B
                     1.  X-axis                          a.   includes data values, category name, series name, etc.

                     2.  Y-axis                          b.    key which shows the meanings of symbols and colours
                                                             used in the chart

                     3.  Legend                          c.   category axis
                     4.  Chart Area                      d.   value axis

                     5.  Data Labels                     e.   includes all objects and elements in a chart

                  D.  Competency-based/Application-based question.

                      Sanjay is preparing an analysis sheet for his office. He wants to present information by showing
                      names of salesmen making maximum sales to those making minimum sales. How can he do so?

                     ...........................................................................................................................................................................................................

                   76       Modular (Ver. 2.1)-VII
   73   74   75   76   77   78   79   80   81   82   83