Introduction

Welcome to MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide: Excel Associate Exam MO-200! This book is the first step in your journey to becoming a Microsoft Certified Office Specialist for Microsoft Excel, which is a component of the Microsoft 365 suite of productivity applications to which you can subscribe. You can also use this book with the one-time purchase version of Excel, which Microsoft calls Excel 2019.

Microsoft 365 allows you to use the different versions of Excel on many platforms, including Windows, macOS, iOS, iPadOS, and Android. You can even use the web version of Excel on the free online version of Microsoft 365. This book, however, talks about using the most popular version of Excel on the most popular operating system, which happens to be Excel for Microsoft 365 running on Windows 10.

You may already know about a lot of Excel features by working with it, but regardless of whether you use Excel for your regular documentation tasks or you're new to the application, you'll learn a lot about the power that Excel gives you to create all kinds of documents.

Who Should Read This Book

If you want to prepare to take the Microsoft Excel Exam MO-200, which will help you become a certified Excel specialist and hopefully increase your stature, marketability, and income, then this is the book for you. Even if you're not going to take the exam but you want to learn how to use Excel more effectively, this book will show you how to get the most out of using Excel based on features that Microsoft believes are important for you to know.

What You'll Learn from This Book

What you learn in this book adheres to the topics in the Microsoft Excel Exam MO-200, because this book is designed to help you learn about the topics in the exam and pass it on the first try.

After you finish reading the book and complete all the exercises, you'll have an in-depth understanding of Excel that you can use to become more productive at work and at home (or in your home office).

Hardware and Software Requirements

You should be running a computer with Windows 10 installed, and you should have Excel for Microsoft 365 or Excel 2019 installed and running too before you dive into this book. Either version of Excel contains all the features that are documented in this book so that you can pass the exam.

How to Use This Book

Start by taking the Assessment Test after this introduction to see how well you know Excel already. Even if you've been using Excel for a while, you may be surprised at how much you don't know about it.

Next, read each chapter and go through each of the exercises in the chapter to reinforce the concepts in each section. When you reach the end of the chapter, answer each of the 10 Review Questions to test what you learned. You can check your answers in the appendix at the back of the book.

If you're indeed taking the exam, then there are two other valuable tools that you can use: Flashcards and a Practice Exam. You may remember flashcards from when you were in school, and they're useful when you want to reinforce your knowledge. Use the Flashcards with a friend or relative if you like. (They might appreciate learning about Excel, too.) The Practice Exam will help you further hone your ability to answer any question on the real exam with no worries.

How to Contact Wiley or the Author

If you believe you have found an error in this book and it is not listed on the book's errata page, you can report the issue to our customer technical support team at support.wiley.com.

You can email the author with your comments or questions at eric@butow.net. You can also visit Eric's website at www.butow.net.

How This Book Is Organized

• Chapter 1: Managing Worksheets and Workbooks  This chapter introduces you to importing data into workbooks, navigating within a workbook, formatting worksheets and workbooks so that they look the way you want, customizing Excel options and views, saving a workbook, sharing a workbook, and inspecting a workbook before you share it, so that all of your recipients can read it.
• Chapter 2: Using Data Cells and Ranges  This chapter follows up by showing you how to manipulate your data in a worksheet to show the data that you want to see; formatting cells and ranges in a worksheet using Excel tools, including Format Painter and styles; defining and referencing cell ranges; and summarizing your data with Sparklines and conditional formatting.
• Chapter 3: Working with Tables and Table Data  This chapter shows you how to use the built-in table tools to create tables of information, convert the table to a cell range (and vice versa), as well as modify the table to look the way that you want. You'll also learn how to sort and filter text in a table.
• Chapter 4: Performing Operations by Using Formulas and Functions  This chapter tells you how to insert references into a cell formula, perform calculations, count cells, execute conditional operations, as well as format text using a variety of built-in Excel functions.
• Chapter 5: Managing Charts  This chapter covers how to create charts within a worksheet and on a separate worksheet, modify a chart to show the data you want, format a chart with layouts and styles, and add alternative text to a chart so that everyone who sees the chart will know what it's about.

Interactive Online Learning Environment and Test Bank

Learning the material in the MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide: Excel Associate Exam MO-200 is an important part of preparing for the Excel Exam MO-200, but we also provide additional tools to help you prepare. The online test bank will help you understand the types of questions that will appear on the certification exam.

The sample tests in the test bank include all of the questions in each chapter as well as the questions from the Assessment Test. In addition, there is a Practice Exam containing 50 questions. You can use this test to evaluate your understanding and identify areas that may require additional study.

The flashcards in the test bank will push the limits of what you should know for the certification exam. The flashcards contain 100 questions provided in digital format. Each flashcard has one question and one correct answer.

The online glossary is a searchable list of key terms introduced in this Study Guide that you should know for the Excel Exam MO-200.

To start using these tools to study for the MCA Microsoft Office Specialist Study Guide: Excel Exam MO-200, go to www.wiley.com/go/sybextestprep and register your book to receive your unique PIN. Once you have the PIN, return to www.wiley.com/go/sybextestprep, find your book, and click Register, or log in and follow the link to register a new account or to add this book to an existing account.

Exam objectives are subject to change at any time without prior notice and at Microsoft's sole discretion. Please visit the Exam MO-200: Microsoft Excel (Excel and Excel 2019) website (https://docs.microsoft.com/en-us/learn/certifications/exams/MO-200) for the most current listing of exam objectives.

Objective Map