Using the data set attached, create a PivotTable using MS Excel to summarize the given data.

Employee Gender Years of Service With internet connection? Age Group 1 F 17 Y 41-45 2 F 6 N 26-30 3 M 8 Y 31-35 4 F 8 31-35 M 16 36-40 F 21 51-55 M 27 51-55 F 7 26-30 LO M 8 31-35 10 M 23 41-45 11 F 9 31-35 12 F 8 26-30 13 8 26-30 14 M 26 46-50 15 F 9 26-30 16 F 9 26-30 17 M 19 36-40 18 M 5 36-40 19 M 19 51-55 20 M 20 46-50