Course contents · Problem book

Choosing between options

Open the practice in the trainer →

When the result is one of several values:

Tasks in the trainer

  1. In C2:C6: “pass” if the score is at least 50, otherwise “fail”.
  2. In B2:B6 give a grade: 90 and above — 5, 75 and above — 4, 50 and above — 3, otherwise 2.
  3. In F2:F4 turn the weekday number into its short name: Mon, Tue, Wed, Thu, Fri, Sat, Sun.
  4. In J2:J3 find the larger of x and y without MAX.
  5. In I6:I8 return “positive”, “negative” or “zero”.

Solve the tasks in the trainer →