Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 25 - 2626_South Point_C-7
P. 25

    4.  Match the columns.
                           Column A                                    Column B

                        a.  Area chart                            (i)  Trends over a period of time

                        b.  Pie chart                             (ii)  Quantitative magnitude of data
                        c.  XY Scatter Plot Chart                 (iii)  Sector showing relative size of each other

                        d.  Line chart                            (iv)  Correlation between two sets of values

                     5.  Short answer type questions.
                        a.  What is a chart? Explain briefly.
                             ______________________________________________________________________________

                        b.  Define legend.
                             ______________________________________________________________________________

                        c.  What is Bar chart?

                             ______________________________________________________________________________
                        d.  What is Area chart?
                             ______________________________________________________________________________

                     6.  Long answer type questions.

                        a.  What are the differences between line chart and XY scatter chart?
                        b.  Explain any 5 components of a chart.

                        c.  Write the steps to change the chart type.

                                                                                            fun Zone

                         Let's soLve                                                                   Experiential Learning
                        1.   Application based question.

                             Suman wants to present the information in the form of a chart. She has a data of single series
                           and the graph must show relative circular size of each value. Which chart type must she use?

                        2.   Solve the crossword using the clues.                                          Critical Thinking

                           Down:

                           1.  It helps us to represent data pictorially.
                           2.  This contains the actual chart and its other components.

                                                                                                  Charts in Excel 2016  23

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