Page 43 - TP_Pro_V5.1_Class6
P. 43

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?       ___________
                    e.   What is the term for the rectangular area that contains the actual chart and
                       includes the plotted data?                                                       ___________
                    f.  What command do you use to change the background of a chart in Excel?           ___________


                                                                                               Charts in Excel 2021  41
   38   39   40   41   42   43   44   45   46   47   48