The Professor’s computer crashed and all that is left of the grades
for the semester is this screenshot. You have been hired to recreate
this worksheet and rebuild all the formulas. Here is a list of the
Part 1: Cell E8 – Average for grades titled Assignment 1 through Assignment 3.
Part 2: Cell I8 – Total of grades titled Lab 1 through Lab 3.
Part 3: Cell M8 – Total Points – The total points are based on the
averages for Assignments, Labs, Midterm, & Final — Be sure to use
the chart in cells O2:P6 for the weight of each category.
Part 4: Cell N8 – Letter Grade – write a formula that will take the
total points and assign a letter grade. The grading scale is included
below. Do not forget to use absolute references where needed.