I have to do an excel test as part of the interview process for an internship at a small credit rating agency. I've already gone through 5 separate behavioural interviews where they've mentioned that using VBA is part of the position and i've told them that i don't have any experience with VBA or financial modelling, to which they have said that i'd have to eventually learn it on the job. I've also stated that i have intermediate excel skills on my CV. They sent me an email telling me that the excel test is meant to verify my excel skills and it will take 1-2 hours. This seems extremely long considering its just an intern position. Does anyone have any suggestions as to what i could expect and what i should prepare for?
List of things i've had a look at so far: