The Excel 2010 Essentials has been replaced with the Excel 365 Essentials – click here to see it.

Use the Microsoft Excel 2010 Essentials test to evaluate a candidate’s experience in sorting and filtering data, creating and applying simple functions and more.  Before you invest the time and money to train a new employee, test your applicants for skills like:

• entering basic formulas
• modifying cell formatting and content
• inserting and labeling charts
• using templates
• managing workbooks and worksheets

This test provides the answers you need to make informed hiring and promotion decisions.

Want more information about this test?  Get it now.  Please REQUEST MORE INFO and we’ll reply promptly.

Not the perfect fit?  No problem.  We have many similar tests to choose from.  See alternatives in the COMPUTER SKILLS category section of our site.

---

 

Microsoft Excel 2010 is the spreadsheet component of the Microsoft Office 2010 suite. The Microsoft Excel 2010 – Essentials simulation evaluates the candidate’s experience in sorting and filtering data, creating and applying simple functions and formulas, modifying cell formatting and content, viewing and printing workbooks, managing workbooks and worksheets, adding headers, footers and page breaks, creating and labeling charts and pivot tables, setting a print area, securing and sharing workbooks, and presenting data in different visual models. The Essentials version consists of the 20 most important and frequently performed tasks. All questions are written at an 8th grade reading level.

Languages Available – English (US)
# of Questions: 20
Average Testing Time – 25 minute time limit
Number of Sittings – One
Designed for Unproctored Environment – Yes
Question Format – Simulation

Knowledge, Skills, Abilities, and Competencies Measured

Test Topics Questions / Topic

• Applying Formulas and Functions 2
• Creating and Analyzing Data 3
• Formatting Cells, Data, and Content 5
• Managing Workbooks and Worksheets 5
• Presenting Data Visually 2
• Printing and Views 3