Home > Store

MOS Study Guide for Microsoft Excel Exam MO-200

MOS Study Guide for Microsoft Excel Exam MO-200

eBook (Watermarked)

  • Your Price: $15.99
  • List Price: $19.99
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Also available in other formats.

Register your product to gain access to bonus material or receive a coupon.


  • Copyright 2020
  • Dimensions: 7-3/8" x 9"
  • Edition: 1st
  • eBook (Watermarked)
  • ISBN-10: 0-13-662722-6
  • ISBN-13: 978-0-13-662722-7

Advance your everyday proficiency with Excel!

And earn the credential that proves it!

Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Excel Associate (Excel and Excel 2019) certification, this official Study Guide delivers:

  • In-depth preparation for each MOS objective
  • Detailed procedures to help build the skills measured by the exam
  • Hands-on tasks to practice what you’ve learned
  • Ready-made practice files

Sharpen the skills measured by these objectives:

  • Manage Worksheets and Workbooks
  • Manage Data Cells and Ranges
  • Manage Tables and Table Data
  • Perform Operations by Using Formulas and Functions
  • Manage Charts
About MOS
A Microsoft Office Specialist (MOS) certification validates your proficiency with Microsoft Office programs, demonstrating that you can meet globally recognized performance standards. Hands-on experience with the technology is required to successfully pass Microsoft Certification exams. 



Follow the instructions to download this book's lesson files.

  1. Click the Download button below to start the download.
  2. If prompted, click Save.
  3. Locate the .zip file on your computer. Right-click the file, click Extract All, and then follow the instructions.

Sample Content

Sample Pages

Download the sample pages (includes Chapter 2)

Table of Contents

1 Manage worksheets and workbooks

Objective 1.1: Import data into workbooks

Objective 1.2: Navigate within workbooks

Objective 1.3: Format worksheets and workbooks

Objective 1.4: Customize options and views

Objective 1.5: Configure content for collaboration

2 Manage data cells and ranges

Objective 2.1: Manipulate data in worksheets

Objective 2.2: Format cells and ranges

Objective 2.3: Define and reference named ranges

Objective 2.4: Summarize data visually

3 Manage tables and table data

Objective 3.1: Create and format tables

Objective 3.2: Modify tables

Objective 3.3: Filter and sort table data

4 Perform operations by using formulas and functions

Objective 4.1: Insert references in formulas

Objective 4.2: Calculate and transform data by using functions

Objective 4.3: Format and modify text by using functions

5 Manage charts

Objective 5.1: Create charts

Objective 5.2: Modify charts

Objective 5.3: Format charts


Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership