Office 2010 V O L U M E 1
PEARSON T O W N S E N D FERRETT HAIN VARGAS
with M ic roso f t
Office 2010 V O L U M E
T O W N S E N D I FERRETT I H A I N 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 AVP/Executive Acquisitions Editor: Stephanie Wall Product Development Manager: Eileen Bien Calabro Editorial Project Manager: Virginia Gitariglia Development Editor: Nancy Lamm Editorial Assistant: Nicole Sam AVP/Director of Online Programs, Media: Richard Keaveny AVP/Dircctor of Product Development, Media: Lisa Strife Editor—Digital Learning & Assessment: Paul Gentile Product Development Manager, Media: Calhi Projitko Media Project Manager, Editorial: Alana Coles Media Project Manager, Production: John Cassar Director of Marketing: Kate Valentine Senior Marketing Manager: Tori Olscn Alves Marketing Coordinator SI/<<I« Osterlitz
Marketing Assistant: Darshika Vyas Senior Managing Editor: Cynthia /.onneveld Associate Managing Editor: Camille Trentacoste Production Project Manager: Camille Trentacoste Senior Operations Supervisor: Natacha Moore Senior Art Director: Jonathan Boylan Art Director: Anthony Gemmellaro Text and Cover Designer: Anthony Gemmellaro Manager, Rights and Permissions: Ilessa Albader Supplements Development Editor: Vonda Keator Full-Service Project Management: MPS Content Services, a Macmiilan Company Composition: MPS Content Services, a Macmiilan Company Printer/Binder: Quad/Graphics Taunton Cover Printer: Lchigli/Phocnix 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
P E A R S O N www.pearsonhighered.com
1 0 9 8 7 6 5 4 3 2
1 S B N – I 0 : 0 – 1 3 – 7 0 3 2 5 7 – 9
I S B N – 1 3 : 9 7 8 – 0 – 1 3 – 7 0 3 2 5 7 – 0http://www.pearsonhighered.com
Contents in Brief
Common Features Chapter 1 Common Features ot Office 2010 2
More Skills 26
Word Chapter 1 Create Documents with Word 2010 30
More Skills 54 Chapter 2 Format and Organize Text 64
More Skills 88 Chapter 3 Work with Graphics, Tabs, and Tables 98
More Skills 122 Chapter 4 Apply Special Text, Paragraph and
Document Formats 132 More Skills 156
Excel Chapter 1 Create Workbooks with Excel 2010 166
More Skills 190
Chapter 2 Create Charts 200 More Skills 224
Chapter 3 Manage Multiple Worksheets 234 More Skills 258
Chapter 4 Use Excel Functions and Tables 268 More Skills 292
Access Chapter 1 Work with Databases and
Create Tables 302 More Skills 326
Chapter 2 M a n a g e Datasheets and Create Queries 336 More Skills 360
Chapter 3 Create Forms 370 More Skills 394
Chapter 4 Create Reports 404 More Skills 428
PowerPoint Chapter 1 Getting Started with PowerPoint 2010 438
More Skills 462 Chapter 2 Format a Presentation 472
More Skills 496 Chapter 3 Enhance Presentations with Graphics 506
More Skills 530 Chapter 4 Present Data Using Tables, Charts,
and Animation 540 More Skills 564
Integrated Projects Chapter 1 Integrating Word, Excel, A c c e s s ,
and PowerPoint 574 More Skills 598
Chapter 2 More Integrated Projects for Word, Excel, A c c e s s , and PowerPoint 610 More Skills 634
Contents in Brief iii
Table of Contents
C o m m o n Fea tu res C h a p t e r 1 C o m m o n F e a t u r e s of Office 2 0 1 0 2
Skill 1 Start Word and Navigate the Word Window 6 Skill 2 Start Excel and PowerPoint and Work with
Multiple Windows 8 Skill 3 Save Files in New Folders 10 Skill 4 Print and Save Documents 12 Skill 5 Open Student Data Files and Save Copies
Using Save As 14 Skill 6 Type and Edit Text 16 Skill 7 Cut, Copy, and Paste Text 18 Skill 8 Format Text and Paragraphs 20 Skill 9 Use the Ribbon 22
Skill 10 Use Shortcut Menus and Dialog Boxes 24
More Skills More Skills 11 Capture Screens with the Snipping
Tool 26 More Skills 12 Use Microsoft Office Help 26 More Skills 13 Organize Files 26 More Skills 14 Save Documents to Windows Live 26
W o r d C h a p t e r 1 C r e a t e D o c u m e n t s with Word 2 0 1 0 3 0
Skill 1 Create New Documents and Enter Text 34 Skill 2 Edit Text and Use Keyboard Shortcuts 36 Skill 3 Select Text 38 Skill 4 Insert Text from Other Documents 40 Skill 5 Change Fonts, Font Sizes, and Font Styles 42 Skill 6 Insert and Work with Graphics 44 Skill 7 Check Spelling and Grammar 46 Skill 8 Use the Thesaurus and Set Proofing Options 48 Skill 9 Create Document Footers 50
Skill 10 Work with the Print Page and Save Documents in Other Formats 52
More Skills More Skills 11 Split and Arrange Windows 54 More Skills 12 Insert Symbols 54 More Skills 13 Use Collect and Paste to Create a
Document 54 More Skills 14 Insert Screen Shots into Documents 54
C h a p t e r 2 Format a n d O r g a n i z e Text 6 4 Skill 1 Set Document Margins 68 Skill 2 Align Text and Set Indents 70 Skill 3 Modify Line and Paragraph Spacing 72 Skill 4 Format Text Using Format Painter 74 Skill 5 Find and Replace Text 76 Skill 6 Create Bulleted and Numbered Lists 78 Skill 7 Insert and Format Headers and Footers 80 Skill 8 Insert and Modify Footnotes 82 Skill 9 Add Citations 84
Skill 10 Create Bibliographies 86
More Skills More Skills 11 Record AutoCorrect Entries 88 More Skills 12 Use AutoFormat to Create
Numbered Lists 88 More Skills 13 Format and Customize Lists 88 More Skills 14 Manage Document Properties 88
C h a p t e r 3 Work with G r a p h i c s , Tabs , a n d T a b l e s 9 8
Skill 1 Insert Pictures from Files 102 Skill 2 Resize and Move Pictures 104 Skill 3 Format Pictures Using Styles and
Artistic Effects 106 Skill 4 Set Tab Stops 108 Skill 5 Enter Text with Tab Stops 110 Skill 6 Apply Table Styles 112 Skill 7 Create Tables 114 Skill 8 Add Rows and Columns to Tables H6 Skill 9 Format Text in Table Cells 118
Skill 10 Format Tables 120
iv Table of Contents
More Skills More Skills 11 Insert Text Boxes 122 More Skills 12 Format with WordArt 122 More Skills 13 Create Tables from Existing Lists 122 More Skills 14 Insert Drop Caps 122
C h a p t e r 4 A p p l y S p e c i a l T e x t , P a r a g r a p h , a n d D o c u m e n t F o r m a t s 1 3 2
Skill 1 Create Multiple-Column Text 136 Skill 2 Insert a Column Break 138 Skill 3 Apply and Format Text Effects 140 Skill 4 Use and Create Quick Styles 142 Skill 5 Add Borders and Shading to Paragraphs
and Pages 144 Skill 6 Insert and Format Clip Art Graphics 146 Skill 7 Insert SmartArt Graphics 148 Skill 8 Format SmartArt Graphics 150 Skill 9 Create Labels Using Mail Merge 152
Skill 10 Preview and Print Mail Merge Documents 154
More Skil ls More Skills 11 More Skills 12 More Skills 13 More Skills 14
Create Resumes from Templates 156 Create Outlines 156 Prepare Documents for Distribution 156 Preview and Save Documents as Web Pages 156
Exce l C h a p t e r 1 C r e a t e W o r k b o o k s w i t h
Exce l 2 0 1 0 Skill 1 Create and Save New Workbooks Skill 2 Enter Worksheet Data and Merge and
Center Titles Skill 3 Construct Addition and
Subtraction Formulas Skill 4 Construct Multiplication and
Division Formulas Skill 5 Adjust Column Widths and Apply Cell Styles Skill 6 Use the SUM Function Skill 7 Copy Formulas and Functions
Using the Fill Handle
1 6 6 170
Skill 8 Format, Edit, and Check the Spelling of Data 184 Skill 9 Create Footers and Change Page Settings 186
Skill 10 Display and Print Formulas and Scale Worksheets for Printing
More Skil ls More Skills 11
More Skills 12 More Skills 13 More Skills 14
Create New Workbooks from Templates Use Range Names in Formulas Change Themes Manage Document Properties
C h a p t e r 2 Skill 1 Skill 2
Skill 3 Skill 4 Skill 5 Skill 6 Skill 7
Skill 9 Skill 10
C r e a t e C h a r t s Open Existing Workbooks and Align Text Construct and Copy Formulas Containing Absolute Cell References Format Numbers Create Column Charts Format Column Charts Create Pie Charts and Chart Sheets Apply 3-D Effects and Rotate Pie Chart Slices Explode and Color Pie Slices, and Insert Text Boxes Update Charts and Insert WordArt Prepare Chart Sheets for Printing
More Ski l ls More Skills 11 More Skills 12 More Skills 13
Insert and Edit Comments Change Chart Types Copy Excel Data to Word Documents
More Skills 14 Fill Series Data into Worksheet Cells
190 190 190 190
2 0 0 204
206 208 210 212 214
218 220 222
172 C h a p t e r 3 M a n a g e M u l t i p l e W o r k s h e e t s 2 3 4
172 Skill 1 Work with Sheet Tabs 238
174 Skill 2 Enter and Format Dates 240 174 Skill 3 Clear Cell Contents and Formats 242
176 Skill 4 Move, Copy, Paste, and Paste Options 244
178 Skill 5 Work with Grouped Worksheets 246
180 Skill 6 Use Multiple Math Operators in a Formula 248 Skill 7 Format Grouped Worksheets 250
182 Skill 8 Insert and Move Worksheets 252
Table of Contents v
Skill 9 Construct Formulas That Refer to Cells in Other Worksheets 254
Skill 10 Create Clustered Bar Charts 256
More Skills More Skills 11 Create Organization Charts 258 More Skills 12 Create Line Charts 258 More Skills 13 Set and Clear Print Areas 258 More Skills 14 Insert Hyperlinks 258
C h a p t e r 4 U s e Exce l F u n c t i o n s a n d T a b l e s 2 6 8 Skill 1 Use the SUM and AVERAGE Functions 272 Skill 2 Use the MIN and MAX Functions 274 Skill 3 Move Ranges with Functions,
Add Borders, and Rotate Text 276 Skill 4 Use the IF Function 278 Skill 5 Apply Conditional Formatting with
Custom Formats, Data Bars, and Sparklines 280 Skill 6 Use Find and Replace and Insert
the NOW Function 282 Skill 7 Freeze and Unfreeze Panes 284 Skill 8 Create and Sort Excel Tables 286 Skill 9 Use the Search Filter in Excel Tables 288
Skill 10 Convert Tables to Ranges, Hide Rows and Columns, and Format Large Worksheets 290
More Skills More Skills 11 Apply Conditional Color Scales
with Top and Bottom Rules 292 More Skills 12 Use the Payment (PMT) Function 292 More Skills 13 Create PivotTable Reports 292 More Skills 14 Use Goal Seek 292
A c c e s s C h a p t e r 1 Work with D a t a b a s e s
a n d C r e a t e T a b l e s 3 0 2 Skill 1 Open and Organize Existing Databases 306 Skill 2 Enter and Edit Table Data 308 Skill 3 Create Forms and Enter Data 310 Skill 4 Filter Data in Queries 312 Skill 5 Create, Preview, and Print Reports 314 Skill 6 Create Databases and Tables 316
vi Table of Contents
Skill 7 Change Data Types and Other Field Properties 318
Skill 8 Create Tables in Design View 320 Skill 9 Relate Tables 322
Skill 10 Enter Data in Related Tables 324
More Skills More Skills 11 Compact and Repair Databases 326 More Skills 12 Import Data from Excel 326 More Skills 13 Work with the Attachment Data
Type 326 More Skills 14 Work with the Hyperlink
and Yes/No Data Types 326
C h a p t e r 2 M a n a g e D a t a s h e e t s a n d C r e a t e Q u e r i e s 3 3 6
Skill 1 Find and Replace Data 340 Skill 2 Filter and Sort Datasheets 342 Skill 3 Use the Simple Query Wizard 344 Skill 4 Format Datasheets 346 Skill 5 Add Date and Time Criteria 348 Skill 6 Create Queries in Design View 350 Skill 7 Add Calculated Fields to Queries 352 Skill 8 Work with Logical Criteria 354 Skill 9 Add Wildcards to Query Criteria 356
Skill 10 Group and Total Queries 358
More Skills More Skills 11 Export Queries to Other Fie Formats 360 More Skills 12 Find Duplicate Records 360 More Skills 13 Find Unmatched Records 360 More Skills 14 Create Crosstab Queries 360
C h a p t e r 3 C r e a t e Forms 3 7 0 Skill 1 Use the Form Wizard 374 Skill 2 Format Forms in Layout View 376 Skill 3 Use Forms to Modify Data 378 Skill 4 Use the Blank Form Tool 380 Skill 5 Customize Form Layouts 382 Skill 6 Add Input Masks 384 Skill 7 Apply Conditional Formatting 386 Skill 8 Create One-to-Many Forms 388 Skill 9 Enter Data Using One-to-Many Forms 390
Skill 10 Create Forms from Queries 392
More Skills More Skills 11 Validate Fields 394 More Skills 12 Add Combo Boxes to Forms 394 More Skills 13 Create Multiple Item Forms 394 More Skills 14 Create Macros 394
C h a p t e r 4 C r e a t e R e p o r t s 4 0 4 Skill 1 Create Reports and Apply Themes 408 Skill 2 Modify Report Layouts 410 Skill 3 Prepare Reports for Printing 412 Skill 4 Use the Blank Report Tool 414 Skill 5 Group and Sort Reports 416 Skill 6 Format and Filter Reports 418 Skill 7 Create Label Reports 420 Skill 8 Use the Report Wizard 422 Skill 9 Modify Layouts in Design View 424
Skill 10 Add Totals and Labels to Reports 426
More Skills More Skills 11 Export Reports to Word 428 More Skills 12 Export Reports to HTML Documents 428 More Skills 13 Create Parameter Queries 428 More Skills 14 Create Reports for Parameter Queries 428
PowerPo in t C h a p t e r 1 G e t t i n g S t a r t e d w i t h
P o w e r P o i n t 2 0 1 0 4 3 8 Skill 1 Open, View, and Save Presentations 442 Skill 2 Edit and Replace Text in Normal View 444 Skill 3 Format Slide Text 446 Skill 4 Check Spelling and Use the Thesaurus 448 Skill 5 Insert Slides and Modify Slide Layouts 450 Skill 6 Insert and Format Pictures 452 Skill 7 Organize Slides Using Slide Sorter View 454 Skill 8 Apply Slide Transitions and View Slide Shows 456 Skill 9 Insert Headers and Footers
and Print Presentation Handouts 458 Skill 10 Add Notes Pages and Print Notes 460
More Skil ls More Skills 11 Type Text in the Outline Tab 462 More Skills 12 Use Keyboard Shortcuts 462
More Skills 13 Move and Delete Slides in Normal View 462
More Skills 14 Design Presentations for Audience and Location 462
C h a p t e r 2 F o r m a t a P r e s e n t a t i o n 4 7 2 Skill 1 Create New Presentations 476 Skill 2 Change Presentation Themes 478 Skill 3 Apply Font and Color Themes 480 Skill 4 Format Slide Backgrounds with Styles 482 Skill 5 Format Slide Backgrounds with Pictures
and Textures 484 Skill 6 Format Text with WordArt 486 Skill 7 Change Character Spacing and Font Color 488 Skill 8 Modify Bulleted and Numbered Lists 490 Skill 9 Move and Copy Text and Objects 492
Skill 10 Use Format Painter and Clear All Formatting Commands 494
More Skil ls More Skills 11 Edit Slide Master 496 More Skills 12 Save and Apply Presentation
Template 496 More Skills 13 Create Slides from Microsoft Word
Outline 496 More Skills 14 Design Presentations with Contrast 496
C h a p t e r 3 E n h a n c e P r e s e n t a t i o n s w i t h G r a p h i c s 5 0 6
Skill 1 Insert Slides from Other Presentations 510 Skill 2 Insert, Size, and Move Clip Art 512 Skill 3 Modify Picture Shapes, Borders, and Effects 514 Skill 4 Insert, Size, and Move Shapes 516 Ski l l5 Add Text to Shapes and Insert Text Boxes 518 Skill 6 Apply Gradient Fills and Group
and Align Graphics 520 Skill 7 Convert Text to SmartArt Graphics
and Add Shapes 522 Skill 8 Modify SmartArt Layouts, Colors, and Styles 524 Skill 9 Insert Video Files 526
Skill 10 Apply Video Styles and Adjust Videos 528
More Skil ls More Skills 11 Compress Pictures 530
Table of Contents vii
More Skills 12 Save Groups as Picture Files 530 More Skills 13 Change Object Order 530 More Skills 14 Design Presentations Using
Appropriate Graphics 530
C h a p t e r 4 P r e s e n t D a t a U s i n g T a b l e s , C h a r t s , a n d A n i m a t i o n 5 4 0
Skill 1 Insert Tables 544 Skill 2 Modify Table Layouts 546 Skill 3 Apply Table Styles 548 Skill 4 Insert Column Charts 550 Skill 5 Edit and Format Charts 552 Skill 6 Insert Pie Charts 554 Skill 7 Apply Animation Entrance
and Emphasis Effects 556 Skill 8 Modify Animation Timing
and Use Animation Painter 558 Skill 9 Remove Animation and Modify Duration 560
Skill 10 Navigate Slide Shows 562
More Ski l ls More Skills 11 Prepare Presentations to be Viewed
Using Office PowerPoint Viewer 564 More Skills 12 Insert Hyperlinks in a Presentation 564 More Skills 13 Create Photo Albums 564 More Skills 14 Design Presentations with
Appropriate Animation 564
I n t e g r a t e d Pro jec ts C h a p t e r 1 I n t e g r a t i n g W o r d , E x c e l , A c c e s s ,
a n d P o w e r P o i n t 5 7 4 Skill 1 Move Text between Word Documents 578 Skill 2 Apply Heading Styles in Word 580 Skill 3 Create a PowerPoint Presentation
from a Word Document 582 Skill 4 Insert and Modify a Shape in PowerPoint 584 Skill 5 Import a Word Table into
an Excel Workbook 586 Skill 6 Insert a Shape from PowerPoint into Word
and Excel 588 Skill 7 Create and Work with an Excel Table 590
viii Table of Contents
Skill 8 Link Data between Office Applications Using O L E
Skill 9 Create Envelopes Using Data from Access Skill 10 Create Name Tags Using Data in Excel
More Ski l ls More Skills 11 Insert Subtotals in Excel and
Link Data to a Word Document More Skills 12 Insert Slides from Another
Presentation More Skills 13 Move and Copy Excel Worksheets
and Consolidate Data More Skills 14 Compare Shared Excel Workbooks
C h a p t e r 2
Skill 1 Skill 2 Skill 3 Skill 4
Skill 6 Skill 7
Skill 8 Skill 9
M o r e I n t e g r a t e d P r o j e c t s f o r W o r d , E x c e l , A c c e s s , a n d P o w e r P o i n t Create an Access Append Query Export Data from Access into Excel Create an Excel PivotTable Report Create External References between Excel Workbooks Insert a SmartArt Organization Chart into PowerPoint Insert an Excel PivotTable into PowerPoint Insert a PowerPoint Outline in Word and Create a Cover Page and Table of Contents Link and Embed Data from Excel into Word Export Data from Access to an R T F File and Insert the File into Word Insert Objects from PowerPoint into Word Skill 10
kills More Skills 11 Create an Excel PivotChart
and Link the PivotChart to Word More Skills 12 Create a Hyperlink between
PowerPoint, Word, and Excel Files More Skills 13 Insert a Total Row in an Excel Table
and Link the Table to PowerPoint More Skills 14 Compare Word Documents
592 594 596
6 1 0 614 616 618
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 Administration.
f t 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 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
Contributors We’d like to thank the following people for their work on Skills for Success:
Instructor Resource Authors Erich Adickes Parkland College Sharon Behrens Northeast Wisconsin Technical College Julie Boyles Portland Community College Barbara Edington St. Francis College Ranida Harris Indiana University Southeast Beth Hendrick Lake Sumter Community College Susan Holland Southeast Community College—Nebraska Andrea Leinbach Harrisburg Area Community College Yvonne Leonard Coastal Carolina Community College
Technical Editors Lisa Bucki Kelly Carling Hilda W i r t h Federico Jacksonville University Tom Lightner Missouri State University Elizabeth Lockley Joyce Nielsen
Reviewers Darrell Abbey Cascadia Community College Bridget I . Archer Oakton Community College Laura Aagard Sierra College John Alcorcha MTI College Barry Andrews Miami Dade College Natalie Andrews Miami Dade College Wilma Andrews Virginia Commonwealth University School
of Business Bridget Archer Oakton Community College Tahir Aziz J. Sargeant Reynolds Greg Balinger Miami Dade College Terry Bass University of Massachusetts, Lowell Lisa Beach Santa Rosa Junior College Rocky Belcher Sinclair Community College Nannette Biby Miami Dade College David Billings Guilford Technical Community College Brenda K. Br i t t Fayetteville Technical Community College Alisa Brown Pulaski Technical College Eric Cameron Passaic Community College
Trina Maurer Anthony Nowakowski Ernest Gines Stacey Gee Hollins John Purcell Ann Rowlette Amanda Shelton Steve St. John Joyce Thompson Karen Wisniewski
Georgia Virtual Technical College Buffalo State College Tarrant County College—Southeast St. Louis Community College—Meramec Castleton State College Liberty University J. Sargeant Reynolds Tulsa Community College Lehigh Carbon Community College County College of Morris
Janet Pickard Linda Pogue Steve Rubin Eric Sabbah Jan Snyder Mara Zebest
Chattanooga State Tech Community College Northwest Arkansas Community College California State University—Monterey Bay
Gene Carbonaro Trey Cherry Kim Childs Pualine Chohonis Lennie Coper Tara Cipriano Paulette Comet
Gail W . Cope Susana Contreras de Finch Chris Corbin Janis Cox Tomi Crawford Martin Cronlund Jennifer Day Ralph DeArazoza Carol Decker Loorna DeDuluc Caroline Delcourt
Long Beach City College Edgecombe Community College Bethany University Miami Dade College Miami Dade College Gateway Technical College Community College of Baltimore
Coun ty—Ca to nsville Sinclair Community College College of Southern Nevada Miami Dade College Tri-County Technical College Miami Dade College Anne Arundel Community College Sinclair Community College Miami Dade College Montgomery College Miami Dade College Black Hawk College
Michael Discello Kevin Duggan Barbara Edington Donna Ehrhart Hilda Wirth Federico Tushnelda Fernandez Arlene Flerchinger Hedy Fossenkemper Kent Foster Penny Foster-Shiver Arlene Franklin George Gabb Barbara Garrell Deb Geoghan Jessica Gilmore Victor Giol Melinda Glander Linda Glassburn Deb Gross Rachelle Hall Marie Hartlein Diane Hartman Betsy Headrick Patrick Healy
Lindsay Henning Kermelle Hensley Diana Hill Rachel Hinton Mary Carole Hollingsworth Stacey Gee Hollins Bill Holmes Steve Holtz Margaret M. Hvatum Joan Ivey Dr. Dianna D. Johnson Kay Johnston Warren T. Jones, Sr. Sally Kaskocsak Renuka Kumar Kathy McKee Hazel Kates Gerald Kearns
Pittsburgh Technical Institute Midlands Technical Community College St. Francis College Genesee Community College Jacksonville University Miami Dade College Chattanooga State Tech Community College Paradise Valley Community College Withrop University Anne Arundel Community College Bucks County Community College Miami Dade College Delaware County Community College Bucks County Community College Highline Community College Miami Dade College Northmetro Technical College Cuyahoga Community College, West Ohio State University Glendale Community College Montgomery County Community College Utah Valley State College Chattanooga State Northern Virginia Community
College—Woodbridge Yavapai College Columbus Technical College Chesapeake College Broome Community College GA Perimeter St. Louis Community College—Meramec Chandler-Gilbert Community College University of Minnesota Duluth St. Louis Community College Lanier Technical College North Metro Technical College Columbia Basin College University of Alabama at Birmingham Sinclair Community College Community College of Baltimore County North Metro Technical College Miami Dade College Forsyth Technical Community College
John Kidd Chris Kinnard Kelli Kleindorfer Kurt Kominek Dianne Kotokoff Cynthia Krebs Jean Lacoste Gene Laugh rey David LeBron Kaiyang Liang Linda Lindaman Felix Lopez Nicki Maines Cindy Manning Patri Mays Norma McKenzie Lee McKinley Sandy McCormack Eric Meyer Kathryn Miller
Gloria A. Morgan Kathy Morris Linda Moulton Ryan Murphy Stephanie Murre Wolf Jackie Myers Dell Najera
Scott Nason Paula Neal Bethanne Newman Eloise Newsome
Karen Nunan Ellen Orr Carol Ottaway Denise Passero Americus Pavese James Gordon Patterson Cindra Phillips
Northern Virginia Community College—Woodbridge
Tarrant County Community College Miami Dade College American Institute of Business NE State Tech Community College Lanier Technical College Utah Valley University Virginia Tech Northern Oklahoma College Miami Dade College Miami Dade College Black Hawk College Miami Dade College Mesa Community College Big Sandy Community and Technical College Paradise Valley Community College El Paso Community College GA Perimeter Monroe Community College Miami Dade College Big Sandy Community and Technical College,
Pike Ville Campus Monroe Community College University of Alabama, Tuscaloosa Montgomery County Community College Sinclair Community College Moraine Park Technical College Sinclair Community College El Paso Community College, Valle Verde
Campus Rowan Cabarrus Community College Sinclair Community College Paradise Valley Community College Northern Virginia Community
College—Woodbridge Northeast State Technical Community College Seminole Community College Chemeketa Community College Fulton-Montgomery Community College Community College of Baltimore County Paradise Valley Community College Clark State CC
Janet Pickard Chattanooga State Tech Community College Diane Stark Phoenix College Floyd Pittman Miami Dade College Neil Stenlund Northern Virginia Community College Melissa Prinzing Sierra College Linda Stoudemayer Lamar Institute of Technology Pat Rahmlow Montgomery County Community College Pamela Stovall Forsyth Technical Community College Mary Rasley Lehigh Carbon Community College Linda Switzer Highline Community College Scott Rosen Santa Rosa Junior College Margaret Taylor College of Southern Nevada Ann Rowlette Liberty University Martha Taylor Sinclair Community College Kamaljeet Sanghera George Mason University Michael M. Taylor Seattle Central Community College June Scott County College of Morris Roseann Thomas Fayetteville Tech Community College Janet Sebesy Cuyahoga Community College Ingrid Thompson-Sellers GA Perimeter Jennifer Sedelmeyer Broome Community College Daniel Thomson Keiser University Kelly SellAnne Arundel Community College Astrid Hoy Todd Guilford Technical Community College Teresa Sept College of Southern Idaho Barb Tollinger Sinclair Community College Pat Serrano Scottsdale Community College Cathy Urbanski Chandler Gilbert Community College Amanda Shelton J. Sargeant Reynolds Sue Van Boven Paradise Valley Community College Gary Sibbits St. Louis Community College—Meramec Philip Vavalides Guildford Technical Community College Janet Siert Ellsworth Community College Pete Vetere Montgomery County Community College— Robert Sindt Johnson County Community College West Campus Karen Smith Technical College of the Lowcountry Asteria Villegas Monroe College Robert Smolenski Delaware County Community College Michael Walton Miami Dade College Robert Sindt Johnson County Community College Teri Weston Harford Community College Gary R. Smith Paradise Valley Community College Julie Wheeler Sinclair Community College Patricia Snyder Midlands Technical College Debbie Wood Western Piedmont Community College Pamela Sorensen Santa Rosa Junior College Thomas Yip Passaic Community College Eric Stadnik Santa Rosa Junior College Lindy Young Sierra Community College Mark Stanchfield Rochester Community and Technical College Matt Zullo Wake Technical Community College
I n s t r u c t o r s – Y o u a s k e d for it s o h e r e it is!
A M i c r o s o f t ® O f f i c e t e x t b o o k t h a t r e c o g n i z e s h o w s t u d e n t s l e a r n t o d a y –
Skills for Success with Microsoft
1 Office 2010 Volume 1
10 X 8.5 F o r m a t – Easy for students to read and type at the same time by simply propping the book up on the desk in front of their monitor
Clear ly Out l ined Sk i l l s – Each skill is presented in a single two-page spread so that students can easily follow along
Numbered S t e p s and Bul le ted Tex t – Students don’t read long paragraphs or text, but they will read information presented concisely
Easy-to-Find S t u d e n t Da ta Fi les – Visual key shows students how to locate and interact with their data files
S t a r t H e r e – Students know exactly where to start and what their starting file will look like
C H A P T E R
G e t t i n g S t a r t e d w i t h W i n d o w s 7 » YOU BK WINDOW 7 ro «CRK M I »F-JF IOM?«L« LOF RUINR-V.*™ PFLNJMN MO»»T*N>WN
MDAU mi mm • J- : >O-L
» IR WIND H I • >\XI OIJJAIZ* TOUR *»RK BV CNUR-J FILCI ir\i PUNNJ THOW tU« WIS FOLDCRI IHJIYAU
Your ilartlng » c r e « n will look Ilk* this: S K I L L !
chapter, you will be
S k i l l s L is t – A visual snapshot of what skills they will complete in the chapter
O u t c o m e – Shows students up front what their completed project will look like
You will tdvo your filoi a t :
T J H N M I M H7_S«II| ‘ ‘
S e q u e n t i a l P a g i n a t i o n – Saves you and your students time in locating topics and assignments I
VISUAL WALK-THROUGH XIII
Skills for Success l ock – Tells how much time students
need to complete the chapter
• KM US TUNTNW *IR*I fie, 01 FGWRN INTO 4 «IR J .: -I—. IT…. I AIULT :;I N..I..: .:
• MIMIJ-»TT*IIHDR»«U««IJI;UIF.:M*NJFOU« |*:R-P<TKF* T > ffirt IN NUJX ITXFFL R»»I« IN RI«J
t Written for T o d a y ‘ s S t u d e n t s – skills are taught with numbered steps and bulleted text so students are less likely to skip valuable information T w o – P a g e S p r e a d s – Each skill is
presented on a two-page spread to help students keep up their momentum
* TITTR.TI bim irii mug], TU L>«
D a t a Files Are a S n a p – Students can now find their files easier than ever before with this visual map
C o l o r e d Text – Clearly shows what a student types
Hands-On – Students start actually working on their skills from Step 1
D o n e ! – Students always know when they’ve completed a skill
XIV VISUAL WALK-THROUGH
Skills for S u c c e s s
UorsSkJh © U M l d t o m i o C k g c n n f M
End-o f -Chapte r M a t e r i a l – Several levels of assessment so you can assign the material that best fits your students’ needs
M o r e S k i l l s – Additional skills included online
K e y T e r m s O n l i n e H e l p Sk i l ls
Midi .. – .! -.. I – :T.
O n l i n e P r o j e c t – Students practice using Microsoft Help online to help prepare them for using the applications on their own
H > u » i « i i HI
•.m • m •
Visual Walk-Through xv
Skills for S u c c e s s
Al l V i d e o s
a n d I n s t r u c t o r m a t e r i a l s
a v a i l a b l e o n t h e I R C D
Instructor Mater ia ls
I n s t r u c t o r ‘ s M a n u a l – Teaching tips and additional resources for each chapter
A s s i g n m e n t S h e e t s – Lists all the assignments for the chapter, you just add in the course information, due dates and points. Providing these to students ensures they will know what is due and when
S c r i p t e d L e c t u r e s – Classroom lectures prepared for you
A n n o t a t e d S o l u t i o n F i l e s – Coupled with the scoring rubrics, these create a grading and scoring system that makes grading so much easier for you
P o w e r P o i n t L e c t u r e s – PowerPoint presentations for each chapter
P r e p a r e d E x a m s – Exams for each chapter and for each application
S c o r i n g R u b r i c s – Can be used either by students to check their work or by you as a quick check-off for the items that need to be corrected
S y l l a b u s T e m p l a t e s – for 8-week, 12-week, and 16-week courses
T e s t B a n k – Includes a variety of test questions for each chapter
C o m p a n i o n W e b S i t e – Online content such as the More Skills Projects, Online Study Guide, Glossary, and Student Data Files are all at www.pearsonhighered.com/skills
xvi Visual Walk-Throughhttp://www.pearsonhighered.com/skills
with M ic roso f t
Office 2010 V O L U M E 1
C H A P T E R J Common Features of Office 2010 • The programs in Microsoft Office 2010—Word, Excel, PowerPoint, and Access—share common
tools that you use in a consistent, easy-to-learn manner.
• Common tasks include opening and saving files, entering and formatting text, and printing your work.
Your starting screen will look like this: SKILLS SKILLS 1 – 1 0 TRAINING Umt Insert Pjgt 1
C M M mailt – 1 1 – * 41 IT
AaBtccJK AaBbCcIK A A B B G .-YABBCC
‘ Items’ “Mo:ca; . rtfacmgl H*jding2 ChtDQt
Past 1 ol I Wmdi 0
A t t h e e n d o f t h i s chapter , y o u w i l l be a b l e t o :
Skill 1 Start Word and Navigate the Word Window Skill 2 Start Excel and PowerPoint and Work with
Multiple Windows Skill 3 Save Files in New Folders Skill 4 Print and Save Documents Skill 5 Open Student Data Files and Save Copies
Using Save As Skill 6 Type and Edit Text Skill 7 Cut, Copy, and Paste Text Skill 8 Format Text and Paragraphs Skill 9 Use the Ribbon Skill 10 Use Shortcut Menus and Dialog Boxes
More Skills 11 Capture Screens with the Snipping Tool More Skills 12 Use Microsoft Office Help More Skills 13 Organize Files More Skills 14 Save Documents to Windows Live
2 C O M M O N FEATURES OF OFFICE 2 0 1 0 | C O M M O N FEATURES C H A P T E R 1
Outcome Using the skills listed to the left will enable you to create documents similar to this:
Visit Aspen Falls! A s p e n F a l l s o v e r l o o k s t h e P a c i f i c O c e a n
a n d is s u r r o u n d e d b y m a n y v i n e y a r d s a n d
w i n e r i e s . O c e a n r e c r e a t i o n is a c c e s s e d
p r i m a r i l y a t D u r a n g o C o u n t y P a r k . T h e
A s p e n L a k e R e c r e a t i o n A r e a p r o v i d e s y e a r
r o u n d f r e s h w a t e r r e c r e a t i o n a n d is t h e
c i t y ‘ s l a r g e s t p a r k .
Local Attractions • W i n e C o u n t r y
o W i n e Tas t ing Tou rs
o Winer ies
• W o r d s w o r t h Fel lowship Museum of A r t
• Du rango C o u n t y M u s e u m of H is to ry
• Conven t ion Center
• A r t Galleries
• Gl ider T o u r s
Aspen Fallc Annual Events • Annua l Starving Artists Sidewalk Sale
• A n n u a l W i n e Festival
• C inco de Mayo
• Vintage Car S h o w
• Her i tage D a y Parade
• Harvest Days
• A m a t e u r Bike Races
• Farmer ‘s Market
• Aspen Lake Nature Cruises
• Aspen Falls T r ia th lon
• Tas te of Aspen Falls
• W i n t e r Blues Festival
Contact Y o u r N a m e for more informat ion.
Common Features of Office 2010
You will save your files as: Lastname_Firstname_cfO 1 _Visit 1 Lastname_Firstname_cfO l_Visit2 Lastname_Firstname_cf01_Visit3
Common Features Chapter 1 | Common Features of Office 2010 3
In t h i s c h a p t e r , y o u w i l l c r e a t e d o c u m e n t s f o r t h e A s p e n F a l l s C i t y
H a l l , w h i c h p r o v i d e s e s s e n t i a l s e r v i c e s f o r t h e c i t i z e n s a n d v i s i t o r s o f
A s p e n F a l l s , C a l i f o r n i a .
C o m m o n Features of Of f ice 2 0 1 0 • Microsoft Office is the most common software used to create and share
personal and business documents.
• Microsoft Office is a suite o f several programs—Word, PowerPoint, Excel, Access, and others—that each have a special purpose.
• Because of the consistent design and layout o f Microsoft Office, when you learn to use one Microsoft Office program, you can use most o f those skil ls when working wi th the other Microsoft Office programs.
• T h e files you create w i t h Microsoft Office need to be named and saved in locations where they can be easily found when you need them.
C o m m o n F e a t u r e s o f O f f i c e 2 0 1 0 | C o m m o n F e a t u r e s C h a p t e r 1
Time to complete all 10 skills – 50 to 90 minutes
Find your student data files here:
Student data files needed for this chapter:
cfOl Visit River
C O M M O N FEATURES C H A P T E R 1 | C O M M O N FEATURES OF OFFICE 2 0 1 0 5
• The Word 2010 program can be launched by clicking the Start button, and then locating and clicking the Microsoft Word 2010 command.
• When you start Word, a new blank document displays in which you can type text.
1. In the lower left corner of the desktop, click the Start button © .
2 . In the lower left corner of the Start menu, click the All Programs command, and then compare your screen with Figure 1 . –
The Microsoft Office folder is located in the All Programs folder. If you have several programs installed on your computer, you may need to scroll to see the Microsoft Office folder.
3 . Click the Microsoft Office folder, and then compare your screen with Figure 2. –
Below the Microsoft Office folder, commands that open various Office 2010 programs display.
4 . From the Start menu, under the Microsoft Office folder, click Microsoft Word 2010, and then wait a few moments for the Microsoft Word window to display.
5 . If necessary, in the upper right corner of the Microsoft Word window, click the Maximize button B| .
• C o n t i n u e t o t h e n e x t p a g e t o c o m p l e t e t h e s
6 Common Features of Office 2010 | Common Features Chapter 1
Ptttuin All Programs folder list
(your list will be different)
Microsoft Office folder
Start button Figure 1
Adobe Acrobat 70 Professional Q Adcbe Designer 7.0 C Dtftuft Program; 9. DesHoe Gadget Gallery tr Internet Eiplorer Cj Window; Anytime Upgrade | | Window! DVD 1 M B . i Window, Fu ind Son
Window, Media Center Q Window! Media Pla/cr ‘ : Window! Update — XPSVI | Accn
MOMSR Cflic SharePoi Startup
Microsoft Office folder
Office 2 0 1 0 programs (your
list may be different)
«•# Window! f a> and Sun • » Window, Media Center B Window! Media Player
Window! Update •4 XPS Viewer
l l l l l l l l l l Game!
Microsoft Office Aj Microsoft Access 2 0 1 0
• M.crcscfl tjcel 2 0 1 0 J3 • ‘ . – WoPath Dowgne. 2 0 1 0 X i r.l;rcsofl Inf cPaal FtCti M 0
N Microsoft OneNcle 2 0 1 0 0 MKicMfl Outlook 2 0 1 0
i_ Mjcroioft PowerPoint 2 3 1 0 _tj Microsoft Publnher 2 0 1 0 1 Microsoft SharePomt Workspace 21 4 lAcrcsoft Wort 2 0 1 0
Mcrosft Olf.ce 2 0 1 0 Tool!
SKILL 1: Start Word and Navigate the Word Window
^ — — — i i !ni(rt fsgcUrrcut RefcuoM! M*!ingl P*.,f.> \
– CWtmlBon,. • u • A” A ‘ A.- ;=•!=•••> 51 “I V • A • c
AaBbCcOc AaBbCcCX AaBbCi A a B b C c r tioimil ‘ I no Sp»cl… Htadlng I Hf a&ng ? Cnarige
Ribbon tab E –
St)M» • -< * « ‘ « « •
names h Home tab
fewer! F>g*l»>©ul Rfffmnol ru . i – 3 : vuw f
C . r . » m ( H , . » , – » – A” A – A.- * • E – 1= ‘ * * )l U A a B b C c O < A»BbCcD( AaBbC. A . l B I . C l . ^A. t mi a • * • x. x ‘
•normal I Mo Saxi-. Mraamg 1 ; Hsasing: – Chlnga
* J f ir.3 –
SlyH.”- < S « » a ‘
.7 f jar. j
Group names Paragraph mark and insertion point
Quick Access Toolbar
New blank Word document
Figure 3 Heading 1 thumbnail
Styles group Show/Hide button selected Insertion point and paragraph mark
Heading 1 formatting applied Home tab is active
On the Ribbon’s Home tab, in the Paragraph group, click the Show/Hide button H until it displays in gold indicating that it is active. Compare your screen with Figure 3 .
Above the blank Word document, the Quick Access Toolbar and Ribbon display. At the top of the Ribbon, a row of tab names display. Each Ribbon tab has buttons that you click to perform actions. The buttons are organized into groups that display their names along the bottom of the Ribbon.
In the document, the insertion point— a vertical line that indicates where text will be inserted when you start typing—flashes near the top left corner.
The Show/Hide button is a toggle button— a button used to turn a feature both on and off. The paragraph mark (f) indicates the end of a paragraph and will not print.
In the document, type your first and last names. As you type, notice that the insertion point and paragraph mark move to the right.
On the Home tab, in the Styles group, point to—but do not click—the Heading 1 thumbnail to show the Live Preview—a feature that displays the result of a formatting change if you select it.
Click the Heading 1 thumbnail to apply the formatting change as shown in Figure 4. If the Word Navigation Pane displays on the left side of the Word window, click its Close [*] button.
You have completed Skill 1 of 10
Figure 4 6 J 6 P M
C Z 3 / 2 3 1 2
Common Features Chapter 1 | Common Features of Office 2010 7
• When you open more than one Office program, each program displays in its own window.
• When you want to work with a program in a different window, you need to make it the active window.
1 . Click the Start button © , and then compare your screen with F i g u r e 1.
Your computer may be configured in such a way that you can open Office programs without opening the All Programs folder. The Office 2010 program commands may display as shortcuts in the Start menu’s pinned programs area or the recently used programs area. Your computer’s taskbar or desktop may also display icons that start each program.
2 . From the Start menu, locate and then click Microsoft Excel 2010. Depending on your computer, you may need to double-click—not single click—to launch Excel. Compare your screen with F i g u r e 2 . If necessary, click the Maximize – button mm\<
A new blank worksheet displays in a new window. The first cell—the box formed by the intersection of a row and column—is active as indicated by the thick, black border surrounding the cell. When you type in Excel, the text is entered into the active cell.
The Quick Access Toolbar displays above the spreadsheet. The Excel Ribbon has its own tabs and groups that you use to work with an Excel spreadsheet. Many of these tabs, groups, and buttons are similar to those found in Word.
On the taskbar, two buttons display—one for Word and one for Excel.
• C o n t i n u e t o t h e n e x t p a g e t o c o m p l e t e t h e s k i l l
8 C o m m o n F e a t u r e s o f O f f i c e 2 0 1 0 | C o m m o n F e a t u r e s C h a p t e r 1
Iciert * » c r l » – M l fttffrtrKci
» * * » * • l « • A* A” A J –
• i • • x . tt
C o m m a n d s
p i n n e d t o — |
S t a r t m e n u
R e c e n t l y o p e n e d A _ ; 1 r A _ Wcrosefl Accra 3)10
O f f i c e p r o g r a m
P r o g r a m s p i n n e d
t o t a s k b a r
S S l.lacxH fact) 3)10
• All Prejrjrm
F i g u r e 1
} l i AjBbCcOc A iSbCdx A a B b G A a B b C r \ fa ^B^L,
I i W ‘ i
‘ Book! – Mkrasc^fccceT
A c t i v e c e l l
N e w , b l a n k E x c e l
s p r e a d s h e e t
E x c e l b u t t o n
W o r d b u t t o n
F i g u r e 2
ciatxi • 11 • A » – J • j a i a• B « > • A • • • i * 5 6 t n – • IS atf :=4 % ^ t . a ‘ & ft | 3 – 2 ( j -il – < – V . | -A H Ccnitocn*! FomjC CfH Sort & pmd i
– 1 FonuSmg ” Ji Tietf • St,’c. • i J f o n W • ^ – f « » – S « « ! – jri^nwcftt V Huntm \ Se>*ci Cfta T”R>op4j
SKILL 2: Start Excel and PowerPoint and Work with Multiple Windows
Pm*nt«iC*J – •Acrowft PovrtfPein*
lnwrt C*i>gn Tr •niftier.; inxubero SM«SftM> P*Mn Vtew
F-‘If , « t – – . . . B y t A . « A . A f i l l M Sn1p.Hnw.9e d t u M i * . / Shoe* jSecnsn’ – » » • ; If leiefl –
O n ™ n C
J U i e u t •
Click to add title
C l i c k t o a d d s u b t i t l e
P r e s e n t a t i o n
s l i d e
P o w e r P o i n t
b u t t o n
F i g u r e 3
M a x i m i z e b u t t o n
r e p l a c e d t h e R e s t o r e
D o w n b u t t o n
T e x t i n s e r t e d i n t o
E x c e l c e l l s
C u r r e n t d a t e
c a l c u l a t e d a n d
d i s p l a y e d
W i n d o w r e s t o r e d
d o w n ( y o u r s i z e
a n d l o c a t i o n m a y
b e d i f f e r e n t )
3 . From the Start menu <PJ, locate and then click Microsoft PowerPoint 2010.
— Compare your screen with F i g u r e 3 . If necessary, Maximize N = M the Presentation 1 – Microsoft PowerPoint window.
A new, blank presentation opens in a new window. The PowerPoint window contains a slide in which you can type text. PowerPoint slides are designed to be displayed as you talk in front of a group of people.
4. In the upper right corner of the PowerPoint window, click the Close button fcgaj.
5. On the taskbar, click the Word button to make it the active window. With the insertion point flashing to the right of your name, press [Enter], and then type Skills for Success Common Features Chapter
6 . In the upper right corner of the Document 1 – Microsoft Word window, click the Minimize button
The Word window no longer displays, but its button is still available on the taskbar.
7 . With the Excel window active, in the first cell—cell A l — t y p e your first name. Press [Tab], and then type your last name.
Press (Enter), type =TODAY() and then press (Enter) to calculate the current date and to display it in the cell.
In the Excel window, click the Restore Down button |jSU and then compare your screen with F i g u r e 4.
The window remains open, but it no longer fills the entire screen. The Maximize button replaced the Restore Down button.
Y o u h a v e c o m p l e t e d S k i l l 2 o f 1 0
F i g u r e 4
C o m m o n F e a t u r e s C h a p t e r 1 | C o m m o n F e a t u r e s o f O f f i c e 2 0 1 0 9http://Sn1p.Hnw.9e
• SKILL 3: Sav<
• A new document or spreadsheet is stored in the computer ‘s temporary memory (RAM) until you save it to your hard drive or USB flash drive.
1 . If you are saving your work on a USB flash drive, insert the USB flash drive into the computer now. If the Windows Explorer button [3 flashes on the taskbar, right-click the button, and then on the Jump List, click Close window.
2 . On the taskbar, click the Word button to make it the active window. On the Quick Access Toolbar, click the Save button [y].
For new documents, the first time you click the Save button, the Save As dialog box opens so that you can name the file.
3 . If you are to save your work on a USB drive, in the Navigation pane scroll down to display the list of drives, and then click your USB flash drive as shown in F i g u r e 1 . If you are saving your work to another location, in the Navigation pane, locate and then click that folder or drive.
4. On the Save As dialog box toolbar, click the New folder button, and then immedi ately type Common Features Chapter 1
5 . Press [En te r ] to accept the folder name, and then press [En te r ] again to open the new folder as shown in F i g u r e 2 .
The new folder is created and then opened in the Save As dialog box file list.
• C o n t i n u e t o t h e n e x t p a g e t o c o m p l e t e t h e s k i l l
0 C o m m o n F e a t u r e s o f O f f i c e 2 0 1 0 | C o m m o n F e a t u r e s C h a p t e r
S a v e A s
d i a l o g b o x
U S B d r i v e
s e l e c t e d i n
N a v i g a t i o n p a n e
( y o u r s t o r a g e
d e v i c e m a y b e
d i f f e r e n t )
Ccmpu-er > USB ORJVE (Ft)
Organic ** New ‘elder
H Videoi – Manx
– Local Dirt ( C I .
Backup Drr-e (D:;
. « DVDRWOmt(fc|
_ USB DRIVE (FJ
S*ve .u type Word Document
Autfcct. Slift for Screen T i g i – d J 11*9
r> Aaaaccoc A a B b G A a B b C | f t l * d ‘
F i g u r e 1
Common Features Chapter 1 f o l d e r d i s p l a y s i n
a d d r e s s b a r
F i l e l i s t
£ M Local Ditk (C:) —
Backup Drive [0:1
t « OVDRWDnve(E: E j
AaBbCcOc A a B b C . A a B b C c
SHOSTHCI… Hiadingl Heading 2 – Change
ft had –
* M Raplati
It Sthd • Cal.ng
Authors SVLJIS lor Sue c m
~ S h e Thumbnail
– Hide Fold m
F i g u r e 2
I Page l o l l ivcroia | _v
Organize * NewJclder
£ j Videos * Nime
•4 Horn eg roup
£ , Local Disk (O) , –
Backup Drive [D;;j ‘.
0 DVORWDrrve(d £ :
A USB DRNE (*) |
Mo farm metcn j sui reirch.
DC AaBbCcDc A a B b G A a i i b C r .
No Spiu… Heading 1 Heading 2 —
M f M <
-f Select –
Save «s type I Word Document
Authors SkJI; tci Success
f_j St.-e Thumbnail
Pigeii of l : Wotdta
? f- rW’~B 101
SKILL 3: S a v e F i l e s i n N e w F o l d e r s
F i l e n a m e t y p e d
i n F i l e n a m e b o x
F i g u r e 3
F i l e n a m e s d i s p l a y
o n t i t l e b a r s
T w o s a v e d O f f i c e
d o c u m e n t s
W i n d o w s E x p l o r e r
b u t t o n Common Features Chapter 1 f o l d e r s e l e c t e d
6. In the Save As dialog box, click in the File name box one time to highlight all of the existing text.
7. With the text in the File name box still highlighted, type Lastname_Firstname_ cfOl_Visitl
– 8 . Compare your screen with F i g u r e 3 , and then click Save.
After the document is saved, the name of the file displays on the title bar at the top of the window.
9 . On the taskbar, click the Windows Explorer button \^\. In the folder window Navigation pane, open [ft] the drive on which you are saving your work, and then click the Common Features Chapter 1 folder. Verify that Lastname_Firstname_ cpl_Visitl displays in file list.
1 0 . On the taskbar, click the Excel button to make it the active window. On the Excel Quick Access Toolbar, click the Save button § ] .
1 1 . In the Save As dialog box Navigation pane, open 0 the drive where you are saving your work, and then click the Common Features Chapter 1 folder to display its file list.
The Word file may not display because the Save As box typically displays only files created by the program you are using. Here, only Excel files will typically display.
1 2 . Click in the File name box, replace the existing value with Lastname_Firstname_ cf01_Visit2 and then click the Save button.
1 3 . On the taskbar, click the Windows Explorer button, and then compare your screen with F i g u r e 4.
Y o u h a v e c o m p l e t e d S k i l l 3 o f 1 0
F i g u r e 4
C o m m o n F e a t u r e s C h a p t e r 1 | C o m m o n F e a t u r e s o f O f f i c e 2 0 1 0 1 1
• SKILL 4: Print an.
• B e f o r e p r i n t i n g , i t i s a g o o d i d e a t o w o r k
i n P a g e L a y o u t v i e w — a v i e w w h e r e y o u
p r e p a r e y o u r d o c u m e n t o r s p r e a d s h e e t
f o r p r i n t i n g .
1 . O n t h e t a s k b a r , c l i c k t h e Excel b u t t o n , a n d t h e n c l i c k t h e Maximize |Uey b u t t o n .
2 . O n t h e R i b b o n , c l i c k t h e View tab, a n d t h e n i n t h e Workbook Views group, c l i c k t h e Page Layout b u t t o n . C o m p a r e y o u r s c r e e n w i t h F i g u r e 1 .
The worksheet displays the cells, the margins, and the edges of the paper as they will be positioned when you print. The cell references—the numbers on the left side and the letters across the top of a spreadsheet that address each cell—will not print.
O n t h e R i b b o n , c l i c k t h e Page Layout tab. I n t h e Page Setup group, c l i c k t h e Margins b u t t o n , a n d t h e n i n t h e Margins g a l l e r y , c l i c k Wide.
C l i c k t h e File tab, a n d t h e n o n t h e l e f t s i d e o f t h e B a c k s t a g e , c l i c k Print. C o m p a r e y o u r s c r e e n w i t h F i g u r e 2.
* j ; A *>’
P a g e L a y o u t
b u t t o n
P a p e r e d g e s
a n d m a r g i n s
W o r k b o o k V i e w s
g r o u p
V i e w t a b i s a c t i v e
F i g u r e 1
P r i n t t a b
The Print tab has commands that affect your print job and a preview of the printed page. Here, the cell references and grid- lines—lines between the cells in a table or spreadsheet—do not display because they will not be printed.
5. I n t h e Print Settings, u n d e r Printer, n o t i c e t h e n a m e o f t h e p r i n t e r . Y o u w i l l
n e e d t o r e t r i e v e y o u r p r i n t o u t f r o m t h i s
p r i n t e r . I f y o u r i n s t r u c t o r h a s d i r e c t e d
y o u t o p r i n t t o a d i f f e r e n t p r i n t e r , c l i c k
t h e P r i n t e r a r r o w , a n d c h o o s e t h e
a s s i g n e d p r i n t e r .
• C o n t i n u e t o t h e n e x t p a g e t o c o m p l e t e t h e s k i l l ^
1 2 C o m m o n F e a t u r e s o f O f f i c e 2 0 1 0 | C o m m o n F e a t u r e s C h a p t e r 1
P r i n t s e t t i n g s
P r e v i e w o f
p r i n t e d p a g e
F i g u r e 2
_ ‘ ; Q Custom v«ws
^^^^^^^^La r tn im fF i ranam* dDl_Vi5it2 – Microsoft tico
Pig* Lij-oui Foinuisi C*ta Renew «
^ iiiinge Zoom to ieltnion
a m it Swe Stvitch Mttioi wcifc-.psce V’.inoows •
– 13 L 14
C l i c H
Ha&f i Pigr. I e l l 11 . 1 1 I K ” , – >S I
[ j j SntAi
: 4 i
Ccpier 1 “
‘ | Print Active Sheet! • — Cn!y print trie active fhett
Pages: t to
• lettei Wide Margin,
l e a left: 1 FJsra 1′
“j J No Suing Rentes the.
ClMrUIH tMh- U – / » / 0 • x j f rant
• V – A – • i • :•- s- AoBbCcCX **BbCc£x A a B b C i A a B b C c S M n
Y o u r N a m e f
S k i l l s f o r S o c c c s s – C o m m o n – F c a t u r e s C h a p t c r * ;
. i o n –
I Hseae hunt P»flt UBKM
G M M f t t M ‘ 13 • A ‘
i i ^ • / n – * . x . * – omf i Fed
M e in ,
• A . – 9 5 – , = • ‘ • – – * * H f
• a – * * a • s- A«BBCtO< AABoCtSX A a B b C A a B b C c j .
‘ Moran r no 5o»n_ HMctng 1 HMdina 2 ; Ctonjt
Y o u r – N a m e ^
‘ S k U U f o r – S u c c e s s
Heading 2 style applied
Message asks if you want to save changes
6. Check with your Course Assignment Sheet or Course Syllabus, or consult with your instructor to determine whether you are to print your work for this chapter. If you are to print your work, at the top left corner of the Print Settings section, click the Print button. If you printed the spreadsheet, retrieve the printout from the printer.
7. On the File tab, click Save.
Because you have already named the file, the Save As dialog box does not display.
O n the File tab, click Exit to close the spreadsheet and exit Excel.
In the Word document, verify that the insertion point is in the second line of text. If not, on the taskbar, click the Word button to make it the active window.
10. On the Home tab, in the Styles group, click the Heading 2 thumbnail. Compare your screen with Figure 3.
11. On the File tab, click Print to display the Print tab. If you are printing your work for this chapter, click the Print button, and then retrieve your printout from the printer.
12. On the File tab, click Exit, and then com- pare your screen with Figure 4.
When you close a window with changes that have not yet been saved, a message will remind you to save your work.
13. Read the displayed message, and then click Save.
• You hove completed Skill 4 of 10
Figure 4 C o m m o n F e a t u r e s C h a p t e r 1 | C o m m o n F e a t u r e s o f O f f i c e 2010 1 3
• This book often instructs you to open a student data file so that you do not need to start the project with a blank document.
• The student data files are located on the student CD that came with this book. Your instructor may have provided an alternate location.
• You use Save As to create a copy of the stu dent data file onto your own storage device.
1 . If necessary, insert the student CD that came with this text. If the AutoPlay dialog box displays, click Close U a 4 .
2 . Using the skills practiced earlier, start Microsoft Word 2010.
3 . In the Documentl – Microsoft Word window, click the File tab, and then click Open.
4 . In the Open dialog box Navigation pane, scroll down and then, if necessary, open \V\ Computer. In the list of drives, click the CD/DVD drive to display the contents of the student CD. If your instructor has provided a different location, navigate to that location instead of using the student CD.
5. In the file list, double-click the 01_ student_data_files folder, double-click the 01_common_features folder, and then double-click the chapter_01 folder. Compare your screen with F i g u r e 1 . –
6. In the file list, click cf01_Visit, and then click the Open button. Compare your screen with F i g u r e 2 .
If you opened the file from the student CD, the title bar indicates that the document is in read-only mode—a mode where you cannot save your changes.