Home › Learn Excel › Test
No tips this time. Answer the questions and see your score: 70% or more and you've passed.
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"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 termsIFS 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 50SUMPRODUCT multiplies the ranges row by row and then adds everything up, in one go. Work out the total order value (quantity times price) in D2IFERROR 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#DIV/0!. IFERROR shows your own value instead. Divide revenue by orders in D2, and show 0 instead of #DIV/0!