Microsoft Office System 2007 (Microsoft Official Academic Course Series)

1226 Pages·2009·60.12 MB·English

by  Microsoft Official Academic Course

069473_FM_US 9/18/08 7:49 PM Page ii
www.wiley.com/college/microsoft orcall the MOAC Toll-Free Number:1+[phone]
(North America Only)
069473_FM_US 10/22/08 12:15 PM Page i
www.wiley.com/college/microsoft orcall the MOAC Toll-Free Number:1+[phone] (North America Only)
069473_FM_US 9/18/08 7:49 PM Page ii
www.wiley.com/college/microsoft orcall the MOAC Toll-Free Number:1+[phone]
(North America Only)
069473_FM_US 9/18/08 7:49 PM Page iii
®
Microsoft Official Academic Course
®
Microsoft Office System 2007
069473_FM_US 9/18/08 7:49 PM Page iv
www.wiley.com/college/microsoft orcall the MOAC Toll-Free Number:1+[phone]
(North America Only)
069473_FM_US 9/22/08 2:52 PM Page v
Microsoft Certified Application Specialist (MCAS)
■ What does this logo mean?
It means this courseware has been approved by the Microsoft® Certified Application Specialist
program to be among the finest available for learning Microsoft® Office Word 2007,
Microsoft® Office Excel 2007, Microsoft® Office PowerPoint 2007, Microsoft® Office Access
2007, or Microsoft® Office Outlook 2007. It also means that upon completion of this course-
ware, you may be prepared to take an exam for Microsoft Certified Application Specialist
qualification.
■ What is a Microsoft Certified Application Specialist?
A Microsoft Certified Application Specialist is an individual who has passed exams for certify-
ing his or her skills in one or more of the Microsoft Office desktop applications such as
Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Outlook, or Microsoft
Access. The Microsoft Certified Application Specialist program is the only program approved
by Microsoft for testing proficiency in Microsoft Office desktop applications. This testing pro-
gram can be a valuable asset in any job search or career development.
■ More Information
To learn more about becoming a Microsoft Certified Application Specialist and exam avail-
ability, visit www.microsoft.com/learning/msbc.
Microsoft, the Microsoft Office Logo, PowerPoint, and Outlook are trademarks or registered
trademarks of Microsoft Corporation in the United States and/or other countries, and the
Microsoft Certified Application Specialist logo is used under license from the owner.
www.wiley.com/college/microsoft orcall the MOAC Toll-Free Number:1+[phone]
(North America Only)
069473_FM_US 9/18/08 7:49 PM Page vi
www.wiley.com/college/microsoft orcall the MOAC Toll-Free Number:1+[phone]
(North America Only)
069473_FM_US 9/18/08 7:49 PM Page vii
®
Microsoft Official Academic Course
®
Microsoft Office System 2007
069473_FM_US 10/29/08 3:25 PM Page viii
Credits
EXECUTIVE EDITOR John Kane
SENIOR EDITOR Gary Schwartz
DIRECTOR OF MARKETING AND SALES Mitchell Beaton
MICROSOFT STRATEGIC RELATIONSHIPS MANAGER Merrick Van Dongen of Microsoft Learning
GLOBAL MOAC MANAGER Laura McKenna
DEVELOPMENT AND PRODUCTION Custom Editorial Productions, Inc
EDITORIAL ASSISTANT Jennifer Lartz
PRODUCTION MANAGER Kelly Tavares
CREATIVE DIRECTOR/COVER DESIGNER Harry Nolan
TECHNOLOGY AND MEDIA Phyllis Bregman/Elena Santa Maria
COVER PHOTO Corbis
Wiley 200th Anniversary logo designed by: Richard J. Pacifico
This book was set in Garamond by Aptara, Inc. and printed and bound by Bind Rite Graphics.
The covers were printed by Phoenix Color.
Copyright © 2009, 2008 by John Wiley & Sons, Inc. All rights reserved.
No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any
means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections
107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher,
or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, Inc. 222
Rosewood Drive, Danvers, MA 01923, [phone], fax [phone]. Requests to the Publisher for permis-
sion should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ
07030-5774, [phone], fax [phone]. To order books or for customer service, please call 1-800-CALL
WILEY (225-5945).
Microsoft, ActiveX, Excel, InfoPath, Microsoft Press, MSDN, OneNote, Outlook, PivotChart, PivotTable,
PowerPoint, SharePoint, Visio, Windows, Windows Mobile, and Windows Vista are either registered trademarks or
trademarks of Microsoft Corporation in the United States and/or other countries. Other product and company
names mentioned herein may be the trademarks of their respective owners.
The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events
depicted herein are fictitious. No association with any real company, organization, product, domain name, e-mail
address, logo, person, place, or event is intended or should be inferred.
The book expresses the author’s views and opinions. The information contained in this book is provided without
any express, statutory, or implied warranties. Neither the authors, John Wiley & Sons, Inc., Microsoft Corporation,
nor their resellers or distributors will be held liable for any damages caused or alleged to be caused either directly or
indirectly by this book.
ISBN 978-0-47044226-5
Printed in the United States of America
10 9 8 7 6 5 4 3 2 1
www.wiley.com/college/microsoft orcall the MOAC Toll-Free Number:1+[phone]
(North America Only)