Instructions

For safety, save your Excel Workbook every few minutes.

Instructions for Student Worksheet (7 points)

Enter the formula for the Test Average in G4 and then copy it down Row G (1 point)

Enter the formula for the Semester Average (Exam Weight 1 * Test Score 1 + Exam Weight 2 * Test Score 2 + Exam Weight 3 * Test Score 3 + Exam Weight 4 * Test Score 4) in cells I4:I17. (2 points)

Use an IF statement to calculate the HW Bonus in Column J. 3 points if the homework is ok and zero points if the homework is poor. (1 point)

Calculate the Final Grade = Semester Average + Homework Bonus (1 point)

Enter forumulas for Averages, Highest Grades and Lowest Grades in Columns Test 1, Test 2, Test 3, Test 4, and Final Grade. (2 points).

Instructions for Goal Worksheet (3 points)

Your goal is to have $1,000,000 at age 65. This result should appear in cell E56 on the Goal worksheet

Your assignment (for three points) is to use Goal Seek to change the Savings amount in cell b9 to achieve this result.