Go! Walkthrough |
|
xviii | |
|
|
|
Chapter 1 Using the Common Features of Microsoft office 2010 |
|
|
1 | (48) |
|
Project 1A PowerPoint File |
|
|
2 | (19) |
|
Objective 1 Use Windows Explorer to Locate Files and Folders |
|
|
3 | (1) |
|
Activity 1.01 Using Windows Explorer to Locate Files and Folders |
|
|
3 | (3) |
|
Objective 2 Locate and Start a Microsoft Office 2010 Program |
|
|
6 | (1) |
|
Activity 1.02 Locating and Starting a Microsoft Office 2010 Program |
|
|
6 | (3) |
|
Objective 3 Enter and Edit Text in an Office 2010 Program |
|
|
9 | (1) |
|
Activity 1.03 Entering and Editing Text in an Office 2010 Program |
|
|
9 | (2) |
|
Objective 4 Perform Commands from a Dialog Box |
|
|
11 | (1) |
|
Activity 1.04 Performing Commands from a Dialog Box |
|
|
11 | (2) |
|
Objective 5 Create a Folder, Save a File, and Close a Program |
|
|
13 | (1) |
|
Activity 1.05 Creating a Folder, Saving a File, and Closing a Program |
|
|
13 | (5) |
|
Objective 6 Add Document Properties and Print a File |
|
|
18 | (1) |
|
Activity 1.06 Adding Document Properties and Printing a File |
|
|
18 | (3) |
|
|
21 | (25) |
|
Objective 7 Open an Existing File and Save it with a New Name |
|
|
22 | (1) |
|
Activity 1.07 Opening an Existing File and Saving it with a New Name |
|
|
22 | (3) |
|
Objective 8 Explore Options for an Application |
|
|
25 | (1) |
|
Activity 1.08 Viewing Application Options |
|
|
25 | (1) |
|
Objective 9 Perform Commands from the Ribbon |
|
|
26 | (1) |
|
Activity 1.09 Performing Commands from the Ribbon |
|
|
26 | (5) |
|
Activity 1.10 Minimizing and Using the Keyboard to Control the Ribbon |
|
|
31 | (1) |
|
Objective 10 Apply Formatting in Office Programs |
|
|
32 | (1) |
|
Activity 1.11 Formatting and Viewing Pages |
|
|
32 | (2) |
|
Activity 1.12 Formatting Text |
|
|
34 | (4) |
|
Activity 1.13 Using the Office Clipboard to Cut, Copy, and Paste |
|
|
38 | (3) |
|
Activity 1.14 Viewing Print Preview and Printing a Word Document |
|
|
41 | (2) |
|
Objective 11 Use the Microsoft office 2010 Help System |
|
|
43 | (1) |
|
Activity 1.15 Using the Microsoft Office 2010 Help System in Excel |
|
|
43 | (1) |
|
Objective 12 Compress Files |
|
|
44 | (1) |
|
Activity 1.16 Compressing Files |
|
|
44 | (2) |
|
Summary, Key Terms, Matching, and Multiple Choice |
|
|
46 | (3) |
|
|
|
Chapter 1 Creating Documents with Microsoft Word 2010 |
|
|
49 | (56) |
|
|
50 | (16) |
|
Objective 1 Create a New Document and Insert Text |
|
|
51 | (1) |
|
Activity 1.01 Starting a New Word Document and Inserting Text |
|
|
51 | (2) |
|
Objective 2 Insert and Format Graphics |
|
|
53 | (1) |
|
Activity 1.02 Formatting Text Using Text Effects |
|
|
53 | (1) |
|
Activity 1.03 Inserting and Resizing Pictures |
|
|
54 | (1) |
|
Activity 1.04 Wrapping Text Around a Picture |
|
|
55 | (1) |
|
Activity 1.05 Moving a Picture |
|
|
56 | (1) |
|
Activity 1.06 Applying Picture Styles and Artistic Effects |
|
|
57 | (1) |
|
Activity 1.07 Adding a Page Border |
|
|
57 | (1) |
|
Objective 3 Insert and Modify Text Boxes and Shapes |
|
|
58 | (1) |
|
Activity 1.08 Inserting a Shape |
|
|
58 | (2) |
|
Activity 1.09 Inserting a Text Box |
|
|
60 | (1) |
|
Activity 1.10 Moving, Resizing, and Formatting Shapes and Text Boxes |
|
|
60 | (2) |
|
Objective 4 Preview and Print a Document |
|
|
62 | (1) |
|
Activity 1.11 Adding a File Name to the Footer |
|
|
62 | (2) |
|
Activity 1.12 Previewing and Printing a Document |
|
|
64 | (2) |
|
Project 1B Information Handout |
|
|
66 | (19) |
|
Objective 5 Change Document and Paragraph Layout |
|
|
67 | (1) |
|
Activity 1.13 Setting Margins |
|
|
67 | (1) |
|
Activity 1.14 Aligning Text |
|
|
68 | (2) |
|
Activity 1.15 Changing Line Spacing |
|
|
70 | (1) |
|
Activity 1.16 Indenting Text and Adding Space After Paragraphs |
|
|
71 | (2) |
|
Objective 6 Create and Modify Lists |
|
|
73 | (1) |
|
Activity 1.17 Creating a Bulleted List |
|
|
73 | (1) |
|
Activity 1.18 Creating a Numbered List |
|
|
74 | (3) |
|
Activity 1.19 Customizing Bullets |
|
|
77 | (1) |
|
Objective 7 Set and Modify Tab Stops |
|
|
78 | (1) |
|
Activity 1.20 Setting Tab Stops |
|
|
78 | (1) |
|
Activity 1.21 Modifying Tab Stops |
|
|
79 | (1) |
|
Objective 8 Insert a SmartArt Graphic |
|
|
80 | (1) |
|
Activity 1.22 Inserting a SmartArt Graphic |
|
|
80 | (1) |
|
Activity 1.23 Modifying a SmartArt Graphic |
|
|
81 | (4) |
|
Summary, Key Terms, Matching, and Multiple Choice |
|
|
85 | (1) |
|
|
86 | (6) |
|
|
92 | (6) |
|
|
98 | (1) |
|
|
99 | (1) |
|
|
100 | (2) |
|
|
102 | (1) |
|
|
103 | (1) |
|
|
104 | (1) |
|
|
|
Chapter 1 Creating a Worksheet and Charting Data |
|
|
105 | (66) |
|
Project 1A Sales Report with Embedded Column Chart and Sparklines |
|
|
106 | (26) |
|
Objective 1 Create, Save, and Navigate an Excel Workbook |
|
|
107 | (1) |
|
Activity 1.01 Starting Excel and Naming and Saving a Workbook |
|
|
107 | (2) |
|
Activity 1.02 Navigating a Worksheet and a Workbook |
|
|
109 | (1) |
|
Objective 2 Enter Data in a Worksheet |
|
|
110 | (1) |
|
Activity 1.03 Entering Text and Using AutoComplete |
|
|
110 | (2) |
|
Activity 1.04 Using Auto Fill and Keyboard Shortcuts |
|
|
112 | (1) |
|
Activity 1.05 Aligning Text and Adjusting the Size of Columns |
|
|
113 | (1) |
|
Activity 1.06 Entering Numbers |
|
|
114 | (2) |
|
Objective 3 Construct and Copy Formulas and Use the SUM Function |
|
|
116 | (1) |
|
Activity 1.07 Constructing a Formula and Using the SUM Function |
|
|
116 | (2) |
|
Activity 1.08 Copying a Formula by Using the Fill Handle |
|
|
118 | (2) |
|
Objective 4 Format Cells with Merge & Center and Cell Styles |
|
|
120 | (1) |
|
Activity 1.09 Using Merge & Center and Applying Cell Styles |
|
|
120 | (1) |
|
Activity 1.10 Formatting Financial Numbers |
|
|
121 | (1) |
|
Objective 5 Chart Data to Create a Column Chart and Insert Sparklines |
|
|
122 | (1) |
|
Activity 1.11 Charting Data in a Column Chart |
|
|
122 | (4) |
|
Activity 1.12 Creating and Formatting Sparklines |
|
|
126 | (1) |
|
Objective 6 Print, Display Formulas, and Close Excel |
|
|
127 | (1) |
|
Activity 1.13 Changing Views, Creating a Footer, and Using Print Preview |
|
|
127 | (2) |
|
Activity 1.14 Deleting Unused Sheets in a Workbook |
|
|
129 | (1) |
|
Activity 1.15 Printing a Worksheet |
|
|
130 | (1) |
|
Activity 1.16 Displaying, Printing, and Hiding Formulas |
|
|
130 | (2) |
|
Project 1B Inventory Valuation |
|
|
132 | (17) |
|
Objective 7 Check Spelling in a Worksheet |
|
|
133 | (1) |
|
Activity 1.17 Checking Spelling in a Worksheet |
|
|
133 | (2) |
|
Objective 8 Enter Data by Range |
|
|
135 | (1) |
|
Activity 1.18 Entering Data by Range |
|
|
135 | (1) |
|
Objective 9 Construct Formulas for Mathematical Operations |
|
|
136 | (1) |
|
Activity 1.19 Using Arithmetic Operators |
|
|
136 | (2) |
|
Activity 1.20 Copying Formulas Containing Absolute Cell References |
|
|
138 | (3) |
|
Objective 10 Edit Values in a Worksheet |
|
|
141 | (1) |
|
Activity 1.21 Editing Values in a Worksheet |
|
|
141 | (1) |
|
Activity 1.22 Formatting Cells with the Percent Style |
|
|
142 | (1) |
|
Objective 11 Format a Worksheet |
|
|
142 | (1) |
|
Activity 1.23 Inserting and Deleting Rows and Columns |
|
|
142 | (2) |
|
Activity 1.24 Adjusting Column Widths and Wrapping Text |
|
|
144 | (5) |
|
Summary, Key Terms, Matching, and Multiple Choice |
|
|
149 | (1) |
|
|
150 | (6) |
|
|
156 | (6) |
|
|
162 | (1) |
|
|
163 | (1) |
|
|
164 | (2) |
|
|
166 | (1) |
|
|
167 | (2) |
|
|
169 | (2) |
|
|
|
Chapter 1 Getting Started with Access Databases |
|
|
171 | (66) |
|
Project 1A Contact Information Database with Two Tables |
|
|
172 | (31) |
|
Objective 1 Identify Good Database Design |
|
|
173 | (1) |
|
Activity 1.01 Using Good Design Techniques to Plan a Database |
|
|
173 | (1) |
|
Objective 2 Create a Table and Define Fields in a New Database |
|
|
174 | (1) |
|
Activity 1.02 Starting with a New Blank Database |
|
|
175 | (2) |
|
Activity 1.03 Assigning the Data Type and Name to Fields |
|
|
177 | (3) |
|
Activity 1.04 Renaming Fields and Changing Data Types in a Table |
|
|
180 | (1) |
|
Activity 1.05 Adding a Record to a Table |
|
|
181 | (1) |
|
Activity 1.06 Adding Additional Records to a Table |
|
|
182 | (1) |
|
Activity 1.07 Importing Data from an Excel Workbook into an Existing Access Table |
|
|
183 | (3) |
|
Objective 3 Change the Structure of Tables and Add a Second Table |
|
|
186 | (1) |
|
Activity 1.08 Deleting a Table Field in Design View |
|
|
186 | (1) |
|
Activity 1.09 Modifying a Field Size and Adding a Description |
|
|
187 | (1) |
|
Activity 1.10 Viewing a Primary Key in Design View |
|
|
188 | (1) |
|
Activity 1.11 Adding a Second Table to a Database by Importing an Excel Spreadsheet |
|
|
189 | (2) |
|
Activity 1.12 Adjusting Column Widths |
|
|
191 | (2) |
|
Activity 1.13 Printing a Table |
|
|
193 | (3) |
|
Objective 4 Create and Use a Query, Form, and Report |
|
|
196 | (1) |
|
Activity 1.14 Using the Simple Query Wizard to Create a Query |
|
|
196 | (2) |
|
Activity 1.15 Creating and Printing a Form |
|
|
198 | (2) |
|
Activity 1.16 Creating, Modifying, and Printing a Report |
|
|
200 | (2) |
|
Objective 5 Save and Close a Database |
|
|
202 | (1) |
|
Activity 1.17 Closing and Saving a Database |
|
|
202 | (1) |
|
Project 1B Student Workshops Database |
|
|
203 | (12) |
|
Objective 6 Create a Database Using a Template |
|
|
204 | (1) |
|
Activity 1.18 Creating a New Database Using a Template |
|
|
204 | (1) |
|
Activity 1.19 Building a Table by Entering Records in a Multiple Items Form |
|
|
205 | (3) |
|
Objective 7 Organiz Objects in the Navigation Pane |
|
|
208 | (1) |
|
Activity 1.20 Organizing Database Objects in the Navigation Pane |
|
|
208 | (2) |
|
Objective 8 Create a New Table in a Database Created with a Template |
|
|
210 | (1) |
|
Activity 1.21 Creating a New Table and Changing its Design |
|
|
210 | (2) |
|
Objective 9 Print a Report and a Table in a Database Created with a Template |
|
|
212 | (1) |
|
Activity 1.22 Viewing and Printing a Report |
|
|
212 | (1) |
|
Activity 1.23 Printing a Table |
|
|
212 | (3) |
|
Summary, Key Terms, Matching, and Multiple Choice |
|
|
215 | (1) |
|
|
216 | (7) |
|
|
223 | (7) |
|
|
230 | (1) |
|
|
231 | (1) |
|
|
232 | (2) |
|
|
234 | (1) |
|
|
235 | (1) |
|
|
236 | (1) |
|
|
|
Chapter 1 Getting Started with Microsoft Office PowerPoint |
|
|
237 | |
|
Project 1A Company Overview |
|
|
238 | (20) |
|
Objective 1 Create a New Presentation |
|
|
239 | (1) |
|
Activity 1.01 Identifying Parts of the PowerPoint Window |
|
|
239 | (1) |
|
Activity 1.02 Entering Presentation Text and Saving a Presentation |
|
|
240 | (1) |
|
Activity 1.03 Applying a Presentation Theme |
|
|
241 | (2) |
|
Objective 2 Edit a Presentation in Normal View |
|
|
243 | (1) |
|
Activity 1.04 Inserting a New Slide |
|
|
243 | (2) |
|
Activity 1.05 Increasing and Decreasing List Levels |
|
|
245 | (2) |
|
Activity 1.06 Adding Speaker's Notes to a Presentation |
|
|
247 | (1) |
|
Activity 1.07 Displaying and Editing Slides in the Slide Pane |
|
|
248 | (2) |
|
Objective 3 Add Pictures to a Presentation |
|
|
250 | (1) |
|
Activity 1.08 Inserting a Picture from a File |
|
|
250 | (2) |
|
Activity 1.09 Applying a Style to a Picture |
|
|
252 | (1) |
|
Activity 1.10 Applying and Removing Picture Artistic Effects |
|
|
253 | (1) |
|
Objective 4 Print and View a Presentation |
|
|
253 | (1) |
|
Activity 1.11 Viewing a Slide Show |
|
|
253 | (1) |
|
Activity 1.12 Inserting Headers and Footers |
|
|
254 | (1) |
|
Activity 1.13 Printing a Presentation |
|
|
255 | (3) |
|
Project 1B New Product Announcement |
|
|
258 | (15) |
|
Objective 5 Edit an Existing Presentation |
|
|
259 | (1) |
|
Activity 1.14 Displaying and Editing the Presentation Outline |
|
|
259 | (1) |
|
Activity 1.15 Inserting Slides from an Existing Presentation |
|
|
260 | (3) |
|
Activity 1.16 Finding and Replacing Text |
|
|
263 | (1) |
|
Objective 6 Format a Presentation |
|
|
263 | (1) |
|
Activity 1.17 Changing Fonts, Font Sizes, Font Styles, and Font Colors |
|
|
263 | (2) |
|
Activity 1.18 Aligning Text and Changing Line Spacing |
|
|
265 | (1) |
|
Activity 1.19 Modifying Slide Layout |
|
|
266 | (1) |
|
Objective 7 Use Slide Sorter View |
|
|
266 | (1) |
|
Activity 1.20 Deleting Slides in Slide Sorter View |
|
|
267 | (1) |
|
Activity 1.21 Moving Slides in Slide Sorter View |
|
|
267 | (2) |
|
Objective 8 Apply Slide Transitions |
|
|
269 | (1) |
|
Activity 1.22 Applying Slide Transitions to a Presentation |
|
|
269 | (1) |
|
Activity 1.23 Displaying a Presentation in Reading View |
|
|
270 | (3) |
|
Summary, Key Terms, Matching, and Multiple Choice |
|
|
273 | (1) |
|
|
274 | (6) |
|
|
280 | (6) |
|
|
286 | (1) |
|
|
287 | (1) |
|
|
288 | (2) |
|
|
290 | (1) |
|
|
291 | (2) |
|
|
293 | |
Glossary |
|
1 | (1) |
Index |
|
1 | |