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.