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
  • Estimated Release: Mar 9, 2020
  • 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 2019, and earn the credential that proves it!
Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Excel 2019 certification, this official Study Guidedelivers:

  • 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
  • Sample files for practice tasks 
  • Solutions files so you can check your work 
Sharpen the skills measured by these objectives:
  • Create and manage worksheets and workbooks
  • Manage data cells and ranges
  • Create tables and manage table data
  • Perform operations by using formulas and functions
  • Create charts and objects
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. 

Sample Content

Table of Contents

IntroductionTaking a Microsoft Office Specialist examPrerequisitesObjective group 1: Create and manage worksheets and workbooksObjective 1.1: Create worksheets and workbooksObjective 1.2: Navigate in worksheets and workbooksObjective 1.3: Format worksheets and workbooksObjective 1.4: Customize options and views for worksheets and workbooksObjective 1.5: Configure worksheets and workbooks for distributionObjective group 2: Manage data cells and rangesObjective 2.1: Insert data in cells and rangesObjective 2.2: Format cells and rangesObjective 2.3: Summarize and organize dataObjective group 3: Create tablesObjective 3.1: Create and manage tablesObjective 3.2: Manage table styles and optionsObjective 3.3: Filter and sort tablesObjective group 4: Perform operations by using formulas and functionsObjective 4.1: Summarize data by using functionsObjective 4.2: Perform conditional operations by using functionsObjective 4.3: Format and modify text by using functionsObjective group 5: Create charts and objectsObjective 5.1: Create chartsObjective 5.2: Format chartsObjective 5.3: Insert and format objects


Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership