Cellwise Hire · Office and admin preset
Excel test for data entry clerks
Data entry is mostly cleanup. Candidates get a contact list pasted from a sign-up form, with mixed capitals, stray spaces and three phone formats, and make it consistent with formulas. Then they check counts in a sales log. Answers are graded on hidden versions of the data, so you see who can clean a list of any length.
Create a free data entry clerk 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: Data entry clerks, Data entry operators, Records and admin assistants, Customer database assistants.
What data entry clerks actually do in Excel
Records come in from web forms, spreadsheets other people kept, scanned forms and system exports. A data entry clerk makes them consistent before they go into a CRM or a database: one format for names, lowercase emails, phone numbers stripped to digits, no duplicates.
Ten rows can be fixed by hand. Four thousand cannot. The skill that matters is knowing which formula turns the whole column into the clean version, then checking the result before it is pasted back as values.
- Trimming spaces and fixing capitals in pasted names
- Lowercasing emails and pulling out the domain
- Stripping brackets, spaces and dashes from phone numbers
- Splitting "Last, First" and handling middle names
- Flagging duplicates and counting unique records
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 data entry clerks, with the real task names and the level each one appears at.
Consistent names
TRIM and PROPER for the whole column, then the last word of a name with a middle name in it, and initials. The extra spaces are inside the names as well as around them.
- Clean up namesBasic
- Last word as last nameAdvanced
- InitialsAdvanced
Emails and domains
Emails in lowercase, the domain after the @, and a count of one domain whatever the capitals.
- Lowercase emailsBasic
- Email domainBasic
- Gmail addressesBasic
Phone numbers to digits
Numbers pasted as (555) 014-2290, 555-014-7731 and 555 014 3384, all reduced to ten digits with nested SUBSTITUTE or a TEXTSPLIT.
- Phone digits onlyIntermediate
Splitting and joining names
Names pasted as "Last, First" with uneven spacing around the comma, split and joined back as "First Last".
- First namesIntermediate
- Last namesIntermediate
- Full namesIntermediate
Duplicates and counts
The same email entered twice in different capitals, flagged; unique addresses counted; and counts in a sales log that you would check against the source system.
- Flag duplicate emailsAdvanced
- Unique contactsAdvanced
- Orders from EastBasic
- Different products soldAdvanced
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 data entry roles: clean names, lowercase emails, the domain, and a count with a wildcard.
- Intermediate · 30 minutes suggestedRoles that prepare imports: split "Last, First", rebuild full names and strip phone numbers to digits.
- Advanced · 40 minutes suggestedDatabase and records roles: middle names, initials, duplicate emails and unique counts.
A real task from this test
This is one of the tasks in the Office and admin preset at the Basic 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 · Pasted contact list · Basic
Clean up names (in D2, filled down to D11). Make every pasted name tidy: no spaces at the start, end or in the middle beyond one, and each word capitalized. One formula, filled down the column.
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Name (as pasted) | Phone | Clean name | |
| 2 | maya CHEN | [email protected] | (555) 014-2290 | |
| 3 | luis ortiz | [email protected] | 555-014-7731 | |
| 4 | PRIYA nair | [email protected] | 555 014 3384 | |
| 5 | sam okafor | [email protected] | (555) 014-9012 | |
| 6 | dana whitfield | [email protected] | 555-014-5547 | |
| 7 | jordan LEE | [email protected] | 555 014 6620 | |
| 8 | ana lopez | [email protected] | (555) 014-1185 | |
| 9 | BEN carter | [email protected] | 555-014-8843 | |
| 10 | grace kim | [email protected] | 555 014 2671 | |
| 11 | omar haddad | [email protected] | (555) 014-3309 |
| Formula in D2 | Sheet they see | Hidden checks | Result |
|---|---|---|---|
=PROPER(TRIM(A2))TRIM, then PROPER | 10 of 10 rows right right | Right on both | Solved |
=PROPER(A2)PROPER on its own | 3 of 10 rows right wrong | Not needed: already wrong | Not solved |
=PROPER(A2)The capitals look right, so it passes a quick glance. But the extra spaces are still there, and a name with a trailing space will not match the same name in another list. That is exactly the kind of problem data entry exists to remove.
Row by row
| Row | Name (as pasted) | =PROPER(TRIM(A2)) | =PROPER(A2) |
|---|---|---|---|
| 2 | ··maya CHEN | Maya Chen | ··Maya Chen (wrong) |
| 3 | luis ortiz· | Luis Ortiz | Luis Ortiz· (wrong) |
| 4 | PRIYA···nair | Priya Nair | Priya···Nair (wrong) |
| 5 | sam okafor | Sam Okafor | Sam Okafor |
| 6 | ·dana··whitfield | Dana Whitfield | ·Dana··Whitfield (wrong) |
| 7 | jordan LEE | Jordan Lee | Jordan Lee |
| 8 | ·ana··lopez· | Ana Lopez | ·Ana··Lopez· (wrong) |
| 9 | BEN carter | Ben Carter | Ben Carter |
| 10 | grace··kim | Grace Kim | Grace··Kim (wrong) |
| 11 | omar···haddad· | Omar Haddad | Omar···Haddad· (wrong) |
In the row-by-row table, red dots show the spaces that make a name messy: spaces at the start or end, and runs of spaces between words (one dot per space). The hidden version has different names with spaces in different places, so typing the clean names in by hand fails there too.
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 data entry clerk 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 data entry clerks, two things are worth a look:
- The notes say when a candidate typed the cleaned values in instead of using a formula. For some data entry jobs careful manual work is fine; the replay shows you exactly how they worked, so you can decide.
- Partly filled columns are flagged ("Filled 6 of 10 cells"), which tells you whether the candidate checked the whole list or stopped at the rows on screen.
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
- Cellwise Hire does not measure typing speed or keystrokes per hour. If speed matters for the role, run a separate typing test alongside it.
- It tests Excel only, not a specific CRM or database. For general office work, see the Excel test for administrative assistants, which uses the same two workbooks with an office focus.
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 are tested for data entry jobs?
Cleaning data with TRIM, PROPER, UPPER and LOWER, pulling text apart with LEFT, MID, FIND or TEXTBEFORE and TEXTAFTER, SUBSTITUTE to strip unwanted characters, joining text, finding duplicates with COUNTIF, and counting records to check against the source.
Does the test check typing speed?
No. It checks whether a candidate can make data consistent and correct with formulas. If typing speed matters for the job, use a separate typing test.
What if a candidate fixes the data by hand?
Typed values are right on the sheet the candidate sees, but the hidden version has different records, so they do not pass, and the report notes "Typed the answer instead of a formula". The replay shows each edit, so you can still see how careful their manual work was.
Which level should I choose for data entry?
Basic for most data entry roles, Intermediate for roles that prepare imports (splitting names, stripping phone numbers), and Advanced for database or records roles where duplicates and middle names matter.
Is it fair to give data entry candidates an Excel test?
A short test that reflects the real work 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.