In cell F4 of Grade Calculations worksheet, enter a formula using the VLookup function to determine the late penalty using the relationship between late days and penalty in cells A16 to B24. Copy the formula to cells F5 to F12.

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