MCAS Office 2007 Exam Prep: Exams for Microsoft Office 2007

MCAS Office 2007 Exam Prep: Exams for Microsoft Office 2007

by Ron Gilster
Released June 2009
Publisher(s): Pearson IT Certification
ISBN: 9780789742384

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

MCAS Exam Prep

Microsoft Certified Application Specialist

Exams for Microsoft® Office 2007

Word 77-601

Excel 77-602

PowerPoint 77-603

Outlook 77-604

Access 77-605

Ron Gilster

CD Features Five Practice Exams

Score Higher on the MCAS Exams!

We provide you with the proven study tools and expert insight that will help you score higher on your exams.

  • Clear and simple explanations, lists, and screen shots walk you through the Microsoft Office processes you need to know to score well on the MCAS exams.

  • Study strategies, challenges, and key terms focus your study so you can maximize your preparation time.

  • Comprehensive discussion of all subject areas covered on the MCAS exams.

  • Practice Questions that include detailed explanations of correct and incorrect answers—so you can learn the material from your success and mistakes.

    • This book covers all the skills measured by the MCAS Exams for Microsoft Office 2007, including

  • Creating, customizing, formatting, and organizing Word documents

  • Working with visual content, references, and document review processes

  • Creating, manipulating, and formatting data and other content in Microsoft Excel

  • Presenting Excel data visually with charts and illustrations

  • Sharing and securing Microsoft Office content

  • Creating, formatting, and delivering PowerPoint presentations

  • Managing messaging, scheduling, and tasks with Microsoft Outlook

  • Working with Outlook contacts and personal contact information

  • Structuring, presenting, managing, and maintaining Access databases

  • Building and modifying Access queries

    • CD Features Five Practice Exams

    The CD includes five practice exams so you can drill and practice—another effective Exam Prep study tool that helps you assess your readiness for the MCAS Exams for Microsoft Office 2007 (Word, Excel, PowerPoint, Outlook, and Access).

    informit.com/examcram

    ISBN-13: 978-0-7897-3774-8

    ISBN-10: 0-7897-3774-4

    Table of contents

    1. Title Page
    2. Copyright Page
    3. Contents at a Glance
    4. Table of Contents
    5. About the Author
    6. Acknowledgments
    7. We Want to Hear from You!
    8. Reader Services
    9. Introduction
    10. Exam Objectives Reference
    11. Getting Ready for the MCAS Exams
    12. Part I: Getting Started
      1. Chapter One: Getting Started with Microsoft Office 2007
    13. Part II: MCAS 77-601: Using Microsoft Office Word 2007
      1. Chapter Two: Creating and Customizing Documents
      2. Chapter Three: Formatting Content
      3. Chapter Four: Working with Visual Content
      4. Chapter Five: Organizing Content Using Quick Parts and Lists
      5. Chapter Six: Organizing Content Using Tables
      6. Chapter Seven: Inserting References and Merging Documents
      7. Chapter Eight: Reviewing Documents
      8. Chapter Nine: Sharing and Securing Content
    14. Part III: MCAS 77-602: Using Microsoft Office Excel 2007
      1. Chapter Ten: Creating and Manipulating Data
      2. Chapter Eleven: Formatting Data and Content
      3. Chapter Twelve: Creating and Modifying Formulas
      4. Chapter Thirteen: Presenting Data Visually
      5. Chapter Fourteen: Collaborating and Securing Data
    15. Part IV: MCAS 77-603: Using Microsoft Office PowerPoint 2007
      1. Chapter Fifteen: Creating and Formatting Presentations
      2. Chapter Sixteen: Working with Slide Animation and Linked Content
      3. Chapter Seventeen: Collaborating on and Delivering Presentations
    16. Part V: MCAS 77-604: Using Microsoft Office Outlook 2007
      1. Chapter Eighteen: Managing Messaging
      2. Chapter Nineteen: Managing Contacts and Scheduling
      3. Chapter Twenty: Organizing Information
    17. Part VI: MCAS 77-605: Using Microsoft Office Access 2007
      1. Chapter Twenty-One: Structuring a Database
      2. Chapter Twenty-Two: Working with Queries and Forms
      3. Chapter Twenty-Three: Presenting and Sharing Data
      4. Chapter Twenty-Four: Managing and Maintaining Databases
    18. Index

    Product information

    • Title: MCAS Office 2007 Exam Prep: Exams for Microsoft Office 2007
    • Author(s): Ron Gilster
    • Release date: June 2009
    • Publisher(s): Pearson IT Certification
    • ISBN: 9780789742384