Page 45 - KEC Khaitan C6 Flipbook
P. 45

e.   What is the term for the rectangular area that contains the actual chart and
                       includes the plotted data?                                                       ___________
                    f.  What command do you use to change the background of a chart in Excel?           ___________

                 4.  Think and answer.
                    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.   Your school conducted a survey on students favourite sports. How would you represent this data
                      visually using excel charts.

                     ______________________________________________________________________________________
                     ______________________________________________________________________________________





                                                                                               21 st
                                                                                            Century   #Media Literacy
                                                                                              Skills
                      Video based question                                                                 Scan the
                      Watch the video and answer the question.                                             QR Code

                          Under which tab, can we change the background of the chart?








                                                                                             21 st
                    LAB ACTIVITY                                                          Century   #Technology Literacy
                                                                                            Skills
                    Visit your computer lab and perform the following actions:
                    ▶  Open MS Excel and perform the following tasks:
                         Enter the following data in Excel:

















                                                                                               Charts in Excel 2021  43
   40   41   42   43   44   45   46   47   48   49   50