MS Excel - Intermediate Test
This Excel intermediate 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 work with multiple workbooks, be able to name a range of cells, use subtotals and consolidate data. You should be able to work with basic functions as well as 3D formulas. You should know how to format numbers. You need to know about functions that change the case of text and about the order of calculations. You also need to know how to link and protect data. Lastly you will be asked about hiding worksheets, filtering, headers and footers and sorting.
All these topics are covered in the MS Excel Intermediate course.