← Back to projects
Premium · 3 days to submit
Excel Job Interview Test
Solve a real Excel assessment given in a job interview: VLOOKUP, conditional formatting and pivot tables.
This project is not translated into your language yet: the instructions stay in English.
Check out this real-world Excel assessment that was given to one of our users as part of a job interview. You will merge two reports with VLOOKUP, spot data quality problems and answer questions with pivot tables.
SkillsLa funzione SEFormattazione condizionaleTabelle pivot 1Scorciatoie per selezionare le celleLa funzione CERCA.VERT
▶ Watch the videoPremium project
Log in or create an account to start a project and follow your progress.
How you are graded
Each project is graded out of 100; you need 70 points to pass. Some criteria are checked automatically in your workbook, the rest are judged by the AI.
- Merging the reports with VLOOKUPAutomaticEvery unique column of Data 1 is brought into Data 2 with VLOOKUP, for every row.20 pts
- Unmatched casesAutomaticThe identifiers that could not be matched are listed under exercise 1.b.10 pts
- Mismatches foundAutomaticThe mismatches between the two worksheets are identified or highlighted.10 pts
- Pivot tableAutomaticA pivot table of the merged Data 2 sits in a worksheet named "Exercise 4 Pivot".10 pts
- Answer 4bAutomaticReports and money spent by country, in descending order of reports.10 pts
- Answer 4cAutomaticReport colors by division, in alphabetical order of division.10 pts
- Data quality practices (exercise 2)AIConcrete functions, formulas or processes to detect duplicate, missing or non-matching data.15 pts
- Cleaning up the data (exercise 5)AIA sensible, specific approach to duplicates, missing data and mismatches.15 pts