Hands-On Excel Excel interview tests Data analyst Test
Data analyst Excel test
10 tasks, 25 minutes. Each one is a small table and a question, like the ones on the Excel test for data analysts page, on data you haven't seen.
- No hints and no checking while the clock runs. Move between tasks freely.
- Any formula that gets the right answer counts. Typed-in numbers don't.
- When time runs out, your answers are handed in as they are.
- Your score is free. The full report, with what went wrong on each task and the lesson that teaches it, comes with Pro.
The tasks: COUNTIFS, SUMIFS, XLOOKUP, MEDIAN, TRIM, UNIQUE, IFERROR, LEFT, MID + FIND, Compare two lists, Pivot tables.
Task 1 of 10: Count with two conditions
In F2, count the North orders that are Shipped. In F3, count the shipped orders from North or South.
COUNTIFS(range 1, condition 1, range 2, condition 2) counts the rows where every condition is true. For "this or that" in the same column, add two counts together.
01 Count with two conditions COUNTIFS Core
Click a cell while typing to insert it, drag to select a range, F4 adds $, Esc cancels.
Tap a cell while writing a formula to insert it, or slide across cells for a range. The strip above the keyboard has = ( ) : , $.