Assessment
Microsoft Office Assessment
Microsoft Office assessment for hiring: Word, Excel, PowerPoint and Outlook tasks by level, sample questions, red flags and a scoring rubric.
The short answer
A microsoft office assessment for hiring typically runs 25-40 minutes, simulated tasks, document correction, multiple choice and short practical exercises, at 3 difficulty levels. Give it after the first screen and before interviews, and score it on the areas below, fixed before you see any answers, so every candidate is judged the same way.
- Word: styles, headings, tables, track changes, comments and mail merge
- Excel: data entry, sorting and filtering, basic formulas and charts
- PowerPoint: clear slide structure, slide masters and presenting data
- Outlook: email organisation, rules, calendar scheduling and shared mailboxes
Cohesyve tests Microsoft Office inside an AI job simulation of the role, after finding and contacting candidates. Ten candidates free, no card.
About to take a Microsoft Office test? Practise it free →A Microsoft Office assessment tests practical skill across the core Microsoft 365 apps: Word for documents, Excel for data, PowerPoint for presentations and Outlook for email and calendars. Employers use it for administrative, operations, sales support, HR and finance support roles where these tools fill most of the day. The best tests ask candidates to produce or fix something, such as a formatted letter, a cleaned spreadsheet or a short deck, rather than name ribbon menus. For roles that live in spreadsheets, add the dedicated Excel assessment.
Format
What it measures
- Word: styles, headings, tables, track changes, comments and mail merge
- Excel: data entry, sorting and filtering, basic formulas and charts
- PowerPoint: clear slide structure, slide masters and presenting data
- Outlook: email organisation, rules, calendar scheduling and shared mailboxes
- Moving content between apps without breaking formatting
- Collaboration: sharing, co-authoring and version history in Microsoft 365
Cohesyve
Test Microsoft Office on the real work
Cohesyve builds an AI job simulation from your job description that covers Microsoft Office as the role uses it, finds and contacts candidates, and returns a ranked shortlist. Ten candidates free, no card.
Who takes it
Topics covered
Word
- Styles and automatic table of contents
- Track changes and comments
- Mail merge
- Page layout and section breaks
Excel
- Sorting and filtering
- SUM, AVERAGE, IF and lookups
- Charts
- Basic pivot tables
PowerPoint
- Slide masters and layouts
- One idea per slide
- Charts from Excel
- Speaker notes
Outlook
- Folders and rules
- Scheduling across time zones
- Shared calendars and mailboxes
- Out-of-office replies
Sample questions
This 12-page report uses manual bold text for headings and a typed contents page that is out of date. Fix it so the contents update automatically.
BasicLook for Applies heading styles, inserts an automatic table of contents, and updates it; does not retype page numbers.
Send a personalised letter to 200 customers from this spreadsheet of names and addresses.
IntermediateLook for Uses mail merge with the spreadsheet as the data source, previews results and checks for blank or badly formatted fields.
Your manager receives 150 emails a day, many automated reports. Set up their Outlook so important messages are not missed.
IntermediateLook for Rules to file automated reports, Focused Inbox or categories, flagged follow-ups, and a simple routine; checks the rules do not hide important mail.
Turn this two-page summary of quarterly results into a five-slide deck for the leadership meeting.
AdvancedLook for Clear storyline, one message per slide, a chart where data helps, consistent layout from the slide master, and detail moved to notes or an appendix.
Red flags
- Formats headings by hand instead of using styles
- Retypes data that could be merged or linked
- Slides crowded with paragraphs of text
- Sorts a single spreadsheet column and breaks the rows
- Cannot use track changes when editing someone else's document
Scoring rubric
| Criterion | Weight | What strong looks like |
|---|---|---|
| Task completion | 35% | Produces the requested output correctly. |
| Use of the right features | 25% | Styles, merges, rules and formulas instead of manual workarounds. |
| Quality of output | 25% | Clean, consistent, ready to send. |
| Efficiency | 15% | Gets there without unnecessary steps. |
Why it is used
For employers
- Separate candidates who list Microsoft Office from those who use it well
- Reduce time spent fixing documents and spreadsheets after hire
- Assess the specific apps the role relies on
- Quick to administer across high-volume admin hiring
For candidates
- Prove skills that every CV claims but few demonstrate
- Practical tasks rather than menu trivia
- A fair chance to stand out for office roles
- Clear signal of which apps the job uses most
Common questions
What is on a Microsoft Office assessment test?
Practical tasks in Word, Excel, PowerPoint and Outlook: formatting documents with styles, using track changes, sorting data and writing basic formulas, building a clear slide deck, and organising email and calendars.
Is the Microsoft Office Specialist (MOS) certification worth asking for?
It can help. MOS is delivered by Certiport with Microsoft and covers Word, Excel, PowerPoint and Outlook. Many capable candidates do not hold it, so a practical assessment is a fairer screen.
How do I prepare for a Microsoft Office test?
Practise the features that save time: heading styles and automatic contents in Word, sorting, filtering and lookups in Excel, slide masters in PowerPoint, and rules and calendar scheduling in Outlook.
Should I test Excel separately?
For finance, analyst and operations roles, yes. Use a dedicated Excel assessment covering lookups, pivot tables and data cleaning, and keep the Office test for general document and email skills.
Cohesyve · Skill assessments for hiring
Test Microsoft Office before the first interview
Cohesyve takes your job description, finds candidates, reaches out to them and tests Microsoft Office in an AI job simulation of the real work, then returns a ranked shortlist.
1,500+
assessments completed
50%
faster time-to-hire
5 min
from JD to assessment
No credit card · 10 free candidates · Plans sized to your hiring volume
For candidates
About to take a Microsoft Office test yourself? Practise on an AI job simulation that uses it. 3 free practice assessments, no card.
From the blog