Question: Please show formulas step by step, thank you A B E F H What was the final letter grade for Bob? Question 7: The following

Please show formulas step by step, thank you
A B E F H What was the final letter grade for Bob? Question 7: The following table presents final grades for a class. Use the Vlookup function in Excel to determine the letter grade for each student in the table below. Create your lookup table using the empty table provided. Use the following grade scale: 90, 80, 70, 60. Answer the question to the right in cell 12. Letter Grade Final Grade 99% 65% 81% Lookup Table F D B A OUT 69% 70% 88% 75% 85% 78% 58% 71% 82% Student Andy Angela Barbara Bob Charles Daniel Derrick Edward Frans Gabriela Heather Jasmine Jason Jose Katty Malik Melissa Nancy Oscar Paul Rick Robert Susan Tammy Tom Warren Xavier |Zach 81% 73% 60% 88% 79% 60% 82% 78% 61% 69% 99% 69% 78% 70% 95% 59%Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
