I've got a job interview next week, and it involves a "short admin test". Was wondering if anyone on here has applied for an admin position before and what that test could entail?
Could include spelling, proofreading, drafting letters and prioritising workload (by ordering scenarios). If they mention Excel make sure you can do PivotTables.
>>11935 That would definitely be a reasonable test. Send 'em to Starbucks for the whole team and see if they remember the order. Forget my soya mocha and you're out the door now.
I've gone for tests in interviews before in admin/finance positions; they can involve a GCSE-level numeracy exam, data entry in Excel, spotting mistakes in a data set, typing out a letter, stuff like that.
If they're not giving details, it probably isn't very complex and will be along the above lines. If you've got the interview through an agency, ask them, they will probably know what it involves.
Everyone uses this, and thinks it is the height of excel use, even people who should know better, but it is just terrible. If you can master a nested match index that is better, it is more versatile(it can go back as well as forwards or even to other sheets, and you don't have to count columns like a wally.
>>11938 When I did my placement year, my programming knowledge basically made me The Excel Bitch for the whole place I was working at, and I often had people make insane uses of VLOOKUP when a 5-line Range.Find script would have done the job just as well.