Test Center

It is easy to see the newest titles that have been added to the test library. Go to the Test Center and click "View All Free Tests". The list will include the latest tests. Come see what is new and measure your skills!

MS Excel 2010


Our MS Excel 2010 test measures knowledge of Excel 2010. Designed for experienced users, this test covers the following topics: Advanced User Features, Functions and Analytical Tools, Multiple Worksheets, Printing and Views, Privacy and Security, Tables and Graphics, Workbook and Worksheet Features, and Worksheet Formatting.

This test is associated with a Job Role. Please visit the Job Role Center for more details.


Once you request a test, your Personal Identification Number (PIN) will be stored in your My Plan for easy access. You will have 90 days in which to take the test you requested.

Test Outline

Advanced User Features
Backstage View
Customize the Ribbon
File Compatability and Conversion
Slicers and Sparklines
Watch Window
Functions and Analytical Tools
Advanced Analysis
Advanced Functions
Common Functions
Macros and Custom Functions
Multiple Worksheets
3-D Formulas
Data Export
Data Import
Printing and Views
Headers and Footers
Page Breaks
Print Features
Privacy and Security
Cell Protection
Precedents and Dependents
Workbook Protection
Worksheet Protection
Tables and Graphics
General Tables
Images and Pictures
Workbook and Worksheet Features
Blank Workbooks and Templates
Cell and Range Names
Data Features
Formula Evaluation
Workbook Add-ins
Worksheet Formatting
Advanced Formatting
Conditional Formatting
Copy and Move Data
Number Formatting
Text Formatting