EXCEL-2003-EXPERT Practice Test

Excel 2003 Expert

    • ||practice_exam_questions|| questions simulating vendor test questions
    • ||free_flash_cards|| complimentary flash cards
    • Detailed explanations for correct/incorrect answers help you grasp underlying concepts
    • Comprehensive score report helps you focus your study efforts
    • 3 year license


Purchase Practice Test

PracticeTest
MOS CD

Only $59.00

MOS Download

Only $59.00

Subtotal

 
add to cart

The Microsoft Excel 2003 Expert test prep product contains comprehensive coverage of all test objectives. Better than a simulation, this product actually works within your Microsoft Excel 2003 software program, creating a completely realistic test prep experience.

You must have a full (ENGLISH VERSION) installation of Microsoft Excel 2003 in order to use this product. MOS products do not work on the Vista operating system.

Important Test Information and Objectives
The following objectives are included on this test:

Organizing and Analyzing Data
  • Use subtotals
  • Define and apply advanced filters
  • Group and outline data
  • Use data validation
  • Create and modify list ranges
  • Add, show, close, edit, merge and summarize scenarios
  • Perform data analysis using automated tools
  • Create PivotTable and PivotChart reports
  • Use Lookup and Reference functions
  • Use Database functions
  • Trace formula precedents, dependents and errors
  • Locate invalid data and formulas
  • Watch and evaluate formulas
  • Define, modify and use named ranges
  • Structure workbooks using XML

Formatting Data and Content

  • Create and modify custom data formats
  • Use conditional formatting
  • Format and resize graphics
  • Format charts and diagrams

Collaborating

  • Protect cells, worksheets, and workbooks
  • Apply workbook security settings
  • Share workbooks
  • Merge workbooks
  • Track, accept, and reject changes to workbooks

Managing Data and Workbooks

  • Import data to Excel
  • Export data from Excel
  • Publish and edit Web worksheets and workbooks
  • Create and edit templates
  • Consolidate data
  • Define and modify workbook properties

Customizing Excel

  • Customize toolbars and menus
  • Create, edit, and run macros
  • Modify Excel default settings