Page 42 - Trackpad_V5_Book 6
P. 42

1.  Tick ( ) the correct option.
               a.  Which of the following is known as a vertical axis?

                   (i)  Category axis                           (ii)  Value axis
                  (iii)  Both (i) & (ii)                       (iv)  None of these

               b.  Which of the following displays the colour representation of each data series in the chart?
                   (i)  Data series                             (ii)  Horizontal axis

                  (iii)  Legend                                (iv)  Plot Area
               c.   Which chart is used to display data within a specified time period in the form of vertical bars?

                   (i)  Column chart                            (ii)  Bar chart

                  (iii)  Line chart                            (iv)  Pie Chart
               d.  Under which tab, can we change the background of the chart?
                   (i)  Home                                    (ii)  Formulas

                  (iii)  Format                                (iv)  Design

               e.  What is an effective way to display data in a pictorial form?
                   (i)  Picture                                 (ii)  Chart

                  (iii)  Table                                 (iv)  Graphics
            2.  Fill in the blanks using the words from the help box.


                                            Scatter, Column, Bar, Pie, Area

               a.  A __________ chart displays the data in the form of vertical bars.

               b.  A __________ chart displays data series in the form of comparative charts.
               c.  A __________ chart is used to display data in the form of vertical bars within a specified time period.
               d.  A __________ chart displays the quantitative magnitude of the data change over the course of time.

               e.  A __________ chart is also known as XY scatter plot chart.
            3.  Write 'T' for true and 'F' for false.

               a.  Data representation using charts is quite inefficient.


               b.  The Y-axis of a chart is also known as the category axis.

               c.  The chart area includes all objects and elements in a chart.


               d.  A doughnut chart consists of more than one data series.

               e.  We cannot create a bar chart in Excel.



             40   Pro (Ver. 5.0)-VI
   37   38   39   40   41   42   43   44   45   46   47