Skills for Success with MS Office 2010 [Vol.1]

691 Pages·2011·57.461 MB·English

by  K. Townsend, et. al.

Microsoft®
with
Office 2010
V O L U ME 1
PEARSON
TOWNSEND FERRETT HAIN VARGAS
with Microsoft
Office 2010
VOLUME
TOWNSEND I FERRETT I HAIN I VARGAS
Prentice Hall
Boston Columbus Indianapolis New York San Francisco Upper Saddle River
Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montreal Toronto
Delhi Mexico City Sao Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo
Library of Congress Cataloging-in-Publication Data
Townsend, Kris.
Skills for success with Office 2010 / by Kris Townsend.
p. cm.
ISBN 978-0-13-703257-0 (alk. paper)
1. Microsoft Office. 2. Business—Computer programs. I, Title.
HF5548.4.M525T692 201 I
005.5—dc22 2010016531
Editor in Chief: Michael Payne Marketing Assistant: Darshika Vyas
AVP/Executive Acquisitions Editor: Stephanie Wall Senior Managing Editor: Cynthia /.onneveld
Product Development Manager: Eileen Bien Calabro Associate Managing Editor: Camille Trentacoste
Editorial Project Manager: Virginia Gitariglia Production Project Manager: Camille Trentacoste
Development Editor: Nancy Lamm Senior Operations Supervisor: Natacha Moore
Editorial Assistant: Nicole Sam Senior Art Director: Jonathan Boylan
AVP/Director of Online Programs, Media: Richard Keaveny Art Director: Anthony Gemmellaro
AVP/Dircctor of Product Development, Media: Lisa Strife Text and Cover Designer: Anthony Gemmellaro
Editor—Digital Learning & Assessment: Paul Gentile Manager, Rights and Permissions: Ilessa Albader
Product Development Manager, Media: Calhi Projitko Supplements Development Editor: Vonda Keator
Media Project Manager, Editorial: Alana Coles Full-Service Project Management: MPS Content Services, a Macmiilan Company
Media Project Manager, Production: John Cassar Composition: MPS Content Services, a Macmiilan Company
Director of Marketing: Kate Valentine Printer/Binder: Quad/Graphics Taunton
Senior Marketing Manager: Tori Olscn Alves Cover Printer: Lchigli/Phocnix
Marketing Coordinator SI/<<I« Osterlitz Typeface: Minion 10.5/12.5
Credits and acknowledgments borrowed from other sources and reproduced, with permission, in this textbook appear on appropriate page within text.
Microsoft' and Windows* are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. Screen shots and icons reprinted with permission from the Microsoft
Corporation. This book is not sponsored or endorsed by or affiliated with the Microsoft Corporation.
Copyright © 2011 Pearson Education, Inc., publishing as Prentice Hall. All lights reserved. Manufactured in the United States of America. This publication is protected by Copyright, and
permission should be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical,
photocopying, recording, or likewise. To obtain permission(s) to use material from this work, please submit a written request to Pearson Education, Inc., Permissions Department, Upper Saddle
River, New Jersey, 07458
Many of the designations by manufacturers and seller to distinguish their products are claimed as trademarks. Where those designations appear in this book, and the publisher was aware of a
trademark claim, the designations have been printed in initial caps or all caps.
Prentice Hall
is an imprint of
PEARSON 10 9 8 7 6 5 4 32
1SBN-I0: 0-13-703257-9
www.pearsonhighered.com ISBN-13: 978-0-13-703257-0
Contents in Brief
Common Features Chapter 2 Manage Datasheets and
Create Queries 336
Chapter 1 Common Features ot Office 2010 2
More Skills 360
More Skills 26
Chapter 3 Create Forms 370
Word More Skills 394
Chapter 1 Create Documents with Word 2010 30 Chapter 4 Create Reports 404
More Skills 54 More Skills 428
Chapter 2 Format and Organize Text 64
PowerPoint
More Skills 88
Chapter 1 Getting Started with PowerPoint 2010 438
Chapter 3 Work with Graphics, Tabs, and Tables 98
More Skills 462
More Skills 122
Chapter 2 Format a Presentation 472
Chapter 4 Apply Special Text, Paragraph and
Document Formats 132 More Skills 496
More Skills 156 Chapter 3 Enhance Presentations with Graphics 506
More Skills 530
Excel
Chapter 4 Present Data Using Tables, Charts,
Chapter 1 Create Workbooks with Excel 2010 166 and Animation 540
More Skills 190 More Skills 564
Chapter 2 Create Charts 200
Integrated Projects
More Skills 224
Chapter 1 Integrating Word, Excel, Access,
Chapter 3 Manage Multiple Worksheets 234
and PowerPoint 574
More Skills 258 More Skills 598
Chapter 4 Use Excel Functions and Tables 268 Chapter 2 More Integrated Projects for Word,
Excel, Access, and PowerPoint 610
More Skills 292
More Skills 634
Access
Glossary 646
Chapter 1 Work with Databases and
Create Tables 302
Index 654
More Skills 326
Contents in Brief iii
Table of Contents
C o m m on Features More Skills
More Skills 11 Split and Arrange Windows 54
Chapter 1 Common Features of Office 2010 2 More Skills 12 Insert Symbols 54
Skill 1 Start Word and Navigate the Word Window 6 More Skills 13 Use Collect and Paste to Create a
Skill 2 Start Excel and PowerPoint and Work with Document 54
Multiple Windows 8 More Skills 14 Insert Screen Shots into Documents 54
Skill 3 Save Files in New Folders 10
Chapter 2 Format and Organize Text 64
Skill 4 Print and Save Documents 12
Skill 1 Set Document Margins 68
Skill 5 Open Student Data Files and Save Copies
Skill 2 Align Text and Set Indents 70
Using Save As 14
Skill 3 Modify Line and Paragraph Spacing 72
Skill 6 Type and Edit Text 16
Skill 4 Format Text Using Format Painter 74
Skill 7 Cut, Copy, and Paste Text 18
Skill 5 Find and Replace Text 76
Skill 8 Format Text and Paragraphs 20
Skill 6 Create Bulleted and Numbered Lists 78
Skill 9 Use the Ribbon 22
Skill 7 Insert and Format Headers and Footers 80
Skill 10 Use Shortcut Menus and Dialog Boxes 24
Skill 8 Insert and Modify Footnotes 82
More Skills
Skill 9 Add Citations 84
More Skills 11 Capture Screens with the Snipping
Skill 10 Create Bibliographies 86
Tool 26
More Skills
More Skills 12 Use Microsoft Office Help 26
More Skills 11 Record AutoCorrect Entries 88
More Skills 13 Organize Files 26
More Skills 12 Use AutoFormat to Create
More Skills 14 Save Documents to Windows Live 26
Numbered Lists 88
More Skills 13 Format and Customize Lists 88
More Skills 14 Manage Document Properties 88
Word
Chapter 3 Work with Graphics, Tabs,
Chapter 1 Create Documents with Word 2010 30 and Tables 98
Skill 1 Create New Documents and Enter Text 34 Skill 1 Insert Pictures from Files 102
Skill 2 Edit Text and Use Keyboard Shortcuts 36 Skill 2 Resize and Move Pictures 104
Skill 3 Select Text 38 Skill 3 Format Pictures Using Styles and
Skill 4 Insert Text from Other Documents 40 Artistic Effects 106
Skill 5 Change Fonts, Font Sizes, and Font Styles 42 Skill 4 Set Tab Stops 108
Skill 5 Enter Text with Tab Stops 110
Skill 6 Insert and Work with Graphics 44
Skill 6 Apply Table Styles 112
Skill 7 Check Spelling and Grammar 46
Skill 7 Create Tables 114
Skill 8 Use the Thesaurus and Set Proofing Options 48
Skill 8 Add Rows and Columns to Tables H6
Skill 9 Create Document Footers 50
Skill 9 Format Text in Table Cells 118
Skill 10 Work with the Print Page and
Save Documents in Other Formats 52 Skill 10 Format Tables 120
iv Table of Contents
More Skills Skill 8 Format, Edit, and Check the Spelling of Data 184
More Skills 11 Insert Text Boxes 122 Skill 9 Create Footers and Change Page Settings 186
Skill 10 Display and Print Formulas and
More Skills 12 Format with WordArt 122
Scale Worksheets for Printing 188
More Skills 13 Create Tables from Existing Lists 122
More Skills 14 Insert Drop Caps 122 More Skills
Chapter 4 Apply Special Text, Paragraph, More Skills 11 Create New Workbooks from
and Document Formats 132 Templates 190
More Skills 12 Use Range Names in Formulas 190
Skill 1 Create Multiple-Column Text 136
More Skills 13 Change Themes 190
Skill 2 Insert a Column Break 138
More Skills 14 Manage Document Properties 190
Skill 3 Apply and Format Text Effects 140
Skill 4 Use and Create Quick Styles 142 Chapter 2 Create Charts 200
Skill 5 Add Borders and Shading to Paragraphs Skill 1 Open Existing Workbooks and Align Text 204
and Pages 144 Skill 2 Construct and Copy Formulas
Skill 6 Insert and Format Clip Art Graphics 146 Containing Absolute Cell References 206
Skill 7 Insert SmartArt Graphics 148 Skill 3 Format Numbers 208
Skill 8 Format SmartArt Graphics 150 Skill 4 Create Column Charts 210
Skill 9 Create Labels Using Mail Merge 152 Skill 5 Format Column Charts 212
Skill 10 Preview and Print Mail Merge Documents 154 Skill 6 Create Pie Charts and Chart Sheets 214
More Skills Skill 7 Apply 3-D Effects and Rotate Pie Chart
Slices 216
More Skills 11 Create Resumes from Templates 156
Skill 8 Explode and Color Pie Slices,
More Skills 12 Create Outlines 156
and Insert Text Boxes 218
More Skills 13 Prepare Documents for Distribution 156
Skill 9 Update Charts and Insert WordArt 220
More Skills 14 Preview and Save Documents as
Skill 10 Prepare Chart Sheets for Printing 222
Web Pages 156
More Skills
More Skills 11 Insert and Edit Comments 224
Excel More Skills 12 Change Chart Types 224
More Skills 13 Copy Excel Data to Word
Chapter 1 Create Workbooks with Documents 224
Excel 2010 166 More Skills 14 Fill Series Data into Worksheet
Skill 1 Create and Save New Workbooks 170 Cells 224
Skill 2 Enter Worksheet Data and Merge and
Chapter 3 Manage Multiple Worksheets 234
Center Titles 117722
Skill 1 Work with Sheet Tabs 238
Skill 3 Construct Addition and
Skill 2 Enter and Format Dates 240
Subtraction Formulas 117744
Skill 3 Clear Cell Contents and Formats 242
Skill 4 Construct Multiplication and
Division Formulas 176 Skill 4 Move, Copy, Paste, and Paste Options 244
Skill 5 Adjust Column Widths and Apply Cell Styles 178 Skill 5 Work with Grouped Worksheets 246
Skill 6 Use the SUM Function 180 Skill 6 Use Multiple Math Operators in a Formula 248
Skill 7 Copy Formulas and Functions Skill 7 Format Grouped Worksheets 250
Using the Fill Handle 182 Skill 8 Insert and Move Worksheets 252
Table of Contents v
Skill 9 Construct Formulas That Refer to Cells Skill 7 Change Data Types and Other Field
in Other Worksheets 254 Properties 318
Skill 10 Create Clustered Bar Charts 256 Skill 8 Create Tables in Design View 320
Skill 9 Relate Tables 322
More Skills
Skill 10 Enter Data in Related Tables 324
More Skills 11 Create Organization Charts 258
More Skills 12 Create Line Charts 258 More Skills
More Skills 13 Set and Clear Print Areas 258 More Skills 11 Compact and Repair Databases 326
More Skills 14 Insert Hyperlinks 258 More Skills 12 Import Data from Excel 326
More Skills 13 Work with the Attachment Data
Chapter 4 Use Excel Functions and Tables 268
Type 326
Skill 1 Use the SUM and AVERAGE Functions 272
More Skills 14 Work with the Hyperlink
Skill 2 Use the MIN and MAX Functions 274
and Yes/No Data Types 326
Skill 3 Move Ranges with Functions,
Chapter 2 Manage Datasheets and
Add Borders, and Rotate Text 276
Create Queries 336
Skill 4 Use the IF Function 278
Skill 1 Find and Replace Data 340
Skill 5 Apply Conditional Formatting with
Skill 2 Filter and Sort Datasheets 342
Custom Formats, Data Bars, and Sparklines 280
Skill 3 Use the Simple Query Wizard 344
Skill 6 Use Find and Replace and Insert
Skill 4 Format Datasheets 346
the NOW Function 282
Skill 5 Add Date and Time Criteria 348
Skill 7 Freeze and Unfreeze Panes 284
Skill 6 Create Queries in Design View 350
Skill 8 Create and Sort Excel Tables 286
Skill 7 Add Calculated Fields to Queries 352
Skill 9 Use the Search Filter in Excel Tables 288
Skill 8 Work with Logical Criteria 354
Skill 10 Convert Tables to Ranges, Hide Rows
and Columns, and Format Large Worksheets 290 Skill 9 Add Wildcards to Query Criteria 356
Skill 10 Group and Total Queries 358
More Skills
More Skills 11 Apply Conditional Color Scales More Skills
with Top and Bottom Rules 292 More Skills 11 Export Queries to Other Fie Formats 360
More Skills 12 Use the Payment (PMT) Function 292 More Skills 12 Find Duplicate Records 360
More Skills 13 Create PivotTable Reports 292 More Skills 13 Find Unmatched Records 360
More Skills 14 Use Goal Seek 292 More Skills 14 Create Crosstab Queries 360
Chapter 3 Create Forms 370
Skill 1 Use the Form Wizard 374
Access
Skill 2 Format Forms in Layout View 376
Chapter 1 Work with Databases Skill 3 Use Forms to Modify Data 378
and Create Tables 302 Skill 4 Use the Blank Form Tool 380
Skill 1 Open and Organize Existing Databases 306 Skill 5 Customize Form Layouts 382
Skill 2 Enter and Edit Table Data 308 Skill 6 Add Input Masks 384
Skill 3 Create Forms and Enter Data 310 Skill 7 Apply Conditional Formatting 386
Skill 4 Filter Data in Queries 312 Skill 8 Create One-to-Many Forms 388
Skill 5 Create, Preview, and Print Reports 314 Skill 9 Enter Data Using One-to-Many Forms 390
Skill 6 Create Databases and Tables 316 Skill 10 Create Forms from Queries 392
vi Table of Contents
More Skills More Skills 13 Move and Delete Slides in
More Skills 11 Validate Fields 394 Normal View 462
More Skills 12 Add Combo Boxes to Forms 394 More Skills 14 Design Presentations for Audience
and Location 462
More Skills 13 Create Multiple Item Forms 394
More Skills 14 Create Macros 394
Chapter 2 Format a Presentation 472
Chapter 4 Create Reports 404 Skill 1 Create New Presentations 476
Skill 1 Create Reports and Apply Themes 408 Skill 2 Change Presentation Themes 478
Skill 2 Modify Report Layouts 410 Skill 3 Apply Font and Color Themes 480
Skill 3 Prepare Reports for Printing 412 Skill 4 Format Slide Backgrounds with Styles 482
Skill 4 Use the Blank Report Tool 414 Skill 5 Format Slide Backgrounds with Pictures
Skill 5 Group and Sort Reports 416 and Textures 484
Skill 6 Format and Filter Reports 418 Skill 6 Format Text with WordArt 486
Skill 7 Create Label Reports 420 Skill 7 Change Character Spacing and Font Color 488
Skill 8 Use the Report Wizard 422 Skill 8 Modify Bulleted and Numbered Lists 490
Skill 9 Modify Layouts in Design View 424 Skill 9 Move and Copy Text and Objects 492
Skill 10 Add Totals and Labels to Reports 426 Skill 10 Use Format Painter and Clear All
Formatting Commands 494
More Skills
More Skills
More Skills 11 Export Reports to Word 428
More Skills 11 Edit Slide Master 496
More Skills 12 Export Reports to HTML Documents 428
More Skills 12 Save and Apply Presentation
More Skills 13 Create Parameter Queries 428
Template 496
More Skills 14 Create Reports for Parameter Queries 428
More Skills 13 Create Slides from Microsoft Word
Outline 496
PowerPoint More Skills 14 Design Presentations with Contrast 496
Chapter 1 Getting Started with Chapter 3 Enhance Presentations
PowerPoint 2010 438 with Graphics 506
Skill 1 Open, View, and Save Presentations 442 Skill 1 Insert Slides from Other Presentations 510
Skill 2 Edit and Replace Text in Normal View 444 Skill 2 Insert, Size, and Move Clip Art 512
Skill 3 Format Slide Text 446 Skill 3 Modify Picture Shapes, Borders, and Effects 514
Skill 4 Check Spelling and Use the Thesaurus 448 Skill 4 Insert, Size, and Move Shapes 516
Skill 5 Insert Slides and Modify Slide Layouts 450 Skill5 Add Text to Shapes and Insert Text Boxes 518
Skill 6 Insert and Format Pictures 452 Skill 6 Apply Gradient Fills and Group
Skill 7 Organize Slides Using Slide Sorter View 454 and Align Graphics 520
Skill 8 Apply Slide Transitions and View Slide Shows 456 Skill 7 Convert Text to SmartArt Graphics
Skill 9 Insert Headers and Footers and Add Shapes 522
and Print Presentation Handouts 458 Skill 8 Modify SmartArt Layouts, Colors, and Styles 524
Skill 10 Add Notes Pages and Print Notes 460 Skill 9 Insert Video Files 526
Skill 10 Apply Video Styles and Adjust Videos 528
More Skills
More Skills 11 Type Text in the Outline Tab 462 More Skills
More Skills 12 Use Keyboard Shortcuts 462 More Skills 11 Compress Pictures 530
Table of Contents vii
More Skills 12 Save Groups as Picture Files 530 Skill 8 Link Data between Office Applications
More Skills 13 Change Object Order 530 Using OLE 592
More Skills 14 Design Presentations Using Skill 9 Create Envelopes Using Data from Access 594
Appropriate Graphics 530 Skill 10 Create Name Tags Using Data in Excel 596
Chapter 4 Present Data Using Tables, More Skills
Charts, and Animation 540 More Skills 11 Insert Subtotals in Excel and
Skill 1 Insert Tables 544 Link Data to a Word Document 598
Skill 2 Modify Table Layouts 546 More Skills 12 Insert Slides from Another
Presentation 598
Skill 3 Apply Table Styles 548
More Skills 13 Move and Copy Excel Worksheets
Skill 4 Insert Column Charts 550
and Consolidate Data 598
Skill 5 Edit and Format Charts 552
More Skills 14 Compare Shared Excel Workbooks 598
Skill 6 Insert Pie Charts 554
Skill 7 Apply Animation Entrance Chapter 2 More Integrated Projects for Word,
and Emphasis Effects 556 Excel, Access, and PowerPoint 610
Skill 8 Modify Animation Timing Skill 1 Create an Access Append Query 614
and Use Animation Painter 558 Skill 2 Export Data from Access into Excel 616
Skill 9 Remove Animation and Modify Duration 560 Skill 3 Create an Excel PivotTable Report 618
Skill 10 Navigate Slide Shows 562 Skill 4 Create External References between
More Skills Excel Workbooks 620
Skill 5 Insert a SmartArt Organization Chart into
More Skills 11 Prepare Presentations to be Viewed
PowerPoint 622
Using Office PowerPoint Viewer 564
Skill 6 Insert an Excel PivotTable into PowerPoint 624
More Skills 12 Insert Hyperlinks in a Presentation 564
Skill 7 Insert a PowerPoint Outline in Word
More Skills 13 Create Photo Albums 564
and Create a Cover Page
More Skills 14 Design Presentations with
and Table of Contents 626
Appropriate Animation 564
Skill 8 Link and Embed Data from Excel into Word 628
Skill 9 Export Data from Access to an RTF File
and Insert the File into Word 630
Integrated Projects Skill 10 Insert Objects from PowerPoint into Word 632
Chapter 1 Integrating Word, Excel, Access, kills
and PowerPoint 574 More Skills 11 Create an Excel PivotChart
Skill 1 Move Text between Word Documents 578 and Link the PivotChart to Word 634
Skill 2 Apply Heading Styles in Word 580 More Skills 12 Create a Hyperlink between
Skill 3 Create a PowerPoint Presentation PowerPoint, Word, and Excel Files 634
from a Word Document 582 More Skills 13 Insert a Total Row in an Excel Table
Skill 4 Insert and Modify a Shape in PowerPoint 584 and Link the Table to PowerPoint 634
Skill 5 Import a Word Table into More Skills 14 Compare Word Documents 634
an Excel Workbook 586
Glossary
Skill 6 Insert a Shape from PowerPoint into Word 646
and Excel 588
Index
654
Skill 7 Create and Work with an Excel Table 590
viii Table of Contents
About the Authors
Kris Townsend is an Information Systems instructor at Spokane Falls Community College in
Spokane, Washington. Kris earned a bachelor's degree in both Education and Business, and a
master's degree in Education. He has also worked as a public school teacher and as a systems
analyst. Kris enjoys working with wood, snowboarding, and camping. He commutes to work
by bike and enjoys long road rides in the Palouse country south of Spokane.
Robert L. Ferrett recently retired as the Director of the Center for Instructional Computing
at Eastern Michigan University, where he provided computer training and support to faculty.
He has authored or co-authored more than 70 books on Access, PowerPoint, Excel, Publisher,
WordPerfect, Windows, and Word. He has been designing, developing, and delivering
computer workshops for more than two decades.
Catherine Hain is an instructor at Central New Mexico Community College in Albuquerque,
New Mexico. She teaches computer applications classes in the Business and Information
Technology School, both in the classroom and through the distance learning office. Catherine
holds a bachelor's degree in Management and Marketing and a master's degree in Business
1
Administration.
Alicia Vargas is an Associate Professor of Business Information Technology at Pasadena City
College in California. She holds a bachelor's and a master's degree in Business Education from
California State University, Los Angeles and has authored numerous textbooks and training
ft materials on Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.
A Special Thank You
Pearson Prentice Hall gratefully acknowledges the contribution made by Shelley Gaskin to the
first edition publication of this series—Skills for Success with Office 2007. The series has truly
benefited from her dedication toward developing a textbook that aims to help students and
instructors.We thank her for her continued support of this series.
About the Authors ix