Part 1 You are to create a spreadsheet which will automate the computation of grades for a class. The work to be graded in the class in question consists of two tests, tow lab projects, and a final exam. Each test will count 25% of the grade; each lab project will count 10%; the final exam will count 30%. However, the instructor varies these percentages occasionally, so we'd like to construct our spreadsheet so that these values are problem parameters (as opposed to being hard-coded into formulas) which can be easily modified without changing any formulas directly. Begin by constructing a spreadsheet that will compute the weighted average for each student in the class. The spreadsheet should be constructed so that all results are automatically recalculated whenever a grade is changed. The Final display should look something like the following (use the data given here when you test your spreadsheet): Tests = Projects = Exam = 25% 10% 30% Name Bill Jones Nan Knox Jill Smith Joe Timms Test 1 80 75 83 77 Test 2 70 65 99 Project 1 90 80 89 82 Project 2 85 90 89 76 Exam 83 88 90 82 Average 79.90 78.40 90.10 82.65 92