This exam measures your ability to accomplish the technical tasks also; the questions may test on, but will not be limited to, the topics described in the below text.
Create and manipulate data
Insert data by using AutoFill, ensure data integrity, modify cell contents and formats, change worksheet views, and manage worksheets.
Format data and content
Format worksheets, insert and modify rows and columns, format cells and cell content, and format data as a table.
Create and modify formulas
Reference data in formulas, summarise data by using a formula, summarise data by using subtotals, conditionally summarise data by using a formula, look up data by using a formula, use conditional logic in a formula, format or modify text by using formulas, display, and print formulas.
Present data visually
Create and format charts, modify charts, apply conditional formatting, insert and modify illustrations, outline data, sort, and filter data.
Collaborate on and secure data
Manage changes to workbooks, protect and share workbooks, prepare workbooks for distribution, save workbooks, set print options for printing data, worksheets, and workbooks.
Who should take this exam?
Candidates for this exam should have the equivalent of six months to one year of hands-on experience creating business deliverables with Microsoft Office Excel 2007 and might have experience with previous versions of Office Excel. These candidates are especially effective and efficient at creating and manipulating data, formatting data and content, creating and modifying formulas, presenting data visually, and collaborating on and securing data.