Cellwise Start free

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.

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
Every task in the Office and admin preset, by level and workbook
LevelPasted contact listSales log
BasicClean up names
Lowercase emails
Email domain
Gmail addresses
Revenue per order
Total units
Average order size
Orders from East
IntermediateFirst names
Last names
Full names
Phone digits only
Commission per order
Revenue for one region
Desk lamps in that region
Large orders
AdvancedLast 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

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.

RowABCDEFGHIJK
1Order dateRepRegionProductUnitsUnit priceRevenueCommissionCommission rate4%
2Oct 2, 2026Maya ChenEastDesk lamp12$24.50$294.00RegionWest
3Oct 3, 2026Luis OrtizWestOffice chair4$149.00$596.00
4Oct 7, 2026Priya NairNorthDesk lamp20$24.50$490.00Revenue, region in K2
5Oct 9, 2026Maya ChenEastMonitor arm6$89.00$534.00Desk lamp units, region in K2
6Oct 14, 2026Sam OkaforSouthOffice chair3$149.00$447.00Orders of 10+ units
7Oct 16, 2026Luis OrtizWestDesk lamp15$24.50$367.50
8Oct 21, 2026Priya NairNorthStanding desk2$420.00$840.00
9Oct 23, 2026Sam OkaforSouthMonitor arm9$89.00$801.00
10Oct 28, 2026Maya ChenEastStanding desk1$420.00$420.00
11Oct 30, 2026Luis OrtizWestMonitor arm10$89.00$890.00
Answers to the sample task, what each returns on the visible sheet, and the hidden checks
Formula in K4Sheet they seeHidden checksResult
=SUMIF(C2:C11,K2,G2:G11)SUMIF pointed at K2 $1,853.50 right Right on bothSolved
=SUMIF(C2:C11,"West",G2:G11)The region typed into the formula $1,853.50 right Wrong on new numbersNot 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:

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

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)

Create a free administrative assistant testCompare plans

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.