Build a student grading board
83%
AVERAGEIFRANK.EQ
A grading board turns four subject marks into several different answers. AVERAGE gives the score, IF handles the pass boundary, RANK.EQ compares it with the class, and nested IF assigns a grade band.
The boundary matters: a score of exactly 50 passes, 60 stays in grade C, and only scores above 80 earn an A. Build one formula for each output column, then copy them down.
Fill F2:I5 with formulas for average, Pass or Fail, rank, and grade.
The grid for this exercise needs a free profile.
Everything above is yours to read either way. 19 exercises stay open with no profile at all.
Adapted from Excel Beginners Practice Lab by Muhammad Auwal Abdulaziz (MIT).