Excel: Pre-Advanced User (post power user)
        Test your knowledge

In the following questions, please select the best answer for the question. It is possible there is more than one answer – and you will only score the maximum points for the best answer.

1. Your standards in building spreadsheets. Which method do you operate?

2. In your naming conventions, do you :

3. In your view, simple macros are:

4. What are range names?

5. The nesting of if statements means to:

6. The sumif function generates:

7. The iferror() function:

8. Content Security: which of these is FALSE?

9. The quickest way to filter data is:

10. The best way to extract a unique list from a data-set column, to a new location is:

11. Better to use DSUM() where:

12. One accurate explanation of how criteria work is:

13. The Find ()function allows users:

14. Which of the following is NOT true:  Vlookups:

15. Which IS true: The LEFT() MID() RIGHT() and LEN() formulas:

16. The Index()function allows users:

17. The Match() function:

18. You wish to remove all sub totals from a Pivot table you created. You;

19. In another pivot table you wish to analyse the data in groups. You:

20. You wish to create a simple chart, quickly. You:

21. You wish to make your pivot table reports look better and be more engaging. You:

22. You seek to allow your users easier and quicker access to their report information. To produce the reports you implement a means of managing report filters and contents being:

Please provide your email to receive your results
Your Company: 
Your Seniority: 
Your Experience: