Hands-On Excel Excel interview tests Quick quiz Test
Quick Excel quiz
5 tasks, 10 minutes. Each one is a small table and a question, like the ones on the Excel quiz 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: Absolute references, IF, COUNTIF, VLOOKUP, TRIM.
Task 1 of 5: Lock it with $
Every item is taxed at the rate in F1. Calculate the tax for each item in column C, then fill down.
When you fill down, F1 would slide to F2, F3… Lock it by writing $F$1 so it always points at the tax rate.
01 Lock it with $ Absolute references Core
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 = ( ) : , $.