Hands-On Excel Excel interview tests Basic Test
Basic Excel test
10 tasks, 25 minutes. Each one is a small table and a question, like the ones on the Basic 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: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTBLANK, Relative references, Absolute references, Percentages, IF, Sort, Filter.
Task 1 of 10: Add it up
Your monthly expenses are listed below. In B7, write a formula that adds up every cost.
Every formula starts with =. Type =SUM(, then drag across B2 to B6 and press Enter.
01 Add it up SUM Starter
Ready
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 = ( ) : , $.