Excel Tests

[jayoneill]

Im currently recruiting for a Junior Marketing Analyst and would like to set each interviewee a little competency exam for excel so i can see where theyre at and make sure they can do what they say they can

Does anyone have a template or a ready made test? It doesnt need to be too complicated - in fact i would like a basic level one and possibly an intermediate if anyone can help

[tim201110]

maybe intermediate

[jayoneill]

Sorry i dont see how that is a test

There are no questions

Does anyone have a basic or intermediate test?

[ELeGault]

A good test is not one with questions -

Find a spreadsheet off the forum here - I have posted several and I am sure you can find a plethora... but screen shot it and bullet functionality.

Then you give them a time limit to recreate to the best of their ability.

You can run through it one time so they see it move, but hide the formula bar while you do this just so you can test their knowledge to the level you need.

And really it would be best to utilize something you house there in your company that they would be using in practice daily as it will teach them the book all while testing them so that they are ready to start building/redesigning on day 1.

Now if you need help prepping an existing book of yours or want to see if there are any quick enhancements... I would recommend posting a sample version and let the forum tear it apart and build it back up so that you can then present and test their ability/knowledge of Excel.

[Sam Capricci]

I created this one a while ago.