Inserting Tables in Excel Exercises
1.) Input the data
2.) Use the AutoSum function to AVERAGE the
grades for Zoe.
3.) Use AutoFill to get the AVERAGE for all of the
other students’ grades
4.) Select the data you’ve typed, then insert a table
5.) Using the AutoFilter button at the top of
column A, SORT the students’ names in
alphabetical order ( A—Z)
Supporting files:
Tip Type: