Page 25 - TP_Pluse_V2.2_Class_7
P. 25

4.  Short answer type questions.
                    a.  What are gridlines?
                         ______________________________________________________________________________

                    b.  Define legend.
                         ______________________________________________________________________________

                    c.  What is Bar chart?
                         ______________________________________________________________________________

                    d.  What is Area chart?
                         ______________________________________________________________________________
                 5.  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.
                         ______________________________________________________________________________

                         ______________________________________________________________________________
                         ______________________________________________________________________________


                 6.  Competency-based/Application-based questions.

                    a.   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?
                    b.   You’re presenting your class project on how different sports teams performed
                       throughout the year. Which types of charts in Excel will help you visualise and
                       compare the performance of each team more clearly?



                                                                                      teCh Zone


                     Let's soLve
                                                                                               21 st
                                                                                             Century   #Critical Thinking
                       Solve the crossword using the clues.                                    Skills
                     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