Last Name First Name UserID Test 1 Test 2 Test 3 Test 4 Average Grade Redfield Logan OGLD 94 89 91 90 94.73 A Goodwin Jon ONIN 97 90 87 93 94.68 A Verma Zaniyah 91 88 90 98 Ahmad Kalel 92 87 89 90 Jurecki Oaklee 83 85 97 80 Krueger Mohamed 85 79 94 82 Wood Tristian 88 96 79 79 McMillan Melvin 85 93 78 82 Waldrop Alma 85 86 100 70 Swaim Shruti 88 85 82 75 Shepherd Manuel 83 78 87 81 Taylor Gatlin 82 87 89 71 Wurz Alexandria 91 93 54 94 Baugh Winnie 80 90 65 91 Harry Melany 91 77 72 85 Jain Brandon 72 72 99 88 King Miles 92 90 74 68 Browne Emory 76 70 88 88 Govindappa Talon 86 79 68 88 Buquet Oscar 76 81 90 73 Corley Felix 73 84 91 72 Price Lian 81 78 83 77 Tao Paris 84 81 71 83 Robinson Lyric 81 83 81 73 Hensley Lauren 92 90 45 91 Cangelosi Yaretzi 90 73 63 90 Sturm Ariel 90 49 85 94 Bryant Hunter 92 88 46 90 Melton Atlas 85 83 80 66 Kimbrell Boston 93 90 79 54 Torres Serena 89 60 73 90 Morris Brandon 86 84 72 69 Schuhmacher Helena 89 78 72 71 Mathew Kinley 89 79 58 83 Aird Reign 88 80 53 85 User Ezra 93 93 74 47 Fernandez Rylie 71 75 84 73 Aziz John 78 64 86 74 1. Create UserID which consists of the 2nd and 3rd letter of the 1st name and the last 2 letters of the last name. 2. Find Average after a. adding 20% to the highest test score (but not going past 100) b. adding 10% to the lowest score 3. Assign grades Use Vlookup or IFS. 0 to