| About this Book |
|
xi | |
| Exam Tips |
|
|
What Is Microsoft Office Specialist Certification? |
|
|
1 | (1) |
|
|
|
2 | (1) |
|
The Microsoft Office Specialist Certification Process |
|
|
3 | (8) |
|
|
|
5 | (1) |
|
|
|
5 | (1) |
|
|
|
6 | (3) |
|
|
|
9 | (1) |
|
5 Purchase an Exam Voucher |
|
|
9 | (1) |
|
6 Take the Exam and Receive the Results |
|
|
10 | (1) |
|
|
|
11 | (2) |
|
|
|
13 | (2) |
| Microsoft Word 2010 Exam Reference |
|
|
Getting Started with Word 2010 |
|
|
15 | (8) |
|
|
|
15 | (1) |
|
|
|
16 | (1) |
|
|
|
16 | (1) |
|
Open, Save, and Close Documents |
|
|
17 | (2) |
|
Navigate in the Document Window |
|
|
19 | (1) |
|
|
|
20 | (1) |
|
|
|
21 | (1) |
|
|
|
21 | (2) |
|
Word Objective 1 Sharing and Maintaining Documents |
|
|
23 | (13) |
|
Apply Different Views to a Document |
|
|
23 | (3) |
|
Apply Protection to a Document |
|
|
26 | (3) |
|
|
|
29 | (1) |
|
|
|
30 | (4) |
|
|
|
34 | (1) |
|
Apply a Template to a Document |
|
|
35 | (1) |
|
Word Objective 2 Formatting Content |
|
|
36 | (26) |
|
Apply Font and Paragraph Attributes |
|
|
36 | (6) |
|
Navigate and Search Through a Document |
|
|
42 | (5) |
|
Apply Indentation and Tab Settings to Paragraphs |
|
|
47 | (6) |
|
Apply Spacing Settings to Text and Paragraphs |
|
|
53 | (2) |
|
|
|
55 | (1) |
|
Manipulate Tables in a Document |
|
|
56 | (4) |
|
Apply Bullets to a Document |
|
|
60 | (2) |
|
Word Objective 3 Applying Page Layout and Reusable Content |
|
|
62 | (9) |
|
Apply and Manipulate Page Setup Settings |
|
|
62 | (3) |
|
|
|
65 | (1) |
|
Construct Content in a Document by Using the Quick Parts Tools |
|
|
66 | (2) |
|
Create and Manipulate Page Backgrounds |
|
|
68 | (1) |
|
Create and Modify Headers and Footers |
|
|
69 | (2) |
|
Word Objective 4 Including Illustrations and Graphics in a Document |
|
|
71 | (17) |
|
Insert and Format Pictures in a Document |
|
|
71 | (5) |
|
Insert and Format Shapes, WordArt, and SmartArt |
|
|
76 | (6) |
|
Insert and Format Clip Art |
|
|
82 | (3) |
|
|
|
85 | (1) |
|
Apply and Manipulate Text Boxes |
|
|
85 | (3) |
|
Word Objective 5 Proofreading Documents |
|
|
88 | (5) |
|
Validate Content by Using Spelling and Grammar Checking Options |
|
|
88 | (2) |
|
Configure AutoCorrect Settings |
|
|
90 | (1) |
|
Insert and Modify Comments in a Document |
|
|
91 | (2) |
|
Word Objective 6 Applying References and Hyperlinks |
|
|
93 | (6) |
|
|
|
93 | (1) |
|
Create Endnotes and Footnotes in a Document |
|
|
94 | (2) |
|
Create a Table of Contents in a Document |
|
|
96 | (3) |
|
Word Objective 7 Performing Mail Merge Operations |
|
|
99 | (3) |
|
|
|
99 | (3) |
| Word 2010 Expert Objectives |
|
|
Word Expert Objective 1 Sharing and Maintaining Documents |
|
|
102 | (4) |
|
|
|
102 | (1) |
|
Apply Protection to a Document |
|
|
103 | (1) |
|
Apply a Template to a Document |
|
|
104 | (2) |
|
Word Expert Objective 2 Formatting Content |
|
|
106 | (6) |
|
Apply Advanced Font and Paragraph Attributes |
|
|
106 | (1) |
|
|
|
107 | (1) |
|
Construct Reusable Content in a Document |
|
|
108 | (3) |
|
|
|
111 | (1) |
|
Word Expert Objective 3 Tracking and Referencing Documents |
|
|
112 | (9) |
|
Review, Compare, and Combine Documents |
|
|
112 | (2) |
|
|
|
114 | (1) |
|
Create a Table of Authorities in a Document |
|
|
115 | (3) |
|
Create an Index in a Document |
|
|
118 | (3) |
|
Word Expert Objective 4 Performing Mail Merge Operations |
|
|
121 | (8) |
|
|
|
121 | (2) |
|
Create a Mail Merge by Using Other Data Sources |
|
|
123 | (3) |
|
|
|
126 | (3) |
|
Word Expert Objective 5 Manage Macros and Forms |
|
|
129 | (10) |
|
Apply and Manipulate Macros |
|
|
129 | (1) |
|
Apply and Manipulate Macros Options |
|
|
130 | (3) |
|
|
|
133 | (4) |
|
|
|
137 | (2) |
| Microsoft Excel 2010 Exam Reference |
|
|
Getting Started with Excel 2010 |
|
|
139 | (6) |
|
|
|
139 | (1) |
|
|
|
140 | (1) |
|
|
|
140 | (1) |
|
Open, Save, and Close Workbooks |
|
|
141 | (1) |
|
Navigate in the Worksheet Window |
|
|
142 | (1) |
|
|
|
143 | (1) |
|
|
|
144 | (1) |
|
Excel Objective 1 Managing the Worksheet Environment |
|
|
145 | (6) |
|
Navigate Through a Worksheet |
|
|
145 | (1) |
|
Print a Worksheet or Workbook |
|
|
146 | (3) |
|
Personalize the Environment by Using Backstage |
|
|
149 | (2) |
|
Excel Objective 2 Creating Cell Data |
|
|
151 | (9) |
|
|
|
151 | (5) |
|
|
|
156 | (2) |
|
Apply and Manipulate Hyperlinks |
|
|
158 | (2) |
|
Excel Objective 3 Formatting Cells and Worksheets |
|
|
160 | (8) |
|
Apply and Modify Cell Formats |
|
|
160 | (2) |
|
|
|
162 | (1) |
|
Create Row and Column Titles |
|
|
162 | (3) |
|
Hide or Unhide Rows and Columns |
|
|
165 | (1) |
|
Manipulate Page Setup Options for Worksheets |
|
|
166 | (1) |
|
Create and Apply Cell Styles |
|
|
167 | (1) |
|
Excel Objective 4 Managing Worksheets and Workbooks |
|
|
168 | (7) |
|
Create and Format Worksheets |
|
|
168 | (4) |
|
|
|
172 | (1) |
|
Manipulate Workbook Views |
|
|
173 | (2) |
|
Excel Objective 5 Applying Formulas and Functions |
|
|
175 | (6) |
|
|
|
175 | (1) |
|
|
|
175 | (1) |
|
Apply Cell References in Formulas |
|
|
176 | (1) |
|
Apply Conditional Logic in a Formula |
|
|
177 | (2) |
|
Apply Named Ranges in Formulas |
|
|
179 | (1) |
|
Apply Cell Ranges in Formulas |
|
|
180 | (1) |
|
Excel Objective 6 Presenting Data Visually |
|
|
181 | (5) |
|
Create Charts Based on Worksheet Data |
|
|
181 | (1) |
|
Apply and Manipulate Illustrations |
|
|
181 | (2) |
|
Create and Modify Images by Using the Image Editor |
|
|
183 | (1) |
|
|
|
184 | (2) |
|
Excel Objective 7 Sharing Worksheet Data with Other Users |
|
|
186 | (7) |
|
Share Spreadsheets by Using Backstage 186 Manage Comments |
|
|
|
Excel Objective 8: Analyzing and Organizing Data |
|
|
188 | (1) |
|
|
|
188 | (2) |
|
|
|
190 | (1) |
|
Apply Conditional Formatting |
|
|
190 | (3) |
| Excel 2010 Expert Objectives |
|
|
Excel Expert Objective 1 Sharing and Maintaining Workbooks |
|
|
193 | (3) |
|
Apply Workbook Settings, Properties, and Data Options |
|
|
193 | (1) |
|
Apply Protection and Sharing Properties to Workbooks and Worksheets |
|
|
194 | (1) |
|
Maintain Shared Workbooks |
|
|
195 | (1) |
|
Excel Expert Objective 2 Applying Formulas and Functions |
|
|
196 | (6) |
|
|
|
196 | (2) |
|
Manipulate Formula Options |
|
|
198 | (1) |
|
Perform Data Summary Tasks |
|
|
199 | (1) |
|
Apply Functions in Formulas |
|
|
200 | (2) |
|
Excel Expert Objective 3 Presenting Data Visually |
|
|
202 | (5) |
|
Apply Advanced Chart Features |
|
|
202 | (1) |
|
|
|
203 | (1) |
|
Apply and Manipulate PivotTables |
|
|
204 | (1) |
|
Apply and Manipulate PivotCharts |
|
|
205 | (1) |
|
Demonstrate How to Use the Slicer |
|
|
206 | (1) |
|
Excel Expert Objective 4 Working with Macros and Forms |
|
|
207 | (4) |
|
Create and Manipulate Macros |
|
|
207 | (2) |
|
Insert and Manipulate Form Controls |
|
|
209 | (2) |
| Microsoft Access 2010 Exam Reference |
|
|
Getting Started with Access 2010 |
|
|
211 | (6) |
|
|
|
211 | (1) |
|
|
|
212 | (1) |
|
|
|
212 | (1) |
|
|
|
213 | (1) |
|
|
|
213 | (1) |
|
|
|
214 | (1) |
|
Save arid Close Objects and Databases |
|
|
215 | (1) |
|
|
|
216 | (1) |
|
|
|
216 | (1) |
|
Access Objective 1 Managing the Access Environment |
|
|
217 | (3) |
|
Create and Manage a Database |
|
|
217 | (2) |
|
Configure the Navigation Pane |
|
|
219 | (1) |
|
|
|
219 | (1) |
|
Access Objective 2 Building Tables |
|
|
220 | (8) |
|
|
|
220 | (2) |
|
|
|
222 | (2) |
|
|
|
224 | (1) |
|
|
|
225 | (2) |
|
Import Data from a Single Data File |
|
|
227 | (1) |
|
Access Objective 3 Building Forms |
|
|
228 | (7) |
|
|
|
228 | (1) |
|
Apply Form Design Options |
|
|
229 | (2) |
|
Apply Form Arrange Options |
|
|
231 | (2) |
|
Apply Form Format Options |
|
|
233 | (2) |
|
Access Objective 4 Creating and Managing Queries |
|
|
235 | (5) |
|
|
|
235 | (2) |
|
Manage Source Tables and Relationships |
|
|
237 | (1) |
|
|
|
238 | (1) |
|
|
|
239 | (1) |
|
Generate Calculated Fields |
|
|
239 | (1) |
|
Access Objective 5 Designing Reports |
|
|
240 | (9) |
|
|
|
240 | (1) |
|
Apply Report Design Options |
|
|
241 | (2) |
|
Apply Report Arrange Options |
|
|
243 | (2) |
|
Apply Report Format Options |
|
|
245 | (1) |
|
Apply Report Page Setup Options |
|
|
246 | (1) |
|
Sort and Filter Records for Reporting |
|
|
246 | (3) |
| Microsoft PowerPoint 2010 Exam Reference |
|
|
Getting Started with PowerPoint 2010 |
|
|
249 | (9) |
|
Start and Exit PowerPoint |
|
|
249 | (1) |
|
View the PowerPoint Window |
|
|
250 | (1) |
|
|
|
250 | (1) |
|
|
|
251 | (1) |
|
|
|
252 | (1) |
|
|
|
253 | (1) |
|
|
|
254 | (1) |
|
Create, Open, and Close Presentations |
|
|
254 | (1) |
|
Navigate in the PowerPoint Window |
|
|
255 | (1) |
|
|
|
256 | (1) |
|
|
|
256 | (2) |
|
PowerPoint Objective 1 Managing the PowerPoint Environment |
|
|
258 | (3) |
|
|
|
258 | (1) |
|
Manipulate the PowerPoint Window |
|
|
259 | (1) |
|
Configure the Quick Access Toolbar |
|
|
259 | (1) |
|
Configure PowerPoint File Options |
|
|
259 | (2) |
|
PowerPoint Objective 2 Creating a Slide Presentation |
|
|
261 | (20) |
|
Construct and Edit Photo Albums |
|
|
261 | (2) |
|
Apply Slide Size and Orientation Settings |
|
|
263 | (1) |
|
|
|
264 | (2) |
|
|
|
266 | (3) |
|
|
|
269 | (5) |
|
|
|
274 | (7) |
|
PowerPoint Objective 3 Working With Graphical and Multimedia Elements |
|
|
281 | (16) |
|
Manipulate Graphical Elements |
|
|
281 | (5) |
|
|
|
286 | (5) |
|
Modify WordArt and Shapes |
|
|
291 | (1) |
|
|
|
292 | (3) |
|
Edit Video and Audio Content |
|
|
295 | (2) |
|
PowerPoint Objective 4 Creating Charts and Tables |
|
|
297 | (9) |
|
Construct and Modify Tables |
|
|
297 | (4) |
|
|
|
301 | (2) |
|
|
|
303 | (1) |
|
|
|
304 | (1) |
|
Manipulate Chart Elements |
|
|
305 | (1) |
|
PowerPoint Objective 5 Applying Transitions and Animations |
|
|
306 | (5) |
|
Apply Built-In and Custom Animations |
|
|
306 | (1) |
|
Apply Effect and Path Options |
|
|
307 | (1) |
|
|
|
308 | (2) |
|
Apply and Modify Transitions Between Slides |
|
|
310 | (1) |
|
PowerPoint Objective 6 Collaborating on Presentations |
|
|
311 | (2) |
|
Manage Comments in Presentations |
|
|
311 | (1) |
|
|
|
312 | (1) |
|
PowerPoint Objective 7 Preparing Presentations for Delivery |
|
|
313 | (6) |
|
|
|
313 | (3) |
|
|
|
316 | (2) |
|
|
|
318 | (1) |
|
|
|
318 | (1) |
|
PowerPoint Objective 8 Delivering Presentations |
|
|
319 | (6) |
|
|
|
319 | (1) |
|
|
|
320 | (2) |
|
|
|
322 | (1) |
|
|
|
323 | (2) |
| Index |
|
325 | |
