Skip to content
Skills
Problems
Questions
Drills
Roles
Skills
Interview
Contest
Leaderboard
Problems
Questions
Drills
Roles
Skills
Interview
Contest
Leaderboard
Home
/
Data Analyst
/
Questions
/
Excel
Data Analyst
Excel questions
10 questions on Excel for data analysts, easiest first.
Easy
5
What a pivot table does
easy
Absolute references in Excel
easy
VLOOKUP returns wrong prices
easy
SUMIFS with two conditions
easy
Lost leading zeros in IDs
easy
Medium
4
Looking up a value to the left
medium
Share of sales in a pivot table
medium
Pivot ignores new data rows
medium
Same cleaning every Monday
medium
Hard
1
Grand total of an average pivot
hard
