Excel Tests

The Excel Tests contain herein are for you to evaluate your excel skills. The terms beginner, intermediate, advanced and expert have different definitions depending on the websites you go to. It depends entirely on the benchmarks they used. Like wise for this website, the terms are defined based on the benchmarks I used. For example, I would consider someone who knows about pivot tables as an advanced user. To others, they are considered experts.

As such, we decided to set up a number of tests for you to gauge your excel skills based on our standards. We hope that the tests would help you improve your experiences in using the website.

7 Weeks Challenge

Are you an expert in Excel? If you are, try this 7 weeks challenge. One challenge will be issued per week and you are to find out whether you can complete the test given. The solution will be given to you in the following week. At the end of the 7 weeks challenge, we will share with you a 5 seconds solution to the most throny problem you could encounter with text formatted dates. Sign up for this 7 weeks SAP challenge now!.

5 seconds test on absolute and relative cell reference

Take this test to find out whether you really know how to use abosolute and relative cell reference to your advantage.

Download Basic Test 1 Data

Did you manage to get the right answer to the test? If you didn't, download this file for the solution.

Download Basic Test 1 Data Solution

One minute test to gauge whether you are an Expert User

Expert users would have no problem completing the excel test within a minute. If you are able to use the right steps to complete the test but takes more than a minute, you are on your way to becoming an expert. If you don’t know how to do it at all, you can be a beginner, intermediate or advanced user. We will come out with more tests so that you find out where you are.

The test requires you to know excel worksheets functions, methods and how to apply them.

Based on the data provided below, find out how many people are born in the month of Jan, Feb,…Nov, Dec.

Download Excel Test Data File

Did you manage to complete the test within one minute? If you have not, take a look at the solution and find out whether you have used the right approach to get the solution.

Click here for Excel Tests Solution

Knowing what the formulas and functions in Excel can do is not enough to maximise the use of Excel. The above tests shows that the importance of applying these formulas in your work. Here is a course that will teach you how to apply those seemingly useless formulas and functions to your excel projects and unleash the potential of Excel. By the way, the title of the course is called "Unleashing the Potential of Excel".