15 In cell Z3 , insert the RANK function to display the first
6.000 student ’ s rank in the class based on the student ’ s total points compared to the range of all students ’ total points . Copy the function to the range Z4 : Z21 .
16 Insert a list of range names starting in cell D3 in the 5.000
Documentation worksheet .
17 Create a footer on each worksheet with the text
6.000
Exploring Series on the left side , the sheet name code in the center , and the file name code on the right side .
18 Ensure that the worksheets are placed in the following
0.000 order in the workbook : Documentation , Grades . Save the workbook . Close the workbook and then exit Excel . Submit the workbook as directed .