Page 44 - trackpad v5.1 class 6 flipbook
P. 44

4.  Think and answer.
                     a.  Define a chart in Excel. Name any two of its types.

                      ______________________________________________________________________________________

                      ______________________________________________________________________________________
                     b.  List two advantages of using charts to represent data.

                      ______________________________________________________________________________________

                      ______________________________________________________________________________________
                     c.  Explain how you can update a chart when new rows and columns are added to the data range.

                      ______________________________________________________________________________________

                      ______________________________________________________________________________________
                      ______________________________________________________________________________________

                     d.  What is the purpose of gridlines in a chart?

                      ______________________________________________________________________________________
                      ______________________________________________________________________________________

                     e.  How can you move a chart in Excel?

                      ______________________________________________________________________________________
                      ______________________________________________________________________________________

                                                                                                  21 st
                  5.   Competency-based/Application-based questions.                           Century   #Critical Thinking
                                                                                                 Skills
                     a.   Aniket has a dataset that shows the sales figures for different regions over the past
                        year. He wants to display this data to highlight the relationship between sales in different
                        regions. Which chart type should he use?

                     b.   Ramesh wants to show how two different variables, such as advertising spend and sales revenue,
                        are related to each other. Which type of chart is most suitable for this purpose?

                     c.   Anjali has data on the monthly temperature and rainfall for her city over the past year. She wants to
                        analyse the relationship between temperature and rainfall to see if there is any correlation between
                        the two. Which type of chart should she use, and why?
                     d.   Manoj is a teacher who wants to track the progress of his students' scores in multiple subjects over
                        the entire academic year. He has data for each subject for every month. Which type of chart would
                        best help him identify trends and patterns in student performance over time, and why?



                                                                                                21 st
                                                                                              Century   #Media Literacy
                                                                                               Skills
                       Video based question                                                                 Scan the
                                                                                                            QR Code
                       Watch the video and answer the question.
                            Under which tab, can we change the background of the chart?







                   42   Pro (V5.1)-VI
   39   40   41   42   43   44   45   46   47   48   49