+353-1-416-8900REST OF WORLD
+44-20-3973-8888REST OF WORLD
1-917-300-0470EAST COAST U.S
1-800-526-8630U.S. (TOLL FREE)

MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide. Word Exam MO-100, Excel Exam MO-200, and PowerPoint Exam MO-300. Edition No. 1

  • Book

  • 704 Pages
  • August 2021
  • John Wiley and Sons Ltd
  • ID: 5842344

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

Authors

Eric Butow