|
|
|
Start and Exit Office Applications |
|
|
4 | (2) |
|
Navigate the Program Windows |
|
|
6 | (2) |
|
|
8 | (2) |
|
Customize the Quick Access Toolbar |
|
|
10 | (2) |
|
|
12 | (2) |
|
|
|
|
14 | (2) |
|
|
16 | (2) |
|
|
18 | (2) |
|
|
20 | (2) |
|
Check your File for Hidden or Personal Data |
|
|
22 | (2) |
|
|
24 | (2) |
|
|
26 | (2) |
|
Cut, Copy, and Paste Data |
|
|
28 | (2) |
|
|
30 | (2) |
|
|
|
|
32 | (2) |
|
View Clip Art with the Clip Organizer |
|
|
34 | (2) |
|
|
36 | (2) |
|
|
38 | (2) |
|
|
40 | (2) |
|
|
42 | (2) |
|
|
44 | (2) |
|
|
46 | (1) |
|
|
47 | (1) |
|
|
48 | (1) |
|
|
49 | (1) |
|
|
50 | (2) |
|
|
52 | (2) |
|
Working with Office Files Online |
|
|
|
|
54 | (2) |
|
Upload a File to Office Live Workspace |
|
|
56 | (2) |
|
Create a New File in Office Live Workspace |
|
|
58 | (2) |
|
Edit a File in Office Live Workspace |
|
|
60 | (2) |
|
|
62 | (2) |
|
|
64 | (1) |
|
Delete a File From Office Live Workspace |
|
|
65 | (3) |
|
|
|
|
|
|
68 | (2) |
|
|
70 | (2) |
|
|
72 | (2) |
|
|
74 | (2) |
|
|
76 | (2) |
|
|
|
Change the Font, Size, and Color |
|
|
78 | (4) |
|
|
82 | (1) |
|
|
83 | (1) |
|
|
84 | (2) |
|
|
86 | (2) |
|
|
88 | (2) |
|
|
90 | (2) |
|
|
92 | (1) |
|
|
93 | (1) |
|
|
94 | (2) |
|
|
96 | (2) |
|
|
|
|
98 | (2) |
|
|
100 | (2) |
|
|
102 | (2) |
|
|
104 | (2) |
|
|
106 | (1) |
|
Insert an Excel Spreadsheet |
|
|
107 | (1) |
|
|
108 | (2) |
|
Insert Footnotes and Endnotes |
|
|
110 | (2) |
|
Insert Page Numbers and Page Breaks |
|
|
112 | (2) |
|
|
114 | (2) |
|
|
116 | (2) |
|
Generate a Table of Contents |
|
|
118 | (2) |
|
|
120 | (2) |
|
|
|
|
122 | (2) |
|
|
124 | (2) |
|
Check Spelling and Grammar |
|
|
126 | (2) |
|
|
128 | (2) |
|
Use Word's Thesaurus and Dictionary |
|
|
130 | (2) |
|
|
132 | (2) |
|
Track and Review Document Changes |
|
|
134 | (2) |
|
|
136 | (2) |
|
|
138 | (4) |
|
|
|
|
|
|
142 | (2) |
|
|
144 | (2) |
|
Faster Data Entry with AutoFill |
|
|
146 | (2) |
|
|
148 | (1) |
|
Center Data Across Columns |
|
|
149 | (1) |
|
|
150 | (2) |
|
|
152 | (2) |
|
|
154 | (1) |
|
Increase or Decrease Decimals |
|
|
155 | (1) |
|
|
156 | (2) |
|
|
158 | (2) |
|
Apply Conditional Formatting |
|
|
160 | (2) |
|
|
162 | (2) |
|
|
164 | (1) |
|
|
165 | (1) |
|
|
166 | (2) |
|
|
168 | (2) |
|
|
|
|
170 | (1) |
|
|
171 | (1) |
|
Change Page Setup Options |
|
|
172 | (2) |
|
|
174 | (1) |
|
|
175 | (1) |
|
|
176 | (2) |
|
|
178 | (2) |
|
|
180 | (2) |
|
Track and Review Worksheet Changes |
|
|
182 | (4) |
|
|
186 | (2) |
|
Working with Factors and Functions |
|
|
|
|
188 | (2) |
|
|
190 | (2) |
|
Apply Absolute and Relative Cell References |
|
|
192 | (2) |
|
|
194 | (2) |
|
|
196 | (2) |
|
|
198 | (2) |
|
Audit a Worksheet for Errors |
|
|
200 | (2) |
|
|
202 | (2) |
|
|
|
|
204 | (2) |
|
|
206 | (2) |
|
|
208 | (1) |
|
|
209 | (1) |
|
|
210 | (1) |
|
|
211 | (1) |
|
|
212 | (2) |
|
|
214 | (1) |
|
|
215 | (1) |
|
Use Sparklines to View Data Trends |
|
|
216 | (4) |
|
|
|
|
|
Create a Photo Album Presentation |
|
|
220 | (2) |
|
Create a Presentation with a Template |
|
|
222 | (2) |
|
Build a Blank Presentation |
|
|
224 | (2) |
|
|
226 | (2) |
|
|
228 | (1) |
|
|
229 | (1) |
|
|
230 | (2) |
|
Populating Presentation Slides |
|
|
|
|
232 | (2) |
|
Change the Font, Size, and Color |
|
|
234 | (4) |
|
|
238 | (1) |
|
|
239 | (1) |
|
|
240 | (1) |
|
Add a Text Box to a Slide |
|
|
241 | (1) |
|
|
242 | (2) |
|
|
244 | (2) |
|
|
246 | (2) |
|
Add a Video Clip to a Slide |
|
|
248 | (2) |
|
|
250 | (1) |
|
|
251 | (1) |
|
Assembling and Presenting a Slide Show |
|
|
|
|
252 | (2) |
|
|
254 | (2) |
|
Organize Slides into Sections |
|
|
256 | (2) |
|
|
258 | (2) |
|
|
260 | (2) |
|
Create a Custom Animation |
|
|
262 | (2) |
|
|
264 | (1) |
|
|
265 | (1) |
|
|
266 | (2) |
|
|
268 | (2) |
|
|
270 | (2) |
|
Package Your Presentation on a CD |
|
|
272 | (4) |
|
|
|
Understanding Database Basics |
|
|
276 | (2) |
|
Create a Database Based on a Template |
|
|
278 | (2) |
|
|
280 | (2) |
|
|
282 | (2) |
|
|
284 | (2) |
|
|
286 | (1) |
|
Delete a Field from a Table |
|
|
287 | (1) |
|
|
288 | (1) |
|
|
289 | (1) |
|
|
290 | (2) |
|
|
292 | (1) |
|
|
293 | (1) |
|
|
294 | (1) |
|
|
295 | (1) |
|
|
296 | (1) |
|
|
297 | (1) |
|
Adding, Finding, and Querying Data |
|
|
|
|
298 | (2) |
|
|
300 | (2) |
|
Navigate Records in a Form |
|
|
302 | (1) |
|
Search for a Record in a Form |
|
|
303 | (1) |
|
Delete a Record from a Table |
|
|
304 | (1) |
|
Delete a Record from a Form |
|
|
305 | (1) |
|
|
306 | (2) |
|
|
308 | (2) |
|
Apply Conditional Formating |
|
|
310 | (2) |
|
|
312 | (4) |
|
|
316 | (6) |
|
|
|
|
|
|
322 | (2) |
|
|
324 | (2) |
|
Schedule a Recurring Appointment |
|
|
326 | (2) |
|
|
328 | (2) |
|
|
330 | (2) |
|
|
332 | (2) |
|
|
334 | (2) |
|
|
336 | (2) |
|
Perform an Instant Search |
|
|
338 | (1) |
|
|
339 | (1) |
|
|
|
Compose and Send a Message |
|
|
340 | (2) |
|
|
342 | (1) |
|
|
343 | (1) |
|
Reply to or Forward a Message |
|
|
344 | (2) |
|
Add a Sender to Your Outlook Contacts |
|
|
346 | (1) |
|
|
347 | (1) |
|
|
348 | (2) |
|
|
350 | (1) |
|
|
351 | (1) |
|
|
352 | (2) |
|
|
354 | (4) |
|
|
|
|
|
|
358 | (2) |
|
Create a Blank Publication |
|
|
360 | (2) |
|
|
362 | (2) |
|
|
364 | (1) |
|
|
365 | (1) |
|
Add a Picture to a Publication |
|
|
366 | (2) |
|
Fine-Tuning a Publication |
|
|
|
Change the Font, Size, and Color |
|
|
368 | (4) |
|
|
372 | (1) |
|
|
373 | (1) |
|
|
374 | (1) |
|
|
375 | (3) |
|
|
378 | (1) |
|
Move and Resize Publication Objects |
|
|
378 | (2) |
|
|
380 | (2) |
|
Add a Building Block Object |
|
|
382 | (2) |
|
Create a Building Block Object |
|
|
384 | (4) |
|
|
|
Taking Notes with OneNote |
|
|
|
|
388 | (2) |
|
|
390 | (2) |
|
Paste a Picture into OneNote |
|
|
392 | (1) |
|
|
393 | (1) |
|
|
394 | (2) |
|
|
396 | (2) |
|
Organizing and Sharing Notes |
|
|
|
|
398 | (1) |
|
|
399 | (1) |
|
|
400 | (2) |
|
Rename Sections and Pages |
|
|
402 | (2) |
|
|
404 | (2) |
|
|
406 | (2) |
|
|
408 | (1) |
|
Convert Notes to PDF or XPS Format |
|
|
409 | |