Using your understanding of the basic functions of Excel and the VLOOKUP function covered in lecture, calculate the Exam Average for each student as well as the average for each assignment. The project is out of 10 points. The exams are out of 100 points. This assignment will build upon your previous assignment formula. Again, make sure to satisfy the following conditions: 1. The lowest exam grade will be dropped. 2. If the project is turned in with a grade of 8 or higher it will increase the letter grade to the next higher grade unless its an A in which case it remains an A. 3. Rename the primary worksheet to Overview, then create another worksheet in the workbook and call it Scores. Student ID Name 00001 Swanson, R. Exam 1 Exam 2 Exam 3 Project 100 00002 Lahey, J. 66 81 67 90 10 00003 55 May, J. 8 80 00004 Belichick, W. 74 90 9 99 00005 Costanza, G. 95 99 8 60 4. Add the table above to the Scores worksheet. 75 75 7 5. Using the VLOOKUP function, setup the Overview worksheet to reference the Scores worksheet to pull the necessary data. 6. Create a