Cellwise Hire · Office and admin preset
Excel test for administrative assistants
Candidates do the Excel an office actually runs on: tidy a contact list pasted from a form, split and join names, then answer quick questions from a sales log. Every answer is checked by what it calculates, so you see who can make a sheet that keeps working after they hand it over.
Create a free administrative assistant testSee a sample task
Free for your first 3 candidates. The Office and admin preset is preselected for you.
The test at a glance
- Workbooks
- Pasted contact list + Sales log
- Tasks
- 8 hands-on tasks at the level you pick
- Levels
- Basic, Intermediate or Advanced
- Time
- You choose; 20 to 40 minutes suits most
- Grading
- By result, on the visible sheet and 2 hidden versions
Good for: Administrative assistants, Executive assistants, Office managers, Receptionists and office coordinators.
What administrative assistants actually do in Excel
An administrative assistant is often the person who keeps the shared lists: contacts, attendees, suppliers, a team rota. The data arrives pasted from a web form or an email, in mixed capitals with stray spaces, and has to be tidy before it goes into a mail merge or a name badge.
They are also the person a manager leans over to and asks "how many orders came from the East region?" or "what did West bring in this month?". The good answer is a formula that still gives the right number when the list grows or the region changes.
- Cleaning names and emails pasted from forms and exports
- Splitting "Last, First" into two columns and joining them back for a mail merge
- Totals, averages and counts from a log, with COUNTIF for "how many from East?"
- Answers that follow an input cell, so changing the region updates the total
- Spotting people who signed up twice
What the test checks
The Office and admin preset uses two workbooks: Pasted contact list (contacts pasted in from a sign-up form export: inconsistent capitals, extra spaces and mixed phone formats) and Sales log (october orders: one row per order, with the rep, region, product, units and unit price). Here is what that covers for administrative assistants, with the real task names and the level each one appears at.
Tidying a pasted list
Extra spaces removed and names capitalized properly, emails in lowercase, and the domain pulled out of each address. TRIM and PROPER together, LOWER, and a little text work with FIND or TEXTAFTER.
- Clean up namesBasic
- Lowercase emailsBasic
- Email domainBasic
Names for a mail merge
Names pasted as "Last, First" with uneven spacing, split into first and last name columns and joined back as "First Last".
- First namesIntermediate
- Last namesIntermediate
- Full namesIntermediate
Quick totals and counts
A column total, an average rounded to one decimal, a COUNTIF, and a revenue column filled down. The everyday questions, answered with formulas that cover the whole column.
- Total unitsBasic
- Average order sizeBasic
- Orders from EastBasic
- Revenue per orderBasic
Answers that follow a cell
Totals for whichever region is typed in a cell, and a commission rate locked with $ so the formula fills down. This is what separates a sheet a manager can reuse from a one-off answer.
- Revenue for one regionIntermediate
- Commission per orderIntermediate
- Large ordersIntermediate
Duplicates and unique counts
People who signed up twice with the same email in different capitals, flagged, and a count of unique addresses. At the Advanced level, for office managers who own the lists.
- Flag duplicate emailsAdvanced
- Unique contactsAdvanced
Every task in this test, by level
| Level | Pasted contact list | Sales log |
|---|---|---|
| Basic | Clean up names Lowercase emails Email domain Gmail addresses | Revenue per order Total units Average order size Orders from East |
| Intermediate | First names Last names Full names Phone digits only | Commission per order Revenue for one region Desk lamps in that region Large orders |
| Advanced | Last word as last name Initials Flag duplicate emails Unique contacts | Running total Rep with the biggest order Rep revenue since a date Different products sold |
Each test uses one level: four tasks from each workbook.
Which level to choose
- Basic · 20 minutes suggestedMost administrative assistant and receptionist roles: tidy names and emails, totals, an average and a COUNTIF.
- Intermediate · 30 minutes suggestedExecutive assistants and office coordinators who prepare figures for others: names split for a mail merge, totals that follow an input cell.
- Advanced · 40 minutes suggestedOffice managers who own the data: duplicate sign-ups, unique counts, running totals and date-based totals.
A real task from this test
This is one of the tasks in the Office and admin preset at the Intermediate level, on the sheet candidates see. The answers below were run through the same grader that marks real tests: on this sheet, and on two hidden versions with different data and an extra row inserted.
Sample task · Sales log · Intermediate
Revenue for one region (in K4). Total the revenue (column G) for whichever region is typed in K2, so that changing K2 changes the total.
| Row | A | B | C | D | E | F | G | H | I | J | K |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order date | Rep | Region | Product | Units | Unit price | Revenue | Commission | Commission rate | 4% | |
| 2 | Oct 2, 2026 | Maya Chen | East | Desk lamp | 12 | $24.50 | $294.00 | Region | West | ||
| 3 | Oct 3, 2026 | Luis Ortiz | West | Office chair | 4 | $149.00 | $596.00 | ||||
| 4 | Oct 7, 2026 | Priya Nair | North | Desk lamp | 20 | $24.50 | $490.00 | Revenue, region in K2 | |||
| 5 | Oct 9, 2026 | Maya Chen | East | Monitor arm | 6 | $89.00 | $534.00 | Desk lamp units, region in K2 | |||
| 6 | Oct 14, 2026 | Sam Okafor | South | Office chair | 3 | $149.00 | $447.00 | Orders of 10+ units | |||
| 7 | Oct 16, 2026 | Luis Ortiz | West | Desk lamp | 15 | $24.50 | $367.50 | ||||
| 8 | Oct 21, 2026 | Priya Nair | North | Standing desk | 2 | $420.00 | $840.00 | ||||
| 9 | Oct 23, 2026 | Sam Okafor | South | Monitor arm | 9 | $89.00 | $801.00 | ||||
| 10 | Oct 28, 2026 | Maya Chen | East | Standing desk | 1 | $420.00 | $420.00 | ||||
| 11 | Oct 30, 2026 | Luis Ortiz | West | Monitor arm | 10 | $89.00 | $890.00 |
| Formula in K4 | Sheet they see | Hidden checks | Result |
|---|---|---|---|
=SUMIF(C2:C11,K2,G2:G11)SUMIF pointed at K2 | $1,853.50 right | Right on both | Solved |
=SUMIF(C2:C11,"West",G2:G11)The region typed into the formula | $1,853.50 right | Wrong on new numbers | Not solvedRight on the visible data only |
=SUMIF(C2:C11,"West",G2:G11)It gives the right total today, because K2 says West. Change K2 to another region and it still totals West. The hidden version has a different region in K2, so this answer is caught there.
Both answers match on the sheet the candidate sees. A test that only checked the final number would pass both. The hidden check is what tells them apart, and it is the same thing that goes wrong when an assistant hands over a sheet and the next person changes the region.
Results calculated by the Cellwise formula engine. The hidden versions stay on our server, so this page shows only whether each answer passed them.
See the screen your administrative assistant candidates work in: try a 3-minute sample test and read the report you would get. No signup.
What the report shows
When a candidate finishes, you get an overall score and every task: solved or not, the exact formula they wrote, the time spent and the number of tries, plain-English notes, and a replay of every edit with the sheet as it looked at each step. For administrative assistants, two things are worth a look:
- Look at the "follow a cell" tasks. A region or a rate typed into a formula shows up as a plain-English note, so you know whether their sheets will survive being reused.
- On the contact list, the formula tells you whether they cleaned the data with TRIM and PROPER or retyped it. Retyping ten rows works; retyping a thousand-row export does not, and the hidden version has different names.
You can also add 8 multiple-choice knowledge questions at the same level, scored separately. Candidates never see their score.
What this test does not cover
- It does not test formatting, printing, charts, PivotTables, Word or Outlook. If the job relies on those, check them in the interview.
- It does not measure typing speed. For roles where volume keying matters, see the Excel test for data entry clerks.
Pricing
Free for your first 3 candidates, no card needed. Then Starter is $79 a month or $790 a year for 25 completed candidates a month, and Agency is $199 a month or $1,990 a year for unlimited candidates. Only candidates who complete a test count.
Founding price: locked for as long as you stay subscribed (first 10 customers)
FAQ
What Excel skills should an administrative assistant have?
Keeping lists tidy (TRIM, PROPER, sorting and filtering without scrambling rows), quick totals and counts with SUM, AVERAGE and COUNTIF, a simple IF, and copying a formula down without breaking it. Executive assistants and office managers often add SUMIF with a criterion in a cell, splitting and joining names, and finding duplicates.
Which level should I choose for an admin role?
Basic suits most administrative assistant and receptionist roles. Intermediate suits executive assistants and coordinators who prepare figures for others. Advanced is for office managers who own shared data and reports.
Do candidates need Excel installed?
No. The test runs in the browser with a formula bar, fill-down, copy and paste and the usual keyboard shortcuts. Candidates open your link, enter their name and email, and start. No account is needed.
Can I use the same test for every admin vacancy?
Yes. One test link works for every candidate, and each email address can take it once. Using the same test and time limit for everyone applying for a role keeps results comparable.
Is it fair to give admin candidates an Excel test?
A short test that reflects what the job really involves is a common part of hiring. Give every candidate the same test and time, follow local hiring law, and keep tests job-related.
Related
Looking to learn Excel yourself? Start the free Cellwise course.