8
Using the range $A$11:$H$50, insert a PivotTable in
5.000
cell A10 on the Analysis worksheet.
9
On the Analysis worksheet add Subject, LastName, and
TotalSessions to the PivotTable. Move Subject to the
COLUMNS area. Right-click cell H12, point to Sort, and
then sort the data in descending order. Apply Pivot Style
Medium 16 to the PivotTable. View the data in the
PivotTable to answer question 1. In cell A2, type the
student’s last name who attended the most tutoring
sessions. In cell B2, type the student’s last name with
the second highest number.
10.00
0