MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide

ABOUT THE AUTHORERIC BUTOW is the author of 41 books on technology topics and has developed and taught networking, computing, and usability courses for Ed2Go, Virtual Training Company, California State University, Sacramento, and Udemy. He has been using Office since 1994. He’s served as a technical writer for companies like Intel, Wells Fargo, Cisco Systems, and Hewlett-Packard. He is the founder and owner of Butow Communications Group in Jackson, California.

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

Select Guide Rating