Certification

Microsoft Certified Application Specialist Exam Skill Standards: Excel 2007 (77-602)

Creating and Manipulating Data

• Insert data by using AutoFill.
• Ensure data integrity.
• Modify cell contents and formats.
• Change worksheet views.
• Manage worksheets.

Formatting Data and Content

• Format worksheets.
• Insert and modify rows and columns.
• Format cells and cell content.
• Format data as a table.

Creating and Modifying 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 or modify text by using formulas.
• Display and print formulas.

Presenting Data Visually

• Create and format charts.
• Modify charts.
• Apply conditional formatting.
• Insert and modify illustrations.
• Outline data.
• Sort and filter data.

Collaborating on and Securing Data

• Manage changes to workbooks.
• Protect and share workbooks.
• Prepare workbooks for distribution.
• Save workbooks.
• Set print options for printing data, worksheets, and workbooks.

Back to Microsoft Certified Application Specialist Exams