Picture two hypothetical applicants for the same data entry assignment. The first types 75 words per minute on casual practice sites but rushes, and on the agency’s timed test her accuracy drops to 91 percent. The second types a steady 48 words per minute with 99 percent accuracy and knows how to use Excel’s sort, filter and VLOOKUP without searching for help. For most office roles, the second applicant has the stronger result. Speed gets attention. Accuracy and practical spreadsheet skill get people placed.
That is the pattern behind most office assessments: they measure whether you can produce correct work at a reasonable pace, not whether you can win a typing race.
In short
Staffing firms and many employers test four things for office and admin roles: keyboarding speed with accuracy, data entry (alphanumeric and often 10-key), Excel at a basic-to-intermediate level, and sometimes Word or proofreading. Accuracy usually matters as much as speed, tests are timed and often taken online, and a few weeks of focused practice on the actual task types will move your scores more than general typing games.
Keyboarding tests: what is measured
A standard typing test gives you a passage and a time limit, often one to five minutes. The score is usually reported as net words per minute, which subtracts errors from your gross speed, plus an accuracy percentage. A “word” is typically counted as five characters, including spaces.
Employers set their own thresholds, and they vary by role. A receptionist post may care more about phone skills than typing speed; a transcription or data role will care much more. Read the posting or ask the recruiter what score they look for rather than relying on a number from a forum.
How to improve
- Fix technique first. Home-row position, eyes on the screen, no looking at the keys. Hunt-and-peck typists hit a ceiling quickly.
- Practice for accuracy, then speed. Slow down until you hit 98 percent or better, then push the pace gradually.
- Use real text. Business emails and paragraphs with numbers, punctuation and capital letters are closer to test passages than random word lists.
- Fifteen minutes a day beats a two-hour session on a weekend.
Data entry and 10-key tests
Data entry tests usually show you a form or a table of records and ask you to key the information into fields. They are scored by keystrokes per hour and error rate. Alphanumeric tests mix names, addresses and codes. A 10-key test uses only the numeric keypad and is common for accounting clerk, billing and payroll roles.
- Learn the 10-key home position: index finger on 4, middle on 5, ring on 6, thumb on 0.
- Practice with a laptop and an external numeric keypad if your laptop does not have one; testing centers and many agencies use full keyboards.
- Double-check fields like ZIP codes, dates and dollar amounts. One transposed digit counts as an error, and errors are what clients notice.
We go deeper into accuracy habits in our guide to data entry accuracy skills.
The Excel skills that come up most
Office Excel assessments are usually task-based: you get a workbook and instructions, and the software records whether you completed each task correctly. Some are multiple-choice. Either way, the same skills show up again and again.
| Level | Skills commonly tested |
|---|---|
| Basic | Entering and formatting data, adjusting column width, freezing panes, basic formulas (SUM, AVERAGE, MIN, MAX), sorting, simple charts, printing a selected range |
| Intermediate | Filters, conditional formatting, absolute vs. relative references, IF, COUNTIF, SUMIF, VLOOKUP or XLOOKUP, removing duplicates, basic pivot tables |
| Advanced | Nested formulas, INDEX/MATCH, data validation, pivot tables with grouping, macros (rare for entry roles) |
For most admin and clerical jobs, solid intermediate skills are enough. Practice in the actual program: Microsoft offers free Excel training videos and templates on its support site, and building a small personal budget or a fake inventory list will teach you more than reading about functions.
If you want proof beyond a staffing firm’s test, the Microsoft Office Specialist exam is one option; see our MOS certification guide for what it involves.
Word and proofreading checks
Some employers add a Word test (formatting a letter, inserting a table, using track changes, mail merge) or a proofreading exercise where you mark errors in a short document. For proofreading, read slowly, read the document twice, and pay attention to numbers, names and consistent formatting, not just spelling.
Testing conditions to expect
- Many agencies send a link to take assessments online from home; others ask you to test at a branch.
- Tests are timed, and some can be taken only once within a set period.
- You may be asked not to use outside help. Do the test honestly; a client will see your real skill level on day one anyway.
- If you have a disability that affects testing, you can ask for a reasonable accommodation. The EEOC’s guidance on employment tests says employers must provide reasonable accommodations in how tests are given, unless doing so would cause undue hardship.
Frequently asked questions
Can I retake a staffing agency’s typing test?
Often yes, after a waiting period, but policies differ. Ask the recruiter. If your first score was low, tell them you have been practicing and ask for a retest in a week or two.
Does it matter if I learned on Google Sheets instead of Excel?
The concepts are almost identical, but the menus differ. If a test is in Excel, spend a few sessions in Excel first so you are not hunting for options under a time limit.
Should I list my typing speed on a resume?
Only a recent, tested number that helps you. A verified result from an agency or a recognized test is better than a self-reported figure.
What if my laptop has no numeric keypad?
An inexpensive USB keypad is enough for practice. Before an in-person test, ask what equipment you will use so you can practice on the same layout.
What to do this week
Take one baseline typing test and write down your net speed and accuracy. Then practice 15 minutes a day for seven days, aiming to raise accuracy first. Spend three evenings in Excel building a small list and practicing sorting, filtering, SUMIF and VLOOKUP. At the end of the week, retest your typing and compare. Bring both numbers to your next recruiter call.



