Excel Tests
The Excel Tests contain herein are for you to evaluate your Microsoft® 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 Microsoft® 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
Excel dates.
Sign up for this
7 weeks 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
This excel file contains a list of products which are arranged in rows of 3. Below show a small
subset of the data.
| Column A | Column B | Column C |
| Row 1 | Product 1A | Product 1B | Product 1C |
| Row 2 | Product 2A | Product 2B | Product 2C |
| Row 3 | Product 3A | Product 3B | Product 3C |
| ...... |
Can you find a way to re-arrange the products (without using Macro) and list them in
one column as shown:
| Column A |
| Row 1 | Product 1A |
| Row 2 | Product 1B |
| Row 3 | Product 1C |
| Row 4 | Product 2A |
| Row 5 | Product 2B |
| ...... |
Download the working file and take the test!
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.
The title of the course is called
"Sales Performance Analytics with Excel".
•
|
New! Comments
Have your say about what you just read! Leave me a comment in the box below.