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

Excel Associate Exam MO-200

Eric Butow

• Publisher: Sybex
• Year: 2021
• Print ISBN: 9781119718246
• eBook ISBN: 9781119718253
• Edition: 1
• Topic: Computer Science
• Subtopic: Certification Guides in Computer Science
• Index: Computer Science

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.

Chapter 1
Managing Worksheets and Workbooks

MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:

• Manage worksheets and workbooks
  • Import data into workbooks
    • Import data from .txt files
    • Import data from .csv files
  • Navigate within workbooks
    • Search for data within a workbook
    • Navigate to named cells, ranges, or workbook elements
    • Insert and remove hyperlinks
  • Format worksheets and workbooks
    • Modify page setup
    • Adjust row height and column width
    • Customize headers and footers
  • Customize options and views
    • Customize the Quick Access toolbar
    • Display and modify workbook content in different views
    • Freeze worksheet rows and columns
    • Change window views
    • Modify basic workbook properties
    • Display formulas
  • Configure content for collaboration
    • Set a print area
    • Save workbooks in alternative file formats
    • Configure print settings
    • Inspect workbooks for issues

Welcome to this book, designed to help you study for and pass the MO‐200 Microsoft Excel (Excel and Excel 2019) exam and become a certified Microsoft Office Specialist: Excel Associate. If you're all settled in, it's time to get this show on the road.

In this chapter, I'll start by showing you how to import data in other formats into Excel spreadsheets, which Excel calls worksheets, as well as collections of spreadsheets that Excel calls a workbook. Next, I'll show you how to navigate within a workbook and get comfortable with the Excel interface.

When you feel good about creating an Excel spreadsheet, I'll show you how to format that spreadsheet so that it looks the way you want. You'll also learn how to change the way information is presented to make Excel work better for you.

Finally, I'll show you how to get your spreadsheets ready to share in print and online. You'll also learn how to inspect your workbooks 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 in 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‐200 exam.

Importing Data into Workbooks

If you need to import existing data into a workbook, you should first check to see if the file is in a format that Excel likes. The most common formats are the native Excel, text, and comma‐delimited value (CSV) formats.

The native Excel format has the .xls filename extension that dates all the way back to MS‐DOS days, so you can obviously open those files. However, if you open an older XLS file, you may experience some issues with formatting.

It is more likely that you will receive files in text format with the .txt file extension and in comma‐separated values (CSV) format with the .csv file extension. These two formats are what Microsoft focuses on in the MO‐200 exam.

Text and CSV formats use a delimiter, which is a character that separates blocks of text, like between numbers. A text file will use a tab character to separate those blocks. A CSV file uses commas to separate each block of text.

After you open a text file, Excel does not change the format of the file. The file remains with the .txt or .csv extension as you save updates to it.

---

Excel allows you to import an...

Table of contents

• Cover
• Table of Contents
• Title Page
• Copyright
• Dedication
• Acknowledgments
• About the Author
• About the Technical Editor
• Table of Exercises
• Introduction
• Chapter 1: Managing Worksheets and Workbooks
• Chapter 2: Using Data Cells and Ranges
• Chapter 3: Working with Tables and Table Data
• Chapter 4: Performing Operations by Using Formulas and Functions
• Chapter 5: Managing Charts
• Appendix: Answers to Review Questions
• Index
• Online Test Bank
• End User License Agreement