Question: Please show work in Excel using correct formulas including VLOOKUP in part b. Guide for Grade Computation Test 1 100 Test 2 100 Assessment 100

Please show work in Excel using correct formulas including VLOOKUP in part b.

Please show work in Excel using correct formulas

Guide for Grade Computation Test 1 100 Test 2 100 Assessment 100 Semester Total 300 Semester Grade A Points OF 180 D 210 C -Scale 240 B 270 A Problem 3: Grades of four individuals on various parts of the course are given below. a. There were 290 possible points on the assessments. Compute the assessment percentages and give their values below. Total possible points Assessments on Assessments Percentages 290 259 117 200 190 b. Using "VLOOKUP" function, Compute the semester grades of the four individulas shown below. Assessments Semester Test 1 Test 2 Percentages Grade Possible points 100 100 Nancy 98 94 Donald 59 58 Jacob 80 90 Betsy 75 76

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!