2 Sort the values in the Campus column using a custom
9 sort order list. Use the following order: Valley, Park, and thenWest.
3 Sort the Sport Group column in ascending order as a
6 second level sort in the table, and then sort the Program Name column in ascending order as a third level sort in the table.
4 Convert the table to a range. 4
5 Display the Sports Season Comparison worksheet.
9
Name the range A2: F3 using the name Criteria. Name the range A6: F15 using the name Database, and then name the range A18: F18 using the name Extract.
6 In cell D3, type Fall and in cell E3, type Summer.
8
Create an advanced filter that will copy all records from the Database range with Fall as their primary season