After a phone call with a recruiter, I was given a home assignment in Excel that included extensive data from the company's system. I was required to clean and process the data, and then answer a series of questions based on it. Following the assignment, I was invited to an in-person interview with the team leader.
Home test on Excel report analysis
Several reports in each subject, it was necessary to unite them and create pivot tables and do an analysis of all the data in all the tables together.
Questions d'entretien [1]
Question 1
Can I work with several reports at the same time when each of them has data that I need to use?