# Excel test for administrative assistants: what to expect

> Office and admin roles often screen for everyday Excel: totals and averages, simple IF rules, counting entries, cleaning names and emails, and working with dates.

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

## What employers usually test

| Skill | Functions | Practice |
|---|---|---|
| Totals and averages | SUM, AVERAGE | [Lesson 2: SUM, AVERAGE, MIN, MAX & COUNT](https://spreadsheetpractice.com/learn/sum-average-min-max-count) (free) |
| Simple rules | IF | [Lesson 5: The IF function](https://spreadsheetpractice.com/learn/if-function) (free) |
| Counting entries | COUNTIF | [Lesson 7: COUNTIF & SUMIF](https://spreadsheetpractice.com/learn/countif-sumif) (free) |
| Combining names | & and TEXTJOIN | [Lesson 19: Joining text](https://spreadsheetpractice.com/learn/joining-text) (Pro) |
| Fixing messy text | TRIM, PROPER | [Lesson 20: Cleaning messy data](https://spreadsheetpractice.com/learn/cleaning-messy-data) (Pro) |
| Dates | YEAR, TEXT | [Lesson 23: DATE, YEAR, MONTH & TEXT](https://spreadsheetpractice.com/learn/date-year-month-text) (Pro) |

## A sample task

**Full name.** In D2, join first and last name with a space. Fill down to D6.

From [Joining text](https://spreadsheetpractice.com/learn/joining-text). Solve it, graded instantly, at [the administrative assistant test page](https://spreadsheetpractice.com/excel-test/administrative-assistant).

## A 14-day prep plan

About 30 minutes a day.

| Day | Focus | Access |
|---|---|---|
| 1 | [Your first formula](https://spreadsheetpractice.com/learn/first-formula) | Free |
| 2 | [SUM, AVERAGE, MIN, MAX & COUNT](https://spreadsheetpractice.com/learn/sum-average-min-max-count) | Free |
| 3 | [Relative vs absolute references](https://spreadsheetpractice.com/learn/relative-absolute-references) | Free |
| 4 | [Percentages & growth](https://spreadsheetpractice.com/learn/percentages-and-growth) | Free |
| 5 | [The IF function](https://spreadsheetpractice.com/learn/if-function) | Free |
| 6 | [AND, OR & IFS](https://spreadsheetpractice.com/learn/and-or-ifs) | Free |
| 7 | [COUNTIF & SUMIF](https://spreadsheetpractice.com/learn/countif-sumif) | Free |
| 8 | [VLOOKUP](https://spreadsheetpractice.com/learn/vlookup) | Pro |
| 9 | [Joining text](https://spreadsheetpractice.com/learn/joining-text) | Pro |
| 10 | [Cleaning messy data](https://spreadsheetpractice.com/learn/cleaning-messy-data) | Pro |
| 11 | [DATE, YEAR, MONTH & TEXT](https://spreadsheetpractice.com/learn/date-year-month-text) | Pro |
| 12 | [UNIQUE & SORT](https://spreadsheetpractice.com/learn/unique-sort) | 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

### Do I need advanced formulas?

Usually not. Speed and accuracy on the basics matter more: totals, simple IF rules, sorting and clean text.

### What if the test uses an older Excel version?

Everything in the first two tracks works in any version. Newer functions like XLOOKUP are marked in each lesson.

### How long should I prepare?

The free lessons take about an hour each with practice, and two weeks covers the plan below.

## Prep for other roles

- [Financial analyst](https://spreadsheetpractice.com/excel-test/financial-analyst)
- [Accountant](https://spreadsheetpractice.com/excel-test/accountant)
- [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)
- [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.
