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

✍ Scribed by Eric Butow

• Publisher: Sybex
• Year: 2021
• Tongue: English
• Leaves: 707
• Edition: 1
• Category: Library

✦ Synopsis

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

Cover
Title Page
Copyright Page
Acknowledgments
About the Author
About the Technical Editor
Contents at a Glance
Contents
Table of Exercises
Introduction
Interactive Online Learning Environment and TestBank
Objective Map
Assessment Test
Answers to Assessment Test
Part I Word Exam MO-100
Chapter 1 Working with Documents
Navigating Within Documents
Searching for Text
Linking to Locations Within Documents
Moving to Specific Locations and Objects in Documents
Showing and Hiding Formatting Symbols and Hidden Text
Formatting Documents
Setting Up Document Pages
Applying Style Settings
Inserting and Modifying Headers and Footers
Configuring Page Background Elements
Saving and Sharing Documents
Saving Documents in Alternative File Formatting
Changing Basic Document Properties
Modifying Print Settings
Sharing Documents Electronically
Inspecting Documents for Issues
Locating and Removing Hidden Properties and Personal Information
Finding and Fixing Accessibility Issues
Locating and Correcting Compatibility Issues
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 2 Inserting and Formatting Text
Adding and Replacing Text
Finding and Replacing Text
Inserting Symbols and Special Characters
Formatting Text and Paragraphs
Adding Text Effects
Applying Formatting by Using Format Painter
Setting Line and Paragraph Spacing and Indentation
Applying Built-In Styles to Text
Clearing Formatting
Creating and Configuring Document Sections
Formatting Text in Multiple Columns
Inserting Page, Section, and Column Breaks
Changing Page Setting Options for a Section
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 3 Managing Tables and Lists
Creating Tables
Converting Text to Tables
Switching Tables to Text
Creating Tables by Specifying Rows and Columns
Modifying Tables
Sorting Table Data
Configuring Cell Margins and Spacing
Merging and Splitting Cells
Resizing Tables, Rows, and Columns
Splitting Tables
Configuring a Repeating Row Header
Creating and Formatting Lists
Structuring Paragraphs as Numbered and Bulleted Lists
Changing Bullet Characters and Number Formatting
Defining Custom Bullet Characters and Number Formatting
Increasing and Decreasing List Levels
Restarting and Continuing List Numbering
Setting Starting Number Values
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 4 Building References
Creating and Managing Referencing Elements
Inserting Footnotes and Endnotes
Modifying Footnote and Endnote Properties
Creating and Modifying Bibliography Citation Sources
Inserting Citations for Bibliographies
Working with Referencing Tables
Inserting Tables of Contents
Customizing Tables of Contents
Adding Bibliographies
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 5 Adding and Formatting Graphic Elements
Inserting Illustrations and Text Boxes
Adding Shapes
Including Pictures
Inserting 3D Models
Adding SmartArt Graphics
Placing Screenshots and Screen Clippings
Inserting Text Boxes
Formatting Illustrations and Text Boxes
Applying Artistic Effects
Adding Picture Effects and Picture Styles
Removing Picture Backgrounds
Formatting Graphic Elements
Setting Up SmartArt Graphics
Working with 3D Models
Adding and Organizing Text
Formatting Text in Text Boxes
Adding Text in Shapes
Changing SmartArt Graphic Content
Modifying Graphic Elements
Positioning Objects
Wrapping Text Around Objects
Adding Alt Text to Objects
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 6 Working with Other Users on Your Document
Adding Comments
Inserting Comments
Reviewing and Replying to Comments
Resolving Comments
Deleting Comments
Tracking Your Changes
Turning On Track Changes
Reviewing Tracked Changes
Accepting and Rejecting Tracked Changes
Locking and Unlocking Change Tracking
Summary
Key Terms
Exam Essentials
Review Questions
Part II Excel Exam MO-200
Chapter 7 Managing Worksheets and Workbooks
Importing Data into Workbooks
Bringing in Data from TXT Files
Importing Data from CSV Files
Navigating Within Workbooks
Searching for Data Within a Workbook
Navigating to Named Cells, Ranges, or Workbook Elements
Inserting and Removing Hyperlinks
Formatting Worksheets and Workbooks
Modifying Page Settings
Adjusting Row Height and Column Width
Customizing Headers and Footers
Customizing Options and Views
Customizing the Quick Access Toolbar
Displaying and Modifying Workbook Content in Different Views
Freezing Worksheet Rows and Columns
Changing Window Views
Modifying Basic Workbook Properties
Displaying Formulas
Configuring Content for Collaboration
Setting a Print Area
Saving Workbooks in Other File Formats
Configuring Print Settings
Inspecting Workbooks for Issues
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 8 Using Data Cells and Ranges
Manipulating Data in Worksheets
Pasting Data by Using Special Paste Options
Filling Cells by Using Auto Filling
Inserting and Deleting Multiple Columns or Rows
Adding and Removing Cells
Formatting Cells and Ranges
Merging and Unmerging Cells
Modifying Cell Alignment, Orientation, and Indentation
Formatting Cells by Using Format Painter
Wrapping Text Within Cells
Using Number Formatting
Applying Cell Formatting from the Format Cells Dialog Box
Working with Cell Styles
Clearing Cell Formatting
Defining and Referencing Named Ranges
Defining a Named Range
Naming a Table
Summarizing Data Visually
Inserting Sparklines
Applying Built-In Conditional Formatting
Removing Conditional Formatting
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 9 Working with Tables and Table Data
Creating and Formatting Tables
Creating Excel Tables from Cell Ranges
Applying Table Styles
Converting Tables to Cell Ranges
Modifying Tables
Adding or Remove Table Rows and Columns
Configuring Table Style Options
Inserting and Configuring Total Rows
Filtering and Sorting Table Data
Filtering Records
Sorting Data by Multiple Columns
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 10 Performing Operations by Using Formulas and Functions
Inserting References
Inserting Relative, Absolute, and Mixed References
Referencing Named Ranges and Named Tables in Formulas
Calculating and Transforming Datas
Performing Calculations Using the AVERAGE(), MAX(), MIN(), and SUM() Functions
Perform Conditional Operations by Using the IF() Function
Formatting and Modifying Text
Formatting Text Using the RIGHT(), LEFT(), and MID() Functions
Formatting Text Using the UPPER(), LOWER(), and LEN() Functions
Formatting Text Using the CONCAT() and TEXTJOIN() Functions
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 11 Managing Charts
Creating Charts
Building Charts
Working with Chart Sheets
Modifying Charts
Adding Data Series to Charts
Switching Between Rows and Columns in Source Data
Adding and Modifying Chart Elements
Formatting Charts
Using Chart Layouts
Applying Chart Styles
Adding Alternative Text to Charts for Accessibility
Summary
Key Terms
Exam Essentials
Review Questions
Part III PowerPoint Exam MO-300
Chapter 12 Creating Presentations
Modifying Slide Masters, Handout Masters, and Note Masters
Changing the Slide Master Theme or Background
Modifying Slide Master Content
Creating Slide Layouts
Modify Slide Layouts
Modifying the Handout Master
Modifying the Notes Master
Changing Presentation Options and Views
Changing the Slide Size
Displaying Presentations in Different Views
Setting Basic File Properties
Configuring Print Settings for Presentations
Printing All or Part of a Presentation
Printing Notes Pages
Printing Handouts
Printing in Color, Grayscale, or Black and White
Configuring and Presenting Slideshows
Creating Custom Slideshows
Configuring Slideshow Options
Rehearsing Slideshow Timing
Setting Up Slideshow Recording Options
Presenting Slideshows by Using Presenter View
Preparing Presentations for Collaboration
Mark Presentations as Final
Protecting Presentations by Using Passwords
Inspecting Presentations for Issues
Adding and Managing Comments
Preserving Presentation Content
Exporting Presentations to Other Formats
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 13 Managing Slides
Inserting Slides
Importing Word Document Outlines
Inserting Slides from Another Presentation
Inserting Slides and Selecting Slide Layouts
Inserting Summary Zoom Slides
Duplicating Slides
Modifying Slides
Hiding and Unhiding Slides
Modifying Individual Slide Backgrounds
Inserting Slide Headers, Footers, and Page Numbers
Ordering and Grouping Slides
Creating Sections
Modifying the Slide Order
Renaming Sections
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 14 Inserting and Formatting Text, Shapes, and Images
Formatting Text
Applying Formatting and Styles to Text
Formatting Text in Multiple Columns
Creating Bulleted and Numbered Lists
Inserting Links
Inserting Hyperlinks
Inserting Section Zoom Links and Slide Zoom Links
Inserting and Formatting Images
Resizing and Cropping Images
Applying Built-In Styles and Effects to Images
Inserting Screenshots and Screen Clippings
Inserting and Formatting Graphic Elements
Inserting and Changing Shapes
Drawing by Using Digital Ink
Adding Text to Shapes and Text Boxes
Resizing Shapes and Text Boxes
Formatting Shapes and Text Boxes
Applying Built-In Styles to Shapes and Text Boxes
Adding Alt Text to Graphic Elements for Accessibility
Ordering and Grouping Objects on Slides
Ordering Shapes, Images, and Text Boxes
Aligning Shapes, Images, and Text Boxes
Grouping Shapes and Images
Displaying Alignment Tools
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 15 Inserting Tables, Charts, SmartArt, 3D Models, and Media
Inserting and Formatting Tables
Creating and Inserting Tables
Inserting and Deleting Table Rows and Columns
Applying Built-In Table Styles
Inserting and Modifying Charts
Creating and Inserting Charts
Modifying Charts
Inserting and Formatting SmartArt Graphics
Inserting SmartArt Graphics
Converting Lists to SmartArt Graphics
Adding and Modifying SmartArt Graphic Content
Inserting and Modifying 3D Models
Inserting 3D Models
Modifying 3D Models
Inserting and Managing Media
Inserting Audio and Video Clips
Creating and Inserting Screen Recordings
Configuring Media Playback Options
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 16 Applying Transitions and Animations
Applying and Configuring Slide Transitions
Applying Basic and 3D Slide Transitions
Configuring Transition Effects
Animating Slide Content
Animating Text and Graphic Elements
Animating 3D Models
Configuring Animation Effects
Configuring Animation Paths
Reordering Animations on a Slide
Setting Timing for Transitions
Setting Transition Effect Duration
Configuring Transition Start and Finish Options
Summary
Key Terms
Exam Essentials
Review Questions
Appendix: Answers to Review Questions
Part I: Word Exam MO-100Chapter 1: Working with Documents
Chapter 2: Inserting and Formatting Text
Chapter 3: Managing Tables and Lists
Chapter 4: Building References
Chapter 5: Adding and Formatting Graphic Elements
Chapter 6: Working with Other Users on Your Document
Part II: Excel Exam MO-200
Chapter 7: Managing Worksheets and Workbooks
Chapter 8: Using Data Cells and Ranges
Chapter 9: Working with Tables and Table Data
Chapter 10: Performing Operations by Using Formulas and Functions
Chapter 11: Managing Charts
Part III: PowerPoint Exam MO-300
Chapter 12: Creating Presentations
Chapter 13: Managing Slides
Chapter 14: Inserting and Formatting Text, Shapes, and Images
Chapter 15: Inserting Tables, Charts, SmartArt, 3D Models, and Media
Chapter 16: Applying Transitions and Animations
Index
EULA