Excel 2002 Core

MOUS Exam Objectives
Posted: October 18, 2001
 
Exam objectives are categories of examination tasks, identified by subject-matter experts, that certify an ability to productively use Microsoft Office applications. These categories are organized into skill sets representing the more basic functions of each Office application.

Exam objectives and skill sets for the Microsoft Excel 2002 Core Exam are provided below to assist in your exam preparation. Training centers and courseware providers authorized by the Microsoft Office User Specialist (MOUS) program tailor their instruction to these criteria.
 

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

MOUS Exam Objectives
Posted: February 21, 2002
 
Exam objectives are categories of examination tasks, identified by subject-matter experts, that certify an ability to productively use Microsoft Office programs. These categories are organized into skill sets representing the more basic functions of each Office program.

Exam objectives and skill sets for the Microsoft Excel 2002 Expert Exam are provided below to assist in your exam preparation. Training centers and courseware providers authorized by the Microsoft Office User Specialist (MOUS) program tailor their instruction to these criteria.
 

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