Answer:
Step-by-step explanation:
1. Add data into excel and name both the columns
2. Select top cell and press Ctrl+T to convert data into table
3. Click on any cell on the table and click pivot table in the 'Insert' tab. You will get a pivot table frame.
a. Which exam did most students attempt?
i. Move 'Test name' field to row in the pivot table. Also move test scores field to the value table.
ii. This by default will give you the sum of scores. Click on the field under 'value' table and change it from 'sum of values' to 'count of values' Â
The answer is GMAT taken by 13 students
b. Which exam has the highest average score?
i. From the pivot table created in part a, change the field setting to 'Average' instead of count.
The answer is GMAT with 499.07 average
c. Use the pivot table to determine the exam attempted by the student with highest score
i. In the pivot created above, change field setting to 'Max'
The answer is MCAT with 589
What is the exam attempted by the student with lowest score.
i. Change the field setting in the pivot to 'Min'
The answer is GRE with 267
