Microsoft Business Analyst interview questions

there were 2 people interviewing for two similar positions at the same time. One of them was very intimidating. the other one was the total opposite. the intimidating person kept acting like he was the best at everything, which I later found out he was also human, and lots of mistakes were made. but I learned a lot from the interview, and the job itself.

Five rounds of interview process mostly of excel written test, excel questions asked buy the interviewer, SQL test, Aptitude test, personality development round, one on one with three different managers, power point presentation, situation round, etc..