How do you set up spreadsheet that automatically calculates your grade in this class as you enter the grades that you receive. It should include: 1) the weights of each graded assignment,2) your grade in each assignment, and 3) your final grade.Be sure to label everything: such as the places where the information, is stored; the names of each assignment; and where to add the actual grades that you receive. Make this sheet user friendly; especially for users that see the sheet for the first time. 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.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. To test your calculator, make up grades for all assignments. This will allow you to test it and make sure that you get the correct final grade. 1) "give yourself" 85 on all assignments, make sure the final is 85. Now change all grades to 90 and verify that your final grade is 90. 2) Next change one of the quizzes from 90 to 80, and make sure the final grade is lower. 3) Then change the 80 back to 90 and change the mid term grade to 80. Make sure that the result is different.