[Solved] Paper 2 Mi Entation Quizzes Final Exam Grade 7300 9500 8400 100 8500 5600 8300 9200 7200 9 Q37191037
need help to enter a formula for the grade?
Paper 2 Mi entation Quizzes Final Exam Grade 73.00 95.00 84.00 1.00 85.00 56.00 83.00 92.00 72.00 95.00 89.00 90.00 76.00 67.00 91.00 85.00 2841253 2842210 2842854 2843969 76 86 70 75 71.00 80 55.90 2845645 92.00 71.20 94.85 2847889 2849478 100 75.95 66.60 90.60 16 2854586 90.00 100 89.30 76.00 100 65.00 1.00 85.00 90.00 64.05 24 25 54 84.10 2864287 75.45 72 Syllabus+ Students Activity Weights Midtermm ActivityPaper1 Weight Paper 2 Presentation Quizzes 2591-10 %l Final Exam 091 1591 15%1 25% Letter Grades Grade To From 50 59 D+ 60 65 70 75 80 85 90 95100 A 64 C- 74 C+ 79 B- 84 B 89 B+ 94 A- 2 Remove any cell borders and adjust the column widths as needed. No formatting is required. The above table was as displayed in the course syllabus, but we are going to use the VLOOKUP function on it, and for that, the lookup values must be in ascending order. Sort the table data from smallest to largest score. Complete the exercise on the Student worksheet Enter a VLOOKUP function for each student in the Grade column that returns the letter grade from the Grade Table. We do not want an exact match, so the range_lookup should be “TRUE” or omitted. Hint: the first student should get a letter grade of C+. Center align it and copy the function to the other students, remembering absolute and relative references Copy your VLOOKUP function over the #DIV/O Function at the bottom of the grade column. This will display the letter grade for the class average, which should be 80.4, with a letter grade of B. There is no need to round up the class average. Below the Gradebook table, create a mini-table that returns a single students’ letter grade when a valid student ID # is entered in the table. The table should look like this. Add colors if you want. Student ID# 1 Grade 2839278Ct Show transcribed image text Paper 2 Mi entation Quizzes Final Exam Grade 73.00 95.00 84.00 1.00 85.00 56.00 83.00 92.00 72.00 95.00 89.00 90.00 76.00 67.00 91.00 85.00 2841253 2842210 2842854 2843969 76 86 70 75 71.00 80 55.90 2845645 92.00 71.20 94.85 2847889 2849478 100 75.95 66.60 90.60 16 2854586 90.00 100 89.30 76.00 100 65.00 1.00 85.00 90.00 64.05 24 25 54 84.10 2864287 75.45 72 Syllabus+ Students
Activity Weights Midtermm ActivityPaper1 Weight Paper 2 Presentation Quizzes 2591-10 %l Final Exam 091 1591 15%1 25% Letter Grades Grade To From 50 59 D+ 60 65 70 75 80 85 90 95100 A 64 C- 74 C+ 79 B- 84 B 89 B+ 94 A- 2
Remove any cell borders and adjust the column widths as needed. No formatting is required. The above table was as displayed in the course syllabus, but we are going to use the VLOOKUP function on it, and for that, the lookup values must be in ascending order. Sort the table data from smallest to largest score. Complete the exercise on the Student worksheet Enter a VLOOKUP function for each student in the Grade column that returns the letter grade from the Grade Table. We do not want an exact match, so the range_lookup should be “TRUE” or omitted. Hint: the first student should get a letter grade of C+. Center align it and copy the function to the other students, remembering absolute and relative references Copy your VLOOKUP function over the #DIV/O Function at the bottom of the grade column. This will display the letter grade for the class average, which should be 80.4, with a letter grade of B. There is no need to round up the class average. Below the Gradebook table, create a mini-table that returns a single students’ letter grade when a valid student ID # is entered in the table. The table should look like this. Add colors if you want. Student ID# 1 Grade 2839278Ct
Expert Answer
Answer to Paper 2 Mi entation Quizzes Final Exam Grade 73.00 95.00 84.00 1.00 85.00 56.00 83.00 92.00 72.00 95.00 89.00 90.00 76.0… . . .
OR
