Excel Test or Exams

[the_crooked_toe]

My company is looking for an excel exam to test people coming into a new position. I am looking for a test that a user would only have to know formulas and not VBA. Some sort of test where someone with a little above average knowledge of Excel could do moderatly easy.

if anyone has any tests or website links to download some tests it would be greatly appreciated.

 

[NateO]

You're welcome.

Sorry, that particular UDF is a bit of a doosey... There's some complicated VB logic there, including implicit Array->String->Long coercion and Unicode->ASCII considerations... You're probably in the Expert+ category (of VB[A] at least) if you can makes heads or tails of that one.


You can build much simpler UDFs as well, that was just an example.

Good hunting.