Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 43 - 2615_KEC
P. 43

    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  41

| 38 39 40 41 42 43 44 45 46 47 48 |