This certification exam was developed based on a product task analysis that defined the skills required to use Microsoft Excel to create, modify, share, and revise workbooks, using templates, automated procedures, and the Web, and to retrieve, analyze and summarize data at a minimally competent level for a specialist-level user. This exam consists of 18 performance-based, multiple-task exam items. Examinees are given 50 minutes to complete the exam, which is delivered using the live Microsoft Excel application.
Approximate percentage of examination by content area:10% Managing the Worksheet Environment: Navigate through a worksheet; Print a worksheet or workbook; Personalize environment by using Backstage.10% Creating Cell Data: Construct cell data; Apply AutoFill; Apply and manipulate hyperlinks.18% Formatting Cells and Worksheets: Apply and modify cell formats; Merge or split cells; Create row and column titles; Hide and unhide rows and columns; Manipulate Page Setup options for worksheets; Create and apply cell styles.11% Managing Worksheets and Workbooks: Create and format worksheets; Manipulate window views; Manipulate workbook views.19% Applying Formulas and Functions: Create formulas; Enforce precedence; Apply cell references in formulas; Apply conditional logic in a formula (,=); Apply named ranges in formulas; Apply cell ranges in formulas.13% Presenting Data Visually: Create charts based on worksheet data; Apply and manipulate illustrations; Create and modify images by using the Image Editor; Apply Sparklines.8% Sharing worksheet data with other users: Share spreadsheets by using Backstage; Manage comments.11% Analyzing and Organizing Data: Filter data; Sort data; Apply conditional formatting.