Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 33 - 2612 Digimind C6
P. 33

    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.  Define a chart in Excel. Name any two of its types.

                         ______________________________________________________________________________________

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

                         ______________________________________________________________________________________

                         ______________________________________________________________________________________
                        c.  What is the purpose of gridlines in a chart?

                         ______________________________________________________________________________________
                         ______________________________________________________________________________________

                        d.  How can you move a chart in Excel?

                         ______________________________________________________________________________________
                         ______________________________________________________________________________________

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

                         ______________________________________________________________________________________
                         ______________________________________________________________________________________

                         ______________________________________________________________________________________

                                                                                                    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?

                                                                                                   Charts in Excel 2021  31

| 28 29 30 31 32 33 34 35 36 37 38 |