The end-client asked me questions that had very little to do with the main job I was interviewing for, the questions pertaining to the specific position were asked at the end of interview and were relatively easy (e.g. How do you keep a variable's value within a subroutine or function? - Use ByVal).
Some of the technical questions were quite obscure - I'm not sure anyone actually uses the Excel CHOOSE function. Other Excel VBA questions were hard to understand what the interviewer was actually asking.