Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given this table in one sheet And this table isn another sheet What is the VLOOKUP equation used to solve for final grade? Total Points
Given this table in one sheet
And this table isn another sheetWhat is the VLOOKUP equation used to solve for final grade?
Total Points Calculated Grade 0 F 450 D 490 C- 535 560 B- 600 B 635 A- 675 A . Grade Case Student name Acosta, Angelica Alnusf, Ali AISabt, Sadon A KHA Anderson, Chester Ballantine, David Behbehani, Mohammad Beier, Susanna Blackett, Christopher Cabander, Frida Cooper, Alexander Corson, Bailey Cunningham, Brett Elenbaas, Andrew Friend, Jason Grzanowski, Michael Harkavy, Alexander Exam 1 Exam 2 Quizz 1 Quiz 2 Quiz 3 Project 1 Project 2 Project 3 Project 4 Total Points Final Grade Pass/Fail 100 77 2 48 38.5 100 37.345 97 66.22 566.065 PASS 96 78 4 37.5 39 100 37.83 93.12 67.08 552.53 PASS 75 99 4 43.5 49.5 100 48.015 72.75 85.14 576.905 PASS 87 98 11.5 48 49 100 47.53 84.39 84.28 609.7 PASS 96 92 21.5 22.5 46 100 44.62 93.12 79.12 594.86 PASS 45 93 21.5 39 46.5 100 45.105 43.65 79.98 513.735 FAIL 78 8 22.5 33 4 100 3.88 75.66 6.88 331.92 FAIL 66 4 22.5 49 2 100 1.94 64.02 3.44 312.9 FAIL 98 83 23 38.5 41.5 100 40.255 95.06 71.38 590.695 PASS 77 85 24 44 42.5 100 41.225 74.69 73.1 561.515 PASS 88 74 26.5 23 37 100 35.89 85.36 63.64 533.39 FAIL 46 72 27 39 36 100 34.92 44.62 61.92 461.46 FAIL 78 74 27.5 49.5 37 100 35.89 75.66 63.64 541.19 FAIL 99 75 28 38 37.5 100 36.375 96.03 64.5 574.405 PASS 76 89 28 39 44.5 100 43.165 73.72 76.54 569.925 PASS 78 78 28 28 39 37.83 75.66 67.08 531.57 FAIL 100Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started