Microsoft claims that more than 1 bn. people use the Office suite. And if you look around – not only in the business world but also for private tasks, Excel is a very important software. So, how well do you know Microsoft Excel? Are you an Excel expert? Test your Excel knowledge with these 12 questions.
But before you start one comment: This quiz is designed to be hard. Hardly anybody answers all 12 questions correctly. Can you? How many points out of 12 can you score?
Answer the questions below and click on “Send”. Your points and detailed answers are shown right away on the next screen.
The Quiz: Are you an Excel expert?
Results of the Excel test
After you’ve pressed “Send”, you need to scroll up to see your number of points and the correct answers.
Your Excel test result is between 0 and 5 Points
Still starting with Excel? Although you have scored below 6 points, you might still be a good Excel user. Again: This quiz was designed to be hard.
But maybe it’s time to take your Excel knowledge to the next level? My first recommendation: Feel free to sign up for my monthly Excel newsletter.
Or what about an online Excel class? I can recommend this class (which is for new joiners of Udemy usually between 10 and 20$ – I don’t receive anything for promoting it here, just mentioning), but there are many others available. Just search the internet.
Your result is between 6 and 9 Points
You have a solid Excel knowledge and know many things. And admittedly, some questions were quite tricky. But as said in the introduction: This test is not easy.
Why don’t you continue your path? The easiest thing you could do right now: Sign up for my free, monthly Excel newsletter.
Build on your good knowledge and even improve your (very minor) blind spots. Also for you, maybe an additional online class might help? I can recommend this class (which is for new joiners of Udemy usually between 10 and 20$ – I don’t receive anything for promoting it here, just mentioning), but there are many others available. Just search the internet.
Your Excel test score is 10 to 11 Points
You are a real master of Excel! There is probably not much I can teach you.
Maybe PowerQuery or Power BI might be the next topics to discover for you?
You have answered all questions correctly (12 Points)
Wow, I’m really impressed! Interested in writing guest posts for us?
Have you ever built an app based on Excel?
You want to know more? Here is some further reading for the questions above.
- Question 1: Keyboard shortcuts
- Question 2: LEFT() function
- Questions 3 and 4: SUMIFS() function
- Question 5: $-sign
- Question 6: COUNTIFS() function
- Question 8: Restrict cell inputs
- Question 9: 2D lookups
- Question 11: Combine text in Excel
- Question 12: Worksheet names
I really enjoyed the test, it was really interesting. I am wondering if the results will be sent to my e-mail address, or not. Will this happen ? I saved the page, anyway, but I think it will be useful to receive those results automatically from your WebSite. By the way, I scored 12 out of 12 :-))).
Cool test. I scored 11 out of 12. That was fun.