The Go! System Visual Walk-Through |
|
xxiii | |
|
|
|
Creating Documents with Microsoft Word 2007 |
|
|
1 | (70) |
|
|
3 | (22) |
|
Create and Save a New Document |
|
|
4 | (1) |
|
Starting Word and Identifying Parts of the Word Window |
|
|
4 | (1) |
|
Beginning a New Document and Displaying Formatting Marks |
|
|
5 | (1) |
|
Entering Text and Inserting Blank Lines |
|
|
6 | (3) |
|
Creating Folders for Document Storage and Saving a Document |
|
|
9 | (4) |
|
|
13 | (1) |
|
Editing Text with the Delete and Backspace Keys |
|
|
13 | (1) |
|
|
14 | (1) |
|
Select, Delete, and Format Text |
|
|
15 | (1) |
|
Selecting and Deleting Text |
|
|
15 | (3) |
|
Changing Font and Font Size |
|
|
18 | (2) |
|
|
20 | (1) |
|
|
21 | (1) |
|
Accessing Headers and Footers |
|
|
21 | (2) |
|
|
23 | (2) |
|
|
25 | (46) |
|
|
26 | (1) |
|
Opening and Closing an Existing Document |
|
|
26 | (1) |
|
Inserting Existing Text into a New Document |
|
|
26 | (2) |
|
|
28 | (3) |
|
|
31 | (1) |
|
|
31 | (2) |
|
Splitting Windows and Arranging Panes |
|
|
33 | (2) |
|
Add a Graphic to a Document |
|
|
35 | (1) |
|
|
35 | (2) |
|
Use the Spelling and Grammar Checker |
|
|
37 | (1) |
|
Checking Individual Spelling and Grammar Errors |
|
|
38 | (1) |
|
Checking Spelling and Grammar in an Entire Document |
|
|
39 | (4) |
|
Preview and Print Documents, Close a Document, and Close Word |
|
|
43 | (1) |
|
Previewing and Printing a Document |
|
|
43 | (3) |
|
Closing a Document and Closing Word |
|
|
46 | (1) |
|
Use the Microsoft Help System |
|
|
46 | (1) |
|
|
46 | (2) |
|
|
48 | (1) |
|
|
49 | (1) |
|
|
49 | (1) |
|
|
50 | (1) |
|
|
51 | (1) |
|
|
52 | (6) |
|
|
58 | (7) |
|
|
65 | (1) |
|
|
66 | (5) |
|
More on your Student CD Content-Based Assessments |
|
|
|
Project L Mastering Word / Project M Mastering Word / Project N Business Running Case |
|
|
|
Outcome-Based Assessments |
|
|
|
Project O Problem Solving / Project P Problem Solving / Project Q You and Go! / Project R Go! with Help / Project S Group Business Running Case |
|
|
|
Formatting and Organizing Text |
|
|
71 | (74) |
|
|
73 | (28) |
|
Change Document and Paragraph Layout |
|
|
74 | (1) |
|
|
74 | (2) |
|
|
76 | (2) |
|
|
78 | (2) |
|
Adding Space After Paragraphs |
|
|
80 | (1) |
|
|
81 | (2) |
|
Change and Reorganize Text |
|
|
83 | (1) |
|
Finding and Replacing Text |
|
|
84 | (1) |
|
Cutting, Copying, and Pasting Text |
|
|
85 | (3) |
|
Moving Text to a New Location |
|
|
88 | (2) |
|
Undoing and Redoing Changes |
|
|
90 | (1) |
|
Inserting Nonbreaking Spaces and Hyphens |
|
|
91 | (1) |
|
|
92 | (1) |
|
|
93 | (1) |
|
|
93 | (1) |
|
Using AutoFormat to Create a Numbered List |
|
|
94 | (2) |
|
|
96 | (2) |
|
|
98 | (3) |
|
|
101 | (44) |
|
Insert and Format Headers and Footers |
|
|
102 | (1) |
|
Inserting and Formatting Page Numbers |
|
|
102 | (2) |
|
Inserting the Current Date and Time |
|
|
104 | (1) |
|
Insert Frequently Used Text |
|
|
105 | (1) |
|
Recording AutoCorrect Entries |
|
|
106 | (3) |
|
|
109 | (2) |
|
Insert and Format References |
|
|
111 | (1) |
|
|
111 | (2) |
|
Modifying a Footnote Style |
|
|
113 | (2) |
|
|
115 | (4) |
|
Creating a Reference Page |
|
|
119 | (1) |
|
Managing Document Properties |
|
|
120 | (1) |
|
|
121 | (1) |
|
|
122 | (1) |
|
|
122 | (1) |
|
|
123 | (1) |
|
|
124 | (1) |
|
|
125 | (7) |
|
|
132 | (8) |
|
|
140 | (1) |
|
|
141 | (4) |
|
More on your Student CD Content-Based Assessments |
|
|
|
Project L Mastering Word / Project M Mastering Word / Project N Business Running Case |
|
|
|
Outcome-Based Assessments |
|
|
|
Project O Problem Solving / Project P Problem Solving / Project Q You and Go! / Project R Go! with Help / Project S Group Business Running Case |
|
|
|
Using Graphics and Tables |
|
|
145 | (68) |
|
|
147 | (24) |
|
Insert and Format Graphics |
|
|
148 | (1) |
|
Formatting Text Using WordArt |
|
|
148 | (2) |
|
Inserting Pictures from Files |
|
|
150 | (1) |
|
|
151 | (1) |
|
Wrapping Text Around a Graphic |
|
|
152 | (2) |
|
|
154 | (1) |
|
|
154 | (2) |
|
|
156 | (1) |
|
|
157 | (1) |
|
Setting Tab Stops and Using Click and Type |
|
|
157 | (3) |
|
Formatting and Removing Tab Stops |
|
|
160 | (2) |
|
Using Tab Stops to Enter Text |
|
|
162 | (2) |
|
|
164 | (1) |
|
Insert and Modify Text Boxes and Shapes |
|
|
165 | (1) |
|
|
165 | (1) |
|
Moving, Resizing, and Formatting a Text Box |
|
|
166 | (2) |
|
Inserting a Predefined Shape |
|
|
168 | (3) |
|
|
171 | (42) |
|
|
172 | (1) |
|
Creating and Entering Text |
|
|
172 | (2) |
|
|
174 | (1) |
|
Changing the Width of a Table Column |
|
|
174 | (1) |
|
Adding a Column to a Table |
|
|
175 | (2) |
|
Converting Text to Tables |
|
|
177 | (2) |
|
|
179 | (1) |
|
Formatting Text in Cells and Shading Cells |
|
|
179 | (2) |
|
Changing the Table Border |
|
|
181 | (2) |
|
|
183 | (1) |
|
|
183 | (1) |
|
Applying a Predefined Format to a Table |
|
|
184 | (3) |
|
|
187 | (1) |
|
|
188 | (1) |
|
|
188 | (1) |
|
|
189 | (1) |
|
|
190 | (1) |
|
|
191 | (7) |
|
|
198 | (10) |
|
|
208 | (1) |
|
|
209 | (4) |
|
More on your Student CD Content-Based Assessments |
|
|
|
Project L Mastering Word / Project M Mastering Word / Project N Business Running Case |
|
|
|
Outcome-Based Assessments |
|
|
|
Project O Problem Solving / Project P Problem Solving / Project Q You and Go! / Project R Go! with Help / Project S Group Business Running Case |
|
|
|
Special Document Formats, Columns, and Mail Merge |
|
|
213 | (60) |
|
|
215 | (21) |
|
Collect and Paste Text and Graphics |
|
|
216 | (1) |
|
Using Collect and Paste to Gather Images and Text |
|
|
216 | (3) |
|
Pasting Information from the Clipboard Task Pane |
|
|
219 | (1) |
|
Create and Format Columns |
|
|
220 | (1) |
|
Changing One Column of Text to Two Columns |
|
|
220 | (1) |
|
Formatting Multiple Columns |
|
|
221 | (1) |
|
|
222 | (2) |
|
Adding Graphics to Columns |
|
|
224 | (1) |
|
Use Special Character and Paragraph Formatting |
|
|
225 | (1) |
|
Using Small Caps and Changing the Font Color |
|
|
225 | (2) |
|
Adding a Border and Shading to a Paragraph |
|
|
227 | (1) |
|
Create Mailing Labels Using Mail Merge |
|
|
228 | (1) |
|
Opening the Mail Merge Wizard Template |
|
|
229 | (2) |
|
Completing the Mail Merge Wizard |
|
|
231 | (4) |
|
Previewing and Printing the Mail Merge Document |
|
|
235 | (1) |
|
|
236 | (37) |
|
|
237 | (1) |
|
Inserting Text Hyperlinks |
|
|
237 | (1) |
|
Adding a Hyperlink to a Graphic |
|
|
238 | (2) |
|
Testing and Modifying Hyperlinks |
|
|
240 | (1) |
|
Insert a SmartArt Graphic |
|
|
241 | (1) |
|
Inserting a SmartArt Graphic |
|
|
241 | (1) |
|
Adding Text to a SmartArt Graphic |
|
|
242 | (2) |
|
Preview and Save a Document as a Web Page |
|
|
244 | (1) |
|
Previewing a Document as a Web Page |
|
|
244 | (2) |
|
Saving a Document as a Web Page |
|
|
246 | (1) |
|
|
247 | (1) |
|
|
248 | (1) |
|
|
248 | (1) |
|
|
249 | (1) |
|
|
250 | (1) |
|
|
251 | (7) |
|
|
258 | (9) |
|
|
267 | (1) |
|
|
268 | (5) |
|
More on your Student CD Content-Based Assessments |
|
|
|
Project L Mastering Word / Project M Mastering Word / Project N Business Running Case |
|
|
|
Outcome-Based Assessments |
|
|
|
Project O Problem Solving / Project P Problem Solving / Project Q You and Go! / Project R Go! with Help / Project S Group Business Running Case |
|
|
|
|
|
Creating a Worksheet and Charting Data |
|
|
273 | (98) |
|
|
275 | (51) |
|
Create, Save, and Navigate an Excel Workbook |
|
|
276 | (1) |
|
Starting Excel and Naming and Saving a Workbook |
|
|
276 | (3) |
|
Navigating a Worksheet and a Workbook |
|
|
279 | (3) |
|
Selecting Parts of a Worksheet |
|
|
282 | (3) |
|
Enter and Edit Data in a Worksheet |
|
|
285 | (1) |
|
Entering Text, Using AutoComplete, Filling a Series with Auto Fill, and Using Spelling Checker and Undo to Correct Typing Errors |
|
|
285 | (5) |
|
Aligning Text and Adjusting the Size of Columns and Rows |
|
|
290 | (2) |
|
|
292 | (3) |
|
Inserting and Deleting Rows and Columns, and Using the Insert Options Button |
|
|
295 | (2) |
|
Construct and Copy Formulas, Use the Sum Function, and Edit Cells |
|
|
297 | (1) |
|
Constructing a Formula, Using the Sum Function, and Editing Numbers in Cells |
|
|
297 | (5) |
|
Copying a Formula by Using the Fill Handle |
|
|
302 | (2) |
|
Format Data, Cells, and Worksheets |
|
|
304 | (1) |
|
Formatting Financial Numbers, Using Column AutoFit, and Using Format Painter |
|
|
304 | (5) |
|
Formatting Text and Using Merge and Center |
|
|
309 | (2) |
|
Close and Reopen a Workbook |
|
|
311 | (1) |
|
Closing and Reopening an Existing Workbook |
|
|
311 | (1) |
|
|
312 | (1) |
|
|
312 | (7) |
|
Use Page Layout View, Prepare a Worksheet for Printing, and Close Excel |
|
|
319 | (1) |
|
Changing Views, Creating a Footer, and Using Print Preview |
|
|
320 | (2) |
|
Deleting Unused Sheets in a Workbook |
|
|
322 | (1) |
|
|
323 | (1) |
|
Displaying, Printing, and Hiding Formulas |
|
|
323 | (3) |
|
|
326 | (45) |
|
|
327 | (1) |
|
Setting Column Widths and Creating Row and Column Titles |
|
|
327 | (2) |
|
|
329 | (1) |
|
Construct Formulas for Mathematical Operations |
|
|
330 | (1) |
|
Using Arithmetic Operators |
|
|
330 | (2) |
|
Copying Formulas Containing Absolute Cell References |
|
|
332 | (3) |
|
Format Percentages and Move Formulas |
|
|
335 | (1) |
|
Formatting Cells with the Percent Style Button |
|
|
335 | (1) |
|
Inserting Rows in a Worksheet Containing Formulas and Wrapping Text in a Cell |
|
|
336 | (2) |
|
Create a Pie Chart and a Chart Sheet |
|
|
338 | (1) |
|
Creating a Pie Chart and a Chart Sheet |
|
|
338 | (3) |
|
Use the Excel Help System |
|
|
341 | (1) |
|
Using the Excel Help System |
|
|
341 | (1) |
|
|
341 | (1) |
|
|
342 | (1) |
|
|
342 | (2) |
|
|
344 | (1) |
|
|
345 | (2) |
|
|
347 | (8) |
|
|
355 | (11) |
|
|
366 | (1) |
|
|
367 | (4) |
|
More on your Student CD Content-Based Assessments |
|
|
|
Project L Mastering Word / Project M Mastering Word / Project N Business Running Case |
|
|
|
Outcome-Based Assessments |
|
|
|
Project O Problem Solving / Project P Problem Solving / Project Q You and Go! / Project R Go! with Help / Project S Group Business Running Case |
|
|
|
Managing Workbooks and Analyzing Data |
|
|
371 | (74) |
|
|
373 | (28) |
|
Create and Save a Workbook from an Existing Workbook |
|
|
374 | (1) |
|
Creating and Saving a Workbook from an Existing Workbook |
|
|
374 | (1) |
|
Navigate a Workbook and Rename Worksheets |
|
|
374 | (1) |
|
Navigating Among Worksheets, Renaming Worksheets, and Changing the Tab Color of a Worksheet |
|
|
374 | (2) |
|
Enter Dates, Clear Contents, and Clear Formats |
|
|
376 | (1) |
|
Entering and Formatting Dates |
|
|
377 | (2) |
|
Clearing Cell Contents and Formats |
|
|
379 | (1) |
|
Move, Copy, and Paste Cell Contents |
|
|
380 | (3) |
|
Copying, Pasting, and Moving Cell Contents |
|
|
383 | (1) |
|
Edit and Format Multiple Worksheets at the Same Time |
|
|
383 | (1) |
|
Wrapping Text in a Cell in Several Worksheets at the Same Time |
|
|
383 | (3) |
|
Entering Data and Constructing Formulas on Multiple Worksheets |
|
|
386 | (7) |
|
|
393 | (1) |
|
Constructing Formulas that Refer to Cells in Another Worksheet |
|
|
394 | (3) |
|
Format and Print Multiple Worksheets in a Workbook |
|
|
397 | (1) |
|
Moving and Formatting Worksheets in a Workbook |
|
|
397 | (2) |
|
Printing All the Worksheets in a Workbook |
|
|
399 | (2) |
|
|
401 | (44) |
|
Design a Worksheet for What-If Analysis |
|
|
402 | (1) |
|
Using Parentheses in a Formula |
|
|
402 | (3) |
|
|
405 | (1) |
|
Calculating a Value After an Increase |
|
|
406 | (2) |
|
|
408 | (1) |
|
Performing What-If Analysis and Using Paste Special |
|
|
408 | (4) |
|
Compare Data with a Line Chart |
|
|
412 | (1) |
|
|
412 | (5) |
|
|
417 | (1) |
|
|
418 | (1) |
|
|
418 | (1) |
|
|
419 | (1) |
|
|
420 | (1) |
|
|
421 | (8) |
|
|
429 | (10) |
|
|
439 | (1) |
|
|
440 | (5) |
|
More on your Student CD Content-Based Assessments |
|
|
|
Project L Mastering Word / Project M Mastering Word / Project N Business Running Case |
|
|
|
Outcome-Based Assessments |
|
|
|
Project O Problem Solving / Project P Problem Solving / Project Q You and Go! / Project R Go! with Help / Project S Group Business Running Case |
|
|
|
Using Functions and Tables |
|
|
445 | (74) |
|
|
447 | (28) |
|
Use Sum, Average, Median, Min, and Max Functions |
|
|
448 | (1) |
|
Using the Sum, Average, and Median Functions |
|
|
448 | (5) |
|
Using the Min and Max Functions |
|
|
453 | (1) |
|
Moving Data, Adding Borders, and Rotating Text |
|
|
454 | (2) |
|
Use Countif and If Functions, and Apply Conditional Formatting |
|
|
456 | (1) |
|
Using the Countif Function |
|
|
456 | (1) |
|
Using the If Function and Applying Conditional Formatting |
|
|
457 | (3) |
|
Applying Conditional Formatting Using Custom Formats and Data Bars |
|
|
460 | (2) |
|
|
462 | (1) |
|
|
463 | (1) |
|
|
463 | (1) |
|
Freeze Panes and Create an Excel Table |
|
|
464 | (1) |
|
Freezing and Unfreezing Panes |
|
|
465 | (1) |
|
Sorting and Filtering in an Excel Table |
|
|
466 | (3) |
|
Inserting a Second Table in a Worksheet |
|
|
469 | (2) |
|
Converting a Table to a Range of Data |
|
|
471 | (1) |
|
Format and Print a Large Worksheet |
|
|
472 | (1) |
|
Printing Large Worksheets |
|
|
472 | (3) |
|
|
475 | (44) |
|
|
476 | (1) |
|
Designing a Loan Worksheet |
|
|
476 | (1) |
|
Inserting the PMT Financial Function |
|
|
477 | (2) |
|
|
479 | (1) |
|
Using Goal Seek to Produce the Desired Result |
|
|
479 | (2) |
|
Using Goal Seek to Find an Increased Period |
|
|
481 | (1) |
|
|
482 | (1) |
|
Designing a Two-Variable Data Table |
|
|
483 | (2) |
|
Using a Data Table to Calculate Options |
|
|
485 | (4) |
|
|
489 | (1) |
|
|
490 | (1) |
|
|
490 | (1) |
|
|
491 | (1) |
|
|
492 | (2) |
|
|
494 | (8) |
|
|
502 | (11) |
|
|
513 | (1) |
|
|
514 | (5) |
|
More on your Student CD Content-Based Assessments |
|
|
|
Project L Mastering Word / Project M Mastering Word / Project N Business Running Case |
|
|
|
Outcome-Based Assessments |
|
|
|
Project O Problem Solving / Project P Problem Solving / Project Q You and Go! / Project R Go! with Help / Project S Group Business Running Case |
|
|
|
|
|
Getting Started with Access Databases and Tables |
|
|
519 | (82) |
|
Doctor and Patient Contact Information |
|
|
521 | (36) |
|
Start Access and Create a New Blank Database |
|
|
522 | (1) |
|
Starting Access, Creating and Naming a Folder, and Creating a Database from a New Blank Database |
|
|
522 | (5) |
|
|
527 | (1) |
|
Adding Records to a Table |
|
|
528 | (3) |
|
Rename Table Fields in Datasheet View |
|
|
531 | (1) |
|
Renaming the Fields in a Table in Datasheet View |
|
|
531 | (1) |
|
Changing the Data Type of a Field in Datasheet View |
|
|
532 | (4) |
|
Modify the Design of a Table |
|
|
536 | (1) |
|
Deleting a Field in Design View |
|
|
536 | (2) |
|
Modifying a Field Size and Description in Design View |
|
|
538 | (1) |
|
Setting a Primary Key and Saving a Table |
|
|
539 | (1) |
|
Add a Second Table to a Database |
|
|
540 | (1) |
|
Adding a Second Table to a Database |
|
|
541 | (1) |
|
Adding Records to a Second Table |
|
|
542 | (1) |
|
|
543 | (1) |
|
Adjusting Column Widths and Printing a Table |
|
|
543 | (6) |
|
|
549 | (1) |
|
Using the Simple Query Wizard to Create a Query |
|
|
549 | (3) |
|
|
552 | (1) |
|
|
553 | (1) |
|
Create and Print a Report |
|
|
554 | (1) |
|
Creating and Printing a Report |
|
|
555 | (1) |
|
Close and Save a Database |
|
|
556 | (1) |
|
Closing and Saving a Database |
|
|
556 | (1) |
|
|
557 | (44) |
|
Create a Database Using a Template |
|
|
558 | (1) |
|
Creating a New Database Using a Template |
|
|
558 | (1) |
|
Building a Table by Entering Records in a Multiple Items Form |
|
|
559 | (3) |
|
Organize Database Objects in the Navigation Pane |
|
|
562 | (1) |
|
Organizing Database Objects in the Navigation Pane |
|
|
562 | (3) |
|
Create a New Table in a Database Created with a Template |
|
|
565 | (1) |
|
Creating a New Table and Changing Its Design |
|
|
565 | (3) |
|
View a Report and Print a Table in a Database Created with a Template |
|
|
568 | (1) |
|
|
568 | (1) |
|
|
569 | (1) |
|
Use the Access Help System |
|
|
570 | (1) |
|
Using the Access Help System |
|
|
570 | (1) |
|
|
571 | (1) |
|
|
572 | (1) |
|
|
572 | (1) |
|
|
573 | (1) |
|
|
574 | (1) |
|
|
575 | (9) |
|
|
584 | (11) |
|
|
595 | (1) |
|
|
596 | (5) |
|
More on your Student CD Content-Based Assessments |
|
|
|
Project L Mastering Word / Project M Mastering Word / Project N Business Running Case |
|
|
|
Outcome-Based Assessments |
|
|
|
Project O Problem Solving / Project P Problem Solving / Project Q You and Go! / Project R Go! with Help / Project S Group Business Running Case |
|
|
|
Sort and Query a Database |
|
|
601 | (88) |
|
|
603 | (29) |
|
Open an Existing Database |
|
|
604 | (1) |
|
Renaming and Opening an Existing Database |
|
|
604 | (1) |
|
Opening an Existing Database and Resolving Security Alerts |
|
|
605 | (1) |
|
Create Table Relationships |
|
|
606 | (1) |
|
Creating Table Relationships and Enforcing Referential Integrity |
|
|
606 | (4) |
|
Printing a Relationship Report |
|
|
610 | (2) |
|
|
612 | (1) |
|
Sorting Records in a Table in Ascending or Descending Order |
|
|
612 | (2) |
|
Sorting Records in a Table on Multiple Fields |
|
|
614 | (1) |
|
Create a Query in Design View |
|
|
615 | (1) |
|
Creating a New Select Query in Design View |
|
|
615 | (3) |
|
Running, Saving, Printing, and Closing a Query |
|
|
618 | (1) |
|
Create a New Query from an Existing Query |
|
|
619 | (1) |
|
Creating a New Query From an Existing Query |
|
|
619 | (3) |
|
|
622 | (1) |
|
|
622 | (2) |
|
Specify Criteria in a Query |
|
|
624 | (1) |
|
Specifying Text Criteria in a Query |
|
|
625 | (2) |
|
Specifying Criteria Using a Field Not Displayed in the Query Result |
|
|
627 | (2) |
|
Using Is Null Criteria to Find Empty Fields |
|
|
629 | (3) |
|
Athletes and Scholarships |
|
|
632 | (57) |
|
Create a New Table by Importing an Excel Spreadsheet |
|
|
633 | (1) |
|
Opening an Existing Database and Preparing to Import an Excel Spreadsheet |
|
|
633 | (2) |
|
Creating a New Table by Importing an Excel Spreadsheet |
|
|
635 | (3) |
|
Specify Numeric Criteria in a Query |
|
|
638 | (1) |
|
Specifying Numeric Criteria in a Query |
|
|
638 | (2) |
|
Using Comparison Operators |
|
|
640 | (2) |
|
Using the Between... And Comparison Operator |
|
|
642 | (1) |
|
|
643 | (1) |
|
Using And Criteria in a Query |
|
|
643 | (1) |
|
Using Or Criteria in a Query |
|
|
644 | (2) |
|
Create a Query Based on More Than One Table |
|
|
646 | (1) |
|
Creating a Query Based on More Than One Table |
|
|
646 | (3) |
|
|
649 | (1) |
|
Using a Wildcard in a Query |
|
|
649 | (2) |
|
Use Calculated Fields in a Query |
|
|
651 | (1) |
|
Using Calculated Fields in a Query |
|
|
652 | (3) |
|
Group Data and Calculate Statistics in a Query |
|
|
655 | (1) |
|
Using the Min, Max, Avg and Sum Functions in a Query |
|
|
655 | (2) |
|
|
657 | (2) |
|
|
659 | (1) |
|
|
660 | (1) |
|
|
660 | (1) |
|
|
661 | (1) |
|
|
662 | (1) |
|
|
663 | (10) |
|
|
673 | (10) |
|
|
683 | (1) |
|
|
684 | (5) |
|
More on your Student CD Content-Based Assessments |
|
|
|
Project L Mastering Word / Project M Mastering Word / Project N Business Running Case |
|
|
|
Outcome-Based Assessments |
|
|
|
Project O Problem Solving / Project P Problem Solving / Project Q You and Go! / Project R Go! with Help / Project S Group Business Running Case |
|
|
|
Forms, Filters, and Reports |
|
|
689 | (82) |
|
|
691 | (27) |
|
|
692 | (1) |
|
|
692 | (3) |
|
Use a Form to Add and Delete Records |
|
|
695 | (1) |
|
Adding Records to a Table by Using a Form |
|
|
695 | (2) |
|
Deleting Records from a Table by Using a Form |
|
|
697 | (1) |
|
|
698 | (1) |
|
Create a Form by Using the Form Wizard |
|
|
699 | (1) |
|
Creating a Form by Using the Form Wizard |
|
|
700 | (1) |
|
Modify a Form in Design View and in Layout View |
|
|
701 | (1) |
|
Modifying a Form in Design View |
|
|
701 | (4) |
|
Adding, Resizing, and Moving Controls in Layout View |
|
|
705 | (3) |
|
Formatting and Aligning Controls in Layout View |
|
|
708 | (4) |
|
|
712 | (1) |
|
Filtering Data by Selection on One Field |
|
|
712 | (2) |
|
|
714 | (4) |
|
Employers and Job Openings |
|
|
718 | (53) |
|
Create a Report by Using the Report Tool |
|
|
719 | (1) |
|
Creating and Modifying a Report Using the Report Tool and Layout View |
|
|
719 | (3) |
|
Create a Report by Using the Blank Report Tool |
|
|
722 | (1) |
|
Creating a Report by Using the Blank Report Tool |
|
|
722 | (3) |
|
Create a Report by Using the Report Wizard |
|
|
725 | (1) |
|
Creating a Report by Using the Report Wizard |
|
|
725 | (4) |
|
Modify the Design of a Report |
|
|
729 | (1) |
|
Modifying a Report in Layout View |
|
|
729 | (4) |
|
Modifying a Report in Design View |
|
|
733 | (3) |
|
Print a Report and Keep Data Together |
|
|
736 | (1) |
|
Keeping Data Together and Printing a Report |
|
|
736 | (3) |
|
|
739 | (1) |
|
|
740 | (1) |
|
|
740 | (1) |
|
|
741 | (1) |
|
|
742 | (1) |
|
|
743 | (10) |
|
|
753 | (1) |
|
|
753 | (1) |
|
|
754 | (17) |
|
More on your Student CD Content-Based Assessments |
|
|
|
Project L Mastering Word / Project M Mastering Word / Project N Business Running Case |
|
|
|
Outcome-Based Assessments |
|
|
|
Project O Problem Solving / Project P Problem Solving / Project Q You and Go! / Project R Go! with Help / Project S Group Business Running Case |
|
|
|
|
|
Getting Started with Microsoft PowerPoint 2007 |
|
|
771 | (64) |
|
|
773 | (26) |
|
Open, View, and Save a Presentation |
|
|
774 | (1) |
|
Starting PowerPoint and Identifying Parts of the PowerPoint Window |
|
|
774 | (1) |
|
|
775 | (2) |
|
|
777 | (1) |
|
Creating Folders and Saving a Presentation |
|
|
778 | (2) |
|
|
780 | (1) |
|
|
780 | (1) |
|
|
781 | (1) |
|
Increasing and Decreasing List Levels |
|
|
782 | (2) |
|
|
784 | (2) |
|
Editing Text by Using the Thesaurus |
|
|
786 | (1) |
|
Adding Speaker's Notes to a Presentation |
|
|
787 | (1) |
|
|
788 | (1) |
|
Changing Font and Font Size |
|
|
788 | (2) |
|
|
790 | (1) |
|
Aligning Text and Changing Line Spacing |
|
|
791 | (1) |
|
|
791 | (2) |
|
Changing the Presentation Theme |
|
|
793 | (2) |
|
Create Headers and Footers and Print a Presentation |
|
|
795 | (1) |
|
Creating Headers and Footers |
|
|
795 | (1) |
|
Previewing and Printing a Presentation and Closing PowerPoint |
|
|
796 | (3) |
|
|
799 | (36) |
|
Create a New Presentation |
|
|
800 | (1) |
|
Starting a New Presentation |
|
|
800 | (2) |
|
Inserting Slides from an Existing Presentation |
|
|
802 | (3) |
|
|
805 | (1) |
|
Selecting and Deleting Slides |
|
|
805 | (1) |
|
|
806 | (1) |
|
Add Pictures to a Presentation |
|
|
806 | (1) |
|
|
806 | (3) |
|
|
809 | (2) |
|
Applying a Style to a Picture |
|
|
811 | (1) |
|
Use the Microsoft Help System |
|
|
812 | (1) |
|
Accessing PowerPoint Help |
|
|
812 | (1) |
|
|
813 | (1) |
|
|
814 | (1) |
|
|
814 | (1) |
|
|
815 | (1) |
|
|
816 | (1) |
|
|
817 | (6) |
|
|
823 | (7) |
|
|
830 | (1) |
|
|
831 | (4) |
|
More on your Student CD Content-Based Assessments |
|
|
|
Project L Mastering Word / Project M Mastering Word / Project N Business Running Case |
|
|
|
Outcome-Based Assessments |
|
|
|
Project O Problem Solving / Project P Problem Solving / Project Q You and Go! / Project R Go! with Help / Project S Group Business Running Case |
|
|
|
Designing a PowerPoint Presentation |
|
|
835 | (70) |
|
|
837 | (24) |
|
|
838 | (1) |
|
Selecting Placeholder Text and Using the Repeat Key |
|
|
838 | (2) |
|
Changing a Bulleted List to a Numbered List |
|
|
840 | (1) |
|
Modifying the Bulleted List Style |
|
|
840 | (2) |
|
Applying WordArt Styles to Text |
|
|
842 | (2) |
|
|
844 | (1) |
|
Insert and Format Pictures and Shapes |
|
|
845 | (1) |
|
Inserting a Picture Using a Content Layout |
|
|
845 | (1) |
|
Changing the Size and Shape of a Picture |
|
|
846 | (2) |
|
Inserting and Positioning a Text Box |
|
|
848 | (3) |
|
Inserting, Sizing, and Positioning Shapes |
|
|
851 | (1) |
|
|
852 | (1) |
|
Applying Shape and Picture Styles and Effects |
|
|
853 | (2) |
|
Duplicating and Aligning Objects |
|
|
855 | (3) |
|
|
858 | (1) |
|
Applying Slide Transitions to a Presentation |
|
|
858 | (3) |
|
|
861 | (44) |
|
Reorganize Presentation Text and Clear Formats |
|
|
862 | (1) |
|
|
862 | (2) |
|
Copying Multiple Selections by Using the Office Clipboard |
|
|
864 | (2) |
|
Undoing and Redoing Changes |
|
|
866 | (1) |
|
Clearing Formatting from a Selection |
|
|
867 | (1) |
|
Create and Format a SmartArt Graphic |
|
|
867 | (1) |
|
Creating a SmartArt Diagram by Using a Content Layout |
|
|
867 | (3) |
|
Adding and Removing Shapes in a Diagram |
|
|
870 | (2) |
|
Changing the Diagram Type and Size |
|
|
872 | (3) |
|
Creating a SmartArt Diagram from Bullet Points |
|
|
875 | (1) |
|
Changing the Color and Style of a Diagram |
|
|
875 | (2) |
|
|
877 | (1) |
|
|
878 | (1) |
|
|
878 | (1) |
|
|
879 | (1) |
|
|
880 | (1) |
|
|
881 | (7) |
|
|
888 | (11) |
|
|
899 | (1) |
|
|
900 | (5) |
|
More on your Student CD Content-Based Assessments |
|
|
|
Project L Mastering Word / Project M Mastering Word / Project N Business Running Case |
|
|
|
Outcome-Based Assessments |
|
|
|
Project O Problem Solving / Project P Problem Solving / Project Q You and Go! / Project R Go! with Help / Project S Group Business Running Case |
|
|
|
Enhancing a Presentation with Animation, Tables, and Charts |
|
|
905 | (62) |
|
|
907 | (16) |
|
Customize Slide Backgrounds and Themes |
|
|
908 | (1) |
|
Applying a Background Style |
|
|
908 | (1) |
|
Hiding Background Graphics |
|
|
909 | (1) |
|
Formatting a Slide Background with a Picture |
|
|
910 | (4) |
|
Applying a Background Fill Color and Resetting a Slide Background |
|
|
914 | (1) |
|
|
914 | (2) |
|
|
916 | (1) |
|
Applying Entrance Effects |
|
|
916 | (2) |
|
Setting Effect and Timing Options |
|
|
918 | (3) |
|
Applying Animation to a SmartArt Graphic |
|
|
921 | (2) |
|
|
923 | (44) |
|
|
924 | (1) |
|
|
924 | (2) |
|
Modifying the Layout of a Table |
|
|
926 | (3) |
|
|
929 | (2) |
|
|
931 | (1) |
|
Creating a Column Chart and Applying a Chart Style |
|
|
931 | (4) |
|
Deleting Chart Data and Changing the Chart Type |
|
|
935 | (2) |
|
|
937 | (1) |
|
|
938 | (1) |
|
|
939 | (1) |
|
|
939 | (1) |
|
|
940 | (1) |
|
|
941 | (1) |
|
|
942 | (8) |
|
|
950 | (10) |
|
|
960 | (1) |
|
|
961 | (6) |
|
More on your Student CD Content-Based Assessments |
|
|
|
Project L Mastering Word / Project M Mastering Word / Project N Business Running Case |
|
|
|
Outcome-Based Assessments |
|
|
|
Project O Problem Solving / Project P Problem Solving / Project Q You and Go! / Project R Go! with Help / Project S Group Business Running Case |
|
|
|
|
|
Using Access Data with Other Office Programs |
|
|
967 | (12) |
|
|
969 | (10) |
|
Export Access Data to Excel |
|
|
970 | (1) |
|
Exporting Access Data to Excel |
|
|
970 | (1) |
|
Create a Formula in Excel |
|
|
971 | (1) |
|
Creating a Formula for Calculation in Excel |
|
|
971 | (1) |
|
|
972 | (1) |
|
Creating a Chart in Excel |
|
|
972 | (2) |
|
Copy Access Data into a Word Document |
|
|
974 | (1) |
|
Copying Access Data to a Word Document |
|
|
974 | (1) |
|
Copy Excel Data into a Word Document |
|
|
975 | (1) |
|
Copying Excel Data to a Word Document |
|
|
975 | (1) |
|
Insert an Excel Chart into a PowerPoint Presentation |
|
|
976 | (1) |
|
Adding an Excel Chart to a PowerPoint Presentation |
|
|
976 | (3) |
|
Using Tables in Word and Excel |
|
|
979 | (10) |
|
|
981 | (8) |
|
|
982 | (1) |
|
Starting Word and Planning the Table |
|
|
982 | (1) |
|
Enter Data and Format a Table in Word |
|
|
983 | (1) |
|
|
983 | (1) |
|
|
984 | (1) |
|
Create a Table in Word from Excel Data |
|
|
985 | (1) |
|
Creating a Table in Word from Excel Data |
|
|
985 | (1) |
|
Create an Excel Worksheet from a Word Table |
|
|
986 | (1) |
|
Creating an Excel Worksheet from a Word Table |
|
|
986 | (3) |
|
Using Excel as a Data Source in a Mail Merge |
|
|
989 | (8) |
|
|
991 | (6) |
|
Prepare a Mail Merge Document for Mailing Labels |
|
|
992 | (1) |
|
Setting up Mailing Labels Using the Mailings Tab |
|
|
992 | (1) |
|
Choose an Excel Worksheet as a Data Source |
|
|
993 | (1) |
|
Selecting the Data Source for the Mailing Labels |
|
|
993 | (1) |
|
Produce and Save Merged Mailing Labels |
|
|
994 | (1) |
|
Adding Merge Fields to the Mailing Labels |
|
|
994 | (1) |
|
Producing the Mailing Labels |
|
|
995 | (1) |
|
Open a Saved Main Document for Mail Merge |
|
|
995 | (1) |
|
Opening a Main Document for Mail Merge |
|
|
995 | (2) |
|
Linking Data in Office Documents |
|
|
997 | (8) |
|
|
999 | (6) |
|
Insert and Link an Excel Object in Word |
|
|
1000 | (1) |
|
Inserting and Linking an Excel Object |
|
|
1000 | (1) |
|
Revise a Linked Excel Worksheet and Update Links in Word |
|
|
1001 | (1) |
|
Revising a Linked Worksheet and Updating Links in a Document |
|
|
1001 | (1) |
|
Open a Word Document That Includes a Linked Object and Update Links |
|
|
1002 | (1) |
|
Opening a Word Document That Includes a Linked Object |
|
|
1002 | (1) |
|
|
1002 | (3) |
|
Creating Presentation Content from Office Documents |
|
|
1005 | |
|
|
1007 | |
|
Insert a Word Outline into PowerPoint |
|
|
1008 | (1) |
|
Inserting a Word Outline into PowerPoint |
|
|
1008 | (1) |
|
Import Excel Data into a PowerPoint Chart |
|
|
1009 | (1) |
|
Importing Excel Data into a Chart in PowerPoint |
|
|
1009 | (3) |
|
Insert a Hyperlink into a PowerPoint Slide |
|
|
1012 | (1) |
|
Inserting a Hyperlink into a PowerPoint Slide |
|
|
1012 | |
Glossary |
|
1 | (1) |
Index |
|
1 | |