This MS Office Online Test
Separates Good From Bad Hires

Screen with work-sample questions

Work-samples are the best predictor of work performance. 8,000+ companies use TestDome premium questions.

About the test

The MS Office test evaluates a candidate’s ability to work with documents and spreadsheets, including the knowledge of how to create, modify, format, and style information contained within a document, and also to organize, calculate, analyze and visualize data contained within a spreadsheet.

It’s an ideal test for pre-employment screening of candidates applying for a variety of job roles. Good candidates for most office jobs require competency with using word processing and spreadsheet software, such as MS Word and MS Excel. This MS Office test can be used to screen large groups of candidates to select only those with the required word processing and spreadsheet knowledge to bring in for an interview.

This test requires candidates to download files, perform assignments within word processing and spreadsheet software, and upload their solution files for automatic evaluation. Candidates can use either their personal copy of MS Office or the free web version of MS Office to complete the test.

Sample public questions

Your company sells products to customers in two cities, New York and San Francisco. You have been asked to calculate each product’s retail prices inclusive of sales taxes in these cities.

Specifically, you need to:

  • Write formulas to calculate the retail prices, inclusive of sales tax, using the net prices of each product.
  • Make sure you reference cells A5 and B5 in your formulas.

Note: Do not use array formulas in your work.

Your task is to download the file ‘TaxInclusive-RawData.xlsx’ file and execute the request. When you have completed your work, save it in .xlsx format, then upload that file for evaluation.

MS Excel
Formulas and Functions
10 min

Working as a teacher at a university, you have compiled a write-up on learning objectives and want to forward it to upper management. To organize the document better, you want to add a table of contents and page numbers to the document.

Download the ‘RightQuestions-Template.docx’ file and implement the following:

  • Add a table of contents to the beginning of the document.
  • Add a page break just after the table of contents so that the rest of the text starts from the next page.
  • Add page numbers to the document so that all pages after the table of contents display a page number at the bottom of each page.

When you have completed your work, save it in .docx format, then upload that file for evaluation.

MS Word
Document Navigation
Word Page Layout
7 min

For jobseekers: get certified

Earn a free certificate by achieving top 25% on the MS Office test with public questions.

Take a Certification Test

Sample silver certificate

Peter Gibbons

Java and SQL


TestDome logo on certificate

For companies: premium questions

Buy TestDome to access premium questions that can't be practiced.
Get money back if you find any premium question answered online.

Sign Up to Offer this Test

Skills and topics tested

  • MS Excel
  • Formulas and Functions
  • Data Filtering
  • Data Management
  • Data Sorting
  • Data Lookup
  • Bar Chart
  • Charting
  • Pie Chart
  • MS Word
  • Word Tables
  • Word Page Layout
  • Word Styling
  • Headers and Footers
  • Pivot Tables

For job roles

  • Account Manager
  • Accountant
  • Administrative Assistant
  • Executive Assistant
  • Manager
  • Sales Manager
  • Sales Person
  • Secretary

Solve all your skill testing needs

150+ Pre-made tests

From web development and database administration to project management and customer support. See all pre-made tests.

Multi-skills Test

Mix questions for different skills or even custom questions in one short test. See an example.

How TestDome works

Choose a pre-made test or create a custom test.
Invite candidates via email, URL or your ATS
Candidates take a test remotely
Sort candidates and get individual reports

Want to know more?

Not exactly what you're looking for?

Related MS Office Tests: