Page 81 - modular4.0
P. 81

Chapter Profile
                     2.  Name and explain any three types of charts available in Excel.







                     3.  Define Legend.








                                                                                                 21 st
                 F.   Competency-based/Application-based questions.                            Century   #Information Literacy
                                                                                                Skills
                     1.   Kriti wants to represent the statistical data of her company in the form of shares.
                         She aims to display a single data series in a circular format. Which specific chart
                         should she use for this?
                     2.   Advit is analyzing the relationship between advertising spend and sales revenue
                         for a particular product.  He  wants  to see if  there is a correlation between  these  two  variables.
                         Which chart would you recommend for Advit’s analysis?



                                                                                                21 st
                 In the Lab                                                                  Century   #Technology Literacy
                                                                                               Skills
                   Create the following worksheet:











                    (i)  a.  Create a column chart based on the above data.  (B2 to G6)
                        b.  Give the title as Marksheet.
                        c.  Place the legend on the right side of the chart.
                        d.  Display the gridlines.
                    (ii)  a.  Use formula to calculate total and percentage.
                        b.  Create a pie chart showing the name and percentage of students.
                        c.  Display the data labels.




                   Teacher's Corner

                      Describes the different types of charts provided by Excel 2019 to the students.
                      Talk to the students about the different styles which can be applied to a chart.




                                                                                                      Charts in Excel  79
   76   77   78   79   80   81   82   83   84   85   86