Using cell names defined in the previous step where applicable, write a formula in cell H4 to calculate the number of bonus points. The number of bonus points is the minimum of bonus days (G4) times bonus points per day and max bonus. Copy the formula to cells H5 to H12.

C D E F G H J K L A B Grade Calculation for Assignments 1 2 Late Days Penalty 95 0 Bonus days Bonus Points Net Score Weight Weighted Points 0.075 0.1 3 83 75 -1 0.025 96 -3 Due Date Submitted Date Raw Score 9/5/2019 9/5/2019 9/19/2019 9/22/2019 9/23/2019 9/22/2019 10/10/2019 10/7/2019 10/14/2019 10/15/2019 10/24/2019 10/31/2019 11/7/2019 11/2/2019 11/28/2019 12/10/2019 12/12/2019 12/12/2019 88 3 Item 4 Assignment 1 5 Assignment 2 6 Assignment 3 7 Assignment 4 8 Assignment 5 9 Assignment 6 10 Assignment 7 11 Assignment 8 12 Project 13 Total 14 15 Late Days 1 0.1 0.025 0.075 0.125 83 7 -5 78 90 12 0.125 0.35 92 0 Penalty #SPILL! Bonus Points 16 0 2 per Day Max Bonus 2 1 9 2 17 18 19 20 21 3 - W NPO oo ou 4 o 800 vouo 22 10 8 20 23 24 15 30