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 17 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:17.0% Creating and Manipulating Data: Create data by using AutoFill; Ensure data integrity; Find data and modify cell contents; Change worksheet views; Manage worksheets.17.1% Formatting Data and Content: Format worksheets; Insert and modify rows and columns; Format cells and cell content; Format data as a table.24.4% Construct and Modify Formulas: Reference data in formulas; Summarize data by using a formula; Summarize data by using subtotals; Conditionally summarize data by using a formula; Look up data by using a formula; Use conditional logic in a formula; Format text by using formulas; Display and print formulas.24.4% Present Data Visually: Create and format charts; Modify charts; Apply conditional formatting; Insert and modify illustrations; Outline data; Sort and filter data.17.1% Secure and Collaborate on Data: Manage changes to documents; Protect and share workbooks; Prepare for distribution; Save workbooks; Prepare a worksheet or workbook for printing.