Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 154 - 2626_South Point_C-7
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 |