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

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

by Eric Butow
Released June 2021
Publisher(s): Sybex
ISBN: 9781119718499

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

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

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

Product information

  • Title: MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide
  • Author(s): Eric Butow
  • Release date: June 2021
  • Publisher(s): Sybex
  • ISBN: 9781119718499