Microsoft® Office EXCEL® 2007

77-602: Using Microsoft® Office EXCEL® 2007

The Excel 2007 exam tests your effectiveness and efficiency in data management using the Excel 2007 application.

Passing this exam proves you are especially effective and efficient at creating and manipulating data, formatting data and content, creating and modifying formulas, presenting data visually, and collaborating on and securing data.

The following details the objectives tested on the exam.

Creating and Manipulating Data

  • Insert data by using AutoFill.
  • Ensure data integrity.
  • Modify cell contents and formats.
  • Change Worksheets 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 using a formula.
  • Summarize data 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 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.