Microsoft
Excel 2002 Core and Expert Objectives
This page describes how to prepare for the Microsoft® Office Specialist exam in Microsoft Excel 2002. Exam
objectives and skill sets for the Microsoft Excel 2002 Core Exam are
provided below to assist in your exam preparation.
Excel
2002 Core Exam Objectives
The table below lists the skill sets and activities performed by individuals
identified as Core User.
| Skill Sets |
Activities |
| Working
with Cells and Cell Data
|
- Insert, delete and move cells
- Enter and edit cell data including
text, numbers, and formulas
- Check spelling
- Find and replace cell data and
formats
- Work with a subset of data by
filtering lists
|
| Managing
Workbooks
|
- Manage workbook files and folders
- Create workbooks using templates
- Save workbooks using different names
and file formats
|
| Formatting
and Printing Worksheets
|
- Apply and modify cell formats
- Modify row and column settings
- Modify row and column formats
- Apply styles
- Use automated tools to format
worksheets
- Modify Page Setup options for
worksheets
- Preview and print worksheets and
workbooks
|
| Modifying
Workbooks
|
- Insert and delete worksheets
- Modify worksheet names and positions
- Use 3-D references
|
| Creating
and Revising Formulas
|
- Create and revise formulas
- Use statistical, date and time,
financial, and logical functions in formulas
|
| Creating
and Modifying Graphics
|
- Create, modify, position, and print
charts
- Create, modify, and position
graphics
|
| Workgroup
Collaboration
|
- Convert worksheets into Web pages
- Create hyperlinks
- View and edit comments
|
Excel
2002 Expert Exam Objectives
Exam objectives and skill sets for the
Microsoft Excel 2002 Expert Exam are provided below to assist in your exam
preparation.
Expert Users must be able to perform all activities listed for Core
Users in addition to the activities listed in the table below.
| Skill Sets |
Activities |
| Importing and
Exporting Data |
-
Import data to Excel
-
Export data from Excel
-
Publish worksheets and workbooks to the Web
|
| Managing
Workbooks |
-
Create, edit, and apply templates
-
Create workspaces
-
Use data consolidation
|
| Formatting
Numbers
|
-
Create and apply custom number formats
-
Use conditional formats
|
| Working with
Ranges
|
-
Use named ranges in formulas
-
Use Lookup and Reference functions
|
| Customizing
Excel
|
-
Customize toolbars and menus
-
Create, edit, and run macros
|
| Auditing
Worksheets
|
-
Audit formulas
-
Locate and resolve errors
-
Identify dependencies in formulas
|
| Summarizing
Data
|
-
Use subtotals with lists and ranges
-
Define and apply filters
-
Add group and outline criteria to ranges
-
Use data validation
-
Retrieve external data and create queries
-
Create Extensible Markup Language (XML) Web queries
|
| Analyzing Data
|
-
Create a Microsoft PivotTable®, Microsoft PivotChart®, and PivotTable/PivotChart Reports
-
Forecast values with what-if analysis
-
Create and display scenarios
|
| Workgroup
Collaboration
|
-
Modify passwords, protections, and properties
-
Create a shared workbook
-
Track, accept and reject changes to workbooks
-
Merge workbooks
|
|
