ClickATest Assessment Services

Only £52.00


Sample reports

Sample certificates

Adobe Reader is required to view these sample reports

MS Excel 2010 Test

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.



Scope of the online MS Excel 2010 Test

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
Linking
Printing and Views
Headers and Footers
Page Breaks
Print Features
Viewing
Privacy and Security
Cell Protection
Precedents and Dependents
Workbook Protection
Worksheet Protection
Tables and Graphics
Charts
General Tables
Images and Pictures
PivotTables
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

Duration

40 minutes.

Assessment Method of Questions

Multiple choice questions

Each question has between 2 and 8 options out of which 1 or more may be correct.

More links

Related Professions

Computer End-User Support Specialist, Project Manager, Bookkeeper, Financial Analyst, Market Research Analyst, Knowledge Worker, IT Business Analyst, Legal Secretary, Medical Transcriptionist, Receptionist

Keywords

ms excel 2010 assessment test, ms excel 2010 skill assessment test