Hands-On Excel Excel interview tests Admin and office Test
Office and admin Excel test
10 tasks, 25 minutes. Each one is a small table and a question, like the ones on the Excel test for administrative assistants 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: COUNT, COUNTA, COUNTBLANK, Paste Special → Values, MIN, MAX, COUNTIF, IF, Relative references, &, CONCAT, PROPER, VLOOKUP, Sort, Filter.
Task 1 of 10: Count what's there
Ten people signed up for a workshop. Column B shows what each person paid; Fay's place is free. In E2, count everyone who signed up. In E3, count the people who have paid. In E4, count the people who still have to pay.
COUNTA counts every cell that isn't empty. COUNT counts only cells with numbers. COUNTBLANK counts the empty ones.
01 Count what's there COUNT, COUNTA, COUNTBLANK Starter
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 = ( ) : , $.