How to Prepare for Pre-Employment Office Skills Tests

1 month ago

By admin

“A staffing agency just emailed me a link to an assessment for an office assistant job. It says Word, Excel, filing and proofreading, and I have a week to finish it. Where do I even start?” That message describes a very common situation. Pre-employment skills tests are routine for clerical and admin roles, and a week is enough time to improve your score noticeably if you practice the right things.

The quick answer

  1. Find out exactly which tests you will take, how long each one is and whether you can retake them.
  2. Take a baseline practice run on each skill so you know where you stand.
  3. Spend most of your week on the weakest skill, with short daily sessions on the rest.
  4. Practice in the same software and on the same kind of keyboard you will use for the real test.
  5. Test when rested, in a quiet place, with nothing else open on your computer.

The tests you are most likely to see

Microsoft Word

Usually task-based: you open a document and follow instructions. Common tasks include applying styles and headings, changing margins and orientation, inserting and formatting a table, adding headers, footers and page numbers, using find and replace, tracking changes and accepting or rejecting edits, and occasionally a mail merge.

Microsoft Excel

Data entry and formatting, sorting and filtering, basic formulas such as SUM and AVERAGE, cell references, IF statements, lookups, simple charts and sometimes a pivot table. Our guide to typing speed and Excel skills breaks these into basic, intermediate and advanced levels.

Outlook or email

Less common but possible: scheduling a meeting with attendees, creating a folder rule, setting an out-of-office message.

Filing and alphabetizing

You put a list of names, companies or numbers in order following a filing rule. The tricky parts are the rules: how to file “The Smith Group,” names with prefixes like “Mc” or “De,” hyphenated names, numbers written as words, and dates. Read the instructions on the test screen; they usually state which rules apply.

10-key and data entry

Timed entry using the numeric keypad, scored by keystrokes per hour and accuracy. Accuracy usually weighs heavily. See our article on data entry accuracy for checking habits.

Proofreading

You compare two versions of a document or mark errors in one: misspellings, wrong numbers, inconsistent formatting, missing words, transposed digits in addresses or phone numbers. Speed matters less than catching everything.

Typing

A timed passage scored in net words per minute plus accuracy.

A one-week practice plan

Plan on about an hour a day. Adjust the focus based on your baseline.

Day Focus What to do
1 Baseline Take a free typing test, a 10-key test and a short proofreading exercise. Open Word and Excel and try five tasks from each list above. Write down your scores and what you could not do.
2 Excel Build a small list of 30 rows (for example, a hypothetical supply order). Practice sorting, filtering, SUM, AVERAGE, IF and a lookup. Make one chart.
3 Word Format a two-page letter and a memo: styles, a table, headers and footers, page numbers, track changes. Time yourself.
4 Accuracy skills Twenty minutes of 10-key, twenty minutes of typing for accuracy, twenty minutes of proofreading two versions of the same document.
5 Filing and weak spot Alphabetize lists with tricky names and companies. Spend the rest on whatever scored lowest on Day 1.
6 Mixed timed run Simulate the real test: one sitting, timer on, no breaks between sections, no outside help.
7 Light review Twenty minutes of typing and 10-key only. Rest. Check your computer, browser and internet connection for the real test.

Where to practice for free

If you want a formal credential that proves Office skills beyond a single employer’s test, see our guide to the Microsoft Office Specialist certification.

On test day

Common questions

Can I ask for accommodations on a skills test?

Yes. If you have a disability that affects testing, you can ask the employer or agency for a reasonable accommodation, such as extra time or a different format. The EEOC’s guidance on employment tests says employers must provide reasonable accommodations in test administration unless doing so would cause undue hardship.

What happens if I score low?

It depends on the employer. Some agencies place people in roles that match their current scores and allow retakes after a waiting period. Ask the recruiter what the policy is, keep practicing, and request a retest when you have improved.

Is it OK to look things up during the test?

Follow the test’s instructions. Many say not to use outside help. Even when nothing stops you, your score should reflect what you can do on the first day of the job.

Do employers share my results?

Staffing agencies usually keep scores in your profile and may share them with clients when submitting you. Ask the recruiter if you want to know how they are used.

A simple next step

Reply to the recruiter today and ask three questions: which tests are included, how long each takes and whether retakes are allowed. Then take your Day 1 baseline tonight. Knowing your starting numbers turns a vague week of worry into a short, specific practice plan.

About the Author

Author

Trending Articles: