We are looking for some Excel/VBA devs. They need to be good, or better.
I’m not a big fan of silly questions that have no bearing in the real world, but equally, I need in 20 minutes or less, to get a good sense of whether the candidate is going to cope in the harsh reality of financial services spreadsheeting. (And over the phone).
Here is what I have come up with so far:
Whats the keyboard short cut to open the VBAIDE?.
Name 3 new functions in Excel 2007
How would you translate one set of product codes into another (assume 1 to 1 matching)
What is the SQL to return a list of products where the maturity date is after June 2010.
In excel what is a volatile function? Name 2?
In VBA what does option explicit do for you, and how do you set it.
What size of spreadsheets have you worked with?
What is the main body interested in spreadsheet quality?
Name a couple of good on-line resources for Excel VBA
Describe decent code
Talk about combining Excel and C#
Describe the best and worst spreadsheets you have worked with
Have you got any favourite questions?
I’m not thinking of ‘pass or fail’ type questions, more ones that will allow us to get a good sense of people strengths and weaknesses. Just technical, someone else will be covering the other stuff.