Page 25 - Plus_V2.2_C7_Flipbook
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