Excel Job Interview
With over 15 years of experience in corporate training, I find that many clients are overestimating their knowledge in Excel. That’s why when you apply for a job requiring good knowledge of Excel, companies will test the candidates upfront for their current knowledge.
This project is a multiple-choice Quiz of 40 Excel questions of different levels.
For Each question, the candidate must select an answer from a drop list in column D.
After completing the quiz, a single click on the “Giant Pen” icon will reveal your score, evaluate your level and show you the number of correct and incorrect answers on a doughnut chart.
With another click on the “QUIZ” cube icon, you can reset the quiz questions and start over again.
You can download the finished project by clicking on the link here below
I encourage you to take that quiz and write in a comment: Your Score and Rating… You will definitely enrich your knowledge in Excel.
By creating different questions, the concept can be applied to any work situation like: A survey, a client feedback, a knowledge test, Patient admission form or any other purpose…
In a more advanced scenario, questions and answers can be randomized to ensure a fair evaluation.
In my next tutorial I will show you how to build this project from ground up in Excel, using lots of tools:
Data Validation, Functions, Conditional Formatting, Charts, Macros, protection and much more…
So stay tuned for the upcoming tutorial and make sure you subscribe to my YouTube channel to be notified when this exciting video is released.
Now it’s Quiz Time