Hands-On Excel Excel interview tests Advanced Test
Advanced Excel test
10 tasks, 25 minutes. Each one is a small table and a question, like the ones on the Advanced Excel test 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: Nested IF, AND, OR, Mixed references, VLOOKUP approximate match, MATCH, INDEX + MATCH, XLOOKUP, SUMIFS, change, lookup, Pivot tables, UNIQUE.
Task 1 of 10: Grade bands with nested IF
Give each student a grade in column C: 80 or more is an A, 65 or more a B, 50 or more a C, and anything lower an F.
Put one IF inside another: if the first test is false, the next IF gets its turn. IF stops at the first test that is true, so start with the highest band.
01 Grade bands with nested IF Nested IF 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 = ( ) : , $.