Are you a candidate looking to sharpen your skills? Try our practice tests or view sample interview questions & Get hired by the best. Click Here×

Microsoft Word and Excel Assessment Test

Topics Covered

  • Tables
  • Charts
  • Shapes
  • Character Formatting
  • Pivot Chart
  • VLOOKUP function
  • Format Painter
  • Header
  • Footer
  • Toolbar functions

Useful for hiring

  • Office Administrative Professionals
  • Microsoft Office Specialists

Start hiring job-fit candidates using this assessment

GET A DEMO

"We are impressed by the caliber, depth, and breadth of the assessments provided by Interview Mocha. With Interview Mocha's online proctoring & powerful reports, we are able to hire quality candidates overcoming geographical barriers."

Megan Akhras, J'Excelle,Canada,
Co-founder & director
Question

You are at page 234 of a document, and want to make adjustment at page 4, the keyboard combination for the Go To Page dialog box that instantly takes you to page 4 is:

Answer
    • CTRL + P

    • CTRL + G

    • CTRL + Page Up

    • CTRL + Page Down

Question

How can you combine different chart types for different data series on the same chart?

Answer
    • Click on the chart to activate it, go to Format Contextual Tab, in the Shape Styles group click on Combine Chart Types button and choose different chart types for different data series

    • Click on the chart to activate it, go to Review Tab, in the Changes group click on Change Chart Type button and choose different chart types for different data series

    • Click on the chart to activate it, go to Design Contextual Tab, and in the Type group, click on Change Chart Type button. In a popup window select Combo group and choose different chart types for different data series

    • You cannot have different chart types on the same chart

Question

One of Excel’s most exciting and most powerful features is its ability to work with arrays in formulas. Which one of the below-listed statements IS NOT TRUE regarding Array formulas?

Answer
    • An array is a collection of items operated on collectively or individually

    • In Excel, an array can be one dimensional, two dimensional or three dimensional

    • Arrays don’t have to be stored in cells

    • Excel supports two types of Array formulas - Single-cell array formulas and Multi-cell array formulas

Test details:

Microsoft Word and Excel proficiency test enable employers to identify & hire MS Office specialists by evaluating working skills and job readiness. Therefore, an emphasis is laid upon evaluating the knowledge of applied skills gained through real work experience rather than theoretical knowledge.

The Microsoft Excel and Word test may contain MCQ's (Multiple Choice Questions), MAQ's (Multiple Answer Questions), Fill in the Blank, Descriptive, Whiteboard Questions, Audio / Video Questions, True or False.

Test Duration: 20 minutes

10 Application Questions

MS Word and Excel test contains a combination of application and theory questions that help you to evaluate the application as well as practical skills of candidates.

Test description:

Microsoft Excel is one of the most versatile Microsoft Office products which is nearly used by every professional in the world. Excel is a spreadsheet program included in Microsoft Office suite of applications which provides with the values arranged in rows and columns that can be changed mathematically using both basic and complex arithmetic operations and functions. Another commonly used Microsoft Office product is Microsoft Word which is used to write reports, important business letters, and other correspondence. Many entry-level or administration job roles, strong knowledge of word and excel is required.

Our Microsoft Word and Excel test is designed & developed by experienced subject matter experts (SMEs) to evaluate MS Excel as well as MS Word skills of the candidate as per industry standards. Employers can use MS Word and Excel test for employment of right fit candidates.

MS Word and Excel test contain questions on following topics:

  1. Tables, Charts, Shapes

  2. Character Formatting

  3. Pivot Chart

  4. VLOOKUP function

  5. Format Painter

  6. Header

  7. Footer

  8. Toolbar functions


Our Microsoft Word and Excel assessment test ensure the recruiters to hire best applicants, who have good knowledge of formatting, file management, printing, editing, graphics, formulas, functions, and tools in word and excel. The score reports give you a detailed analysis of every candidate that provides better insights on who could be the best fit for your organization.

Good News! You can customize this test as per your requirement

  • Choose and add questions from Interview Mocha question libraries

  • Add your own set of questions

  • Customize test settings like duration, number of questions, passing score, web proctoring and much more

  • Mail us at support@interviewmocha.com to create a custom test

Looking for a tailor-made test, to suit your assessment needs?

Get in touch

Global companies using Mocha assessments

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • akamai

How Mocha assessments are brewed

Speed up your IT recruitment with Interview Mocha

  • 500+ IT skill tests
  • 20+ coding languages
  • 50+ domain knowledge tests
  • 100+ digital 2.0 skill tests
  • Customer focus aptitude tests
  • Enterprise ready features & more...
GET A DEMO

Why hiring managers and recruiters across the globe love Interview Mocha

Take your first step to hire job fit candidates

GET A DEMO