# Operations analyst Excel test: skills, sample task and prep plan

> Operations roles test practical logic: flag orders that meet rules, count by status, look up rates, round up quantities, and count working days between dates.

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

## What employers usually test

| Skill | Functions | Practice |
|---|---|---|
| Rules and flags | IF, AND, OR | [Lesson 6: AND, OR & IFS](https://spreadsheetpractice.com/learn/and-or-ifs) (free) |
| Counts by status | COUNTIFS | [Lesson 8: COUNTIFS, SUMIFS & AVERAGEIFS](https://spreadsheetpractice.com/learn/countifs-sumifs-averageifs) (free) |
| Rate lookups | XLOOKUP | [Lesson 13: XLOOKUP](https://spreadsheetpractice.com/learn/xlookup) (Pro) |
| Tiered pricing | approximate match | [Lesson 15: Tiered lookups & IFERROR](https://spreadsheetpractice.com/learn/tiered-lookups-iferror) (Pro) |
| Capacity math | ROUNDUP | [Lesson 33: ROUND, ROUNDUP & ROUNDDOWN](https://spreadsheetpractice.com/learn/round-roundup-rounddown) (Pro) |
| Working days | NETWORKDAYS | [Lesson 24: EDATE, EOMONTH & NETWORKDAYS](https://spreadsheetpractice.com/learn/edate-eomonth-networkdays) (Pro) |

## A sample task

**Boxes needed.** In D2, calculate how many boxes each order needs. A partial box still counts as a box. Fill down to D6.

From [ROUND, ROUNDUP & ROUNDDOWN](https://spreadsheetpractice.com/learn/round-roundup-rounddown). Solve it, graded instantly, at [the operations analyst test page](https://spreadsheetpractice.com/excel-test/operations-analyst).

## 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 | [The IF function](https://spreadsheetpractice.com/learn/if-function) | Free |
| 4 | [AND, OR & IFS](https://spreadsheetpractice.com/learn/and-or-ifs) | Free |
| 5 | [COUNTIF & SUMIF](https://spreadsheetpractice.com/learn/countif-sumif) | Free |
| 6 | [COUNTIFS, SUMIFS & AVERAGEIFS](https://spreadsheetpractice.com/learn/countifs-sumifs-averageifs) | Free |
| 7 | [XLOOKUP](https://spreadsheetpractice.com/learn/xlookup) | Pro |
| 8 | [Tiered lookups & IFERROR](https://spreadsheetpractice.com/learn/tiered-lookups-iferror) | Pro |
| 9 | [DATE, YEAR, MONTH & TEXT](https://spreadsheetpractice.com/learn/date-year-month-text) | Pro |
| 10 | [EDATE, EOMONTH & NETWORKDAYS](https://spreadsheetpractice.com/learn/edate-eomonth-networkdays) | Pro |
| 11 | [ROUND, ROUNDUP & ROUNDDOWN](https://spreadsheetpractice.com/learn/round-roundup-rounddown) | Pro |
| 12 | [RANK, LARGE & SMALL](https://spreadsheetpractice.com/learn/rank-large-small) | Pro |
| 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

### What does a typical task look like?

A table of orders or shipments, with questions like "how many late orders per region" or "flag orders over a threshold that ship to a priority customer."

### Which functions matter most?

IF with AND/OR, COUNTIFS and lookups cover most operations tasks.

### How long should I prepare?

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)
- [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)
- [Project manager](https://spreadsheetpractice.com/excel-test/project-manager)

---

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