Page 44 - KEC Khaitan C6 Flipbook
P. 44

1.  Tick ( ) the correct option.
                     a.   Choose among the following, which chart type is used to display data in the form of long rectangular
                        rods?
                         (i)  Column Chart                            (ii)  Bar Chart

                        (iii)  Line Chart                            (iv)  Pie Chart
                     b.  Find out the component of a chart that describes the main purpose and content.
                         (i)  Legend                                  (ii)  Data Series

                        (iii)  Title                                 (iv)  Gridlines
                     c.  Name the tab you select for changing the type of an existing chart in Excel.

                         (i)  Insert                                  (ii)  Design
                        (iii)  Format                                (iv)  Chart Design
                     d.  What is the first step in creating a chart in Excel?

                         (i)  Click on the Insert tab                 (ii)  Select the data range
                        (iii)  Choose the desired chart              (iv)  Click on the Chart Design tab

                     e.  Tell the name of the chart, which is shaped like a circle divided into slices.
                         (i)  Area Chart                              (ii)  Doughnut Chart
                        (iii)  Pie Chart                             (iv)  Scatter Chart

                  2.  Fill in the blanks using the words from the help box.

                                                   Shift, Line, X, Gridlines, Legend


                     a.  The ______________ axis is also known as the category axis.

                     b.  A ______________ chart displays continuous data at regular intervals.
                     c.  The ______________ of a chart displays the symbols or colors used in the chart.

                     d.  ______________ can be either horizontal or vertical lines that make it easier to read and understand
                        values in a chart.

                     e.   To resize a chart proportionally, select the chart then press and hold the ______________ key while
                        dragging.
                  3.  Answer in one or two words.

                     a.  What is another name for the Y-axis in a chart?                                 ___________
                     b.  Which type of chart is also known as a frequency polygon?                       ___________

                     c.  Which chart displays the relationship of parts to a whole?                      ___________
                     d.  Which chart type is used to show correlations between two sets of values?       ___________






                   42   Premium Edition-VI
   39   40   41   42   43   44   45   46   47   48   49