Create an Intro to Biology grade table from the data in Table 5 6. Also include

Create an Intro to Biology grade table from the data in Table 5 6. Also include a Final % fi eld and a Grade fi eld. Both are calculated columns. Final % is calculated with each quiz being worth 10% and each test being worth 35%. Create a Grade table in the range J6: K20 using the data shown in Table 5 7. Use the VLOOKUP function to determine the grade to assign to each record. Add the total row to the table. Show the averages of each quiz and test. In cell range A19: B19 show Mark Kennedys grade using the MATCH and INDEX functions.