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

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

  1. English
  2. ePUB (mobile friendly)
  3. Available on iOS & Android
eBook - ePub

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

About this book

Master one of the most essential skillsetsfor thecontemporaryoffice

As Microsoft Officebecomes ever more ubiquitous in modern offices across the world, competence and familiarity with its intricaciesis more important than ever. Now you can set yourself apart from the pack and prove yourskills withthe Microsoft Office Specialistcertification.

TheMCA Microsoft Office Specialist(Office 365 and Office 2019)Complete StudyGuide: Word Associate Exam MO-100, Excel Associate Exam MO-200, and PowerPoint Associate Exam MO-300 deliversa comprehensive roadmap to achieving the certification with easy-to-follow instruction for each of the three requiredproficiencies: Word, Excel, and PowerPoint. You'llenjoy access to chapter review questions andExam Essentials, a feature that identifies critical subject areas.

Discover practical, hands-on exercises that prepare you forreal-world roles andjobs, andgain valuable experience as you reinforcekey Microsoft Office skillsthatyou'll be expected todemonstrateinjob interviews and your day-to-day professional life.Learnto manage and create text documents in Word, perform operations with formulas in Excel, andcreate engaging slideshows and presentations in PowerPoint.

This practical bookalso provides:

  • Fully updatedinformationfor the latest Microsoft Office Specialist certification examscovering Microsoft Office 365
  • Access to new career opportunitieswith a professional certification that's relevant to virtually any office environment
  • Accesstothe Sybex onlinestudy tools, with chapter review questions, full-length practice exams, hundreds of electronic flashcards, and a glossary of key terms

TheMCA Microsoft Office Specialist(Office 365 and Office 2019)Complete Study Guide offerscrystal-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 toimprove their mastery of Microsoft Office 365.

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn more here.
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide by Eric Butow in PDF and/or ePUB format, as well as other popular books in Computer Science & Certification Guides in Computer Science. We have over one million books available in our catalogue for you to explore.

PART I
Word Exam MO‐100

Chapter 1
Working with Documents

MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:
  • Manage documents
    • Navigate within documents
      • Search for text
      • Link to locations within documents
      • Move to specific locations and objects in documents
      • Show and hide formatting symbols and hidden text
    • Format documents
      • Set up document pages
      • Apply style sets
      • Insert and modify headers and footers
      • Configure page background elements
    • Save and share documents
      • Save documents in alternative file formats
      • Modify basic document properties
      • Modify print settings
      • Share documents electronically
    • Inspect documents for issues
      • Locate and remove hidden properties and personal information
      • Find and correct accessibility issues
      • Locate and correct compatibility issues
image
You're reading this book because you want to study for and pass the MO‐100 Microsoft Word (Word and Word 2019) exam and become a certified Microsoft Office Specialist: Word Associate. I hope you have your favorite beverage nearby, you're comfortable, and you have Word fired up so that you can go through the exercises in this chapter.
Before embarking on a road trip, we often refer to the directions provided by our favorite map app before we leave. In this chapter, I'll show you how to work with documents, including navigating within documents so that you can edit them easily. Next, I'll show you how to format documents to make them look the way you want.
When you know how to control your documents, I'll show you how to save them in the format you want and share them with other people. Finally, I'll show you how to inspect your documents so that you can find and remove hidden properties as well as fix any issues with accessibility and compatibility.
I'll have an exercise at the end of every section within this chapter so that you can practice doing different tasks. Then, at the end of this chapter, you'll find a set of review questions that mimic the test questions you'll see on the MO‐100 exam.

Navigating Within Documents

It's easy just to fire up Word and start writing. But, of course, you're doing more than just writing. You inevitably need to start moving around the document and making changes to it, and in this section I talk about the tools Word gives you to do those tasks.
Microsoft has added a lot of powerful search features to Word so that you can find the text you're looking for pretty easily. You can access these tools through menu options and their associated ribbons, as well as by using keyboard shortcuts.
If you want to move quickly from one location in a long document to another so that you don't have to keep scrolling up and down a lot of pages, Word makes it easy to add a link within your document. You can also use tools in the ribbon, as well as keyboard shortcuts, to go to different spots in your document.
Word also has a lot of hidden formatting symbols that you can show. What's more, you can hide text that you don't want to see cluttering your document, but Word also makes it easy to reveal hidden text whenever you want to see it.

Searching for Text

Unless you have only a small amount of text in your document, you'll find that you need help locating the words that you want. Word has you covered with tools not only to find words in your document, but to replace them easily as well.

Using the Search Bar

The Search bar appears within the Word window's title bar to make it more conspicuous. Type one or more search terms in the Search box, and then click the terms within the Find In Document area in the drop‐down list. The Navigation pane opens on the left sid...

Table of contents

  1. Cover
  2. Table of Contents
  3. Title Page
  4. Copyright
  5. Dedication
  6. Acknowledgments
  7. About the Author
  8. About the Technical Editor
  9. Table of Exercises
  10. Introduction
  11. PART I: Word Exam MO‐100
  12. PART II: Excel Exam MO‐200
  13. PART III: PowerPoint Exam MO‐300
  14. Appendix: Answers to Review Questions
  15. Index
  16. Online Test Bank
  17. End User License Agreement