Page 75 - TP_Modular_V2.1_Class7
P. 75

Exercise




                 A.  Tick ( ) the correct option.
                    1.  Which of these is the vertical axis that is used to plot the values?

                       a.  Bar                                        b.  Data

                       c.  Value Axis                                 d.  Plot Area


                    2.  Which of the following is the rectangular area bounded by the two axis?
                       a.  Plot Area                                  b.  Chart Area

                       c.  Gridlines                                  d.  Value Axis


                    3.  Which of the following charts is used to display the quantitative magnitude of the data graphically?
                       a.  Bar chart                                  b.  Area chart

                       c.  Column chart                               d.  Scatter Chart


                    4.  Which one of these tabs contains the Change Chart Type command?
                       a.  Design                                     b.  Layout

                       c.  Format                                     d.  All of these


                 B.  Fill in the blanks using the words given below:


                                              Legend, Scatter, Chart styles, Design, Column chart


                    1.  The ............................... chart usually displays the data in the form of vertical bars.

                    2.  ............................... is a key which shows the meanings of symbols and colours used in the chart.

                    3.  ............................... charts also known as XY scatter plot charts.

                    4.  The ............................... tab is used to change the design of a chart in Excel 2016.
                    5.  Excel 2016 has some in-built ................................

                 C.  Write ‘T’ for true and ‘F’ for false.

                    1.  We cannot create Bar chart in Excel 2016.                                          .....................

                    2.  Excel does not provide any tool to improve the appearance of a chart.              .....................
                    3.  Plot area of a chart is the rectangular area bounded by the two axis.              .....................

                    4.   The bar chart displays the data in the form of long rectangular rods also         .....................
                       called bars.





                                                                                              Charts in Excel     73
   70   71   72   73   74   75   76   77   78   79   80