Part F [7 points]
Use only the data shown to answer the following questions.
All ranges have been named using the labels that appear in the worksheets.
The tables below are from Lab 6.
Your task was to create a formula to produce the results in the Grade column.
Now we want to perform some analysis on
those Grades, by adding the worksheet on the
Create a single formula that will produce the Letter Grade corresponding to each Average
=VLOOKUP( Average_Score, GradeTable, MATCH( Faculty, Faculties, 0))
1 point for each underscore
Illustration 1: GradeTable Illustration 2: Class worksheet