C. Following the given instructions, create a grade calculator using MS Excel. The grade calculator should allow you to enter your assignment marks/ grades and calculate your overall grade for a specific course.
∙ Create a new Excel workbook and name it "Grade Calculator."
∙ Set up the following column headers in cells A1 to C1:
∙ A1: Assignment Name, B1: Max Score, C1: Your Score
∙ In the subsequent rows, enter the names of the assignments, their maximum scores, and obtained scores.
∙ Create a formula in column D (cell D2) to calculate the percentage for each assignment using the formula: (Your Score / Max Score) * 100.
∙ Create another column (column E) and use conditional formatting to assign letter grades based on the following scale:
∙ 90 or above: A, 80-89: B, 70-79: C, 60-69: D, Below 60: F
∙ In cell E1, enter "Grade" as the column header.
∙ Calculate the overall course grade by averaging the percentages of all assignments. Place this average in cell D6 and apply appropriate formatting to display it as a percentage.
∙ Calculate the corresponding letter grade for the overall course grade in cell E6 using the same conditional formatting rules mentioned above.
∙ Save the Excel workbook with an appropriate name.