interview testing excel - should be fun

dwbolland

Board Regular
Joined
Oct 29, 2004
Messages
144
Hello all (good morning afternoon evening , whatever is applicable)

I think this will be a locely one for us all, I thought i'd throw it out there as i'm sure someone will come up with something better than me.

I have a role that i'm interviewing for. They will be working with me on developing all excel and visual basic in the fiannce department. I am potentially going to be recruiting graduates so no experience.

They all claim good with excel and logical thinking as that's what i've asked for (no surprise there).

I would like to give them (for 5-10 mins before I interview) a quick test to see if they can walk the walk as i'm sure they'll all talk the talk.

I'm open to all ideas from just a complex if statement and asking what the result will be to jsut about anything.

I'm not so bothered if can't use excel or vis basic as can train but only if their mind is logical.

I look forward to some interesting ideas folks.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,808
Office Version
  1. 365
Platform
  1. Windows
I think this type of exercise is good for testing both excel skills, accounting knowledge and trouble shooting ability. Obviously dependent on what your finance department does, but you could for instance simply provide the candidate with an extract from the GL showing merely Period; GL Account and Amount. In a seperate workbook provide a list of all GL Accounts, Description, Category. Then ask the candidate to construct a P&L statement... This could, as one of many ways, be achieved through vlookup to retrieve Description & Category into the GL download table. Then a simple pivot table with Period as column segment, Category, then GL Account, then Description as Row segment and amount in Data. It could be made more sophisticated by changing the layout of the source data to use calculated fields to provide breakdown on the statement of e.g. Gross Margin, EBITDA, Net Contribution etc... The options are endless, but this way you can determine who delivered the most impressive statement within the given deadline. E.g. 15mins.

Regards,
Jon
 

dwbolland

Board Regular
Joined
Oct 29, 2004
Messages
144
thanks for both of these responses, it is in a finance dept but we don't touch any ledgers in our team so more analysis so just want logical ability rather than finance knowledge, like the test above but may scare people too much, i got 8/10! think the springs one is C then A, (25,26&27; then 34,35,36: and 3rd 54,55,56 -- so C and A)

was just going to give a big nested if statement and see if they could work out what the answer would be.

keep 'em coming though folks all good and sure people in future will use the post.
 

Forum statistics

Threads
1,136,260
Messages
5,674,695
Members
419,520
Latest member
Jennifer4Dillon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top