MOS Study Guide for Microsoft Excel Exam MO-200

by Lambert, Joan

• ISBN13: 9780136627159
• ISBN10: 0136627153
• Edition: 1st
• Format: Study Guide
• Copyright: 2020-04-16
• Publisher: Microsoft Press

Summary

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. 

Author Biography

Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997. As President and CEO of Online Training Solutions, Inc. (OTSI), Joan guides the translation of technical information and requirements into useful, relevant, and measurable resources for people who are seeking certification of their computer skills or who simply want to know how to get things done efficiently.

Joan is the author or coauthor of more than four dozen books about Windows and Office (for Windows, Mac, and iPad), six generations of Microsoft Office Specialist certification study guides, video-based training courses for SharePoint and OneNote, QuickStudy guides for Windows and Office, and the GO! series book for Outlook 2016.

Joan is a Microsoft Certified Professional, Microsoft Office Specialist Master (for all versions of Office since Office 2003), Microsoft Certified Technology Specialist (for Windows and Windows Server), Microsoft Certified Technology Associate (for Windows), Microsoft Dynamics Specialist, and Microsoft Certified Trainer.

Table of Contents

Introduction

Taking a Microsoft Office Specialist exam

Prerequisites

Objective group 1: Create and manage worksheets and workbooks

Objective 1.1: Create worksheets and workbooks

Objective 1.2: Navigate in worksheets and workbooks

Objective 1.3: Format worksheets and workbooks

Objective 1.4: Customize options and views for worksheets and workbooks

Objective 1.5: Configure worksheets and workbooks for distribution

Objective group 2: Manage data cells and ranges

Objective 2.1: Insert data in cells and ranges

Objective 2.2: Format cells and ranges

Objective 2.3: Summarize and organize data

Objective group 3: Create tables

Objective 3.1: Create and manage tables

Objective 3.2: Manage table styles and options

Objective 3.3: Filter and sort tables

Objective group 4: Perform operations by using formulas and functions

Objective 4.1: Summarize data by using functions

Objective 4.2: Perform conditional operations by using functions

Objective 4.3: Format and modify text by using functions

Objective group 5: Create charts and objects

Objective 5.1: Create charts

Objective 5.2: Format charts

Objective 5.3: Insert and format objects