Excel skills test / Office and administration
Excel test for office and admin jobs
Ten everyday tasks for an administrative assistant, office manager or coordinator, in a live spreadsheet: weekly hours, names and email addresses, an RSVP count, overdue tasks, a phone list, expense claims, deadlines and a sorted list. It's free and there's nothing to sign up for.
What it tests
Administrative work in Excel is mostly lists: people, tasks, dates and small amounts of money. The skills that save the most time are joining and cleaning text, counting and totalling with a condition, simple IF tests, date arithmetic and looking something up in a list. Job adverts that ask for "good Excel skills" for office roles usually mean these.
The 10 tasks
- Totals (beginner): Add up the hours for the week of each person in
G2:G5. One formula inG2, copied down. - Text (beginner): Put the full name of each person in
C2:C5: first name, a space, then last name. - Counting (beginner): How many guests answered Yes? Count them in
E2. - Text (intermediate): Company email addresses are first.last@northwind.example, all in small letters. Build the address of each person in
C2:C5. - Text (intermediate): The room codes were typed carelessly. In
B2:B5, show each one in capitals with no spaces before or after. - Logic (intermediate): In
C2:C6, show Overdue for every task whose due date is before the date inF1, and On track for the rest. - Lookups (intermediate): What is the phone extension of the person named in
E2? Put it inE3, so it changes when another name is typed inE2. - Conditional sums (intermediate): How much has Ben claimed in expenses? Work out the total in
F2. - Dates (advanced): Each request must be answered within the number of working days in column B, counted from the day after it arrived. Work out the deadline of each one in
C2:C5. Weekends do not count. - Dynamic arrays (advanced): List the attendees in alphabetical order, starting in
C2, with one formula that keeps the list in order when names are added or changed.
Your result
- Job-ready (9–10): You would be comfortable with these tasks in an interview or on the first day.
- Strong (7–8): Most of it is there. The tasks you missed are worth an evening each.
- Getting there (4–6): You know the basics of the job. The lessons below fill the gaps.
- Starting out (0–3): A fair first try. Start with the lessons below and come back.
Any formula that gets the right answer counts. Missed a task? The results link to the lesson that teaches it. We keep each attempt's answers and score, without any personal details, to see which tasks people find hard.
Common questions
What Excel skills do I need for an office or admin job?
Entering and tidying data, SUM and AVERAGE, COUNTIF and SUMIF, IF, joining text with &, working with dates, and one lookup function. Sorting, filtering and formatting a sheet so that others can read it matter just as much.
How hard is it?
The first three tasks are basics, the next five are everyday formulas, and the last two (working-day deadlines and a self-sorting list) are the ones that set people apart. You can skip a task and still finish the test.