Hi Coraline,

welcome to the forum.

I am frequently interviewed by idiots who attempt to prove how clever they are by asking the most difficult quetions about things that you would never use in the real world.

Some plonka the other day asked me about Vlookup to which I answered it was for people who didn't understand how to use Index and Match (or Xlookup now) and promptly gave them the answer  to the question that they should have asked. Then they went on to ask about other Excel stuff which was the equivalent of asking what is the best way to use a hairdrier whilst driving your car. Time and again they got a nope, thats the wrong question. Most ammusing thing is that they were attempting to interview me in front of their boss. lol. (I refused the job but the interview was fun).

Don't be put off by one interview and one sites questions that may be more about someone so insecure of their own capabilities that they attempt to compensate by finding questions that they wouldn't be able to answer themselves if similar one's were asked to them. A good interviewer will ask a simple question but then dive further and further in so they are both building your confidence and finding out what you really know rather than almost belittleing you for their own satisfaction.

There will be many things that you do not know until you are on the job and when you do know them you won't be happy with the salary that was no doubt on offer.

Go on then, give us a few of the questions that must have stuck in your mind. They should allow us to easily judge the level of questions and point you in the right direction to improve any holes in your skillset.

Just don't beat yourself up that you don't know everything. I'm FCCA with a masters in accountancy from a world top ten Uni and I still think that I know bugger all.... But most of the time I still know more than the interviewers do, lol.

Interviewers would do well to remember that the interview process is a two way street and when they find the right candidate, stupid questions from them attempting to be clever may well result in the right candidates telling them maybe, if they're lucky, when hell freezes over.... Doesn't pay the mortgage but it gives you a hell of a lot of personal satisfaction, lol.

Keep at it, you will find the right role for you... Now, these questions

Shaun.

p.s. And remember... nobody... and I mean NOBODY... Knows everything no matter how cock sure of themselves they may sound.

Hi Shaun

On a slightly different note; when I applied for a job at a Chamber of Commerce to do their payroll (experience to that point was payroll for 6 people, and this was for nearly 300) interview was going steady and they said they used EARNIE, did I know it?  Yes, I jokingly replied, it tells you if you've won the premium bonds.  That got a laugh and I'm sure helped swing it, because I got the job.