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 formula in cell H10?

Question

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 formula in cell H10?

Answer

=VLOOKUP(G10,GPA!$A$1:$B$10,2)

Answer

=VLOOKUP(G10,GPA!$A$1:$B$10,1,FALSE)

Answer

=VLOOKUP(H10,GPA!$A$1:$B$10,2,FALSE)

Answer

=VLOOKUP(G10,GPA!$A$1:$B$10,2,FALSE)

Answer

=VLOOKUP(G10,GPA!A1:B10,2,FALSE)

Crowdly

In Assessments sheet, calculate the Total Mark for all students and Use VLOOKUP ...

Want instant access to all verified answers on moodle.polytechnic.bh?