0%

MCA Microsoft® Office Specialist (Office 365 and Office 2019) STUDY GUIDE

Your complete guide to preparing for the Microsoft Office Specialist Excel exam

The MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide: Excel Associate Exam MO-200 is your one-stop resource for preparing you to earn the Excel Associate certification. The exam measures your competencies in the fundamentals of Excel. This guide starts you off with an assessment test to measure what you already know and what you still need to learn. Then you move into professional scenarios and examples, practical exercises, and challenging chapter review questions. Finally, you can reinforce and retain what you’ve learned with the Sybex online learning environment and test bank. Get prepared for the Excel Associate Exam with Sybex.

Coverage of 100% of all exam objectives in this Study Guide means you’ll be ready to:

  • Create and manage worksheets and workbooks
  • Apply formulas and functions
  • Populate tables with data
  • Create and edit a workbook with multiple sheets
  • Add a graphic element to represent data visually
  • Interactive learning environment

    Take your exam prep to the next level with Sybex’s superior interactive online study tools. To access our learning environment, simply visit www.wiley.com/go/sybextestprep, register your book to receive your unique PIN, and instantly gain one year of FREE access after activation to:

  • Interactive test bank with a practice exam to help you identify areas where further review is needed. Get more than 90% of the answers correct, and you’re ready to take the certification exam.
  • 100 electronic flashcards to reinforce learning and last-minute prep before the exam.
  • Comprehensive glossary in PDF format gives you instant access to the key terms so you are fully prepared.
  • 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 Test Bank
      2. Objective Map
      3. Assessment Test
      4. Answers to Assessment Test
    10. Chapter 1: 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
    11. Chapter 2: 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
    12. Chapter 3: 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
    13. Chapter 4: 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
    14. Chapter 5: Managing Charts
      1. Creating Charts
      2. Modifying Charts
      3. Formatting Charts
      4. Summary
      5. Key Terms
      6. Exam Essentials
      7. Review Questions
    15. Appendix: Answers to Review Questions
      1. Chapter 1: Managing Worksheets and Workbooks
      2. Chapter 2: Using Data Cells and Ranges
      3. Chapter 3: Working with Tables and Table Data
      4. Chapter 4: Performing Operations by Using Formulas and Functions
      5. Chapter 5: Managing Charts
    16. Index
    17. Online Test Bank
      1. Register and Access the Online Test Bank
    18. End User License Agreement
    3.236.171.68