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.

SkillsDie Funktion WENN Bedingte Formatierung PivotTables 1 Tastenkombinationen zum Markieren von Zellen Die Funktion SVERWEIS

▶ Watch the video

Premium project

Create an account Log in

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