Hands-On Excel Excel interview tests Finance Test
Finance Excel test
10 tasks, 25 minutes. Each one is a small table and a question, like the ones on the Excel test for finance jobs 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: Percentages, Percent change, Absolute references, Mixed references, VLOOKUP approximate match, SUMIFS, SUMIFS, change, lookup, CAGR with ^, ROUND, EOMONTH, NETWORKDAYS.
Task 1 of 10: Percent of a total
What share of the budget does each category take? In C2:C6, divide each amount by the total in B7 and fill down. Then click % to show the shares as percents.
A share is part ÷ total: =B2/B7. Every row divides by the same total, so lock it as $B$7 before you fill down. Don't multiply by 100: the % button does that for you.
01 Percent of a total Percentages 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 = ( ) : , $.