Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Looking for excel help! > File Home Insert Page Layout Formulas Data Review View Help O Search B Share Comments 12 X fr Quiz2 H
Looking for excel help! >
File Home Insert Page Layout Formulas Data Review View Help O Search B Share Comments 12 X fr Quiz2 H M I Midterm 94 G Grade F Total 70 Final 69 96 93 67 49 60 79 90 72 20 81 68 J K L Total is calculated by giving 50% weight to the final, 25% weight to the midterm, and 12.5% weight to each quiz. The grade in the course is "F" if total is 25 or less. The grade is "D" if the total is above 25 buy less than 40. The grade is "C" if the total is 40 or above but less than 60. The grade is "B" if the total is 60 or above but less than 80; otherwise the grade is "A". This exercise should be done using either VLLOKUP or HLOOKUP functions. 28 79 89 94 87 100 75 75 1 Student Nan Quiz1 2 Kris 3 Tyler 4. Jen 5 Chris 6 Henry 7 Angel 8 Jeremy 9 Mark 10 Mat 11 Troy 12 Anthony 13 Lyndy 14 Shannon 15 Dave 16 Nad 50 98 91 75 96 92 97 69 96 91 75 96 60 86 97 100 97 84 95 80 61 68 100 91 64 93 58 66 98 92 97 81 94 23 44 66Step 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