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.

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.

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 formulas needed:

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.


Price: £ 45

100% Plagiarism Free & Custom Written, Tailored to your instructions

Leave your Comments


Can't read the image? click here to refresh