Course contents · Problem book

Combining functions

Open the practice in the trainer →

Harder questions about a table are answered by combining functions:

Tasks in the trainer

  1. In F2:F9 calculate each student’s total score.
  2. In I2 return the surname of the student with the highest total (the first one if there is a tie).
  3. In I3 — the highest total among the 9B students.
  4. In I4 — how many students got 5 in all three subjects.
  5. In I5 — the average total of the 9A students.

Solve the tasks in the trainer →