MS Excel - Formulas and Functions Test
This Excel formulas and functions test should take you 10 – 15 minutes to complete. It has 30 questions and an 80% pass mark. The questions range from true/false, multiple choice, sequence, match and interaction.
In order to pass this test you should be able to use the following functions IF, nested Ifs, NOT, CountA, CountBlank, SUMIF, Case functions. You should fully understand what order calculations are performed in with the order of calculation and work with calculations around dates.
All these topics are covered in the MS Excel Advanced course.