Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Learn Excel › Test

Excel IF and error handling test

No tips this time. Answer the questions and see your score: 70% or more and you've passed.

  1. Pass or fail. IF checks a condition. It returns one value when the condition is true and another when it's false. Show "Pass" in C2 if the score is 60 or more, otherwise "Fail"
  2. Two conditions. AND returns TRUE only when every condition is true. OR needs just one. Check in D2 if the customer is 18 or older AND has agreed to the terms
  3. A grade. IFS checks conditions in order and returns the value of the first one that's true. No nesting needed. Give the score in B2 a grade in C2: A from 90, B from 70, C from 50
  4. Order value. SUMPRODUCT multiplies the ranges row by row and then adds everything up, in one go. Work out the total order value (quantity times price) in D2
  5. Missing product. IFERROR shows your own text when a formula gives an error. Kiwi isn't in the list, so VLOOKUP alone would show #N/A. Look up the stock of Kiwi in F2 and show "Not found" instead of an error
  6. No division error. The new store has no orders yet, so B2/C2 divides by zero and gives #DIV/0!. IFERROR shows your own value instead. Divide revenue by orders in D2, and show 0 instead of #DIV/0!
  7. Error values.
  8. AND.

← All lessons