Microsoft Excel Practical Test (2016)

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 Excel is a spreadsheet which features calculation, graphing tools, pivot tables, and a macro programming language.  Microsoft Excel 2016 is the latest version of Microsoft's Excel series of spreadsheet software by coming together with the rest of its Office 2016 productivity suite. One of the biggest new features of Microsoft Excel 2016 is that it automatically suggests graphs and charts that are appropriate for the data you're processing. Microsoft Excel 2016 is beneficial for any business that's afraid of increasing overhead with the new Office suite.

Microsoft Excel practical test helps recruiting teams & hiring managers to effectively assess the candidate’s advanced excel skills before an interview. Our practical Excel test (2016) is specially designed to check the application and functional skills of MS Excel specialists as per industry standards.

The Microsoft Excel 2016 test helps to screen the candidates who possess below traits:
 

  1. Strong experience in MS Office 2016

  2. Good knowledge of accessing MS Excel 2016

  3. Good knowledge of latest version (MS Excel 2016) features


Our quick Excel 2016 test ensures that the new hires will be a right fit for the position of an MS Excel  2016 expert, having proper knowledge of latest version skills in MS Word 2016 including advanced forecasting, date grouping, histograms, Pareto charts, waterfall charts, and PowerPivot, etc. The process of hiring such candidates will be done through our Excel recruitment tests which are automated and will provide you with detail analytical reports of each appeared candidate. Our score reports will help you to measure the excel skills by making your recruitment process easy with an efficient budget.

This pre-employment test is useful for hiring:
  • Excel Experts
  • Advanced Excel Executive
  • MS Excel Specialists (2 – 5 yrs of experience)

Test details:

The online Excel 2016 assessment enables employers and recruiters to identify dynamic Excel experts by evaluating their 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.

The Excel online assessment 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

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

Candidate Name
Assessment Name
Invited by
Assessment Date
IP Address
Status
















24.00 Out of 40.00
Pass
60%
03
23 Minutes

Java EE

9/10

Hibernate

3/10

Oracle PL/SQL

7/10

Analytical Thinking

5/10

Note:If score<= 30% then its a Weakness. If score >=70% then its a Strength.

Strengths

Java EE, Oracle PL/SQL, Analytical Thinking

Weaknesses

Hibernate

Happy

It was a good test for me, the questions were on the latest technology of java on which I am currently working. It was a great experience. Thank you!

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