Prepare for a Successful Excel Job Interview

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

A picture containing ball, player, holding, sitting Description automatically generated

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

A picture containing drawing Description automatically generatedA picture containing kite Description automatically generated

 

Share This Post
Have your say!
1 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

SUBSCRIBE To Our Emailing List And Receive 3 FREE Gifts...Now

Receive 3 Instant Free Gifts  When Subscribing to our newsletter here below
Two Books( Excel Pivot Tables - Dynamic Charts) and The Magical Shortcuts Quick Reference Card Showing 78  easy to remember Shortcuts.
SUBSCRIBE NOW
close-link