Tabs for Contents, notes, highlights

Hide Contents, Notes, and Highlights

Search TermsShow Hide

« Back to eTextbook

Copyright, ii
Word 2007, 1
Chapter 5. Creating Documents with Microsoft Word 2007, 1
Project 5A: Application Letter, 3
Objective 1: Create and Save a New Document, 3
Activity 5.01: Starting Word and Identifying Parts of the Word Window, 4
Activity 5.02: Beginning a New Document and Displaying Formatting Marks, 5
Activity 5.03: Entering Text and Inserting Blank Lines, 6
Activity 5.04: Creating Folders for Document Storage and Saving a Document, 9
Objective 2: Edit Text, 15
Activity 5.05: Editing Text with the Delete and Backspace Keys, 15
Activity 5.06: Inserting New Text, 17
Objective 3: Select, Delete, and Format Text, 18
Activity 5.07: Selecting and Deleting Text, 18
Activity 5.08: Changing Font and Font Size, 21
Activity 5.09: Adding Emphasis to Text, 23
Objective 4: Print a Document, 25
Activity 5.10: Accessing Headers and Footers, 25
Activity 5.11: Printing a Document, 27
Project 5B: Company Overview, 29
Objective 5: Navigate the Word Window, 30
Activity 5.12: Opening and Closing an Existing Document, 30
Activity 5.13: Inserting Existing Text into a New Document, 30
Activity 5.14: Navigating a Document, 33
Activity 5.15: Changing Document Views, 35
Activity 5.16: Using the Zoom Slider, 36
Activity 5.17: Splitting Windows and Arranging Panes, 38
Objective 6: Add a Graphic to a Document, 40
Activity 5.18: Inserting Clip Art, 40
Objective 7: Use the Spelling and Grammar Checker, 43
Activity 5.19: Checking Individual Spelling and Grammar Errors, 43
Activity 5.20: Checking Spelling and Grammar in an Entire Document, 45
Objective 8: Preview and Print Documents, Close a Document, and Close Word, 48
Activity 5.21: Previewing and Printing a Document, 48
Activity 5.22: Closing a Document and Closing Word, 51
Objective 9: Use the Microsoft Help System, 51
Activity 5.23: Getting Help, 51
There’s More You Can Do!, 53
Summary, 54
Key Terms, 54
Matching, 55
Fill in the Blank, 56
Skills Review, 57
Mastering Word, 63
Business Running Case, 73
Rubric, 75
Problem Solving, 76
You and GO!, 82
GO! with Help, 82
Group Business Running Case, 83
Chapter 6. Formatting and Organizing Text, 85
Project 6A: Seminar, 87
Objective 1: Change Document and Paragraph Layout, 88
Activity 6.01: Setting Margins, 88
Activity 6.02: Aligning Text, 90
Activity 6.03: Changing Line Spacing, 92
Activity 6.04: Adding Space After Paragraphs, 94
Activity 6.05: Using the Format Painter, 96
Objective 2: Change and Reorganize Text, 98
Activity 6.06: Finding and Replacing Text, 99
Activity 6.07: Cutting, Copying, and Pasting Text, 101
Activity 6.08: Moving Text to a New Location, 103
Activity 6.09: Undoing and Redoing Changes, 105
Activity 6.10: Inserting Nonbreaking Spaces and Hyphens, 106
Activity 6.11: Entering a Line Break, 108
Objective 3: Create and Modify Lists, 109
Activity 6.12: Creating a Bulleted List, 109
Activity 6.13: Using AutoFormat to Create a Numbered List, 110
Activity 6.14: Formatting Lists, 113
Activity 6.15: Customizing Bullets, 115
Project 6B: Law Overview, 118
Objective 4: Insert and Format Headers and Footers, 119
Activity 6.16: Inserting and Formatting Page Numbers, 119
Activity 6.17: Inserting the Current Date and Time, 122
Objective 5: Insert Frequently Used Text, 123
Activity 6.18: Recording AutoCorrect Entries, 123
Activity 6.19: Inserting Symbols, 126
Objective 6: Insert and Format References, 128
Activity 6.20: Inserting Footnotes, 128
Activity 6.21: Modifying a Footnote Style, 130
Activity 6.22: Adding Citations, 133
Activity 6.23: Creating a Reference Page, 137
Activity 6.24: Managing Document Properties, 138
There’s More You Can Do!, 139
Summary, 140
Key Terms, 140
Matching, 141
Fill in the Blank, 142
Skills Review, 143
Mastering Word, 151
Business Running Case, 163
Rubric, 165
Problem Solving, 166
You and GO!, 171
GO! with Help, 171
Group Business Running Case, 172
Chapter 7. Using Graphics and Tables, 173
Project 7A: Photography Flyer, 175
Objective 1: Insert and Format Graphics, 176
Activity 7.01: Formatting Text Using WordArt, 176
Activity 7.02: Inserting Pictures from Files, 178
Activity 7.03: Resizing a Graphic, 179
Activity 7.04: Wrapping Text Around a Graphic, 181
Activity 7.05: Moving a Graphic, 183
Activity 7.06: Applying Picture Styles, 184
Activity 7.07: Adding a Page Border, 186
Objective 2: Set Tab Stops, 187
Activity 7.08: Setting Tab Stops and Using Click and Type, 187
Activity 7.09: Formatting and Removing Tab Stops, 191
Activity 7.10: Using Tab Stops to Enter Text, 193
Activity 7.11: Moving Tab Stops, 195
Objective 3: Insert and Modify Text Boxes and Shapes, 196
Activity 7.12: Inserting a Text Box, 197
Activity 7.13: Moving, Resizing, and Formatting a Text Box, 198
Activity 7.14: Inserting a Predefined Shape, 200
Project 7B: Price List, 203
Objective 4: Create a Table, 204
Activity 7.15: Creating and Entering Text into a Table, 204
Activity 7.16: Adding a Row to a Table, 206
Activity 7.17: Changing the Width of a Table Column, 207
Activity 7.18: Adding a Column to a Table, 208
Activity 7.19: Converting Text to Tables, 210
Objective 5: Format a Table, 212
Activity 7.20: Formatting Text in Cells and Shading Cells, 212
Activity 7.21: Changing the Table Border, 215
Activity 7.22: Centering a Table, 217
Activity 7.23: Merging Cells, 218
Activity 7.24: Applying a Predefined Format to a Table, 219
There’s More You Can Do!, 221
Summary, 222
Key Terms, 222
Matching, 223
Fill in the Blank, 224
Skills Review, 225
Mastering Word, 233
Business Running Case, 247
Rubric, 250
Problem Solving, 251
You and GO!, 257
GO! with Help, 257
Group Business Running Case, 258
Chapter 8. Special Document Formats, Columns, and Mail Merge, 259
Project 8A: Garden Newsletter, 261
Objective 1: Collect and Paste Text and Graphics, 262
Activity 8.01: Using Collect and Paste to Gather Images and Text, 262
Activity 8.02: Pasting Information from the Clipboard Task Pane, 265
Objective 2: Create and Format Columns, 266
Activity 8.03: Changing One Column of Text to Two Columns, 266
Activity 8.04: Formatting Multiple Columns, 267
Activity 8.05: Inserting a Column Break, 268
Activity 8.06: Adding Graphics to Columns, 270
Objective 3: Use Special Character and Paragraph Formatting, 271
Activity 8.07: Using Small Caps and Changing the Font Color, 272
Activity 8.08: Adding a Border and Shading to a Paragraph, 273
Objective 4: Create Mailing Labels Using Mail Merge, 275
Activity 8.09: Opening the Mail Merge Wizard Template, 275
Activity 8.10: Completing the Mail Merge Wizard, 279
Activity 8.11: Previewing and Printing the Mail Merge Document, 283
Project 8B: Television Hosts, 285
Objective 5: Insert Hyperlinks, 286
Activity 8.12: Inserting Text Hyperlinks, 286
Activity 8.13: Adding a Hyperlink to a Graphic, 288
Activity 8.14: Testing and Modifying Hyperlinks, 289
Objective 6: Insert a SmartArt Graphic, 290
Activity 8.15: Inserting a SmartArt Graphic, 291
Activity 8.16: Adding Text to a SmartArt Graphic, 292
Objective 7: Preview and Save a Document as a Web Page, 294
Activity 8.17: Previewing a Document as a Web Page, 295
Activity 8.18: Saving a Document as a Web Page, 296
There’s More You Can Do!, 299
Summary, 300
Key Terms, 300
Matching, 301
Fill in the Blank, 302
Skills Review, 303
Mastering Word, 310
Business Running Case, 322
Rubric, 325
Problem Solving, 326
You and GO!, 331
GO! with Help, 331
Group Business Running Case, 332
Excel 2007, 333
Chapter 9. Creating a Worksheet and Charting Data, 333
Project 9A: Auto Sales, 335
Objective 1: Create, Save, and Navigate an Excel Workbook, 336
Activity 9.01: Starting Excel and Naming and Saving a Workbook, 336
Activity 9.02: Navigating a Worksheet and a Workbook, 339
Activity 9.03: Selecting Parts of a Worksheet, 342
Objective 2: Enter and Edit Data in a Worksheet, 345
Activity 9.04: Entering Text, Using AutoComplete, Filling a Series with Auto Fill, and Using Spelling Checker and Undo to Correct Typing Errors, 345
Activity 9.05: Aligning Text and Adjusting the Size of Columns and Rows, 351
Activity 9.06: Entering Numbers, 352
Activity 9.07: Inserting and Deleting Rows and Columns, and Using the Insert Options Button, 355
Objective 3: Construct and Copy Formulas, Use the Sum Function, and Edit Cells, 357
Activity 9.08: Constructing a Formula, Using the Sum Function, and Editing Numbers in Cells, 358
Activity 9.09: Copying a Formula by Using the Fill Handle, 362
Objective 4: Format Data, Cells, and Worksheets, 364
Activity 9.10: Formatting Financial Numbers, Using Column AutoFit, and Using Format Painter, 364
Activity 9.11: Formatting Text and Using Merge and Center, 370
Objective 5: Close and Reopen a Workbook, 373
Activity 9.12: Closing and Reopening an Existing Workbook, 373
Objective 6: Chart Data, 373
Activity 9.13: Charting Data, 373
Objective 7: Use Page Layout View, Prepare a Worksheet for Printing, and Close Excel, 382
Activity 9.14: Changing Views, Creating a Footer, and Using Print Preview, 383
Activity 9.15: Deleting Unused Sheets in a Workbook, 386
Activity 9.16: Printing a Worksheet, 386
Activity 9.17: Displaying, Printing, and Hiding Formulas, 387
Project 9B: Safety Shop, 389
Objective 8: Design a Worksheet, 390
Activity 9.18: Setting Column Widths and Creating Row and Column Titles, 390
Activity 9.19: Entering Data by Range, 392
Objective 9: Construct Formulas for Mathematical Operations, 393
Activity 9.20: Using Arithmetic Operators, 394
Activity 9.21: Copying Formulas Containing Absolute Cell References, 394
Objective 10: Format Percentages and Move Formulas, 398
Activity 9.22: Formatting Cells with the Percent Style Button, 398
Activity 9.23: Inserting Rows in a Worksheet Containing Formulas and Wrapping Text in a Cell, 399
Objective 11: Create a Pie Chart and a Chart Sheet, 401
Activity 9.24: Creating a Pie Chart and a Chart Sheet, 402
Objective 12: Use the Excel Help System, 404
Activity 9.25: Using the Excel Help System, 404
There’s More You Can Do!, 404
Summary, 405
Key Terms, 405
Matching, 407
Fill in the Blank, 408
Skills Review, 410
Mastering Excel, 418
Business Running Case, 433
Rubric, 436
Problem Solving, 437
You and GO!, 442
GO! with Help, 442
Group Business Running Case, 443
Chapter 10. Managing Workbooks and Analyzing Data, 445
Project 10A: Ticket Sales, 447
Objective 1: Create and Save a Workbook from an Existing Workbook, 448
Activity 10.01: Creating and Saving a Workbook from an Existing Workbook, 448
Objective 2: Navigate a Workbook and Rename Worksheets, 448
Activity 10.02: Navigating Among Worksheets, Renaming Worksheets, and Changing the Tab Color of a Worksheet, 449
Objective 3: Enter Dates, Clear Contents, and Clear Formats, 450
Activity 10.03: Entering and Formatting Dates, 451
Activity 10.04: Clearing Cell Contents and Formats, 453
Objective 4: Move, Copy, and Paste Cell Contents, 454
Activity 10.05: Copying, Pasting, and Moving Cell Contents, 454
Objective 5: Edit and Format Multiple Worksheets at the Same Time, 457
Activity 10.06: Wrapping Text in a Cell in Several Worksheets at the Same Time, 457
Activity 10.07: Entering Data and Constructing Formulas on Multiple Worksheets, 460
Objective 6: Create a Summary Sheet, 468
Activity 10.08: Constructing Formulas that Refer to Cells in Another Worksheet, 468
Objective 7: Format and Print Multiple Worksheets in a Workbook, 471
Activity 10.09: Moving and Formatting Worksheets in a Workbook, 471
Activity 10.10: Printing All the Worksheets in a Workbook, 473
Project 10B: Growth Projection, 475
Objective 8: Design a Worksheet for What-If Analysis, 476
Activity 10.11: Using Parentheses in a Formula, 476
Activity 10.12: Formatting as You Type, 479
Activity 10.13: Calculating a Value After an Increase, 481
Objective 9: Perform What-If Analysis, 483
Activity 10.14: Performing What-If Analysis and Using Paste Special, 483
Objective 10: Compare Data with a Line Chart, 486
Activity 10.15: Creating a Line Chart, 486
There’s More You Can Do!, 492
Summary, 493
Key Terms, 493
Matching, 494
Fill in the Blank, 495
Skills Review, 496
Mastering Excel, 504
Business Running Case, 518
Rubric, 521
Problem Solving, 522
You and GO!, 527
GO! with Help, 527
Group Business Running Case, 528
Chapter 11. Using Functions and Tables, 529
Project 11A: Milan Inventory, 531
Objective 1: Use SUM, AVERAGE, MEDIAN, MIN, and MAX Functions, 532
Activity 11.01: Using the SUM, AVERAGE, and MEDIAN Functions, 532
Activity 11.02: Using the MIN and MAX Functions, 537
Activity 11.03: Moving Data, Adding Borders, and Rotating Text, 538
Objective 2: Use COUNTIF and IF Functions, and Apply Conditional Formatting, 541
Activity 11.04: Using the COUNTIF Function, 541
Activity 11.05: Using the IF Function and Applying Conditional Formatting, 542
Activity 11.06: Applying Conditional Formatting Using Custom Formats and Data Bars, 545
Activity 11.07: Using Find and Replace, 547
Objective 3: Use a Date Function, 548
Activity 11.08: Using the NOW Function, 548
Objective 4: Freeze Panes and Create an Excel Table, 550
Activity 11.09: Freezing and Unfreezing Panes, 550
Activity 11.10: Sorting and Filtering in an Excel Table, 551
Activity 11.11: Inserting a Second Table in a Worksheet, 555
Activity 11.12: Converting a Table to a Range of Data, 557
Objective 5: Format and Print a Large Worksheet, 558
Activity 11.13: Printing Large Worksheets, 558
Project 11B: Loan Payment, 561
Objective 6: Use Financial Functions, 562
Activity 11.14: Designing a Loan Worksheet, 562
Activity 11.15: Inserting the PMT Financial Function, 563
Objective 7: Use Goal Seek, 566
Activity 11.16: Using Goal Seek to Produce the Desired Result, 566
Activity 11.17: Using Goal Seek to Find an Increased Period, 568
Objective 8: Create a Data Table, 570
Activity 11.18: Designing a Two-Variable Data Table, 570
Activity 11.19: Using a Data Table to Calculate Options, 572
There’s More You Can Do!, 576
Summary, 577
Key Terms, 577
Matching, 578
Fill in the Blank, 579
Skills Review, 581
Mastering Excel, 589
Business Running Case, 603
Rubric, 606
Problem Solving, 607
You and GO!, 612
GO! with Help, 612
Group Business Running Case, 613
Access 2007, 615
Chapter 12. Getting Started with Access Databases and Tables, 615
Project 12A: Doctor and Patient Contact Information, 617
Objective 1: Start Access and Create a New Blank Database, 618
Activity 12.01: Starting Access, Creating and Naming a Folder, and Creating a Database from a New Blank Database, 618
Objective 2: Add Records to a Table, 623
Activity 12.02: Adding Records to a Table, 624
Objective 3: Rename Table Fields in Datasheet View, 627
Activity 12.03: Renaming the Fields in a Table in Datasheet View, 627
Activity 12.04: Changing the Data Type of a Field in Datasheet View, 629
Objective 4: Modify the Design of a Table, 634
Activity 12.05: Deleting a Field in Design View, 634
Activity 12.06: Modifying a Field Size and Description in Design View, 636
Activity 12.07: Setting a Primary Key and Saving a Table, 637
Objective 5: Add a Second Table to a Database, 638
Activity 12.08: Adding a Second Table to a Database, 638
Activity 12.09: Adding Records to a Second Table, 641
Objective 6: Print a Table, 642
Activity 12.10: Adjusting Column Widths and Printing a Table, 642
Objective 7: Create and Use a Query, 648
Activity 12.11: Using the Simple Query Wizard to Create a Query, 648
Objective 8: Create and Use a Form, 651
Activity 12.12: Creating a Form, 652
Objective 9: Create and Print a Report, 654
Activity 12.13: Creating and Printing a Report, 654
Objective 10: Close and Save a Database, 656
Activity 12.14: Closing and Saving a Database, 656
Project 12B: Health Seminars, 657
Objective 11: Create a Database Using a Template, 658
Activity 12.15: Creating a New Database Using a Template, 658
Activity 12.16: Building a Table by Entering Records in a Multiple Items Form, 660
Objective 12: Organize Database Objects in the Navigation Pane, 662
Activity 12.17: Organizing Database Objects in the Navigation Pane, 663
Objective 13: Create a New Table in a Database Created with a Template, 665
Activity 12.18: Creating a New Table and Changing Its Design, 666
Objective 14: View a Report and Print a Table in a Database Created with a Template, 669
Activity 12.19: Viewing a Report, 669
Activity 12.20: Printing a Table, 670
Objective 15: Use the Access Help System, 671
Activity 12.21: Using the Access Help System, 671
There’s More You Can Do!, 672
Summary, 673
Key Terms, 673
Matching, 674
Fill in the Blank, 675
Skills Review, 676
Mastering Access, 685
Business Running Case, 701
Rubric, 703
Problem Solving, 704
You and GO!, 709
GO! with Help, 709
Group Business Running Case, 710
Chapter 13. Sort and Query a Database, 711
Project 13A: Instructors and Courses, 713
Objective 1: Open an Existing Database, 714
Activity 13.01: Renaming and Opening an Existing Database, 714
Activity 13.02: Opening an Existing Database and Resolving Security Alerts, 715
Objective 2: Create Table Relationships, 716
Activity 13.03: Creating Table Relationships and Enforcing Referential Integrity, 717
Activity 13.04: Printing a Relationship Report, 721
Objective 3: Sort Records in a Table, 723
Activity 13.05: Sorting Records in a Table in Ascending or Descending Order, 724
Activity 13.06: Sorting Records in a Table on Multiple Fields, 725
Objective 4: Create a Query in Design View, 726
Activity 13.07: Creating a New Select Query in Design View, 726
Activity 13.08: Running, Saving, Printing, and Closing a Query, 730
Objective 5: Create a New Query from an Existing Query, 732
Activity 13.09: Creating a New Query From an Existing Query, 732
Objective 6: Sort Query Results, 735
Activity 13.10: Sorting Query Results, 735
Objective 7: Specify Criteria in a Query, 738
Activity 13.11: Specifying Text Criteria in a Query, 738
Activity 13.12: Specifying Criteria Using a Field Not Displayed in the Query Result, 740
Activity 13.13: Using Is Null Criteria to Find Empty Fields, 743
Project 13B: Athletes and Scholarships, 746
Objective 8: Create a New Table by Importing an Excel Spreadsheet, 747
Activity 13.14: Opening an Existing Database and Preparing to Import an Excel Spreadsheet, 747
Activity 13.15: Creating a New Table by Importing an Excel Spreadsheet, 749
Objective 9: Specify Numeric Criteria in a Query, 753
Activity 13.16: Specifying Numeric Criteria in a Query, 753
Activity 13.17: Using Comparison Operators, 755
Activity 13.18: Using the Between . . . And Comparison Operator, 757
Objective 10: Use Compound Criteria, 759
Activity 13.19: Using AND Criteria in a Query, 759
Activity 13.20: Using OR Criteria in a Query, 760
Objective 11: Create a Query Based on More Than One Table, 762
Activity 13.21: Creating a Query Based on More Than One Table, 762
Objective 12: Use Wildcards in a Query, 766
Activity 13.22: Using a Wildcard in a Query, 766
Objective 13: Use Calculated Fields in a Query, 768
Activity 13.23: Using Calculated Fields in a Query, 768
Objective 14: Group Data and Calculate Statistics in a Query, 772
Activity 13.24: Using the MIN, MAX, AVG and SUM Functions in a Query, 772
Activity 13.25: Grouping Data in a Query, 774
There’s More You Can Do!, 777
Summary, 778
Key Terms, 778
Matching, 779
Fill in the Blank, 780
Skills Review, 781
Mastering Access, 791
Business Running Case, 805
Rubric, 807
Problem Solving, 808
You and GO!, 813
GO! with Help, 813
Group Business Running Case, 814
Chapter 14. Forms, Filters, and Reports, 815
Project 14A: Candidate Interviews, 817
Objective 1: Create a Form, 818
Activity 14.01: Creating a Form, 818
Objective 2: Use a Form to Add and Delete Records, 821
Activity 14.02: Adding Records to a Table by Using a Form, 821
Activity 14.03: Deleting Records from a Table by Using a Form, 823
Activity 14.04: Printing a Form, 825
Objective 3: Create a Form by Using the Form Wizard, 826
Activity 14.05: Creating a Form by Using the Form Wizard, 826
Objective 4: Modify a Form in Design View and in Layout View, 828
Activity 14.06: Modifying a Form in Design View, 828
Activity 14.07: Adding, Resizing, and Moving Controls in Layout View, 832
Activity 14.08: Formatting and Aligning Controls in Layout View, 836
Objective 5: Filter Records, 839
Activity 14.09: Filtering Data by Selection on One Field, 840
Activity 14.10: Using Filter by Form, 841
Project 14B: Employers and Job Openings, 846
Objective 6: Create a Report by Using the Report Tool, 847
Activity 14.11: Creating and Modifying a Report Using the Report Tool and Layout View, 847
Objective 7: Create a Report by Using the Blank Report Tool, 851
Activity 14.12: Creating a Report by Using the Blank Report Tool, 851
Objective 8: Create a Report by Using the Report Wizard, 854
Activity 14.13: Creating a Report by Using the Report Wizard, 855
Objective 9: Modify the Design of a Report, 858
Activity 14.14: Modifying a Report in Layout View, 858
Activity 14.15: Modifying a Report in Design View, 864
Objective 10: Print a Report and Keep Data Together, 867
Activity 14.16: Keeping Data Together and Printing a Report, 867
There’s More You Can Do!, 870
Summary, 871
Key Terms, 871
Matching, 872
Fill in the Blank, 873
Skills Review, 875
Mastering Access, 885
Business Running Case, 903
Rubric, 906
Problem Solving, 907
You and GO!, 912
GO! with Help, 912
Group Business Running Case, 913
PowerPoint 2007, 915
Chapter 15. Getting Started with Microsoft PowerPoint 2007, 915
Project 15A: Expansion, 917
Objective 1: Open, View, and Save a Presentation, 918
Activity 15.01: Starting PowerPoint and Identifying Parts of the PowerPoint Window, 918
Activity 15.02: Opening a Presentation, 920
Activity 15.03: Viewing a Slide Show, 922
Activity 15.04: Creating Folders and Saving a Presentation, 923
Objective 2: Edit a Presentation, 925
Activity 15.05: Editing Slide Text, 925
Activity 15.06: Inserting a New Slide, 926
Activity 15.07: Increasing and Decreasing List Levels, 928
Activity 15.08: Checking Spelling, 930
Activity 15.09: Editing Text by Using the Thesaurus, 932
Activity 15.10: Adding Speaker’s Notes to a Presentation, 933
Objective 3: Format a Presentation, 934
Activity 15.11: Changing Font and Font Size, 934
Activity 15.12: Applying Font Styles, 936
Activity 15.13: Aligning Text and Changing Line Spacing, 937
Activity 15.14: Modifying Slide Layout, 938
Activity 15.15: Changing the Presentation Theme, 939
Objective 4: Create Headers and Footers and Print a Presentation, 941
Activity 15.16: Creating Headers and Footers, 942
Activity 15.17: Previewing and Printing a Presentation and Closing PowerPoint, 943
Project 15B: Overview, 946
Objective 5: Create a New Presentation, 947
Activity 15.18: Starting a New Presentation, 947
Activity 15.19: Inserting Slides from an Existing Presentation, 950
Objective 6: Use Slide Sorter View, 952
Activity 15.20: Selecting and Deleting Slides, 952
Activity 15.21: Moving Slides, 953
Objective 7: Add Pictures to a Presentation, 953
Activity 15.22: Inserting Clip Art, 954
Activity 15.23: Moving and Sizing Images, 956
Activity 15.24: Applying a Style to a Picture, 958
Objective 8: Use the Microsoft Help System, 959
Activity 15.25: Accessing PowerPoint Help, 959
There’s More You Can Do!, 960
Summary, 961
Key Terms, 961
Matching, 962
Fill in the Blank, 963
Skills Review, 964
Mastering PowerPoint, 971
Business Running Case, 982
Rubric, 984
Problem Solving, 985
You and GO!, 990
GO! with Help, 990
Group Business Running Case, 991
Chapter 16. Designing a PowerPoint Presentation, 993
Project 16A: Welcome, 995
Objective 1: Format Slide Elements, 996
Activity 16.01: Selecting Placeholder Text and Using the Repeat Key, 996
Activity 16.02: Changing a Bulleted List to a Numbered List, 999
Activity 16.03: Modifying the Bulleted List Style, 999
Activity 16.04: Applying WordArt Styles to Text, 1001
Activity 16.05: Using Format Painter, 1003
Objective 2: Insert and Format Pictures and Shapes, 1004
Activity 16.06: Inserting a Picture Using a Content Layout, 1005
Activity 16.07: Changing the Size and Shape of a Picture, 1006
Activity 16.08: Inserting and Positioning a Text Box, 1007
Activity 16.09: Inserting, Sizing, and Positioning Shapes, 1010
Activity 16.10: Adding Text to Shapes, 1012
Activity 16.11: Applying Shape and Picture Styles and Effects, 1013
Activity 16.12: Duplicating and Aligning Objects, 1015
Objective 3: Apply Slide Transitions, 1019
Activity 16.13: Applying Slide Transitions to a Presentation, 1019
Project 16B: Itinerary, 1022
Objective 4: Reorganize Presentation Text and Clear Formats, 1023
Activity 16.14: Moving and Copying Text, 1023
Activity 16.15: Copying Multiple Selections by Using the Office Clipboard, 1026
Activity 16.16: Undoing and Redoing Changes, 1028
Activity 16.17: Clearing Formatting from a Selection, 1028
Objective 5: Create and Format a SmartArt Graphic, 1029
Activity 16.18: Creating a SmartArt Diagram by Using a Content Layout, 1029
Activity 16.19: Adding and Removing Shapes in a Diagram, 1032
Activity 16.20: Changing the Diagram Type and Size, 1034
Activity 16.21: Creating a SmartArt Diagram from Bullet Points, 1037
Activity 16.22: Changing the Color and Style of a Diagram, 1037
There’s More You Can Do!, 1039
Summary, 1040
Key Terms, 1040
Matching, 1041
Fill in the Blank, 1042
Skills Review, 1043
Mastering PowerPoint, 1050
Business Running Case, 1064
Rubric, 1067
Problem Solving, 1068
You and GO!, 1074
GO! with Help, 1074
Group Business Running Case, 1075
Chapter 17. Enhancing a Presentation with Animation, Tables, and Charts, 1077
Project 17A: New Homes, 1079
Objective 1: Customize Slide Backgrounds and Themes, 1080
Activity 17.01: Applying a Background Style, 1080
Activity 17.02: Hiding Background Graphics, 1081
Activity 17.03: Formatting a Slide Background with a Picture, 1082
Activity 17.04: Applying a Background Fill Color and Resetting a Slide Background, 1086
Activity 17.05: Modifying Font Themes, 1087
Objective 2: Animate a Slide Show, 1088
Activity 17.06: Applying Entrance Effects, 1088
Activity 17.07: Setting Effect and Timing Options, 1091
Activity 17.08: Applying Animation to a SmartArt Graphic, 1095
Project 17B: Developments, 1097
Objective 3: Create and Modify Tables, 1098
Activity 17.09: Creating a Table, 1098
Activity 17.10: Modifying the Layout of a Table, 1101
Activity 17.11: Modifying a Table Design, 1104
Objective 4: Create and Modify Charts, 1106
Activity 17.12: Creating a Column Chart and Applying a Chart Style, 1106
Activity 17.13: Deleting Chart Data and Changing the Chart Type, 1111
Activity 17.14: Animating a Chart, 1113
There’s More You Can Do!, 1115
Summary, 1116
Key Terms, 1116
Matching, 1117
Fill in the Blank, 1118
Skills Review, 1119
Mastering PowerPoint, 1127
Business Running Case, 1140
Rubric, 1143
Problem Solving, 1144
You and GO!, 1150
GO! with Help, 1150
Group Business Running Case, 1151
Integrated Projects, 1153
Chapter 18. Using Access Data with Other Office Programs, 1153
Project 18A: Meeting Slides, 1155
Objective 1: Export Access Data to Excel, 1156
Activity 18.01: Exporting Access Data to Excel, 1156
Objective 2: Create a Formula in Excel, 1157
Activity 18.02: Creating a Formula for Calculation in Excel, 1157
Objective 3: Create a Chart in Excel, 1158
Activity 18.03: Creating a Chart in Excel, 1158
Objective 4: Copy Access Data into a Word Document, 1160
Activity 18.04: Copying Access Data to a Word Document, 1160
Objective 5: Copy Excel Data into a Word Document, 1161
Activity 18.05: Copying Excel Data to a Word Document, 1161
Objective 6: Insert an Excel Chart into a PowerPoint Presentation, 1162
Activity 18.06: Adding an Excel Chart to a PowerPoint Presentation, 1162
Chapter 19. Using Tables in Word and Excel, 1165
Project 19A: Meeting Notes, 1167
Objective 1: Plan a Table in Word, 1168
Activity 19.01: Starting Word and Planning the Table, 1168
Objective 2: Enter Data and Format a Table in Word, 1169
Activity 19.02: Entering Data, 1169
Activity 19.03: Formatting a Table, 1170
Objective 3: Create a Table in Word from Excel Data, 1171
Activity 19.04: Creating a Table in Word from Excel Data, 1171
Objective 4: Create an Excel Worksheet from a Word Table, 1172
Activity 19.05: Creating an Excel Worksheet from a Word Table, 1172
Chapter 20. Using Excel as a Data Source in a Mail Merge, 1175
Project 20A: Mailing Labels, 1177
Objective 1: Prepare a Mail Merge Document for Mailing Labels, 1178
Activity 20.01: Setting up Mailing Labels Using the Mailings Tab, 1178
Objective 2: Choose an Excel Worksheet as a Data Source, 1179
Activity 20.02: Selecting the Data Source for the Mailing Labels, 1179
Objective 3: Produce and Save Merged Mailing Labels, 1180
Activity 20.03: Adding Merge Fields to the Mailing Labels, 1180
Activity 20.04: Producing the Mailing Labels, 1181
Objective 4: Open a Saved Main Document for Mail Merge, 1181
Activity 20.05: Opening a Main Document for Mail Merge, 1181
Chapter 21. Linking Data in Office Documents, 1183
Project 21A: Weekly Sales, 1185
Objective 1: Insert and Link an Excel Object in Word, 1186
Activity 21.01: Inserting and Linking an Excel Object, 1186
Objective 2: Revise a Linked Excel Worksheet and Update Links in Word, 1187
Activity 21.02: Revising a Linked Worksheet and Updating Links in a Document, 1187
Objective 3: Open a Word Document That Includes a Linked Object and Update Links, 1188
Activity 21.03: Opening a Word Document That Includes a Linked Object, 1188
Activity 21.04: Updating a Linked Object, 1188
Chapter 22. Creating Presentation Content from Office Documents, 1191
Project 22A: New Employees, 1193
Objective 1: Insert a Word Outline into PowerPoint, 1194
Activity 22.01: Inserting a Word Outline into PowerPoint, 1194
Objective 2: Import Excel Data into a PowerPoint Chart, 1195
Activity 22.02: Importing Excel Data into a Chart in PowerPoint, 1195
Objective 3: Insert a Hyperlink into a PowerPoint Slide, 1198
Activity 22.03: Inserting a Hyperlink into a PowerPoint Slide, 1198
Glossary, G-1
Index, I-1
Single PC License Agreement and Limited Warranty, EP-1

Search Results

« Back to eTextbook


PAGE	Description

109	...

Tabs for Contents, notes, highlights

Table of Contents

Search Results