Suppose you are working as an internee in examination department of Virtual University of Pakistan. Your supervisor gives you graded papers of five subjects of a class and asks you to compile this data and prepare result for the class using MS Excel. You are required to
- Arrange data in spreadsheet in rows and columns showing student name and each subject’s marks.
- Calculate Sum of each student marks using Sum formula (Do not use AutoSum ∑).
- Calculate Average of each student marks using Average formula.
- Develop a bar chart showing total marks and average of each student.
Your compiled and prepared Result should look like the following image.
Solution: Download Complete Solution HereDOWNLOAD SOLUTION HERE