Page 154 - Plus_V2.2_C7_Flipbook
P. 154

https://www
                                                                PROJECT







                     A.   In Excel, create a tabular data of 5 of your friends' marks obtained in the previous exams
          https://www                                                                                                      https://www
                        and plot a graph for the average marks and the average percentage obtained for each of
                        them. Here is an example dataset.
                                                                                                      Subject Enrichment







          https://www                                                                                                    https://www















                                                                                                       Subject Enrichment
                     B.  Make the following table in Excel.




























                        •    The formula for calculating average has been shown in the first cell.
         https://www                                                                                                      https://www
                        •    Calculate averages for all the players using the formulas.

                        •    Calculate grand total of runs scored by all the players.

                        •    Create a pie-chart of the average runs scored by the players.






                  152   Premium Edition-VII
   149   150   151   152   153   154   155   156   157   158   159