Exam 3: Data Visualization

The data on the scores obtained by students in 5 different entrance exams have been collected from 50 colleges and they are provided below. Create a PivotTable in Excel to display the number of students who had taken up each exam and the average score for students in each exam. a. Which exam did most students attempt? b. Which exam has the highest average score? c. Use the PivotTable to determine the exam attempted by the student with the highest score. What is the exam attempted by the student with the lowest score?