What I would ask if you claimed you knew Excel

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

  1. Is it possible to work with text data in Excel? Can you give me an example?
  2. What exactly is conditional formatting? Can you tell me about a time you used it in MS-Excel?
  3. How would you password protect a file in Excel?
  4. When are you better off using data filters instead of pivot tables? Whatever your answer, what is your reasoning?
  5. I’m not a fan of pie charts. Do you agree with my opinion, or not? Why?
  6. Give me your best guess about a keyboard shortcut in Excel that I’ll not be aware of.
  7. Index and Match, or Vlookup – which is better, and why?
  8. How would you go about creating dynamic charts in Excel? Or sentences that update automatically when new data is fed in to the sheet?
  9. What is your favorite Excel add-in? Why?
  10. 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?