Add NoteAdd Note

HighlightHighlight

CopyCopy

ZoomZoom

PrintPrint

HelpHelp

PreviousPrevious

NextNext

« Back to My CourseSmart

Exploring Microsoft® Office 2007 Volume 1, Second Edition

by Robert T. Grauer; Michelle Hulett; Cynthia Krebs; Maurie Wigman Lockley; Keith Mulbery; Judy Scheeren

eTextbook digital rental: 180 days

Our Price: $53.35

Regular Price: $133.33

You save: $79.98

Available Online Only

NOT AVAILABLE FOR PURCHASE.

View Student Resources

Free Trial

Access sample pages from your bookshelf. Take notes, highlight, print and more!

Start Free Trial

Tabs for Contents, notes, highlights

Contents
Notes
Highlights

Detailed Table of Contents

Hide Contents, Notes, and Highlights

Search TermsShow Hide

« Back to eTextbook

Copyright, iv
About the Authors, vii
Acknowledgments, xxi
Preface, xxv
Visual Walk-Through, xxix
Chapter One. Office Fundamentals: Using Word, Excel, Access, and PowerPoint, 1
Objectives, 1
Case Study: Color Theory Design, 2
Microsoft Office 2007 Software, 3
Identifying Common Interface Components, 4
Using Office 2007 Help, 10
Hands-On Exercises 1: Identifying Program Interface Components and Using Help, 12
Universal Tasks, 18
Opening a File, 18
Saving a File, 21
Printing a Document, 24
Hands-On Exercises 2: Performing Universal Tasks, 28
Basic Tasks, 31
Selecting Text to Edit, 31
Inserting Text and Changing to the Overtype Mode, 32
Moving and Copying Text, 34
Finding, Replacing, and Going to Text, 36
Using the Undo and Redo Commands, 39
Using Language Tools, 39
Applying Font Attributes, 43
Copying Formats with the Format Painter, 47
Hands-On Exercises 3: Performing Basic Tasks, 48
Summary, 53
Key Terms, 54
Multiple Choice, 55
Practice Exercises, 57
Mid-Level Exercises, 62
Capstone Exercise, 65
Mini Cases, 66
Word, 69
Chapter One. Microsoft Word: What Will Word Processing Do for Me?, 69
Objectives, 69
Case Study: A Question of Ethics, 70
Introduction to Word Processing, 71
Understanding Word Basics, 72
Using AutoText, 76
Viewing a Document, 78
Using the Mini Toolbar, 80
Hands-On Exercises 1: Introduction to Microsoft Word, 81
Document Formatting, 87
Setting Margins and Specifying Page Orientation, 87
Inserting Page Breaks, 88
Adding Page Numbers, 90
Inserting Headers and Footers, 91
Creating Sections, 92
Inserting a Cover Page, 93
Using Find and Replace Commands, 94
Hands-On Exercises 2: Document Organization, 96
The Final Touches, 103
Checking Spelling and Grammar, 103
Using Save and Backup Options, 104
Selecting Printing Options, 107
Customizing Word, 108
Hands-On Exercises 3: The Final Touches, 110
Summary, 115
Key Terms, 116
Multiple Choice, 117
Practice Exercises, 119
Mid-Level Exercises, 124
Capstone Exercise, 127
Mini Cases, 128
Chapter Two. Gaining Proficiency: Editing and Formatting, 131
Objectives, 131
Case Study: Treyserv-Pitkin Enterprises, 132
Text Formatting, 133
Applying Font Attributes Through the Font Dialog Box, 133
Highlighting Text, 136
Controlling Word Wrapping with Nonbreaking Hyphens and Nonbreaking Spaces, 137
Copying Formats with the Format Painter, 139
Hands-On Exercises 1: Character Formatting, 140
Paragraph Formats, 143
Setting Off Paragraphs with Tabs, Borders, Lists, and Columns, 143
Applying Paragraph Formats, 148
Hands-On Exercises 2: Paragraph Formatting, 152
Styles and Document References, 159
Creating and Modifying Styles, 159
Hands-On Exercises 3: Styles, 164
Table of Contents and Indexes, 171
Creating a Table of Contents, 171
Creating an Index, 171
Hands-On Exercises 4: Reference Pages, 173
Summary, 179
Key Terms, 180
Multiple Choice, 181
Practice Exercises, 183
Mid-Level Exercises, 188
Capstone Exercise, 192
Mini Cases, 193
Chapter Three. Enhancing a Document: Tables and Graphics, 195
Objectives, 195
Case Study: The Ozarks Science and Engineering Fair, 196
Tables, 197
Inserting a Table, 197
Hands-On Exercises 1: Insert a Table, 201
Advanced Table Features, 205
Formatting a Table, 205
Sorting and Applying Formulas to Table Data, 207
Converting Text to a Table, 210
Hands-On Exercises 2: Advanced Table Features, 212
Graphic Tools, 219
Inserting Clip Art and Images into a Document, 219
Formatting a Graphic Element, 220
Inserting WordArt into a Document, 225
Inserting Symbols into a Document, 226
Hands-On Exercises 3: Clip Art, WordArt, and Symbols, 227
Summary, 232
Key Terms, 232
Multiple Choice, 233
Practice Exercises, 235
Mid-Level Exercises, 241
Capstone Exercise, 245
Mini Cases, 246
Chapter Four. Share, Compare, and Document: Workgroups, Collaboration, and References, 249
Objectives, 249
Case Study: Compiling an Employee Handbook, 250
Workgroups and Collaboration, 251
Inserting Comments in a Document, 251
Tracking Changes in a Document, 254
Hands-On Exercises 1: Document Collaboration, 258
Multiple Documents, 263
Viewing Documents Side by Side, 263
Comparing and Combining Documents, 264
Creating Master Documents and Subdocuments, 265
Using Navigation Tools, 267
Hands-On Exercises 2: Document Comparison, Mergers, and Navigation, 270
Reference Resources, 277
Acknowledging a Source, 277
Creating a Bibliography, 279
Selecting a Writing Style, 280
Creating and Modifying Footnotes and Endnotes, 281
Hands-On Exercises 3: Reference Resources, 283
Additional Reference Resources, 287
Adding Figure References, 287
Inserting a Table of Figures, 288
Adding Legal References, 289
Creating Cross-References, 289
Modifying Document Properties, 290
Hands-On Exercises 4: Additional Reference Resources, 292
Summary, 295
Key Terms, 296
Multiple Choice, 297
Practice Exercises, 299
Mid-Level Exercises, 305
Capstone Exercise, 308
Mini Cases, 309
Excel, 311
Chapter One. Introduction to Excel: What Can I Do with a Spreadsheet?, 311
Objectives, 311
Case Study: Weddings by Grace, 312
Introduction to Spreadsheets, 313
Defining Worksheets and Workbooks, 314
Using Spreadsheets Across Disciplines, 314
Planning for Good Workbook and Worksheet Design, 315
Identifying Excel Window Components, 317
Entering and Editing Data in Cells, 322
Hands-On Exercises 1: Introduction to Microsoft Excel, 324
Mathematics and Formulas, 328
Describing and Using Symbols and the Order of Precedence, 328
Displaying Cell Formulas, 330
Inserting and Deleting Rows and Columns, 331
Using Cell Ranges; Excel Move; Copy, Paste, Paste Special; and AutoFill, 332
Hands-On Exercises 2: Jake's Gym Continued, 335
Workbook and Worksheet Enhancements, 340
Managing Worksheets, 340
Formatting Worksheets, 341
Hands-On Exercises 3: Formatting Jake’s Gym Worksheet, 347
Page Setup and Printing, 353
Selecting Page Setup Options for Printing, 353
Managing Cell Comments, 356
Hands-On Exercises 4: Printing Jake’s Gym Worksheet, 357
Summary, 360
Key Terms, 361
Multiple Choice, 362
Practice Exercises, 364
Mid-Level Exercises, 370
Capstone Exercise, 376
Mini Cases, 377
Chapter Two. Formulas and Functions: Math Basics for Spreadsheet Use, 379
Objectives, 379
Case Study: West Transylvania College Athletic Department, 380
Formula Basics, 381
Creating and Copying Formulas, 381
Using Relative and Absolute Cell Addresses, 382
Hands-On Exercises 1: Smithtown Hospital Radiology Department Payroll, 384
Function Basics, 387
Using AutoSum, 389
Inserting Basic Statistical Functions, 390
Using Date Functions, 392
Hands-On Exercises 2: Completing the Smithtown Hospital Radiology Department Payroll, 394
Logical and Lookup Functions, 399
Using the IF Function, 399
Using the VLOOKUP Function, 400
Hands-On Exercises 3: Athletic Department Eligibility Gradebook, 403
Financial Functions, 407
Using the PMT Function, 408
Using the FV Function, 409
Hands-On Exercises 4: Purchasing a Van for the School for Exceptional Children, 410
Summary, 412
Key Terms, 412
Multiple Choice, 413
Practice Exercises, 415
Mid-Level Exercises, 421
Capstone Exercise, 426
Mini Cases, 427
Chapter Three. Charts: Delivering a Message, 429
Objectives, 429
Case Study: The Changing Student Population, 430
A Picture Is the Message, 431
Choosing a Chart Type, 431
Creating a Chart, 438
Hands-On Exercises 1: The First Chart, 443
Chart Enhancements, 450
Modifying a Chart, 450
Enhancing Charts with Graphic Shapes, 453
Hands-On Exercises 2: Multiple Data Series, 454
Chart Distribution, 459
Embedding Charts, 459
Printing Charts, 460
Hands-On Exercises 3: Embedding, Printing, and Saving a Chart as Web Page, 462
Summary, 468
Key Terms, 468
Multiple Choice, 469
Practice Exercises, 471
Mid-Level Exercises, 477
Capstone Exercise, 482
Mini Cases, 483
Chapter Four. Working with Large Worksheets and Tables: Manipulating Worksheets and Table Management, 485
Objectives, 485
Case Study: The Spa Experts, 486
Large Worksheet Preparation, 487
Freezing Rows and Columns, 488
Hiding and Unhiding Rows, Columns, and Worksheets, 489
Protecting a Cell, a Worksheet, and a Workbook, 490
Controlling Calculation, 493
Printing Large Worksheets, 493
Hands-On Exercises 1: Marching Band Roster, 497
Excel Data Tables, 503
Exploring Basic Table Management, 505
Sorting Data, 510
Filtering and Totaling Data, 514
Hands-On Exercises 2: Marching Band Roster Revisited, 519
Summary, 527
Key Terms, 527
Multiple Choice, 528
Practice Exercises, 530
Mid-Level Exercises, 536
Capstone Exercise, 541
Mini Cases, 542
Access, 545
Chapter One. Introduction to Access: Finding Your Way through a Database, 545
Objectives, 545
Case Study: Medical Research—The Lifelong Learning Physicians Association, 546
Data and Files Everywhere!, 547
Exploring, Describing, and Navigating Among the Objects in an Access Database, 547
Understanding the Difference Between Working in Storage and Memory, 554
Practicing Good File Management, 555
Backing up, Compacting, and Repairing Access Files, 556
Hands-On Exercises 1: Introduction to Databases, 557
Filters, Sorts, and Access Versus Excel, 565
Creating Filters, 565
Sorting Table Data on One or More Fields, 568
Knowing When to Use Access or Excel to Manage Data, 570
Hands-On Exercises 2: Data Manipulation: Filters and Sorts, 572
The Relational Database, 578
Using the Relationship Window, 578
Understanding Relational Power, 579
Hands-On Exercises 3: Introduction to Relationships, 581
Summary, 587
Key Terms, 588
Multiple Choice, 589
Practice Exercises, 591
Mid-Level Exercises, 597
Capstone Exercise, 601
Mini Cases, 602
Chapter Two. Relational Databases and Multi-Table Queries: Designing Databases and Using Related Data, 605
Objectives, 605
Case Study: National Conference, 606
Table Design, Properties, Views, and Wizards, 607
Designing Data, 607
Creating Tables, 612
Hands-On Exercises 1: Table Design, Properties, Views, and Wizards, 618
Multiple Table Database, 625
Understanding Table Relationships, 625
Sharing Data with Excel, 626
Establishing Table Relationships, 630
Hands-On Exercises 2: Imports and Relationships, 635
Queries, 642
Creating a Query, 642
Specifying Criteria for Different Data Types, 645
Copying and Running a Query, 649
Using the Query Wizard, 649
Understanding Large Database Differences, 653
Hands-On Exercises 3: Multiple-Table Query, 654
Summary, 659
Key Terms, 660
Multiple Choice, 661
Practice Exercises, 663
Mid-Level Exercises, 670
Capstone Exercise, 674
Mini Cases, 675
Chapter Three. Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions, 677
Objectives, 677
Case Study: Replacements, Ltd., 678
Data Summary and Analysis, 679
Understanding the Order of Precedence, 679
Creating a Calculated Field in a Query, 679
Hands-On Exercises 1: Calculated Query Fields, 683
Expression Builder, 689
Creating Expressions with the Expression Builder, 689
Creating and Editing Access Functions, 690
Performing Date Arithmetic, 694
Hands-On Exercises 2: Expression Builder, Functions, and Date Arithmetic, 695
Data Aggregates, 704
Creating and Working with Data Aggregates, 704
Hands-On Exercises 3: Data Aggregates, 707
Summary, 712
Key Terms, 712
Multiple Choice, 713
Practice Exercises, 715
Mid-Level Exercises, 721
Capstone Exercise, 725
Mini Cases, 726
Chapter Four. Create, Edit, and Perform Calculations in Reports: Creating Professional and Useful Reports, 729
Objectives, 729
Case Study: Northwind Traders, 730
Appearances Matter, 731
Planning a Report, 731
Using Different Report Views, 733
Create and Edit a Report, 737
Hands-On Exercises 1: Introduction to Access Reports, 739
The Anatomy of a Report, 747
Identifying Report Elements, Sections, and Controls, 747
Adding Grouping Levels in Layout View, 750
Adding Fields to a Report, 755
Hands-On Exercises 2: Create, Sort, Edit, Nest, and Remove Groups from Reports, 757
The Report and Label Wizards, 764
Using the Report Wizard, 765
Hands-On Exercises 3: Report Wizard, 770
Summary, 775
Key Terms, 776
Multiple Choice, 777
Practice Exercises, 779
Mid-Level Exercises, 785
Capstone Exercise, 789
Mini Cases, 791
PowerPoint, 793
Chapter One. Introduction to PowerPoint: Presentations Made Easy, 793
Objectives, 793
Case Study: Be a Volunteer, 794
Introduction to PowerPoint, 795
Identifying PowerPoint User Interface Elements, 799
User PowerPoint Views, 804
Opening and Saving a Slide Show, 809
Getting Help, 812
Hands-On Exercises 1: Introduction to PowerPoint, 813
Presentation Creation, 817
Creating a Storyboard, 817
Using Slide Layouts, 820
Applying Design Themes, 820
Reviewing the Presentation, 822
Hands-On Exercises 2: Creating a Presentation, 823
Presentation Development, 829
Adding a Table, 829
Inserting Clip Art, 829
Using Transitions and Animations, 831
Hands-On Exercises 3: Strengthening a Presentation, 834
Navigation and Printing, 840
Running and Navigating a Slide Show, 840
Printing with PowerPoint, 842
Hands-On Exercises 4: Navigating and Printing, 845
Summary, 847
Key Terms, 848
Multiple Choice, 849
Practice Exercises, 851
Mid-Level Exercises, 857
Capstone Exercise, 861
Mini Cases, 863
Chapter Two. Presentation Development: Planning and Preparing a Presentation, 867
Objectives, 867
Case Study: Go Back in Time, 868
Templates, 869
Creating a Presentation Using a Template, 869
Modifying a Template, 871
Hands-On Exercises 1: Using a Template, 874
Outlines, 879
Creating a Presentation in Outline View, 879
Modifying an Outline Structure, 881
Printing an Outline, 882
Hands-On Exercises 2: Creating and Modifying an Outline, 883
Data Imports, 887
Importing an Outline, 887
Adding Existing Content to a Presentation, 888
Hands-On Exercises 3: Importing an Outline and Reusing Slides, 890
Design, 892
Examining Slide Show Design Principles, 892
Applying and Modifying a Design Theme, 892
Inserting a Header or Footer, 896
Hands-On Exercises 4: Applying and Modifying a Design Theme, 899
Summary, 908
Key Terms, 909
Multiple Choice, 910
Practice Exercises, 912
Mid-Level Exercises, 918
Capstone Exercise, 925
Mini Cases, 926
Chapter Three. Presentation Design: Enhancing with Illustrations, 929
Objectives, 929
Case Study: The Kelso Performing Arts Center, 930
Shapes, 931
Creating Shapes, 931
Applying Quick Styles and Customizing Shapes, 936
Hands-On Exercises 1: Working with Shapes, 944
SmartArt, 952
Creating SmartArt, 952
Modifying SmartArt Diagrams, 955
WordArt, 960
Creating WordArt, 961
Modifying WordArt, 961
Hands-On Exercises 2: Working with SmartArt and WordArt, 963
Object Manipulation, 968
Modifying Objects, 968
Arranging Objects, 975
Hands-On Exercises 3: Modifying and Arranging Clip Art, 980
Summary, 988
Key Terms, 988
Multiple Choice, 989
Practice Exercises, 991
Mid-Level Exercises, 997
Capstone Exercise, 1004
Mini Cases, 1006
Chapter Four. PowerPoint Multimedia Tools: Enhancing with Multimedia, 1011
Objectives, 1011
Case Study: Forensics Geology Class Album, 1012
Pictures, 1013
Inserting and Modifying a Picture, 1015
Using the Internet as a Resource, 1021
Hands-On Exercises 1: Using Pictures, 1026
Photo Albums, 1033
Creating a Photo Album, 1033
Setting Photo Album Options, 1033
Hands-On Exercises 2: Creating a Photo Album, 1035
Movies, 1038
Inserting Movies, 1038
Setting Movie Options, 1040
Hands-On Exercises 3: Inserting a Movie, 1042
Sound, 1045
Adding Sound, 1046
Recording and Playing Narration, 1048
Hands-On Exercises 4: Adding Sound, 1051
Summary, 1053
Key Terms, 1053
Multiple Choice, 1054
Practice Exercises, 1056
Mid-Level Exercises, 1062
Capstone Exercise, 1070
Mini Cases, 1073
Windows Vista: Getting Started with Windows Vista, 1077
Objectives, 1077
Case Study, 1078
Basics of Windows Vista, 1079
Describing Windows Vista Versions and Features, 1079
Identify Components of the Windows Vista Interface, 1080
Explore the Desktop, 1080
Display the Windows Sidebar, 1081
Customize the Desktop, 1082
Work with the Taskbar, 1082
Identify Components on the Start Menu, 1084
Working with Windows and Dialog Boxes, 1087
Understand Windows Components, 1087
Open, Size, and Move Windows, 1088
Stack and Cascade Open Windows, 1089
Select Options in Dialog Boxes, 1090
Using Help and Support, 1091
Hands-On Exercises 1: Working with Windows, 1095
Files and Folders, 1099
Managing Files and Folders in Windows Explorer, 1100
Creating, Renaming, and Deleting Folders, 1102
Create Folders, 1102
Rename Folders, 1104
Delete Folders, 1104
Working with Files, 1105
Add Metadata to Files, 1105
Save Files, 1106
Selecting, Copying, and Moving Multiple Files and Folders, 1106
Select Multiple Files and Folders, 1107
Copy and Move Files and Folders, 1108
Hands-On Exercises 2: Working with Files and Folders, 1109
Windows Resources: Search, Recycle Bin, and Control Panel, 1114
Using Windows Search, 1114
Apply Advanced Filters, 1115
Save Searches, 1116
Managing the Recycle Bin, 1117
Changing Computer Settings Through the Control Panel, 1118
Change the Background, 1119
Select a Screen Saver, 1120
Check System Settings, 1121
Install and Uninstall Programs, 1121
Manage the Mouse and Printers, 1122
Create and Manage User Accounts, 1123
Explore Security Settings, 1124
Hands-On Exercises 3: Working with the Recycle Bin, Windows Search, and Control Panel, 1126
Summary, 1130
Key Terms, 1131
Multiple Choice, 1132
Practice Exercises, 1134
Mid-Level Exercises, 1138
Mini Cases, 1140
Capstone Exercises: Using Office in the Legal Profession, Health Care, the Arts, and Hospitality, 1143
Legal, 1145
Word, 1145
Excel, 1149
Access, 1155
PowerPoint, 1161
Integrated, 1167
Health Care, 1173
Word, 1173
Excel, 1178
Access, 1183
PowerPoint, 1189
Integrated, 1193
Arts, 1195
Word, 1195
Excel, 1199
Access, 1203
PowerPoint, 1208
Integrated, 1212
Hospitality, 1215
Word, 1215
Excel, 1220
Access, 1224
PowerPoint, 1229
Integrated, 1233
Glossary, 1237
Multiple Choice Answer Keys, 1247
Index, 1251
Endpaper, EP-1

Search Results

« Back to eTextbook


PAGE	Description

96	...