Enter a formula in cell b7 on the summary

Question

INTRUSTIONS:

1. Enter a formula in cell B7 on the Summary worksheet
   1. use the 3-D cell reference to copy the grade for Alexia Woods from the ISYS 2263 worksheet
2. Enter a formula in cells B8:B26 on the Summary worksheet
   1. use a relative cell reference to copy the formula from cell B7
3. Enter a formula in cells H7:H26 on the Summary worksheet
   1. create a formula to determine (calculate) the GPA for each student
   2. the GPA is calculated by dividing the quality points by the total number of classes
      1. use the absolute cell reference for the total number of classes available from cell B3
   3. Format: Decimal Places: 4
4. Using the Rank function, enter a formula in cell I7 that will rank the GPA value
   1. Copy the formula to I8:I26
5. Enter a formula in cells B31:F35 on the Summary worksheet
   1. to determine (count) the number of A's, B's, C's, etc. for each class
6. Enter a formula in cells G31:G35 on the Summary worksheet
   1. to determine the total number of grades given in each class
7. Enter a formula in cells B37:G37 on the Summary worksheet
   1. to determine the percent of each grade given
   2. the percent is calculated by dividing the sum of the total number of grades (A's, B's, C's, etc.) by 100
8. Format cells B37:G37 on the Summary worksheet
   1. Format: Percent; Decimal Places: 1

Attachment:- Excel Assignment 1.xlsx