← 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.
SkillsФункция ЕСЛИУсловное форматированиеСводные таблицы 1Сочетания клавиш для выделения ячеекФункция ВПР
▶ 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