(Step-by-Step) Create a mock Excel spreadsheet that can be used to calculate your grade in a class. The spreadsheet should include the weights of each graded
Question:
Create a mock Excel spreadsheet that can be used to calculate your grade in a class. The spreadsheet should include the weights of each graded assignment, your grade in each assignment, and your final grade. To use this for your benefit you may want to design it so that it can be used to calculate your interim grade before you have all the grades.
Use a new sheet called "Grade Calculator" in the same Excel file that you are submitting for this assignment.
After this week you will receive the solution from your professor and you will be able to use your solution or our solution for future classes.
The Mock Grading points are as follows
| Exercise 1 is worth 13 points. |
| Exercise 2 is worth 39 points (13 points each). |
| Exercise 3 is worth 15 points. |
| Exercise 4 worth 5 points. |
| Exercise 5 is worth 15 points. |
| Exercise 6 is worth 13 points |
Deliverable: Word Document 