b. Using the percentages that you determined and the "VLOOKUP" function, Compute the semester grades of the students.. Grading scale should be as shown on your syllabus,\ \\\\table[[Student,Test 1,Test 2,\\\\table[[Assessments],[Percentages]],\\\\table[[Semeste],[r Total]],\\\\table[[Semeste],[r Grade]]],[Addie,98,94,,,],[Bob,59,58,,,],[Cate,80,90,,,],[David,75,76,,,],[Emily,90,92,,

\\\\theta

,],[Frank,80,78,,,],[Gina,84,84,,,]]

b. Using the percentages that you determined and the "VLOOKUP" function, Compute the semester grades of the students.. Grading scale should be as shown on your syllabus, b. Using the percentages that you determined and the "VLOOKUP" function, Compute the semester grades of the students.. Grading scale should be as shown on your syllabus