Excel aptitude test inside a workbook

[DaveTurton]

Hi


I am going to be interviewing for a new staff member. Excel is widely used in the role, although mainly for basic tasks and using basic functions.


i.e. Sum, Vlookup, If, Or, And etc


I was wondering if anyone has ever created a workbook that tests people and provides a score, and if so, if that person would mind sharing it?


I know there are tests online but I was looking for a self contained workbook with the test inside.


If no one has one, I will create one myself, and obviously share it after for use by anyone else.


Thank you

 

[DaveTurton]

I have made a start, this is the sort of thing I am thinking of https://docs.google.com/file/d/0ByiZqUlQMjxhaW96bXBzU01Wa1E/edit?usp=sharing

 

[vasim]

Kudos...I loved solving them (Don't know why)

 

[DaveTurton]

I've updated it https://docs.google.com/file/d/0ByiZqUlQMjxhQjV3aXQ5U3g3OXc/edit?usp=sharing


Now had 17 questions which I think just about cover what I need to gauge a basic understanding of what I need from them. Very simple stuff but at least it shows whether or not they have used excel for more than just putting pretty colours in cells.

 

[NARAYANK991]

Hi Dave ,


I have one suggestion , which may be partly because I love problem solving , but also because I believe that the most important quality in an employee is the willingness to try and solve problems , given that time is not a constraint.


For a specific example , let us consider question 16 , where you want the candidates to copy and paste ; I would turn this question slightly inside out ; use the copy + paste special multiply facility to put some figures in Table 2 ; ask the candidates to write down how the second table could have been filled.


To answer this question , the candidate cannot do anything but think ! Either they know or they have to think.


Narayan

 

[DaveTurton]

Hi Narayan


That is a nice idea, I'll add it in


Thanks