# 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.

Source: https://spreadsheetpractice.com/excel-test/project-manager · Updated October 29, 2026

## What employers usually test

| Skill | Functions | Practice |
|---|---|---|
| Totals and variances | SUM, % change | [Lesson 2: SUM, AVERAGE, MIN, MAX & COUNT](https://spreadsheetpractice.com/learn/sum-average-min-max-count) (free) |
| Status rules | IF, AND, OR | [Lesson 6: AND, OR & IFS](https://spreadsheetpractice.com/learn/and-or-ifs) (free) |
| Working days | NETWORKDAYS | [Lesson 24: EDATE, EOMONTH & NETWORKDAYS](https://spreadsheetpractice.com/learn/edate-eomonth-networkdays) (Pro) |
| Due dates | DATE, EDATE | [Lesson 23: DATE, YEAR, MONTH & TEXT](https://spreadsheetpractice.com/learn/date-year-month-text) (Pro) |
| Running budget | running totals | [Lesson 36: Running totals & share of total](https://spreadsheetpractice.com/learn/running-totals-share-of-total) (Pro) |
| Spotting problems | conditional formatting | [Lesson 9: Conditional formatting with formulas](https://spreadsheetpractice.com/learn/conditional-formatting-formulas) (free) |

## A sample task

**Business days.** In F2, count the weekdays from each start date to its end date. Fill down to F6.

From [EDATE, EOMONTH & NETWORKDAYS](https://spreadsheetpractice.com/learn/edate-eomonth-networkdays). Solve it, graded instantly, at [the project manager test page](https://spreadsheetpractice.com/excel-test/project-manager).

## A 14-day prep plan

About 30 minutes a day.

| Day | Focus | Access |
|---|---|---|
| 1 | [SUM, AVERAGE, MIN, MAX & COUNT](https://spreadsheetpractice.com/learn/sum-average-min-max-count) | Free |
| 2 | [Relative vs absolute references](https://spreadsheetpractice.com/learn/relative-absolute-references) | Free |
| 3 | [Percentages & growth](https://spreadsheetpractice.com/learn/percentages-and-growth) | Free |
| 4 | [The IF function](https://spreadsheetpractice.com/learn/if-function) | Free |
| 5 | [AND, OR & IFS](https://spreadsheetpractice.com/learn/and-or-ifs) | Free |
| 6 | [COUNTIF & SUMIF](https://spreadsheetpractice.com/learn/countif-sumif) | Free |
| 7 | [DATE, YEAR, MONTH & TEXT](https://spreadsheetpractice.com/learn/date-year-month-text) | Pro |
| 8 | [EDATE, EOMONTH & NETWORKDAYS](https://spreadsheetpractice.com/learn/edate-eomonth-networkdays) | Pro |
| 9 | [Running totals & share of total](https://spreadsheetpractice.com/learn/running-totals-share-of-total) | Pro |
| 10 | [Conditional formatting with formulas](https://spreadsheetpractice.com/learn/conditional-formatting-formulas) | Free |
| 11 | [PivotTables](https://spreadsheetpractice.com/learn/pivottables) | Free |
| 12 | [Charts: pick the right one](https://spreadsheetpractice.com/learn/charts) | Free |
| 13 | [Timed run: the analyst interview capstone](https://spreadsheetpractice.com/learn/capstone-analyst-interview) | Pro |
| 14 | [Retake the skills test and compare](https://spreadsheetpractice.com/excel-skills-test) | Free |

## 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

- [Financial analyst](https://spreadsheetpractice.com/excel-test/financial-analyst)
- [Accountant](https://spreadsheetpractice.com/excel-test/accountant)
- [Administrative assistant](https://spreadsheetpractice.com/excel-test/administrative-assistant)
- [Data analyst](https://spreadsheetpractice.com/excel-test/data-analyst)
- [Operations analyst](https://spreadsheetpractice.com/excel-test/operations-analyst)
- [Marketing analyst](https://spreadsheetpractice.com/excel-test/marketing-analyst)
- [HR analyst](https://spreadsheetpractice.com/excel-test/hr-analyst)
- [Sales analyst](https://spreadsheetpractice.com/excel-test/sales-analyst)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
