Master one of the most essential skill sets for the contemporary office
As Microsoft Office becomes ever more ubiquitous in modern offices across the world, competence and familiarity with its intricacies is more important than ever. Now you can set yourself apart from the pack and prove your skills with the Microsoft Office Specialist certification.
The MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide : Word Associate Exam MO-100, Excel Associate Exam MO-200, and PowerPoint Associate Exam MO-300 delivers a comprehensive roadmap to achieving the certification with easy-to-follow instruction for each of the three required proficiencies: Word, Excel, and PowerPoint. You’ll enjoy access to chapter review questions and Exam Essentials, a feature that identifies critical subject areas.
Discover practical, hands-on exercises that prepare you for real-world roles and jobs, and gain valuable experience as you reinforce key Microsoft Office skills that you’ll be expected to demonstrate in job interviews and your day-to-day professional life. Learn to manage and create text documents in Word, perform operations with formulas in Excel, and create engaging slideshows and presentations in PowerPoint.
This practical book also provides:
- Fully updated information for the latest Microsoft Office Specialist certification exams covering Microsoft Office 365
- Access to new career opportunities with a professional certification that’s relevant to virtually any office environment
- Access to the Sybex online study tools, with chapter review questions, full-length practice exams, hundreds of electronic flashcards, and a glossary of key terms
The MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide offers crystal-clear organization, comprehensive coverage, and easy-to-understand instruction. It’s perfect for anyone who hopes to prove their skills with the Microsoft Office Specialist certification or to improve their mastery of Microsoft Office 365.
Table of Contents
Introduction xxi
Assessment Test xxviii
Answers to Assessment Test xl
Part I Word Exam MO-100 1
Chapter 1 Working with Documents 3
Navigating Within Documents 4
Searching for Text 4
Linking to Locations Within Documents 8
Moving to Specific Locations and Objects in Documents 9
Showing and Hiding Formatting Symbols and Hidden Text 10
Formatting Documents 13
Setting Up Document Pages 14
Applying Style Settings 15
Inserting and Modifying Headers and Footers 17
Configuring Page Background Elements 18
Saving and Sharing Documents 20
Saving Documents in Alternative File Formatting 20
Changing Basic Document Properties 21
Modifying Print Settings 23
Sharing Documents Electronically 24
Inspecting Documents for Issues 26
Locating and Removing Hidden Properties and Personal Information 26
Finding and Fixing Accessibility Issues 28
Locating and Correcting Compatibility Issues 29
Summary 30
Key Terms 31
Exam Essentials 31
Review Questions 33
Chapter 2 Inserting and Formatting Text 35
Adding and Replacing Text 36
Finding and Replacing Text 36
Inserting Symbols and Special Characters 40
Formatting Text and Paragraphs 42
Adding Text Effects 42
Applying Formatting by Using Format Painter 43
Setting Line and Paragraph Spacing and Indentation 43
Applying Built-In Styles to Text 46
Clearing Formatting 47
Creating and Configuring Document Sections 50
Formatting Text in Multiple Columns 50
Inserting Page, Section, and Column Breaks 52
Changing Page Setting Options for a Section 53
Summary 56
Key Terms 57
Exam Essentials 57
Review Questions 58
Chapter 3 Managing Tables and Lists 61
Creating Tables 62
Converting Text to Tables 64
Switching Tables to Text 65
Creating Tables by Specifying Rows and Columns 66
Modifying Tables 68
Sorting Table Data 68
Configuring Cell Margins and Spacing 70
Merging and Splitting Cells 73
Resizing Tables, Rows, and Columns 75
Splitting Tables 80
Configuring a Repeating Row Header 82
Creating and Formatting Lists 85
Structuring Paragraphs as Numbered and Bulleted Lists 85
Changing Bullet Characters and Number Formatting 86
Defining Custom Bullet Characters and Number Formatting 88
Increasing and Decreasing List Levels 91
Restarting and Continuing List Numbering 92
Setting Starting Number Values 94
Summary 95
Key Terms 96
Exam Essentials 96
Review Questions 97
Chapter 4 Building References 99
Creating and Managing Referencing Elements 100
Inserting Footnotes and Endnotes 100
Modifying Footnote and Endnote Properties 103
Creating and Modifying Bibliography Citation Sources 104
Inserting Citations for Bibliographies 107
Working with Referencing Tables 109
Inserting Tables of Contents 109
Customizing Tables of Contents 110
Adding Bibliographies 112
Summary 113
Key Terms 113
Exam Essentials 114
Review Questions 115
Chapter 5 Adding and Formatting Graphic Elements 117
Inserting Illustrations and Text Boxes 118
Adding Shapes 118
Including Pictures 120
Inserting 3D Models 121
Adding SmartArt Graphics 122
Placing Screenshots and Screen Clippings 123
Inserting Text Boxes 125
Formatting Illustrations and Text Boxes 127
Applying Artistic Effects 127
Adding Picture Effects and Picture Styles 128
Removing Picture Backgrounds 131
Formatting Graphic Elements 132
Setting Up SmartArt Graphics 134
Working with 3D Models 136
Adding and Organizing Text 137
Formatting Text in Text Boxes 137
Adding Text in Shapes 139
Changing SmartArt Graphic Content 141
Modifying Graphic Elements 142
Positioning Objects 142
Wrapping Text Around Objects 143
Adding Alt Text to Objects 146
Summary 148
Key Terms 148
Exam Essentials 148
Review Questions 149
Chapter 6 Working with Other Users on Your Document 151
Adding Comments 152
Inserting Comments 152
Reviewing and Replying to Comments 153
Resolving Comments 154
Deleting Comments 155
Tracking Your Changes 157
Turning On Track Changes 157
Reviewing Tracked Changes 158
Accepting and Rejecting Tracked Changes 159
Locking and Unlocking Change Tracking 162
Summary 165
Key Terms 165
Exam Essentials 165
Review Questions 166
Part II Excel Exam MO-200 169
Chapter 7 Managing Worksheets and Workbooks 171
Importing Data into Workbooks 172
Bringing in Data from TXT Files 173
Importing Data from CSV Files 174
Navigating Within Workbooks 178
Searching for Data Within a Workbook 178
Navigating to Named Cells, Ranges, or Workbook Elements 180
Inserting and Removing Hyperlinks 182
Formatting Worksheets and Workbooks 190
Modifying Page Settings 190
Adjusting Row Height and Column Width 192
Customizing Headers and Footers 200
Customizing Options and Views 206
Customizing the Quick Access Toolbar 207
Displaying and Modifying Workbook Content in Different Views 211
Freezing Worksheet Rows and Columns 214
Changing Window Views 216
Modifying Basic Workbook Properties 218
Displaying Formulas 219
Configuring Content for Collaboration 222
Setting a Print Area 222
Saving Workbooks in Other File Formats 224
Configuring Print Settings 224
Inspecting Workbooks for Issues 225
Summary 229
Key Terms 229
Exam Essentials 229
Review Questions 231
Chapter 8 Using Data Cells and Ranges 233
Manipulating Data in Worksheets 234
Pasting Data by Using Special Paste Options 234
Filling Cells by Using Auto Filling 238
Inserting and Deleting Multiple Columns or Rows 240
Adding and Removing Cells 242
Formatting Cells and Ranges 245
Merging and Unmerging Cells 245
Modifying Cell Alignment, Orientation, and Indentation 246
Formatting Cells by Using Format Painter 249
Wrapping Text Within Cells 250
Using Number Formatting 252
Applying Cell Formatting from the Format Cells Dialog Box 253
Working with Cell Styles 254
Clearing Cell Formatting 256
Defining and Referencing Named Ranges 258
Defining a Named Range 258
Naming a Table 263
Summarizing Data Visually 265
Inserting Sparklines 265
Applying Built-In Conditional Formatting 269
Removing Conditional Formatting 271
Summary 275
Key Terms 275
Exam Essentials 275
Review Questions 277
Chapter 9 Working with Tables and Table Data 279
Creating and Formatting Tables 280
Creating Excel Tables from Cell Ranges 280
Applying Table Styles 282
Converting Tables to Cell Ranges 283
Modifying Tables 285
Adding or Remove Table Rows and Columns 285
Configuring Table Style Options 288
Inserting and Configuring Total Rows 289
Filtering and Sorting Table Data 292
Filtering Records 292
Sorting Data by Multiple Columns 296
Summary 298
Key Terms 299
Exam Essentials 299
Review Questions 300
Chapter 10 Performing Operations by Using Formulas and Functions 303
Inserting References 304
Inserting Relative, Absolute, and Mixed References 305
Referencing Named Ranges and Named Tables in Formulas 307
Calculating and Transforming Datas 310
Performing Calculations Using the AVERAGE(), MAX(), MIN(), and SUM() Functions 310
Perform Conditional Operations by Using the IF() Function 321
Formatting and Modifying Text 325
Formatting Text Using the RIGHT(), LEFT(), and MID() Functions 325
Formatting Text Using the UPPER(), LOWER(), and LEN() Functions 329
Formatting Text Using the CONCAT() and TEXTJOIN() Functions 333
Summary 336
Key Terms 337
Exam Essentials 337
Review Questions 338
Chapter 11 Managing Charts 341
Creating Charts 342
Building Charts 342
Working with Chart Sheets 344
Modifying Charts 348
Adding Data Series to Charts 348
Switching Between Rows and Columns in Source Data 351
Adding and Modifying Chart Elements 352
Formatting Charts 355
Using Chart Layouts 356
Applying Chart Styles 364
Adding Alternative Text to Charts for Accessibility 366
Summary 368
Key Terms 368
Exam Essentials 369
Review Questions 370
Part III PowerPoint Exam MO-300 373
Chapter 12 Creating Presentations 375
Modifying Slide Masters, Handout Masters, and Note Masters 377
Changing the Slide Master Theme or Background 378
Modifying Slide Master Content 383
Creating Slide Layouts 384
Modify Slide Layouts 389
Modifying the Handout Master 393
Modifying the Notes Master 400
Changing Presentation Options and Views 406
Changing the Slide Size 406
Displaying Presentations in Different Views 408
Setting Basic File Properties 410
Configuring Print Settings for Presentations 411
Printing All or Part of a Presentation 411
Printing Notes Pages 413
Printing Handouts 414
Printing in Color, Grayscale, or Black and White 415
Configuring and Presenting Slideshows 417
Creating Custom Slideshows 417
Configuring Slideshow Options 422
Rehearsing Slideshow Timing 423
Setting Up Slideshow Recording Options 427
Presenting Slideshows by Using Presenter View 430
Preparing Presentations for Collaboration 436
Mark Presentations as Final 437
Protecting Presentations by Using Passwords 438
Inspecting Presentations for Issues 439
Adding and Managing Comments 441
Preserving Presentation Content 446
Exporting Presentations to Other Formats 447
Summary 456
Key Terms 457
Exam Essentials 457
Review Questions 459
Chapter 13 Managing Slides 461
Inserting Slides 462
Importing Word Document Outlines 462
Inserting Slides from Another Presentation 465
Inserting Slides and Selecting Slide Layouts 467
Inserting Summary Zoom Slides 469
Duplicating Slides 474
Modifying Slides 475
Hiding and Unhiding Slides 476
Modifying Individual Slide Backgrounds 477
Inserting Slide Headers, Footers, and Page Numbers 480
Ordering and Grouping Slides 484
Creating Sections 484
Modifying the Slide Order 486
Renaming Sections 488
Summary 489
Key Terms 490
Exam Essentials 490
Review Questions 491
Chapter 14 Inserting and Formatting Text, Shapes, and Images 493
Formatting Text 495
Applying Formatting and Styles to Text 495
Formatting Text in Multiple Columns 501
Creating Bulleted and Numbered Lists 502
Inserting Links 504
Inserting Hyperlinks 504
Inserting Section Zoom Links and Slide Zoom Links 505
Inserting and Formatting Images 509
Resizing and Cropping Images 511
Applying Built-In Styles and Effects to Images 513
Inserting Screenshots and Screen Clippings 515
Inserting and Formatting Graphic Elements 518
Inserting and Changing Shapes 518
Drawing by Using Digital Ink 520
Adding Text to Shapes and Text Boxes 523
Resizing Shapes and Text Boxes 525
Formatting Shapes and Text Boxes 527
Applying Built-In Styles to Shapes and Text Boxes 529
Adding Alt Text to Graphic Elements for Accessibility 532
Ordering and Grouping Objects on Slides 534
Ordering Shapes, Images, and Text Boxes 534
Aligning Shapes, Images, and Text Boxes 535
Grouping Shapes and Images 537
Displaying Alignment Tools 538
Summary 539
Key Terms 540
Exam Essentials 540
Review Questions 541
Chapter 15 Inserting Tables, Charts, SmartArt, 3D Models, and Media 543
Inserting and Formatting Tables 544
Creating and Inserting Tables 544
Inserting and Deleting Table Rows and Columns 545
Applying Built-In Table Styles 548
Inserting and Modifying Charts 551
Creating and Inserting Charts 551
Modifying Charts 554
Inserting and Formatting SmartArt Graphics 560
Inserting SmartArt Graphics 560
Converting Lists to SmartArt Graphics 560
Adding and Modifying SmartArt Graphic Content 563
Inserting and Modifying 3D Models 565
Inserting 3D Models 565
Modifying 3D Models 567
Inserting and Managing Media 568
Inserting Audio and Video Clips 568
Creating and Inserting Screen Recordings 576
Configuring Media Playback Options 581
Summary 584
Key Terms 585
Exam Essentials 585
Review Questions 587
Chapter 16 Applying Transitions and Animations 589
Applying and Configuring Slide Transitions 590
Applying Basic and 3D Slide Transitions 590
Configuring Transition Effects 592
Animating Slide Content 596
Animating Text and Graphic Elements 596
Animating 3D Models 606
Configuring Animation Effects 609
Configuring Animation Paths 612
Reordering Animations on a Slide 617
Setting Timing for Transitions 619
Setting Transition Effect Duration 619
Configuring Transition Start and Finish Options 620
Summary 622
Key Terms 622
Exam Essentials 623
Review Questions 624
Appendix Answers to Review Questions 627
Part I: Word Exam MO-100 628
Chapter 1: Working with Documents 628
Chapter 2: Inserting and Formatting Text 628
Chapter 3: Managing Tables and Lists 629
Chapter 4: Building References 630
Chapter 5: Adding and Formatting Graphic Elements 630
Chapter 6: Working with Other Users on Your Document 631
Part II: Excel Exam MO-200 632
Chapter 7: Managing Worksheets and Workbooks 632
Chapter 8: Using Data Cells and Ranges 632
Chapter 9: Working with Tables and Table Data 633
Chapter 10: Performing Operations by Using Formulas and Functions 634
Chapter 11: Managing Charts 634
Part III: PowerPoint Exam MO-300 635
Chapter 12: Creating Presentations 635
Chapter 13: Managing Slides 636
Chapter 14: Inserting and Formatting Text, Shapes, and Images 636
Chapter 15: Inserting Tables, Charts, SmartArt, 3D Models, and Media 637
Chapter 16: Applying Transitions and Animations 638
Index 639
