0%

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
    2. Navigating Within Documents
    3. Formatting Documents
    4. Saving and Sharing Documents
    5. Inspecting Documents for Issues
    6. Summary
    7. Key Terms
    8. Exam Essentials
    9. Review Questions
    10. Chapter 2: Inserting and Formatting Text
    11. Adding and Replacing Text
    12. Formatting Text and Paragraphs
    13. Creating and Configuring Document Sections
    14. Summary
    15. Key Terms
    16. Exam Essentials
    17. Review Questions
    18. Chapter 3: Managing Tables and Lists
    19. Creating Tables
    20. Modifying Tables
    21. Creating and Formatting Lists
    22. Summary
    23. Key Terms
    24. Exam Essentials
    25. Review Questions
    26. Chapter 4: Building References
    27. Creating and Managing Referencing Elements
    28. Working with Referencing Tables
    29. Summary
    30. Key Terms
    31. Exam Essentials
    32. Review Questions
    33. Chapter 5: Adding and Formatting Graphic Elements
    34. Inserting Illustrations and Text Boxes
    35. Formatting Illustrations and Text Boxes
    36. Adding and Organizing Text
    37. Modifying Graphic Elements
    38. Summary
    39. Key Terms
    40. Exam Essentials
    41. Review Questions
    42. Chapter 6: Working with Other Users on Your Document
    43. Adding Comments
    44. Tracking Your Changes
    45. Summary
    46. Key Terms
    47. Exam Essentials
    48. Review Questions
  11. PART II: Excel Exam MO‐200
    1. Chapter 7: Managing Worksheets and Workbooks
    2. Importing Data into Workbooks
    3. Navigating Within Workbooks
    4. Formatting Worksheets and Workbooks
    5. Customizing Options and Views
    6. Configuring Content for Collaboration
    7. Summary
    8. Key Terms
    9. Exam Essentials
    10. Review Questions
    11. Chapter 8: Using Data Cells and Ranges
    12. Manipulating Data in Worksheets
    13. Formatting Cells and Ranges
    14. Defining and Referencing Named Ranges
    15. Summarizing Data Visually
    16. Summary
    17. Key Terms
    18. Exam Essentials
    19. Review Questions
    20. Chapter 9: Working with Tables and Table Data
    21. Creating and Formatting Tables
    22. Modifying Tables
    23. Filtering and Sorting Table Data
    24. Summary
    25. Key Terms
    26. Exam Essentials
    27. Review Questions
    28. Chapter 10: Performing Operations by Using Formulas and Functions
    29. Inserting References
    30. Calculating and Transforming Datas
    31. Formatting and Modifying Text
    32. Summary
    33. Key Terms
    34. Exam Essentials
    35. Review Questions
    36. Chapter 11: Managing Charts
    37. Creating Charts
    38. Modifying Charts
    39. Formatting Charts
    40. Summary
    41. Key Terms
    42. Exam Essentials
    43. Review Questions
  12. PART III: PowerPoint Exam MO‐300
    1. Chapter 12: Creating Presentations
    2. Modifying Slide Masters, Handout Masters, and Note Masters
    3. Changing Presentation Options and Views
    4. Configuring Print Settings for Presentations
    5. Configuring and Presenting Slideshows
    6. Preparing Presentations for Collaboration
    7. Summary
    8. Key Terms
    9. Exam Essentials
    10. Review Questions
    11. Chapter 13: Managing Slides
    12. Inserting Slides
    13. Modifying Slides
    14. Ordering and Grouping Slides
    15. Summary
    16. Key Terms
    17. Exam Essentials
    18. Review Questions
    19. Chapter 14: Inserting and Formatting Text, Shapes, and Images
    20. Formatting Text
    21. Inserting Links
    22. Inserting and Formatting Images
    23. Inserting and Formatting Graphic Elements
    24. Ordering and Grouping Objects on Slides
    25. Summary
    26. Key Terms
    27. Exam Essentials
    28. Review Questions
    29. Chapter 15: Inserting Tables, Charts, SmartArt, 3D Models, and Media
    30. Inserting and Formatting Tables
    31. Inserting and Modifying Charts
    32. Inserting and Formatting SmartArt Graphics
    33. Inserting and Modifying 3D Models
    34. Inserting and Managing Media
    35. Summary
    36. Key Terms
    37. Exam Essentials
    38. Review Questions
    39. Chapter 16: Applying  Transitions and Animations
    40. Applying and Configuring Slide Transitions
    41. Animating Slide Content
    42. Setting Timing for Transitions
    43. Summary
    44. Key Terms
    45. Exam Essentials
    46. 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
44.204.34.64