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
right.
Create a single formula that will produce the Letter Grade corresponding to each Average
Score.[7]
=VLOOKUP( Average_Score, GradeTable, MATCH( Faculty, Faculties, 0))
1 point for each underscore
xrt
Illustration 1: GradeTable Illustration 2: Class worksheet
Unlock document

This preview shows half of the first page of the document.
Unlock all 1 pages and 3 million more documents.

Already have an account? Log in

Get OneClass Notes+

Unlimited access to class notes and textbook notes.

YearlyBest Value
75% OFF
$8 USD/m
Monthly
$30 USD/m
You will be charged $96 USD upfront and auto renewed at the end of each cycle. You may cancel anytime under Payment Settings. For more information, see our Terms and Privacy.
Payments are encrypted using 256-bit SSL. Powered by Stripe.