Answered step by step
Verified Expert Solution
Link Copied!

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! >

image text in transcribed

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 66

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing and Accounting Cases Investigating Issues of Fraud and Professional Ethics

Authors: Jay Thibodeau, Deborah Freier

4th edition

78025567, 978-0078025563

More Books

Students also viewed these Accounting questions