 |
Microsoft Excel 2007 Core Requirements for Microsoft Certified Application Specialist Exam 77-602 |
| Essential Skills measured by Exam 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. |
|
 |