Typing Speed and Excel Skills Employers Actually Test

2 months ago

By admin

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

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.

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

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.

About the Author

Author

Trending Articles: