Crowdly
Add to Chrome
In Assessments sheet, calculate the Total Mark for all students. Total Mark =...
✅ 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.
Total Mark = Exam 1 * 20% + Exam 2 * 30% + Project * 50%
Use VLOOKUP to get the grades for all students using the grade table array in Assessments sheet. What is the formula in cell G30?
❌
❌
❌
❌
✅