Could you write down a best answer for common Interview questions about MS Excel?

Abdullah_Al_Saud 

I had a great career of more than 30 years in Human Resources (although I never studied it). Now retired.

I also am pretty confident I could ask and answer a host of questions about Excel, although I never studied it either.

I taught myself.

If you think that you can memorize answers to give back during an interview then you don't know much about interviewing. A good interviewer will always have follow-up questions at his or her disposal.

So let's assume you can learn to say "VLOOKUP can typically be used to find other values or words, titles, etc. that are associated with an employee's ID number." That would be a relatively safe and accurate answer to the question. But then come some follow-up questions.

• "Good, Abdullah, let me ask you now what are commonly encountered limitations with VLOOKUP? How have you worked around them?"
• "What are other methods within Excel for that same purpose, often actually preferred by users over VLOOKUP?"
• "What have you thought of the recently introduced XLOOKUP function?"

I'm sorry to have to say it, but you'd be better off taking a course in Excel, and actually using it.

Or just admitting to no experience but demonstrating your ability to learn. That might be best.

In the meantime, here's a resource you could use to actually learn not just canned answers but some really practical skills, assuming you open up a spreadsheet and work through the examples. https://exceljet.net/