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