Microsoft Excel 2016 Skills Assessment Test

Topics covered

Excel Formatting, Working with Formulae and Functions, Tables and Charts, Managing Data

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

Microsoft (MS) Excel 2016 test helps recruiting teams & hiring managers to effectively assess the candidate’s excel skills before an interview. Microsoft Excel 2016 is the latest version of Excel and has more enhanced features which help the user to get better results. Microsoft Excel skills assessment test (2016) is specially designed to check the application and functional skills which are related to Excel – as per Industry Standards.

The Microsoft Excel Assessment Test (2016) contains questions on following Topics:
 

  • Excel Formatting

  • Working with Formulae and Functions

  • Tables and Charts

  • Managing Data


Microsoft Excel practical test is a quick Excel test of 20 minutes based on latest version of MS Excel. It is created & validated by our experienced Subject Matter Experts (SME)s. Using powerful reporting, you will have a detailed analysis of test results to help you make better decisions and predict candidate and employee success.

The Excel online assessment test contains MCQ's (Multiple Choice Questions), MAQ's (Multiple Answer Questions), Fill in the Blank, Descriptive, True or False.

This pre-employment test is useful for hiring:
  • Excel Experts
  • Advanced Excel Executive

Test details:

The MS Excel recruitment test enables employers and recruiters to identify dynamic Excel experts by evaluating working skills and job readiness. For this reason, the emphasis is laid upon evaluating the knowledge of applied skills gained through real work experience, rather than theoretical knowledge. 

Test Duration: 20 minutes 

15 Application Questions

05 Theory Questions 


The combination of Application and Theory questions helps to evaluate Technical as well as practical Skills of Candidates.

Microsoft Excel 2016 test

Question #1 of 3

How do you create a chart with the same formatting as the existing one, with the different set of data?

Note: There can be multiple correct answers to this question.

    • You simply copy the chart formatting using Format Painter option in Clipboard group in Home Tab

    • You copy the existing chart and change the data sources (right-click on the chart and choose Select Data option from a list)

    • Create a chart template (right click on the chart and choose Save as a Template option from a list). When you are building a new chart use saved template as a chart type

    • None of the mentioned

Question #2 of 3

How do you select a single chart element?

Note: There can be multiple correct answers to this question.

    • Just click on the element in the chart to select it

    • Select the chart. Go to Format Contextual Tab and in Current Selection group from a drop down list choose the chart element to select

    • Right click on a chart and press Ctrl + 1 to bring out Format task pane. In the Format task pane below the title click a down arrow to bring out a drop-down list and choose the chart element to select

    • None of the mentioned

Question #3 of 3

How do you create a Pivot Chart in Excel 2016?

    • Select any cell outside a Pivot table you created. Go to Insert Tab, Charts group and click on Recommended Charts button and choose one from the offered charts

    • Select any cell in the Pivot table, go to Data Tab, in Sort & Filter group click Advanced option and in popup window under Chart category select PivotChart option

    • Select any cell in the Pivot table, go to Design Contextual Tab, in Layout group click on Report Layout to open drop down menu and select PivotChart option

    • Select any cell in the Pivot table, go to Analyze Contextual Tab, in Tools group click on PivotChart button to open popup box and choose appropriate chart type

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

Score: 18 Out Of 20

Percentage: 90

Result: PASS

passing score image
SECTION PERFORMANCE
Section Name FAIL PASS
Excel 2016
Score: 18/20
STRENGTH AND WEAKNESS
Strength Excel 2016
Weakness -
* 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 : Excel 2016 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