Exam 77-602:

MOS: Using Microsoft Office Excel 2007

Published:February 28, 2007
Language(s):English, Russian
Audience(s):Information Workers
Technology:Microsoft Office Excel 2007
Type:Proctored Exam

How To Get It: Schedule your exam through the following exam provider:

Take exam

Show all itemsHide all items
Preparing for an Exam
The Microsoft Certification website and this preparation guide contain a variety of resources to help you prepare for an exam. Preparing for and Taking an Exam — FAQ provides answers to frequently asked questions about exam registration, preparation, scoring, and policies, including:
  • The most effective way to prepare to take an exam.
  • The relationship between Microsoft training materials and exam content.
  • Microsoft policy concerning the incorporation of service pack and revision updates into exam content.
  • Exam question types and formats.
  • Exam time limits and number of questions asked.
We recommend that you review this preparation guide in its entirety and familiarize yourself with the FAQs and resources on the Microsoft Certification website before you schedule your exam.
Audience Profile
Candidates for this exam should have the equivalent of six months to one year of hands-on experience creating business deliverables with Microsoft Office Excel 2007 and might have experience with previous versions of Microsoft Office Excel. These candidates 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.
Credit Toward CertificationWhen you pass Exam 77-602: MOS: Using Microsoft Office Excel 2007, you complete the requirements for the following certification(s):
Microsoft Office Specialist: Microsoft Office Excel 2007
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.
Skills Being MeasuredThis exam measures your ability to accomplish the technical tasks listed below.The percentages indicate the relative weight of each major topic area on the exam.The higher the percentage, the more questions you are likely to see on that content area on the exam.

The information after “This objective may include but is not limited to” is intended to further define or scope the objective by describing the types of skills and topics that may be tested for the objective. However, it is not an exhaustive list of skills and topics that could be included on the exam for a given skill area. You may be tested on other skills and topics related to the objective that are not explicitly listed here.
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.
Preparation Tools and ResourcesTo help you prepare for this exam, Microsoft Learning recommends that you have hands-on experience with the product and that you use the following training resources. These training resources do not necessarily cover all of the topics listed in the "Skills Measured" tab.
Learning Plans and Classroom Training
Microsoft E-Learning
Microsoft Press Books
Practice Tests
Microsoft Official Academic Course (MOAC)
  • Course 77-602: Microsoft Office Excel 2007 (Wiley.com): This comprehensive Microsoft Official Academic Course includes a textbook, lab manual, and software. The course provides students with the conceptual understanding and real-world experience they need to be ready for the work force and to pass the Microsoft Certified Application Specialist (MCAS) exams for Microsoft Office Excel 2007.

    Each Microsoft Official Academic Course is aligned to existing MCAS exam objectives and includes:
    • A six-month trial copy of Microsoft Office Professional 2007
    • Instruction materials that emphasize building skills to prepare students for workforce success by using an instruction strategy that provides:
      • Authentic business scenarios
      • Immediate introduction of hands-on practice in each lesson
      • Highlighted skills that apply to the workplace and the MCAS exam
  • Certiprep for 2007 Microsoft Office Certifications (Certiport.com): Certiprep for Microsoft Office Certifications is the premier certification-simulation solution for Microsoft Certified Application Specialist certifications. Designed to replicate the certification-testing environment accurately, Certiprep corresponds directly to certification exam objectives and employs the same "live application" technology that is used in the exams.


    Certiprep offers the following features and benefits.
    • Certiprep maintains a large bank of test items that align to specific certification skill objectives.
    • The performance-based technology is similar to that of the certification exams, resulting in an authentic certification exam experience.
    • Each Microsoft Office application features a Practice Test and Learning Mode, which provide test-takers with self-paced learning and exam simulation.
    • Practice Test provides a testing experience that is similar to the actual certification exam experience, including time limitations and a similar user interface. Practice Test assesses initial skills or certification-exam preparedness.
    • Learning Mode provides feedback and step-by-step instruction for each question.
Microsoft Online Resources
  • 2007 Microsoft Office System – Learning Portal: Find special offers and information on training and certification.
  • Product information: Visit the Microsoft Office Excel 2007 Web site for detailed product information and download a free trial version of the product.
  • Microsoft Learning Community: Join newsgroups and visit community forums to connect with your peers for suggestions on training resources and advice on your certification path and studies.
  • TechNet: Designed for IT professionals, this site includes how-to instructions, best practices, downloads, technical resources, newsgroups, and chats.
  • MSDN: Designed for developers, the Microsoft Developer Network (MSDN) features code samples, technical articles, downloads, newsgroups, and chats.
Have Questions? For advice about training and certification, connect with peers: For questions about a specific certification, chat with a Microsoft Certified Professional (MCP): To find out about recommended blogs, Web sites, and upcoming Live Meetings on popular topics, visit our community site:
Exam index