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

  1. Totals (beginner): Add up the hours for the week of each person in G2:G5. One formula in G2, copied down.
  2. Text (beginner): Put the full name of each person in C2:C5: first name, a space, then last name.
  3. Counting (beginner): How many guests answered Yes? Count them in E2.
  4. Text (intermediate): Company email addresses are first.last@northwind.example, all in small letters. Build the address of each person in C2:C5.
  5. Text (intermediate): The room codes were typed carelessly. In B2:B5, show each one in capitals with no spaces before or after.
  6. Logic (intermediate): In C2:C6, show Overdue for every task whose due date is before the date in F1, and On track for the rest.
  7. Lookups (intermediate): What is the phone extension of the person named in E2? Put it in E3, so it changes when another name is typed in E2.
  8. Conditional sums (intermediate): How much has Ben claimed in expenses? Work out the total in F2.
  9. 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.
  10. 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

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.

Other tests