Fridays have become gyaan sessions about employment, internships and jobs, and I suppose that’s a fine thing to keep going. Here are posts on the past two Fridays: On Interning, and “Cracking” Interviews.
Today is about what I would ask you if I was the interviewer, and I see on your CV that you claim to be proficient in MS-Excel. This post will hopefully help you figure out if you know Excel well enough – and by your responses, it’ll help me understand if I’m asking good questions!
Here are ten questions I would have asked about MS-Excel in an interview. I’ve tried to arrange them in increasing order of difficulty, so the first is the easiest one
- Is it possible to work with text data in Excel? Can you give me an example?
- What exactly is conditional formatting? Can you tell me about a time you used it in MS-Excel?
- How would you password protect a file in Excel?
- When are you better off using data filters instead of pivot tables? Whatever your answer, what is your reasoning?
- I’m not a fan of pie charts. Do you agree with my opinion, or not? Why?
- Give me your best guess about a keyboard shortcut in Excel that I’ll not be aware of.
- Index and Match, or Vlookup – which is better, and why?
- How would you go about creating dynamic charts in Excel? Or sentences that update automatically when new data is fed in to the sheet?
- What is your favorite Excel add-in? Why?
- Walk me through the coolest project you’ve ever done in Excel. (This last one if I’m convinced that you are a proper, legit Excel ninja)
How did you do? How did I do? What are questions that I should have asked but didn’t?