Most employer tests split each app into three levels: basic, intermediate, and advanced. Check the level on your invite before you check the app, because an intermediate Excel test and an advanced one share little past the first few questions.
Some tests are multiple choice. Many are simulations: a copy of the Office screen where you click through the task, and the software records what you did.
Microsoft Excel skills assessment
What an Excel test covers depends heavily on its level. At the basic level, expect entering and formatting data, SUM and AVERAGE, sorting, filtering, and a simple chart. Intermediate adds IF, COUNTIF and SUMIF, fixed cell references like $A$1, conditional formatting, and VLOOKUP.
Advanced is the excel vlookup pivot table test for job openings in finance and operations. Expect PivotTables built from raw data, nested IF statements, INDEX and MATCH, data validation, and IFERROR.
Microsoft's own VLOOKUP help page now points readers to XLOOKUP, which works in any direction, so a newer test may accept either one. Our Excel skills assessment guide goes deeper on the Excel test alone.
Microsoft word skills assessment
Word tests start with formatting text, lists, and paragraph spacing, then move to styles and headings, page and section breaks, headers and footers with page numbers, and tables. The intermediate tier usually covers track changes and comments, the tools you use when a document passes between several people.
Advanced tests add a table of contents built from heading styles and mail merge from a contact list. The Microsoft Word skills assessment test page lists the topics one well-known Word test scores, with timings by format.
PowerPoint and Outlook skills assessment
PowerPoint questions check whether you can keep a deck consistent: working from a slide master or template, applying layouts, inserting a chart or table, adding speaker notes, and using transitions with restraint. Outlook questions are about the working day: booking a meeting and checking who is free, handling a time zone, sharing a calendar, filing mail into folders, and writing rules that sort incoming mail for you. See our PowerPoint skills assessment test guide for slide-level detail.
Advanced Office tests ask for small jobs, not single commands
At the advanced level, tests stop asking for single commands and start asking for small jobs. Build a PivotTable from 500 rows and filter it to one region. Run a mail merge that pulls names from an Excel list.
Protect a document so only one section can be edited. To test yourself at this level, take a messy file from a past job or a public data set, set a timer for 20 minutes, and do the whole job without searching for help. Whatever you had to look up is your study list.
Kenexa prove it Microsoft test and the other vendor formats
Most employers buy an Office test rather than write one, so the vendor shapes what you see. Vendors publish little about scoring, so treat the lengths below as typical rather than fixed; the employer can change most of them.
| Test | Who usually sends it | Format | Typical length |
|---|
| Kenexa Prove It | Staffing agencies and large employers | Simulated Office screens plus some multiple choice | Usually 25 to 30 questions per app, according to JobTestPrep |
| eSkill | Employers building their own test mix | Multiple choice and simulations, often customized | Set by the employer |
| TestGorilla | Smaller employers and startups | Short multiple-choice tests, often several bundled | Around 10 minutes per test |
| iMocha | Employers hiring at volume | Multiple choice, with some hands-on tasks | Set by the employer |
| Microsoft Applied Skills lab | You, by choice | Live Microsoft software in a virtual machine | 30 minutes beginner, 45 intermediate or expert, per Microsoft's lab FAQ |
Microsoft applied skills lab assessment
The Applied Skills lab works differently from every vendor test above. Microsoft's assessment lab FAQ explains that the tasks arrive as emails inside the lab, and you complete them in the real product, by any method that works unless the email says otherwise.
You cannot save and come back later, and leaving the lab counts as an attempt. Beginner labs give you 30 minutes and intermediate or expert labs give you 45, with a little extra time available near the end.