Page 80 - modular4.0
P. 80

Chapter Profile
                      3.  Which chart is divided into sectors where each sector shows the relative size of each value?
                          a.  Line Chart                                 b.  Area Chart

                          c.  Bar Chart                                  d.  Pie Chart

                      4.  Which tab appears when you select a chart on the sheet?
                          a.  Chart Area                                 b.  Chart Tools

                          c.  Design Tools                               d.  Format Tools
                  B.   Fill in the blanks using the words given below:


                                                Vertical, gridlines, data labels, category, scatter
                      1.  The horizontal axis of chart is known as                 axis.


                      2.                      chart show the correlations between the two sets of values.
                      3.  In a column chart, values are represented on the                  axis.

                      4.                      can be either horizontal or vertical lines depending on the selected chart type.

                      5.                      includes data values, category name, series name, legend keys and values from
                          cells.

                  C.   Write ‘T’ for true and ‘F’ for false.
                      1.  It is not possible to change the type of an existing chart.

                      2.  Gridlines makes it easier to read and understand the values of chart.

                      3.  It is possible to make 3-D Column Charts in Excel.

                      4.  Column Chart uses connecting dots to display trends over a period of time.

                  D.   Short answer type questions.

                      1.   Why are charts used?


                      2.  Which type of chart can display only one data series?



                      3.  Name the two tabs present on the Chart Tools tab.



                  E.   Long answer type questions.

                      1.   How can you change the design of your chart?









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