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 |
|
