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

"Finding quality talent is a challenge more so when you consider the sheer number of resumes we get each year. To top this, the time we spent on our recruitment process was humongous. Interview Mocha helped us to cut down on our candidate filtration time by 40%, making it our preferred assessment tool."

Pedro Furtado, Altran,
Capacity Manager
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

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