Most Asked Excel Interview Questions for Analysts | Excel Interview Tips #shorts #simplilearn

Key Takeaways

Here are the three Excel interview questions that [music] are asked by big force. First, let's talk about the easy question. And the question is, can you add a note in a given cell and tag it with [music] the given text? And the answer is shift + F2. And then you can type the comment and click on done. A simple credibility booster in interviews that speak of your deeper excel understanding. [music] Now let us talk about intermediate level and the question asked is create a drop-down with all cities in the [music] data set. So for this you can use data validation shortcut which is alt a v and you can choose a list [music] select your city column and boom and a clean dynamic drop-down. Finally, this is kind of a hard question [music] and the question is how do you find duplicate names between two lists and the answer for the same is select both [music] lists, go to home, then choose conditional formatting, highlight cell rules and then you can duplicate the values. All duplicates instantly light up in red. So guys, these were the top three questions about Excel interview. So guys, let us know in the comment section below how much you could answer.