Question

Pivot Table: Which department has the highest average score? (Hint: the quickest way is to use pivot table to analyze the average by department, and then choose the highest)

Allen, Michael	Marketing	87
Angelo, Michael	Finance	86
Aniston, Jen	Finance	80
Bolton, Aaron	Marketing	75
Canada, Rain	Finance	70
Geller, Rose Ann	Management	85
Jordan, Hector	Accounting	88
Lopez, George	Finance	79
Lopez, Maria Angela	Accounting	86
Lu, Lucy	Finance	80
Nakamoto, Derian	Management	69
Ng, Carline	Accounting	79
Oh, Sunwon	IMS	87
Olof, Snow	Finance	84
Omaha, Lincoln	Finance	80
Park, David	Finance	90
Santiago, Ellie	Finance	65
Wu, Frank	Finance	63
Wu, Yiwei	IMS	80

Answer 1

Based on the information available in the question, the Pivot table is as follows:-

Based on the data above, the Department that has the highest Average score is Accounting. Accounting has an average score of 84.33