GO! Walk-Through |
|
xv | |
|
|
|
Chapter 1 Introduction to Microsoft Office 2013 Features |
|
|
1 | (48) |
|
|
2 | (19) |
|
Objective 1 Use File Explorer to Download, Extract, and Locate Files and Folders |
|
|
3 | (1) |
|
Activity 1.01 Using File Explorer to Download, Extract, and Locate Files and Folders |
|
|
3 | (2) |
|
Objective 2 Use Start Search to Locate and Start a Microsoft Office 2013 Desktop App |
|
|
5 | (1) |
|
Activity 1.02 Using Start Search to Locate and Start a Microsoft Office 2013 Desktop App |
|
|
5 | (2) |
|
Objective 3 Enter, Edit, and Check the Spelling of Text in an Office 2013 Program |
|
|
7 | (1) |
|
Activity 1.03 Entering and Editing Text in an Office 2013 Program |
|
|
7 | (2) |
|
Activity 1.04 Checking Spelling |
|
|
9 | (1) |
|
Objective 4 Perform Commands from a Dialog Box |
|
|
10 | (1) |
|
Activity 1.05 Performing Commands from a Dialog Box |
|
|
10 | (2) |
|
|
12 | (1) |
|
Objective 5 Create a Folder and Name and Save a File |
|
|
13 | (1) |
|
Activity 1.07 Creating a Folder and Naming and Saving a File |
|
|
14 | (3) |
|
Objective 6 Insert a Footer, Add Document Properties, Print a File, and Close a Desktop App |
|
|
17 | (1) |
|
Activity 1.08 Inserting a Footer, Inserting Document Info, and Adding Document Properties |
|
|
17 | (2) |
|
Activity 1.09 Printing a File and Closing a Desktop App |
|
|
19 | (2) |
|
|
21 | (28) |
|
Objective 7 Open an Existing File and Save It with a New Name |
|
|
22 | (1) |
|
Activity 1.10 Opening an Existing File and Saving It with a New Name |
|
|
22 | (1) |
|
|
23 | (1) |
|
Objective 8 Sign In to Office and Explore Options for a Microsoft Office Desktop App |
|
|
24 | (1) |
|
Activity 1.11 Signing In to Office and Viewing Application Options |
|
|
24 | (1) |
|
Objective 9 Perform Commands from the Ribbon and Quick Access Toolbar |
|
|
25 | (1) |
|
Activity 1.12 Performing Commands from and Customizing the Ribbon and the Quick Access Toolbar |
|
|
25 | (3) |
|
More Knowledge Customizing the Ribbon |
|
|
28 | (1) |
|
Activity 1.13 Minimizing and Using the Keyboard to Control the Ribbon |
|
|
29 | (1) |
|
Objective 10 Apply Formatting in Office Programs |
|
|
30 | (1) |
|
Activity 1.14 Changing Page Orientation and Zoom Level |
|
|
30 | (1) |
|
More Knowledge Zooming to Page Width |
|
|
31 | (1) |
|
Activity 1.15 Formatting Text by Using Fonts, Alignment, Font Colors, and Font Styles |
|
|
31 | (2) |
|
Activity 1.16 Using Format Painter |
|
|
33 | (2) |
|
Activity 1.17 Using Keyboard Shortcuts and Using the Clipboard to Copy, Cut, and Paste |
|
|
35 | (4) |
|
Objective 11 Compress Files and Use the Microsoft Office 2013 Help System |
|
|
39 | (1) |
|
Activity 1.18 Compressing Files |
|
|
39 | (1) |
|
Activity 1.19 Using the Microsoft Office 2013 Help System in Excel |
|
|
40 | (1) |
|
Objective 12 Install Apps for Office and Create a Microsoft Account |
|
|
41 | (1) |
|
Activity 1.20 Installing Apps for Office |
|
|
41 | (1) |
|
Activity 1.21 Creating a Microsoft Account |
|
|
42 | (2) |
|
Summary, GO! Learn It Online |
|
|
44 | (1) |
|
|
45 | (4) |
|
Word Introduction to Microsoft Word 2013 |
|
|
49 | (60) |
|
Chapter 1 Creating Documents with Microsoft Word 2013 |
|
|
51 | (58) |
|
|
52 | (18) |
|
Objective 1 Create a New Document and Insert Text |
|
|
53 | (1) |
|
Activity 1.01 Starting a New Word Document |
|
|
53 | (1) |
|
More Knowledge Word's Default Settings Are Easier to Read Online |
|
|
54 | (1) |
|
Activity 1.02 Inserting Text from Another Document |
|
|
54 | (1) |
|
Objective 2 Insert and Format Graphics |
|
|
55 | (1) |
|
Activity 1.03 Formatting Text by Using Text Effects |
|
|
55 | (1) |
|
More Knowledge Clear Existing Formatting |
|
|
56 | (1) |
|
Activity 1.04 Inserting Pictures |
|
|
56 | (1) |
|
Activity 1.05 Wrapping Text around a Picture Using Layout Options |
|
|
57 | (1) |
|
Activity 1.06 Resizing Pictures and Using Live Layout |
|
|
58 | (1) |
|
Activity 1.07 Moving a Picture |
|
|
59 | (1) |
|
Activity 1.08 Applying Picture Effects |
|
|
60 | (1) |
|
Activity 1.09 Applying Artistic Effects |
|
|
60 | (1) |
|
Activity 1.10 Adding a Page Border |
|
|
61 | (1) |
|
Objective 3 Insert and Modify Text Boxes and Shapes |
|
|
62 | (1) |
|
Activity 1.11 Inserting, Sizing, and Positioning a Shape |
|
|
62 | (1) |
|
Activity 1.12 Typing Text in a Shape and Formatting a Shape |
|
|
63 | (1) |
|
Activity 1.13 Inserting a Text Box |
|
|
64 | (1) |
|
Activity 1.14 Sizing and Positioning a Text Box and Formatting a Text Box Using Shape Styles |
|
|
64 | (1) |
|
Objective 4 Preview and Print a Document |
|
|
65 | (1) |
|
Activity 1.15 Adding a File Name to the Footer by Inserting a Field |
|
|
65 | (1) |
|
Activity 1.16 Adding Document Properties and Previewing and Printing a Document |
|
|
66 | (2) |
|
|
68 | (1) |
|
Objective Create a Flyer in Word Web App |
|
|
68 | (1) |
|
Activity Creating a Flyer in the Word Web App |
|
|
68 | (2) |
|
Project 1B Information Handout |
|
|
70 | (39) |
|
Objective 5 Change Document and Paragraph Layout |
|
|
71 | (1) |
|
Activity 1.17 Setting Margins |
|
|
71 | (1) |
|
Activity 1.18 Aligning Text |
|
|
72 | (1) |
|
Activity 1.19 Changing Line Spacing |
|
|
73 | (2) |
|
Activity 1.20 Indenting Text |
|
|
75 | (1) |
|
Activity 1.21 Adding Space before and after Paragraphs |
|
|
76 | (1) |
|
Objective 6 Create and Modify Lists |
|
|
77 | (1) |
|
Activity 1.22 Creating a Bulleted List |
|
|
77 | (1) |
|
Activity 1.23 Creating a Numbered List |
|
|
78 | (1) |
|
More Knowledge To End a List |
|
|
79 | (1) |
|
Activity 1.24 Customizing Bullets |
|
|
79 | (1) |
|
Objective 7 Set and Modify Tab Stops |
|
|
80 | (1) |
|
Activity 1.25 Setting Tab Stops |
|
|
80 | (2) |
|
Activity 1.26 Modifying Tab Stops |
|
|
82 | (1) |
|
Objective 8 Insert a SmartArt Graphic and an Online Video |
|
|
83 | (1) |
|
Activity 1.27 Inserting a SmartArt Graphic |
|
|
83 | (1) |
|
Activity 1.28 Sizing and Formatting a SmartArt Graphic |
|
|
84 | (1) |
|
Activity 1.29 Inserting an Online Video |
|
|
85 | (2) |
|
|
87 | (1) |
|
Objective Create a Handout in the Word Web App |
|
|
87 | (1) |
|
Activity Creating a Handout in the Word Web App |
|
|
87 | (2) |
|
GO! with Microsoft Office 365 |
|
|
89 | (1) |
|
Activity Using the Exchange Online Outlook Meeting Tool to Collaborate |
|
|
89 | (1) |
|
Summary, GO! Learn It Online, GO! for Job Success |
|
|
90 | (1) |
|
Guide to Chapter Assessments |
|
|
91 | (1) |
|
|
92 | (1) |
|
|
93 | (6) |
|
|
99 | (8) |
|
|
107 | (1) |
|
|
108 | (1) |
|
Excel Introduction to Microsoft Excel 2013 |
|
|
109 | (66) |
|
Chapter 1 Creating a Worksheet and Charting Data |
|
|
111 | (64) |
|
Project 1A Sales Report with Embedded Column Chart and Sparklines |
|
|
112 | (27) |
|
Objective 1 Create, Save, and Navigate an Excel Workbook |
|
|
113 | (1) |
|
Activity 1.01 Starting Excel, Navigating Excel, and Naming and Saving a Workbook |
|
|
113 | (1) |
|
More Knowledge Creating a New Workbook by Using a Template |
|
|
113 | (2) |
|
Objective 2 Enter Data in a Worksheet |
|
|
115 | (1) |
|
Activity 1.02 Entering Text, Using AutoComplete, and Using the Name Box to Select a Cell |
|
|
116 | (1) |
|
Activity 1.03 Using Auto Fill and Keyboard Shortcuts |
|
|
117 | (1) |
|
Activity 1.04 Aligning Text and Adjusting the Size of Columns |
|
|
118 | (2) |
|
Activity 1.05 Entering Numbers |
|
|
120 | (1) |
|
Objective 3 Construct and Copy Formulas and Use the SUM Function |
|
|
121 | (1) |
|
Activity 1.06 Constructing a Formula and Using the SUM Function |
|
|
121 | (2) |
|
Activity 1.07 Copying a Formula by Using the Fill Handle |
|
|
123 | (1) |
|
Objective 4 Format Cells with Merge & Center, Cell Styles, and Themes |
|
|
124 | (1) |
|
Activity 1.08 Using Merge & Center and Applying Cell Styles |
|
|
124 | (1) |
|
Activity 1.09 Formatting Financial Numbers |
|
|
125 | (1) |
|
Activity 1.10 Changing the Workbook Theme |
|
|
126 | (1) |
|
More Knowledge Formatting a Cell's Font, Style, Size, or Color with Individual Commands |
|
|
126 | (1) |
|
Objective5 Chart Data to Create a Column Chart and Insert Sparklines |
|
|
126 | (1) |
|
Activity 1.11 Charting Data and Using Recommended Charts to Select and Insert a Column Chart |
|
|
126 | (3) |
|
Activity 1.12 Using the Chart Tools to Apply Chart Styles |
|
|
129 | (2) |
|
Activity 1.13 Creating and Formatting Sparklines |
|
|
131 | (1) |
|
Objective 6 Print a Worksheet, Display Formulas, and Close Excel |
|
|
132 | (1) |
|
Activity 1.14 Creating a Footer and Centering a Worksheet |
|
|
132 | (1) |
|
Activity 1.15 Adding Document Properties and Printing a Workbook |
|
|
133 | (1) |
|
Activity 1.16 Printing a Section of the Worksheet |
|
|
134 | (1) |
|
Activity 1.17 Changing Page Orientation and Displaying, Printing, and Hiding Formulas |
|
|
134 | (2) |
|
More Knowledge Inserting a Watermark |
|
|
136 | (1) |
|
|
137 | (1) |
|
Objective Create a Sales Report with an Embedded Column Chart Using the Excel Web App |
|
|
137 | (1) |
|
Activity Creating a Sales Report with Embedded Column Chart Using the Excel Web App |
|
|
137 | (2) |
|
Project 1B Inventory Valuation |
|
|
139 | (36) |
|
Objective 7 Check Spelling in a Worksheet |
|
|
140 | (1) |
|
Activity 1.18 Checking Spelling in a Worksheet |
|
|
140 | (1) |
|
Objective 8 Enter Data by Range |
|
|
141 | (1) |
|
Activity 1.19 Entering Data by Range |
|
|
141 | (2) |
|
Objective 9 Construct Formulas for Mathematical Operations |
|
|
143 | (1) |
|
Activity 1.20 Using Arithmetic Operators |
|
|
143 | (1) |
|
Activity 1.21 Using the Quick Analysis Tool |
|
|
144 | (1) |
|
Activity 1.22 Copying Formulas Containing Absolute Cell References |
|
|
144 | (2) |
|
More Knowledge Calculate a Percentage if You Know the Total and the Amount |
|
|
146 | (1) |
|
Objective 10 Edit Values in a Worksheet |
|
|
146 | (1) |
|
Activity 1.23 Editing Values in a Worksheet |
|
|
146 | (1) |
|
Activity 1.24 Formatting Cells with the Percent Style |
|
|
147 | (1) |
|
Objective 11 Format a Worksheet |
|
|
148 | (1) |
|
Activity 1.25 Inserting and Deleting Rows and Columns |
|
|
148 | (2) |
|
More Knowledge Hiding Rows and Columns |
|
|
150 | (1) |
|
Activity 1.26 Adjusting Column Widths and Wrapping Text |
|
|
150 | (1) |
|
Activity 1.27 Changing Theme Colors |
|
|
150 | (3) |
|
|
153 | (1) |
|
Objective Calculate the Value of an Inventory in the Excel Web App |
|
|
153 | (1) |
|
Activity Creating an Inventory Valuation Report in the Excel Web App |
|
|
153 | (2) |
|
GO! with Microsoft Office 365 |
|
|
155 | (1) |
|
Activity Using the Exchange Online Outlook Meeting Tool to Collaborate |
|
|
155 | (1) |
|
Summary, GO! Learn It Online, GO! for Job Success |
|
|
156 | (1) |
|
Guide to Chapter Assessments |
|
|
157 | (1) |
|
|
158 | (2) |
|
|
160 | (6) |
|
|
166 | (7) |
|
|
173 | (1) |
|
|
174 | (1) |
|
Access Introduction to Microsoft Access 2013 |
|
|
175 | (76) |
|
Chapter 1 Getting Started with Microsoft Access 2013 |
|
|
177 | (74) |
|
Project 1A Student Advising Database with Two Tables |
|
|
178 | (32) |
|
Objective 1 Identify Good Database Design |
|
|
179 | (1) |
|
Activity 1.01 Using Good Design Techniques to Plan a Database |
|
|
179 | (1) |
|
Objective 2 Create a Table and Define Fields in a Blank Desktop Database |
|
|
180 | (1) |
|
Activity 1.02 Starting with a Blank Desktop Database |
|
|
180 | (3) |
|
Activity 1.03 Assigning the Data Type and Name to Fields |
|
|
183 | (2) |
|
More Knowledge Create Fields by Entering Data |
|
|
185 | (1) |
|
Activity 1.04 Renaming Fields and Changing Data Types in a Table |
|
|
185 | (1) |
|
Activity 1.05 Adding a Record to a Table |
|
|
185 | (2) |
|
More Knowledge Renaming or Deleting a Table |
|
|
187 | (1) |
|
Activity 1.06 Adding Additional Records to a Table |
|
|
187 | (1) |
|
Activity 1.07 Importing Data from an Excel Workbook into an Existing Access Table |
|
|
187 | (3) |
|
Objective 3 Change the Structure of Tables and Add a Second Table |
|
|
190 | (1) |
|
Activity 1.08 Deleting a Table Field in Design View |
|
|
190 | (1) |
|
Activity 1.09 Changing a Field Size and Adding a Description |
|
|
191 | (1) |
|
Activity 1.10 Viewing the Primary Key in Design View |
|
|
192 | (1) |
|
Activity 1.11 Adding a Second Table to a Database by Importing an Excel Spreadsheet |
|
|
193 | (2) |
|
Activity 1.12 Adjusting Column Widths |
|
|
195 | (1) |
|
Activity 1.13 Printing a Table |
|
|
196 | (4) |
|
Objective 4 Create a Query, Form, and Report |
|
|
200 | (1) |
|
Activity 1.14 Creating a Query by Using the Simple Query Wizard |
|
|
200 | (2) |
|
Activity 1.15 Creating and Printing a Form |
|
|
202 | (2) |
|
Activity 1.16 Creating, Modifying, and Printing a Report |
|
|
204 | (2) |
|
Objective 5 Close a Database and Exit Access |
|
|
206 | (1) |
|
Activity 1.17 Closing a Database and Exiting Access |
|
|
207 | (1) |
|
|
208 | (1) |
|
Objective Export an Access Table to an Excel Spreadsheet, Save to SkyDrive, Edit a Record, and Save to Your Computer |
|
|
208 | (1) |
|
Activity Exporting an Access Table to an Excel Spreadsheet, Saving the Spreadsheet to SkyDrive, Editing a Record in SkyDrive, and Saving to Your Computer |
|
|
208 | (2) |
|
Project 1B Student Workshops Database |
|
|
210 | (41) |
|
Objective 6 Use a Template to Create a Database |
|
|
211 | (1) |
|
Activity 1.18 Using a Template to Create a Database |
|
|
211 | (1) |
|
Activity 1.19 Building a Table by Entering Records in a Multiple-Items Form and a Single-Record Form |
|
|
212 | (2) |
|
Activity 1.20 Appending Records by Importing from an Excel Spreadsheet |
|
|
214 | (1) |
|
Objective 7 Organize Objects in the Navigation Pane |
|
|
215 | (1) |
|
Activity 1.21 Grouping Database Objects in the Navigation Pane |
|
|
215 | (1) |
|
Objective 8 Create a New Table in a Database Created with a Template |
|
|
216 | (1) |
|
Activity 1.22 Using the Table Tool to Create a New Table |
|
|
216 | (1) |
|
Activity 1.23 Entering Records into a New Table |
|
|
217 | (2) |
|
Objective 9 Print a Report and a Table |
|
|
219 | (1) |
|
Activity 1.24 Viewing Reports and Printing a Report |
|
|
219 | (1) |
|
Activity 1.25 Printing a Table |
|
|
220 | (2) |
|
|
222 | (1) |
|
Objective Export an Access Table to an Excel Spreadsheet, Save to Google Drive, Add a Record, and Save to Your Computer |
|
|
222 | (1) |
|
Activity Exporting an Access Table to an Excel Spreadsheet, Saving the Spreadsheet to Google Drive, Editing a Record in Google Drive, and Saving to Your Computer |
|
|
222 | (2) |
|
GO! with Microsoft Office 365 |
|
|
224 | (1) |
|
Activity Using the Exchange Online Outlook Meeting Tool to Collaborate |
|
|
224 | (2) |
|
Summary, GO! Learn It Online, GO! for Job Success |
|
|
226 | (1) |
|
Guide to Chapter Assessments |
|
|
227 | (1) |
|
|
228 | (2) |
|
|
230 | (9) |
|
|
239 | (10) |
|
|
249 | (1) |
|
|
250 | (1) |
|
PowerPoint Introduction to Microsoft PowerPoint 2013 |
|
|
251 | |
|
Chapter 1 Getting Started with Microsoft PowerPoint |
|
|
253 | |
|
Project 1A Company Overview |
|
|
254 | (21) |
|
Objective 1 Create a New Presentation |
|
|
255 | (1) |
|
Activity 1.01 Creating a New Presentation and Identifying Parts of the PowerPoint Window |
|
|
255 | (1) |
|
Activity 1.02 Entering Presentation Text |
|
|
256 | (1) |
|
Activity 1.03 Applying a Presentation Theme |
|
|
257 | (1) |
|
Objective 2 Edit a Presentation in Normal View |
|
|
258 | (1) |
|
Activity 1.04 Inserting a New Slide |
|
|
258 | (2) |
|
Activity 1.05 Increasing and Decreasing List Levels |
|
|
260 | (1) |
|
Activity 1.06 Adding Speaker's Notes to a Presentation |
|
|
261 | (1) |
|
Activity 1.07 Displaying and Editing Slides in the Slide Pane |
|
|
261 | (2) |
|
Objective 3 Add Pictures to a Presentation |
|
|
263 | (1) |
|
Activity 1.08 Inserting a Picture from a File |
|
|
263 | (1) |
|
Activity 1.09 Applying a Style to a Picture |
|
|
264 | (1) |
|
Activity 1.10 Applying and Removing Picture Artistic Effects |
|
|
265 | (1) |
|
Objective 4 Print and View a Presentation |
|
|
265 | (1) |
|
Activity 1.11 Viewing a Slide Show |
|
|
265 | (1) |
|
Activity 1.12 Using Presenter View |
|
|
266 | (2) |
|
Activity 1.13 Inserting Headers and Footers on Slide Handouts |
|
|
268 | (1) |
|
Activity 1.14 Inserting Slide Numbers on Slides |
|
|
269 | (1) |
|
Activity 1.15 Printing Presentation Handouts |
|
|
270 | (1) |
|
More Knowledge Print a Presentation in Grayscale |
|
|
271 | (1) |
|
Activity 1.16 Printing Speaker Notes |
|
|
271 | (2) |
|
|
273 | (1) |
|
Objective Create a Company Overview Presentation in the PowerPoint Web App |
|
|
273 | (1) |
|
Activity Creating a Company Overview Presentation in the PowerPoint Web App |
|
|
273 | (2) |
|
Project 1B Itinerary Presentation |
|
|
275 | |
|
Objective 5 Edit an Existing Presentation |
|
|
276 | (1) |
|
Activity 1.17 Changing Slide Size |
|
|
276 | (1) |
|
Activity 1.18 Inserting Slides from an Existing Presentation |
|
|
276 | (2) |
|
More Knowledge Inserting All Slides |
|
|
278 | (1) |
|
Activity 1.19 Displaying and Editing the Presentation Outline |
|
|
278 | (1) |
|
Activity 1.20 Deleting and Moving a Slide |
|
|
279 | (1) |
|
Activity 1.21 Finding and Replacing Text |
|
|
280 | (1) |
|
Objective 6 Format a Presentation |
|
|
280 | (1) |
|
Activity 1.22 Applying a Theme Variant |
|
|
280 | (1) |
|
Activity 1.23 Changing Fonts and Font Sizes |
|
|
281 | (1) |
|
Activity 1.24 Changing Font Styles and Font Colors |
|
|
282 | (1) |
|
Activity 1.25 Aligning Text |
|
|
283 | (1) |
|
Activity 1.26 Changing Line Spacing |
|
|
283 | (1) |
|
Activity 1.27 Changing the Slide Layout |
|
|
284 | (1) |
|
Objective 7 Use Slide Sorter View |
|
|
285 | (1) |
|
Activity 1.28 Deleting Slides in Slide Sorter View |
|
|
285 | (1) |
|
Activity 1.29 Moving a Single Slide in Slide Sorter View |
|
|
285 | (1) |
|
Activity 1.30 Selecting Contiguous and Noncontiguous Slides and Moving Multiple Slides |
|
|
286 | (1) |
|
Objective 8 Apply Slide Transitions |
|
|
287 | (1) |
|
Activity 1.31 Applying Slide Transitions to a Presentation |
|
|
287 | (1) |
|
Activity 1.32 Setting Slide Transition Timing Options |
|
|
288 | (1) |
|
More Knowledge Applying Multiple Slide Transitions |
|
|
288 | (1) |
|
Activity 1.33 Displaying a Presentation in Reading View |
|
|
289 | (1) |
|
More Knowledge Present a Presentation Online |
|
|
290 | (1) |
|
|
291 | (1) |
|
Objective Create an Itinerary Presentation in the PowerPoint Web App |
|
|
291 | (1) |
|
Activity Creating an Itinerary Presentation in the PowerPoint Web App |
|
|
291 | (2) |
|
GO! with Microsoft Office 365 |
|
|
293 | (1) |
|
Activity Using the Exchange Online Outlook Meeting Tool to Collaborate |
|
|
293 | (1) |
|
Summary, GO! Learn It Online, GO! for Job Success |
|
|
294 | (1) |
|
Guide to Chapter Assessments |
|
|
295 | (1) |
|
|
296 | (1) |
|
|
297 | (6) |
|
|
303 | (7) |
|
|
310 | (1) |
|
|
311 | |
Glossary |
|
1 | (1) |
Index |
|
1 | |