Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 26 - 2607_Trackpad_Pro_5.1_flipbook_C6
P. 26

    1.  Tick ( ) the correct option.

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

                            (iii)  Table                                 (iv)  Graphics

                         b.  Which of the following is known as a vertical axis?
                             (i)  Category axis                           (ii)  Value axis

                            (iii)  Both (i) & (ii)                       (iv)  None of these
                         c.  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
                         d.   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
                         e.  Under which tab, can we change the background of the chart?

                             (i)  Home                                    (ii)  Formulas
                            (iii)  Format                                (iv)  Design

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

                                               Bar, pie chart, Gridlines, Scatter, informative

                         a.  __________ can be either horizontal or vertical lines depending on the selected chart type.
                         b.  A __________ chart displays data series in the form of comparative charts.

                         c.  A chart is more __________ and enables us to take instant decisions by analysing the data easily.
                         d.  The __________ only displays one data series in the form of comparative charts.
                         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.

                       24   Premium Edition-VI                                                                                                                                                                                Charts in Excel 2021  25

| 21 22 23 24 25 26 27 28 29 30 31 |