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

Length: 704 pages
Edition: 1
Language: English
Publisher: Sybex
Publication Date: 2021-06-29
ISBN-10: 111971849X
ISBN-13: 9781119718499
Sales Rank: #953817 (See Top 100 Books)

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.

Cover
Table of Contents
Title Page
Copyright
Dedication
Acknowledgments
About the Author
About the Technical Editor
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
        Formatting Documents
        Saving and Sharing Documents
        Inspecting Documents for Issues
        Summary
        Key Terms
        Exam Essentials
        Review Questions
    Chapter 2: Inserting and Formatting Text
        Adding and Replacing Text
        Formatting Text and Paragraphs
        Creating and Configuring Document Sections
        Summary
        Key Terms
        Exam Essentials
        Review Questions
    Chapter 3: Managing Tables and Lists
        Creating Tables
        Modifying Tables
        Creating and Formatting Lists
        Summary
        Key Terms
        Exam Essentials
        Review Questions
    Chapter 4: Building References
        Creating and Managing Referencing Elements
        Working with Referencing Tables
        Summary
        Key Terms
        Exam Essentials
        Review Questions
    Chapter 5: Adding and Formatting Graphic Elements
        Inserting Illustrations and Text Boxes
        Formatting Illustrations and Text Boxes
        Adding and Organizing Text
        Modifying Graphic Elements
        Summary
        Key Terms
        Exam Essentials
        Review Questions
    Chapter 6: Working with Other Users on Your Document
        Adding Comments
        Tracking Your Changes
        Summary
        Key Terms
        Exam Essentials
        Review Questions
PART II: Excel Exam MO‐200
    Chapter 7: Managing Worksheets and Workbooks
        Importing Data into Workbooks
        Navigating Within Workbooks
        Formatting Worksheets and Workbooks
        Customizing Options and Views
        Configuring Content for Collaboration
        Summary
        Key Terms
        Exam Essentials
        Review Questions
    Chapter 8: Using Data Cells and Ranges
        Manipulating Data in Worksheets
        Formatting Cells and Ranges
        Defining and Referencing Named Ranges
        Summarizing Data Visually
        Summary
        Key Terms
        Exam Essentials
        Review Questions
    Chapter 9: Working with Tables and Table Data
        Creating and Formatting Tables
        Modifying Tables
        Filtering and Sorting Table Data
        Summary
        Key Terms
        Exam Essentials
        Review Questions
    Chapter 10: Performing Operations by Using Formulas and Functions
        Inserting References
        Calculating and Transforming Datas
        Formatting and Modifying Text
        Summary
        Key Terms
        Exam Essentials
        Review Questions
    Chapter 11: Managing Charts
        Creating Charts
        Modifying Charts
        Formatting Charts
        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 Presentation Options and Views
        Configuring Print Settings for Presentations
        Configuring and Presenting Slideshows
        Preparing Presentations for Collaboration
        Summary
        Key Terms
        Exam Essentials
        Review Questions
    Chapter 13: Managing Slides
        Inserting Slides
        Modifying Slides
        Ordering and Grouping Slides
        Summary
        Key Terms
        Exam Essentials
        Review Questions
    Chapter 14: Inserting and Formatting Text, Shapes, and Images
        Formatting Text
        Inserting Links
        Inserting and Formatting Images
        Inserting and Formatting Graphic Elements
        Ordering and Grouping Objects on Slides
        Summary
        Key Terms
        Exam Essentials
        Review Questions
    Chapter 15: Inserting Tables, Charts, SmartArt, 3D Models, and Media
        Inserting and Formatting Tables
        Inserting and Modifying Charts
        Inserting and Formatting SmartArt Graphics
        Inserting and Modifying 3D Models
        Inserting and Managing Media
        Summary
        Key Terms
        Exam Essentials
        Review Questions
    Chapter 16: Applying  Transitions and Animations
        Applying and Configuring Slide Transitions
        Animating Slide Content
        Setting Timing for Transitions
        Summary
        Key Terms
        Exam Essentials
        Review Questions
Appendix: Answers to Review Questions
    Part I: Word Exam MO‐100
    Chapter 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
Online Test Bank
    Register and Access the Online Test Bank
End User License Agreement