Project manager Excel test: schedules, budgets and tracking
Project and program roles use Excel for schedules, budgets and status tracking. Screens check working-day math, status rules, budget totals and a clean summary a stakeholder can read.
What employers usually test
Take the project manager timed test
Five tasks in a live grid, easiest first. Graded instantly, with a lesson for every gap.
- 5 tasks in a live grid, easiest first. Graded the moment you submit
- About 10 minutes. Skip anything you don't know
- Your level and the exact lessons for your gaps, right away. No signup
- Aced it? Keep going with a bonus round of harder, interview-style tasks
Try a sample task
From lesson 24, EDATE, EOMONTH & NETWORKDAYS. Graded instantly.
Business days
In
F2, count the weekdays from each start date to its end date. Fill down to F6.Your 14-day prep plan
About 30 minutes a day. Free lessons first; Pro lessons are marked.
| Day | Focus | Access | Time |
|---|---|---|---|
| 1 | SUM, AVERAGE, MIN, MAX & COUNT | Free | 22 min |
| 2 | Relative vs absolute references | Free | 24 min |
| 3 | Percentages & growth | Free | 22 min |
| 4 | The IF function | Free | 22 min |
| 5 | AND, OR & IFS | Free | 24 min |
| 6 | COUNTIF & SUMIF | Free | 23 min |
| 7 | DATE, YEAR, MONTH & TEXT | Pro | 23 min |
| 8 | EDATE, EOMONTH & NETWORKDAYS | Pro | 24 min |
| 9 | Running totals & share of total | Pro | 24 min |
| 10 | Conditional formatting with formulas | Free | 25 min |
| 11 | PivotTables | Free | 27 min |
| 12 | Charts: pick the right one | Free | 24 min |
| 13 | Timed run: the analyst interview capstone | Pro | 20 min |
| 14 | Retake the skills test and compare | Free | 10 min |
Questions
Do project managers get tested on Excel?
Often as part of a case exercise: a small schedule or budget and a few questions on dates, totals and status.
Which functions come up most?
NETWORKDAYS and EDATE for schedules, SUMIFS for budgets, and IF rules for status.
How long should I prepare?
One to two weeks at about 30 minutes a day.
Prep for other roles
Updated Checked by running: every exercise answer on this page was graded by our formula engine on .