Microsoft Word and Excel Assessment Test

Topics covered

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

  • MAQ (Multiple Answer Question)
  • MCQ (Multiple Choice Question)
  • Descriptive Question
  • White Board Simulator
  • Coding Simulator
  • Audio Question
  • Video Question
  • Case Study Question

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:

  • Tables, Charts, Shapes

  • Character Formatting

  • Pivot Chart

  • VLOOKUP function

  • Format Painter

  • Header

  • Footer

  • 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.

This pre-employment test is useful for hiring:
  • Office Administrative Professionals
  • Microsoft Office Specialists

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

20 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.

Microsoft Word and Excel Test

Question #1 of 3

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:

    • CTRL + P

    • CTRL + G

    • CTRL + Page Up

    • CTRL + Page Down

Question #2 of 3

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

    • 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 #3 of 3

One of Excel’s most interesting 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?

    • 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

SAMPLE REPORT
Candidate Name: David Messi Test Date: 28-May-2014
Test Name: Microsoft Word and Excel Test Test Start Time: 13.30

Score: 13 Out Of 20

Percentage: 65

Result: PASS

passing score image
SECTION PERFORMANCE
Section Name FAIL PASS
MS Word 2013
Score: 9/10
Excel 2013
Score: 4/10
STRENGTH AND WEAKNESS
Strength MS Word 2013
Weakness Excel 2013
* Note: If score <= 40 then its a Weakness. If score >= 80 then its a Strength.
ONLINE PROCTORING
0%
10 20 30 40 50 60 70 80 90 100%
Tolerable Limit Not acceptable
Window Violation: 0 | Time Violation: 0 secs
CANDIDATE DETAILS
Gender : Male Phone Number : +1-541-754-3010
Total Experience (Years) : 3 Total Experience (Months) : 5
Skill Set : MS Word 2013 Current Employer : Interview Mocha
Current Job Title : Solution Architect Current Salary : 600.00
Expected Salary : 1000000.00 Current Location : Chicago

Sign up for a free trial today

Get your free trial and test up to 10 candidates. No strings attached. No credit card required.

SIGN UP FOR FREE

Schedule a Demo

How Interview Mocha works?

  • Add this test to your account

  • Invite candidates to take this test online

  • Candidates take the test

  • View and share actionable test reports

Trusted by leading brands worldwide

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • hexaware
Why hiring managers and recruiters across the globe love Interview Mocha
  • Largest number of ready pre-employment skill tests
  • Relevant test compositions and quality questions designed by Subject Matter Experts (IM SME)
  • Fastest custom test creation DNA
  • World’s most super easy skill assessment platform
  • High level of platform security implementation
  • Friendly and quick customer support
  • Ready to listen and implement your feedback, we are all ears
  • Affordable pricing

Sign up for a free trial today

Get your free trial and test up to 10 candidates. No strings attached. No credit card required.

SIGN UP FOR FREE

Schedule a Demo