Cellwise Start free

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.

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
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 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.

RowABCD
1Name (as pasted)EmailPhoneClean name
2 maya CHEN[email protected](555) 014-2290
3luis ortiz [email protected]555-014-7731
4PRIYA nair[email protected]555 014 3384
5sam okafor[email protected](555) 014-9012
6 dana whitfield[email protected]555-014-5547
7jordan LEE[email protected]555 014 6620
8 ana lopez [email protected](555) 014-1185
9BEN carter[email protected]555-014-8843
10grace kim[email protected]555 014 2671
11omar haddad [email protected](555) 014-3309
Answers to the sample task, what each returns on the visible sheet, and the hidden checks
Formula in D2Sheet they seeHidden checksResult
=PROPER(TRIM(A2))TRIM, then PROPER 10 of 10 rows right right Right on bothSolved
=PROPER(A2)PROPER on its own 3 of 10 rows right wrongNot needed: already wrongNot 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
Each answer's result in every row of the sample
RowName (as pasted)=PROPER(TRIM(A2))=PROPER(A2)
2··maya CHENMaya Chen··Maya Chen (wrong)
3luis ortiz·Luis OrtizLuis Ortiz· (wrong)
4PRIYA···nairPriya NairPriya···Nair (wrong)
5sam okaforSam OkaforSam Okafor
6·dana··whitfieldDana Whitfield·Dana··Whitfield (wrong)
7jordan LEEJordan LeeJordan Lee
8·ana··lopez·Ana Lopez·Ana··Lopez· (wrong)
9BEN carterBen CarterBen Carter
10grace··kimGrace KimGrace··Kim (wrong)
11omar···haddad·Omar HaddadOmar···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:

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 data entry clerk testCompare plans

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.