Windows 8
Chapter One Getting Started with Windows 8 1
Objectives 1
Case Study: Cedar Grove Elementary School 1
Windows 8 Fundamentals 2
Understanding the Start Screen 2
Configuring the Start Screen 4
Running Windows 8 Apps 7
Closing Apps 9
Understanding the Desktop 9
Managing Windows 8 Apps and Windows 14
Hands-On Exercise 1:
Windows 8 Fundamentals 18
Windows Programs and Security Features 24
Identifying Windows Accessories 24
Working with Security Settings and Software 27
Hands-On Exercise 2:
Windows Programs and Security Features 32
Windows Search and Help 36
Performing a Search 36
Using Targeted Searches 36
Getting Help 37
Hands-On Exercise 3:
Windows Search and Help 41
Chapter Objectives Review 44
Key Terms Matching 45
Multiple Choice 46
Practice Exercises 47
Mid-Level Exercises 51
Beyond the Classroom 52
Capstone Exercise 53
Microsoft Office 2013
Chapter One Office Fundamentals and File Management: Taking the First Step 55
Objectives 55
Case Study: Spotted Begonia Art Gallery 55
Windows 8 Startup 56
Logging In with Your Microsoft Account 56
Identifying the Start Screen Components 57
Interacting with the Start Screen 58
Accessing the Desktop 58
Hands-On Exercise 1:
Windows 8 Startup 60
Files and Folders 64
Using File Explorer 64
Working with Folders and Files 67
Selecting, Copying, and Moving Multiple Files and Folders 69
Hands-On Exercise 2:
Files and Folders 71
Microsoft Office Software 76
Identifying Common Interface Components 76
Getting Office Help 82
Hands-On Exercise 3:
Microsoft Office Software 85
The Backstage View Tasks 90
Opening a File 90
Printing a File 92
Closing a File and Application 93
Hands-On Exercise 4:
The Backstage View Tasks 95
Home Tab Tasks 99
Selecting and Editing Text 99
Using the Clipboard Group Commands 103
Using the Editing Group Commands 106
Hands-On Exercise 5:
Home Tab Tasks 109
Insert Tab Tasks 114
Inserting Objects 114
Review Tab Tasks 116
Reviewing a File 116
Page Layout Tab Tasks 119
Using the Page Setup Dialog Box 120
Hands-On Exercise 6:
Insert Tab Tasks, Page Layout Tab Tasks, and
Review Tab Tasks 122
Chapter Objectives Review 126
Key Terms Matching 127
Multiple Choice 128
Practice Exercises 129
Mid-Level Exercises 133
Beyond the Classroom 135
Capstone Exercise 136
Microsoft Office Word 2013
Chapter One Introduction to Word: Organizing a Document 137
Objectives 137
Case Study: Swan Creek National Wildlife Refuge 137
Introduction to Word Processing 138
Beginning and Editing a Document 139
Customizing Word 148
Hands-On Exercise 1:
Introduction to Word Processing 151
Document Organization 157
Using Features That Improve Readability 157
Viewing a Document in Different Ways 162
Hands-On Exercise 2:
Document Organization 168
Document Settings and Properties 174
Preparing a Document for Distribution 174
Modifying Document Properties 178
Hands-On Exercise 3:
Document Settings and Properties 180
Chapter Objectives Review 184
Key Terms Matching 185
Multiple Choice 186
Practice Exercises 187
Mid-Level Exercises 191
Beyond the Classroom 194
Capstone Exercise 195
Chapter Two Document Presentation: Editing and Formatting 197
Objectives 197
Case Study: Phillips Studio L Photography 197
Text and Paragraph Formatting 198
Applying Font Attributes 198
Formatting a Paragraph 203
Hands-On Exercise 1:
Text and Paragraph Formatting 211
Document Appearance 217
Formatting a Document 217
Applying Styles 220
Hands-On Exercise 2:
Document Formatting 225
Objects 231
Inserting and Formatting Objects 231
Hands-On Exercise 3:
Objects 239
Chapter Objectives Review 245
Key Terms Matching 246
Multiple Choice 247
Practice Exercises 248
Mid-Level Exercises 253
Beyond the Classroom 256
Capstone Exercise 257
Chapter Three Document Productivity: Working with Tables and Mail Merge 259
Objectives 259
Case Study: Traylor University Economic
Impact Study 259
Tables 260
Inserting a Table 260
Formatting a Table 265
Hands-On Exercise 1:
Tables 268
Advanced Table Features 274
Managing Table Data 274
Enhancing Table Data 279
Hands-On Exercise 2:
Advanced Table Features 283
Mail Merge 289
Creating a Mail Merge Document 289
Completing a Mail Merge 293
Hands-On Exercise 3:
Mail Merge 295
Chapter Objectives Review 299
Key Terms Matching 300
Multiple Choice 301
Practice Exercises 302
Mid-Level Exercises 306
Beyond the Classroom 310
Capstone Exercise 311
Chapter Four Collaboration and Research: Communicating and Producing
Professional Papers 313
Objectives 313
Case Study: Literature Analysis 313
Research Paper Basics 314
Using a Writing Style and Acknowledging Sources 314
Creating and Modifying Footnotes and Endnotes 320
Exploring Special Features 322
Hands-On Exercise 1:
Research Paper Basics 326
Document Tracking_332
Reviewing a Document 332
Tracking Changes 335
Hands-On Exercise 2:
Document Tracking 337
Online Document Collaboration 340
Using SkyDrive 340
Sharing and Collaborating on Documents 342
Hands-On Exercise 3:
Online Document Collaboration 356
Chapter Objectives Review 361
Key Terms Matching 362
Multiple Choice 363
Practice Exercises 364
Mid-Level Exercises 368
Beyond the Classroom 370
Capstone Exercise 371
Microsoft Office Excel 2013
Chapter One Introduction to Excel: What Is a Spreadsheet? 373
Objectives 373
Case Study: Ok Office Systems 373
Introduction to Spreadsheets 374
Exploring the Excel Window 374
Entering and Editing Cell Data 377
Hands-On Exercise 1:
Introduction to Spreadsheets 381
Mathematics and Formulas 384
Creating Formulas 384
Using Auto Fill 386
Displaying Cell Formulas 387
Hands-On Exercise 2:
Mathematics and Formulas 389
Workbook and Worksheet Management 394
Managing Worksheets 394
Managing Columns and Rows 397
Hands-On Exercise 3:
Workbook and Worksheet Management 401
Clipboard Tasks 406
Selecting, Moving, Copying, and Pasting Data 406
Hands-On Exercise 4:
Clipboard Tasks 411
Formatting 414
Applying Alignment and Font Options 414
Applying Number Formats 416
Hands-On Exercise 5:
Formatting 419
Page Setup and Printing 423
Selecting Page Setup Options 423
Previewing and Printing a Worksheet 427
Hands-On Exercise 6:
Page Setup and Printing 428
Chapter Objectives Review 432
Key Terms Matching 434
Multiple Choice 435
Practice Exercises 436
Mid-Level Exercises 441
Beyond the Classroom 444
Capstone Exercise 445
Chapter Two Formulas and Functions: Performing Quantitative Analysis 447
Objectives 447
Case Study: Townsend Mortgage Company 447
Formula Basics 448
Using Relative, Absolute, and Mixed Cell References
in Formulas 448
Correcting Circular References 450
Hands-On Exercise 1:
Formula Basics 452
Function Basics 456
Inserting a Function 456
Inserting Basic Math and Statistics Functions 458
Using Date Functions 463
Hands-On Exercise 2:
Function Basics 466
Logical, Lookup, and Financial Functions 471
Determining Results with the IF Function 471
Using Lookup Functions 474
Calculating Payments with the PMT Function 477
Hands-On Exercise 3:
Logical, Lookup, and Financial Functions 478
Range Names 482
Creating and Maintaining Range Names 482
Using Range Names in Formulas 484
Hands-On Exercise 4:
Range Names 485
Chapter Objectives Review 488
Key Terms Matching 489
Multiple Choice 490
Practice Exercises 491
Mid-Level Exercises 496
Beyond the Classroom 501
Capstone Exercise 503
Chapter Three Charts: Depicting Data Visually 505
Objectives 505
Case Study: Computer Job Outlook 505
Chart Creation Basics 506
Selecting the Data Source 506
Choosing a Chart Type 507
Moving, Sizing, and Printing a Chart 517
Hands-On Exercise 1:
Chart Creation Basics 520
Chart Elements 525
Adding Chart Elements 525
Formatting Chart Elements 528
Hands-On Exercise 2:
Chart Elements 533
Chart Design and Sparklines 537
Applying a Chart Style and Colors 537
Modifying the Data Source 538
Creating and Customizing Sparklines 539
Hands-On Exercise 3:
Chart Design and Sparklines 541
Chapter Objectives Review 544
Key Terms Matching 545
Multiple Choice 546
Practice Exercises 547
Mid-Level Exercises 550
Beyond the Classroom 553
Capstone Exercise 554
Chapter Four Datasets and Tables: Managing Large Volumes of Data 555
Objectives 555
Case Study: Reid Furniture Store 555
Large Datasets 556
Freezing Rows and Columns 557
Printing Large Datasets 557
Hands-On Exercise 1:
Large Datasets 561
Excel Tables 565
Designing and Creating Tables 565
Applying a Table Style 569
Hands-On Exercise 2:
Excel Tables 571
Table Manipulation 576
Sorting Data 576
Filtering Data 578
Hands-On Exercise 3:
Table Manipulation 582
Table Aggregation 587
Using Structured References and a Total Row 587
Hands-On Exercise 4:
Table Aggregation 590
Conditional Formatting 594
Applying Conditional Formatting 594
Creating a New Rule 598
Hands-On Exercise 5:
Conditional Formatting 601
Chapter Objectives Review 605
Key Terms Matching 606
Multiple Choice 607
Practice Exercises 608
Mid-Level Exercises 612
Beyond the Classroom 614
Capstone Exercise 616
Chapter Five Subtotals, PivotTables, and PivotCharts: Summarizing and Analyzing Data 617
Objectives 617
Case Study: Ivory Halls Publishing Company 617
Subtotals and Outlines 618
Subtotaling Data 618
Grouping and Ungrouping Data 621
Hands-On Exercise 1:
Subtotals and Outlines 622
Pivottable Basics 626
Creating a PivotTable 626
Modifying a PivotTable 629
Hands-On Exercise 2:
PivotTable Basics 634
Pivottable Options 639
Filtering and Slicing a PivotTable 639
Creating a Calculated Field 642
Hands-On Exercise 3:
PivotTable Options 644
Pivottable Design and Pivotcharts 649
Formatting a PivotTable 649
Using PowerPivot Functionality 650
Creating a PivotChart 652
Hands-On Exercise 4:
PivotTable Design and PivotCharts 654
Chapter Objectives Review 656
Key Terms Matching 657
Multiple Choice 658
Practice Exercises 659
Mid-Level Exercises 663
Beyond the Classroom 665
Capstone Exercise 666
Chapter SIix What-If Analysis: Using Decision-Making Tools 667
Objectives 667
Case Study: Personal Finance: Buying Your
First Home 667
One- and Two-Variable Data Tables 668
Creating a One-Variable Data Table 668
Creating a Two-Variable Data Table 672
Hands-On Exercise 1:
One- and Two-Variable Data Tables 674
Goal Seek and Scenario Manager 679
Identifying an Input Value with Goal Seek 679
Using Scenario Manager 680
Generating Scenario Summary Reports 682
Hands-On Exercise 2:
Goal Seek and Scenario Manager 684
Solver 688
Loading the Solver Add-In 688
Optimizing Results with Solver 689
Hands-On Exercise 3:
Solver 695
Chapter Objectives Review 699
Key Terms Matching 700
Multiple Choice 701
Practice Exercises 702
Mid-Level Exercises 705
Beyond the Classroom 707
Capstone Exercise 709
Chapter Seven Specialized Functions: Logical, Lookup, Databases, and Finances 711
Objectives 711
Case Study: Transpayne Filtration 711
Logical and Lookup Functions 712
Creating a Nested Logical Function 712
Using Match and Index Lookup Functions 716
Hands-On Exercise 1:
Logical and Lookup Functions 719
Database Filtering and Functions 723
Using Advanced Filtering 723
Manipulating Data with Database Functions 725
Hands-On Exercise 2:
Database Filtering and Functions 728
Financial Functions 732
Creating a Loan Amortization Table 732
Performing Other Financial Calculations 734
Hands-On Exercise 3:
Financial Functions 737
Chapter Objectives Review 741
Key Terms Matching 742
Multiple Choice 743
Practice Exercises 744
Mid-Level Exercises 749
Beyond the Classroom 752
Capstone Exercise 753
Chapter Eight Statistical Functions: Analyzing Statistics 755
Objectives 755
Case Study: Education Evaluation 755
Math and Statistical Functions 756
Using Conditional Math and Statistical Functions 756
Calculating Relative Standing with Statistical Functions 759
Hands-On Exercise 1:
Math and Statistical Functions 764
Descriptive Statistical Functions 769
Measuring Central Tendency 769
Hands-On Exercise 2:
Descriptive Statistical Functions 773
Inferential Statistics 776
Loading the Analysis ToolPak 776
Performing Analysis Using the Analysis ToolPak 776
Performing Analysis of Variance (Anova) 776
Calculating Covariance 778
Creating a Histogram 778
Hands-On Exercise 3:
Inferential Statistics 780
Chapter Objectives Review 784
Key Terms Matching 785
Multiple Choice 786
Practice Exercises 787
Mid-Level Exercises 790
Beyond the Classroom 792
Capstone Exercise 793
Microsoft Office Access 2013
Chapter One Introduction to Access: Finding Your Way Through an Access Database 795
Objectives 795
Case Study: Managing a Business in the Global
Economy 795
Databases Are Everywhere! 796
Understanding Database Fundamentals 796
Using an Existing Database 803
Hands-On Exercise 1:
Databases Are Everywhere! 807
Sorts and Filters 814
Sorting Table Data on One or Multiple Fields 814
Creating, Modifying, and Removing Filters 815
Hands-On Exercise 2:
Sorts and Filters 818
Access Versus Excel, and Relational Databases 823
Knowing When to Use Access or Excel to Manage Data 823
Understanding Relational Power 824
Hands-On Exercise 3:
Access Versus Excel, and Relational Databases 827
Access Database Creation 831
Creating a Database 831
Hands-On Exercise 4:
Access Database Creation 835
Chapter Objectives Review 839
Key Terms Matching 840
Multiple Choice 841
Practice Exercises 842
Mid-Level Exercises 847
Beyond the Classroom 851
Capstone Exercise 852
Chapter Two Tables and Queries in Relational Databases: Designing
Databases and Extracting Data 853
Objectives 853
Case Study: Bank Audit 853
Table Design, Creation, and Modification 854
Designing a Table 854
Creating and Modifying Tables 858
Hands-On Exercise 1:
Table Design, Creation, and Modification 864
Multiple-Table Databases 869
Sharing Data 869
Establishing Table Relationships 872
Hands-On Exercise 2:
Multiple-Table Databases 877
Single-Table Queries 883
Creating a Single-Table Query 883
Specifying Query Criteria for Different Data Types 885
Understanding Query Sort Order 889
Running, Copying, and Modifying a Query 889
Using the Query Wizard 890
Hands-On Exercise 3:
Single-Table Queries 893
Multitable Queries 896
Creating a Multitable Query 896
Modifying a Multitable Query 897
Hands-On Exercise 4:
Multitable Queries 901
Chapter Objectives Review 905
Key Terms Matching 907
Multiple Choice 908
Practice Exercises 909
Mid-Level Exercises 914
Beyond the Classroom 918
Capstone Exercise 920
Chapter Three Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions 923
Objectives 923
Case Study: Housing Slump Means Opportunity
For College Students 923
Calculations and Expressions 924
Creating a Calculated Field in a Query 924
Formatting and Saving Calculated Results 927
Hands-On Exercise 1:
Calculations and Expressions 930
The Expression Builder and Functions 935
Creating Expressions with the Expression Builder 935
Using Built-In Functions in Access 937
Hands-On Exercise 2:
The Expression Builder and Functions 940
Aggregate Functions 945
Adding Aggregate Functions to Datasheets 945
Creating Queries with Aggregate Functions 946
Hands-On Exercise 3:
Aggregate Functions 952
Chapter Objectives Review 955
Key Terms Matching 956
Multiple Choice 957
Practice Exercises 958
Mid-Level Exercises 961
Beyond the Classroom 965
Capstone Exercise 967
Chapter Four Creating and Using Professional Forms and Reports:
Moving Beyond Tables and Queries 969
Objectives 969
Case Study: Coffee Shop Starts New Business 969
Form Basics 970
Creating Forms Using Form Tools 970
Using Form Views 977
Working with a Form Layout Control 980
Sorting Records in a Form 982
Hands-On Exercise 1:
Form Basics 984
Report Basics 990
Creating Reports Using Report Tools 990
Using Report Views 997
Modifying a Report 999
Sorting Records in a Report 1002
Hands-On Exercise 2:
Report Basics 1004
Chapter Objectives Review 1008
Key Terms Matching 1010
Multiple Choice 1011
Practice Exercises 1012
Mid-Level Exercises 1015
Beyond the Classroom 1018
Capstone Exercise 1019
Chapter Five Data Validation and Data Analysis: Reducing Errors and
Extracting Better Information 1021
Objectives 1021
Case Study: Implementing a New Database At
Tommy’s Shelter 1021
Data Validation in Tables 1022
Establishing Data Validation 1022
Creating an Input Mask 1025
Creating and Modifying a Lookup Field 1027
Hands-On Exercise 1:
Data Validation in Tables 1032
Data Analysis Using Advanced Select Queries 1037
Creating a Parameter Query 1037
Using Advanced Functions in the Expression Builder 1041
Performing Date Arithmetic 1047
Hands-On Exercise 2:
Data Analysis Using Advanced Select Queries 1051
Chapter Objectives Review 1056
Key Terms Matching 1057
Multiple Choice 1058
Practice Exercises 1059
Mid-Level Exercises 1062
Beyond the Classroom 1064
Capstone Exercise 1066
Microsoft Office PowerPoint 2013
Chapter One Introduction to PowerPoint: Creating a Basic Presentation 1069
Objectives 1069
Case Study: Be a Trainer 1069
Introduction to Powerpoint 1070
Using PowerPoint Views 1071
Typing a Speaker Note 1076
Saving As a Slide Show 1076
Hands-On Exercise 1:
Introduction to PowerPoint 1078
Presentation Creation 1081
Planning a Presentation 1081
Assessing Presentation Content 1084
Reviewing the Presentation 1085
Hands-On Exercise 2:
Presentation Creation 1087
Presentation Enhancement 1091
Inserting Media Objects 1091
Adding a Table 1092
Using Animations and Transitions 1092
Inserting a Header or Footer 1095
Hands-On Exercise 3:
Presentation Enhancement 1097
Navigation and Printing_1102
Running and Navigating a Slide Show 1102
Printing in PowerPoint 1105
Hands-On Exercise 4:
Navigation and Printing 1108
Chapter Objectives Review_1110
Key Terms Matching_1111
Multiple Choice 1112
Practice Exercises_1113
Mid-Level Exercises_1118
Beyond the Classroom_1122
Capstone Exercise 1123
Chapter Two Presentation Development: Planning and Preparing a
Presentation 1125
Objectives 1125
Case Study: The Wellness Education Center 1125
Templates 1126
Creating a Presentation Using a Template 1126
Modifying a Presentation Based on a Template 1128
Hands-On Exercise 1:
Templates 1129
Outlines 1134
Creating a Presentation in Outline View 1134
Modifying an Outline Structure 1135
Printing an Outline 1137
Hands-On Exercise 2:
Outlines 1138
Data Imports 1142
Importing an Outline 1142
Reusing Slides from an Existing Presentation 1142
Hands-On Exercise 3:
Data Imports 1144
Design 1146
Using Sections 1146
Examining Slide Show Design Principles 1147
Modifying a Theme 1149
Modifying the Slide Master 1150
Hands-On Exercise 4:
Design 1153
Chapter Objectives Review 1157
Key Terms Matching 1158
Multiple Choice 1159
Practice Exercises 1160
Mid-Level Exercises 1164
Beyond the Classroom 1167
Capstone Exercise 1168
Glossary 1169
Index 1181