Nielsen Research Analyst interview questions

ROUND 2 (They will give a set of questions and an Excel workbook filled with data for 3 different case studies, 2 hours prior to the 1 on 1 interview. It tests the candidates knowledge and skills on advance excel functions and how they use INDEX, INDIRECT, VLOOKUP, OFFSET, SLICER and DATA VALIDATION, etc. to fill in gaps in the datasheet. During the interview they will ask to click on specific cells to check the formulas and functions used by the candidate. It the interviewer doubt the candidate's skills, they might give random data and test the candidate on spot). ROUND 3 (They will give a case study and a Excel data sheet 12 hours prior tp the interview to test their analyzing and presentation skills. During the interview they will ask question based on the results derived and cross- question the candidate's choice for a particular method for deriving results and choice of presentation tools. They will also ask basic interview questions like "Tell us about yourself', "walk us through your past internships' etc.)

Why should we hire you?