This is the question in my homework.
1. Basic Excel Operation:
Please make an Excel spreadsheet that can be used to calculate your grade in this 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.
I have created the table in excel with the assignments, what percentage they are worth and a colum for the grade that I earn. I am not sure what I am suppposed to do next though in excel to design it so my interim grade will show as I recieve grades during the course.
I am not intending on submitting anyone elses work for my own. I simply need some help trying to understand what steps I need to take in excel after I have created my initial table. That is why I put the entire question, I thought that context would be important.