Microsoft Office Xp Exam Reference Pocket Guide

by Campbell,Jennifer T.

• ISBN13: 9780619109394
• ISBN10: 0619109394
• Edition: 1st
• Format: Paperback
• Copyright: 2002-04-30
• Publisher: Cengage Learning

Summary

A great tool to use as a study companion, reference guide or to brush up on Microsoft Office skills.

Table of Contents

About this Book	p. xiv
Exam Tips	p. 1
What is MOUS Certification?	p. 1
Certification Benefits	p. 1
The MOUS Certification Process	p. 2
Choose an Exam	p. 2
Prepare for the Exam	p. 3
Find a Testing Center	p. 5
Take the Exam	p. 6
Microsoft Word 2002 Exam Reference	p. 9
Getting Started with Word 2002	p. 9
Start and Exit Word	p. 9
View the Word Window	p. 10
Use Toolbars	p. 11
Use Task Panes	p. 11
Open and Close Documents	p. 12
Navigate in the Document Window	p. 13
Use Views	p. 14
Use Smart Tags	p. 14
Get Help	p. 15
Word CORE Exam Reference	p. 16
Inserting and Modifying Text	p. 16
Insert, Modify, and Move Text and Symbols	p. 16
Apply and Modify Text Formats	p. 19
Correct Spelling and Grammar Usage	p. 20
Apply Font and Text Effects	p. 21
Enter and Format Date and Time	p. 22
Apply Character Styles	p. 22
Creating and Modifying Paragraphs	p. 23
Modify Paragraph Formats	p. 23
Set and Modify Tabs	p. 25
Apply Bullet, Outline, and Numbering Format to Paragraphs	p. 26
Apply Paragraph Styles	p. 27
Formatting Documents	p. 28
Create and Modify a Header and Footer	p. 28
Apply and Modify Column Settings	p. 28
Modify Document Layout and Page Setup Options	p. 29
Create and Modify Tables	p. 30
Preview and Print Documents, Envelopes, and Labels	p. 33
Managing Documents	p. 34
Manage Files and Folders for Documents	p. 34
Create Documents Using Templates	p. 34
Save Documents Using Different Names and File Formats	p. 34
Working With Graphics	p. 36
Insert Images and Graphics	p. 36
Create and Modify Diagrams and Charts	p. 36
Workgroup Collaboration	p. 39
Compare and Merge Documents	p. 39
Insert, View, and Edit Comments	p. 39
Convert Documents into Web Pages	p. 40
Word EXPERT Exam Reference	p. 41
Customizing Paragraphs	p. 41
Control Pagination	p. 41
Sort Paragraphs in Lists and Tables	p. 42
Formatting Documents	p. 43
Create and Format Document Sections	p. 43
Create and Apply Character and Paragraph Styles	p. 44
Create and Update Document Indexes and Tables of Contents, Figures, and Authorities	p. 46
Insert a Table of Contents	p. 47
Create Cross-References	p. 49
Add and Revise Endnotes and Footnotes	p. 49
Create and Manage Master Documents and Subdocuments	p. 50
Move within Documents	p. 51
Create and Modify Forms using Various Form Controls	p. 52
Customizing Tables	p. 54
Use Excel Data in Tables	p. 54
Perform Calculations in Word Tables	p. 55
Creating and Modifying Graphics	p. 57
Create, Modify, and Position Graphics	p. 57
Create and Modify Charts Using Data from other Applications	p. 59
Align Text and Graphics	p. 61
Customizing Word	p. 62
Create, Edit, and Run Macros	p. 62
Customize Menus and Toolbars	p. 63
Workgroup Collaboration	p. 65
Track, Accept, and Reject Changes to Documents	p. 65
Merge Input from Several Reviewers	p. 66
Insert and Modify Hyperlinks to Other Documents and Web Pages	p. 66
Create and Edit Web Documents in Word	p. 68
Create Document Versions	p. 69
Protect Documents	p. 69
Define and Modify Default File Locations for Workgroup Templates	p. 69
Modify and Re-post HTML Documents	p. 70
Attach Digital Signatures to Documents	p. 70
Using Mail Merge	p. 71
Merge Letters with a Word, Excel, or Access Data Source	p. 71
Merge Labels with a Word, Excel, or Access Data Source	p. 71
Use Outlook Data as a Mail Merge Data Source	p. 72
Microsoft Excel 2002 Exam Reference	p. 73
Getting Started with Excel 2002	p. 73
Start and Exit Excel	p. 73
View the Excel Window	p. 74
Use Toolbars	p. 74
Open and Close Workbooks	p. 75
Navigate in the Workbook Window	p. 76
Save an Existing Excel Workbook	p. 77
Use Views	p. 77
Use Smart Tags	p. 78
Get Help	p. 78
Excel CORE Exam Reference	p. 79
Working with Cells and Cell Data	p. 79
Insert, Delete, and Move Cells	p. 79
Enter and Edit Cell Data Including Text, Numbers, and Formulas	p. 81
Check Spelling	p. 85
Find and Replace Cell Data and Formats	p. 85
Work with a Subset of Data by Filtering Lists	p. 86
Managing Workbooks	p. 87
Manage Workbook Files and Folders	p. 87
Create Workbooks Using Templates	p. 87
Save Workbooks using Different Names and File Formats	p. 88
Formatting and Printing Worksheets	p. 89
Apply and Modify Cell Formats	p. 89
Modify Row and Column Settings	p. 89
Use Automated Tools to Format Worksheets	p. 92
Modify Page Setup Options for Worksheets	p. 93
Preview and Print Worksheets and Workbooks	p. 94
Modifying Workbooks	p. 95
Insert and Delete Worksheets	p. 95
Modify Worksheet Names and Positions	p. 95
Use 3-D References	p. 96
Creating and Revising Formulas	p. 97
Create and Revise Formulas	p. 97
Use Relative References in Formulas	p. 97
Use Statistical, Date and Time, Financial, and Logical Functions in Formulas	p. 98
Creating and Modifying Graphics	p. 100
Create, Modify, Position, and Print Charts	p. 100
Create, Modify, and Position Graphics	p. 102
Workgroup Collaboration	p. 104
Convert Worksheets into Web Pages	p. 104
Create Hyperlinks	p. 104
View and Edit Comments	p. 105
Excel EXPERT Exam Reference	p. 107
Importing and Exporting Data	p. 107
Import Data to Excel	p. 107
Import Access Database Tables	p. 107
Import Data Using a Query	p. 108
Import Graphics	p. 108
Import Data from the World Wide Web	p. 108
Export Data from Excel	p. 109
Link Excel Data to a PowerPoint Presentation	p. 109
Convert a List to an Access Table	p. 109
Export Excel Data in XML Format	p. 110
Publish Worksheets and Workbooks to the Web	p. 110
Publish an Interactive Workbook to the Web	p. 110
Use Interactive Workbooks	p. 110
Managing Workbooks	p. 112
Create, Edit, and Apply Templates	p. 112
Create a New Workbooks Based on a Template You Created	p. 112
Modify a Workbook Template	p. 112
Create Workspaces	p. 113
Open a Workspace	p. 113
Use Data Consolidation	p. 113
Consolidate Data from Multiple Worksheets with Different Layouts	p. 114
Formatting Numbers	p. 115
Create and Apply Custom Number Formats	p. 115
Create and Apply a Custom Date and Time Format	p. 115
Create and Apply a Custom Format with Text	p. 115
Use Conditional Formats	p. 116
Working with Ranges	p. 117
Use Named Ranges in Formulas	p. 117
Use Labels to Create Range Names	p. 117
Use a Named Range Reference in One or More Formulas	p. 117
Use Lookup and Reference Functions	p. 117
Customizing Excel	p. 119
Customize Toolbars and Menus	p. 119
Add Toolbar Buttons	p. 119
Remove Toolbars Buttons	p. 119
Create, Edit, and Run Macros	p. 120
Run a Macro	p. 120
Edit a Macro	p. 120
Auditing Worksheets	p. 121
Audit Formulas	p. 121
Trace Dependents	p. 121
Locate and Resolve Errors	p. 121
Identify Dependencies in Formulas	p. 122
Remove All Tracer Arrows	p. 122
Summarizing Data	p. 123
Use Subtotals with Lists and Ranges	p. 123
Sort a List by Two Fields	p. 123
Subtotal a List	p. 123
Define and Apply Filters	p. 123
Create an Advanced Filter	p. 124
Add Group and Outline Criteria to Ranges	p. 125
use Data Validation	p. 125
Retrieve External Data and Create Queries	p. 125
Create Extensible Markup Language (XML) Web queries	p. 126
Analyzing Data	p. 127
Create PivotTable Reports and PivotChart Reports	p. 127
Modify a PivotTable Report	p. 127
Update a PivotTable Report	p. 128
Format a PivotTable Report	p. 128
Create a PivotChart Report	p. 129
Modify a PivotChart Report	p. 129
Forecast Values with What-If Analysis	p. 129
Create and Display Scenarios	p. 130
Workgroup Collaboration	p. 131
Modify Passwords, Protections, and Properties	p. 131
Protect Worksheets	p. 131
Protect Workbooks	p. 131
Protect Workbook Elements	p. 132
Create a Shared Workbook	p. 132
Track, Accept, and Reject Changes to Workbooks	p. 132
Accept and Reject Changes	p. 132
Review Changes	p. 133
Merge Workbooks	p. 133
Microsoft Access 2002 Exam Reference	p. 135
Getting Started with Access 2002	p. 135
Start and Exit Access	p. 135
View the Database window	p. 136
Use Toolbars	p. 136
Use Task Panes	p. 137
Open and Close Databases	p. 137
Save Databases	p. 138
Get Help	p. 138
Access CORE Exam Reference	p. 140
Creating and Using Databases	p. 140
Create Access Databases	p. 140
Open Database Objects in Multiple Views	p. 140
Move Among Records	p. 141
Format Datasheets	p. 142
Creating and Modifying Tables	p. 144
Create and Modify Tables	p. 144
Create Lookup Fields	p. 146
Modify Field Properties	p. 147
Creating and Modifying Queries	p. 148
Create and Modify Select Queries	p. 148
Add Calculated Fields to Select Queries	p. 148
Format Values in a Calculated Field	p. 149
Creating and Modifying Forms	p. 150
Create and Display Forms	p. 150
Modify Form Properties	p. 150
Viewing and Organizing Information	p. 152
Enter, Edit, and Delete Records	p. 152
Create Crosstab Queries	p. 153
Sort Records	p. 153
Filter Records	p. 154
Defining Relationships	p. 155
Create One-to-Many Relationships	p. 155
Enforce Referential Integrity	p. 155
Producing Reports	p. 156
Create and Format Reports	p. 156
Add Calculated Controls to Reports	p. 156
Preview and Print Reports	p. 157
Integrating with Other Applications	p. 158
Import Data to Access	p. 158
Export Data from Access	p. 158
Create a Simple Data Access Page	p. 159
Access EXPERT Exam Reference	p. 161
Creating and Modifying Tables	p. 161
Use Data Validation	p. 161
Link Tables	p. 161
Create Lookup Fields and Modify Lookup Field Properties	p. 161
Create and Modify Input Masks	p. 162
Creating and Modifying Forms	p. 164
Create a Form in Design View	p. 164
Create a Switchboard and Set Startup Options	p. 164
Add Subform Controls to Access Forms	p. 166
Refining Queries	p. 167
Specify Multiple Query Criteria	p. 167
Create and Apply Advanced Filters	p. 167
Create and Run Parameter Queries	p. 167
Create and Run Action Queries	p. 168
Use Aggregate Functions in Queries	p. 169
Producing Reports	p. 170
Create and Modify Reports	p. 170
Add SubReport Controls to Access Reports	p. 170
Sort and Group Data in Reports	p. 171
Defining Relationships	p. 172
Establish One-to-Many Relationships	p. 172
Establish Many-to-Many Relationships	p. 172
Operating Access on the Web	p. 174
Create and Modify a Data Access Page	p. 174
Save PivotTable and PivotChart Views to Data Access Pages	p. 174
Using Access Tools	p. 176
Import XML Documents into Access	p. 176
Export Access Data to XML Documents	p. 176
Encrypt and Decrypt Databases	p. 176
Compact and Repair Databases	p. 177
Assign Database Security	p. 177
Creating Database Applications	p. 179
Create Access Modules	p. 179
Use the Database Splitter	p. 179
Microsoft PowerPoint 2002 Exam Reference	p. 181
Getting Started with PowerPoint 2002	p. 181
Start and Exit PowerPoint	p. 181
View the Presentation Window	p. 182
Use Toolbars	p. 182
Use Task Panes	p. 183
Open and Close Presentations	p. 183
Navigate in the Presentation Window	p. 184
Change Views	p. 185
Save Presentations	p. 185
Get Help	p. 185
PowerPoint Comprehesive Exam Reference	p. 187
Creating Presentations	p. 187
Create Presentations Manually and Use Automated Tools	p. 187
Add Slides to and Delete Slides from Presentations	p. 188
Delete Slides from Presentations	p. 188
Modify Headers and Footers in the Slide Master	p. 189
Inserting and Modifying Text	p. 190
Import Text from Word	p. 190
Insert, Format, and Modify Text	p. 190
Inserting and Modifying Visual Elements	p. 194
Add Tables, Charts, Clip Art, and Bitmap Images to Slides	p. 194
Customize Slide Backgrounds	p. 196
Add OfficeArt Elements to Slides	p. 197
Apply Custom Formats to Tables	p. 198
Modifying Presentation Formats	p. 199
Apply Formats to Presentations	p. 199
Apply Animation Schemes	p. 200
Apply Slide Transitions	p. 201
Customize Slide Formats	p. 201
Customize Slide Templates	p. 202
Manage a Slide Master	p. 203
Rearrange Slides	p. 204
Modify Slide Layout	p. 204
Add Links to a Presentation	p. 204
Printing Presentations	p. 205
Preview and Print Slides, Outlines, Handouts, and Speaker Notes	p. 205
Working with Data from Other Sources	p. 207
Import Excel Charts to Slides	p. 207
Add Sound and Video to Slides	p. 207
Insert Word Tables on Slides	p. 208
Export a Presentation as an Outline	p. 208
Managing and Delivering Presentations	p. 209
Set Up Slide Shows	p. 209
Deliver Presentations	p. 209
Manage Files and Folders for Presentations	p. 211
Work with Embedded Fonts	p. 211
Publish Presentations to the Web	p. 211
Use Pack and Go	p. 211
Workgroup Collaboration	p. 212
Set up a Review Cycle	p. 212
Review Presentation Comments	p. 212
Schedule and Deliver Presentation Broadcasts	p. 213
Publish Presentations to the Web	p. 213
Microsoft Outlook 2002 Core Exam Reference	p. 215
Getting Started with Outlook 2002	p. 215
Start and Exit Outlook	p. 215
Set Up an Outlook Profile	p. 216
Outlook Tools	p. 217
Use Toolbars	p. 221
Navigate in the Outlook Window	p. 222
Get Help	p. 223
Outlook CORE Exam Reference	p. 224
Creating and Viewing Messages	p. 224
Display and Print messages	p. 224
Compose and Send Messages	p. 225
Insert Signatures and Attachments	p. 226
Customize Views	p. 227
Scheduling	p. 228
Add Appointments, Meetings, and Events to the Outlook Calendar	p. 228
Apply Conditional Formats to the Outlook Calendar	p. 229
Respond to Meeting Requests	p. 230
Use Categories to Manage Appointments	p. 230
Print Calendars	p. 231
Managing Messages	p. 232
Move Messages	p. 232
Search for Messages	p. 232
Save Messages in Alternate File Formats	p. 233
Use Categories to Manage Messages	p. 233
Set Message Options	p. 234
Creating and Managing Contacts	p. 235
Create and Edit Contacts	p. 235
Organize and Sort Contacts	p. 235
Link Contacts to Activities and Journal Entries	p. 236
Creating and Managing Tasks and Notes	p. 237
Create and Update Tasks	p. 237
Modify Task Organization and Task View	p. 237
Accept, Decline, or Delegate Tasks	p. 238
Create and Modify Notes	p. 238
Use Categories to Manage Tasks and Notes	p. 239
Index	p. 241
Table of Contents provided by Syndetics. All Rights Reserved.