Page 82 - modular4.0
P. 82

Chapter Profile
                3           WORKSHEET


                            (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 2019 allows you to analyse 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.  Comptency-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?





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




                80   Modular (Ver. 4.0)-VII
   77   78   79   80   81   82   83   84   85   86   87