Spreadsheet Practice

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

SkillFunctionsPractice
Totals and variancesSUM, % changeLesson 2 Free
Status rulesIF, AND, ORLesson 6 Free
Working daysNETWORKDAYSLesson 24 Pro
Due datesDATE, EDATELesson 23 Pro
Running budgetrunning totalsLesson 36 Pro
Spotting problemsconditional formattingLesson 9 Free

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.

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 .