In Assessments sheet, calculate the Total Mark for all students and Use VLOOKUP ...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
In Assessments sheet, calculate the Total Mark for all students and Use VLOOKUP to get the grades for all students using the grade table array in Assessments sheet.
Total Mark = Exam 1 * 20% + Exam 2 * 30% + Project * 50%
Use VLOOKUP to get the GPA for all students using the table array in GPA sheet. What is the average GPA for all students? Write you answer in the answer box.
Want instant access to all verified answers on moodle.polytechnic.bh?
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!