Cover image for MOS Study Guide for Microsoft Excel Exam MO-200

MOS Study Guide for Microsoft Excel Exam MO-200

Author Joan Lambert
Release Date: 2020/03/01
Topic:
0%
14
Chapters
0-1
Hours read
0k
Total Words
    Start Reading Now    
       Add to Wishlist       
View table of contents

Book Description

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.

Table of Contents

  1. Cover Page
  2. Title Page
  3. Copyright Page
  4. Contents
  5. Introduction
    1. Who this book is for
    2. How this book is organized
    3. Download the practice files
    4. Adapt procedure steps
    5. Ebook edition
    6. Errata, updates, & book support
    7. Stay in touch
  6. About the author
  7. Objective group 1. Manage worksheets and workbooks
    1. Objective 1.1: Import data into workbooks
    2. Objective 1.2: Navigate within workbooks
    3. Objective 1.3: Format worksheets and workbooks
    4. Objective 1.4: Customize options and views
    5. Objective 1.5: Configure content for collaboration
  8. Objective group 2. Manage data cells and ranges
    1. Objective 2.1: Manipulate data in worksheets
    2. Objective 2.2: Format cells and ranges
    3. Objective 2.3: Define and reference named ranges
    4. Objective 2.4: Summarize data visually
  9. Objective group 3. Manage tables and table data
    1. Objective 3.1: Create and format tables
    2. Objective 3.2: Modify tables
    3. Objective 3.3: Filter and sort table data
  10. Objective group 4. Perform operations by using formulas and functions
    1. Objective 4.1: Insert references in formulas
    2. Objective 4.2: Calculate and transform data by using functions
    3. Objective 4.3: Format and modify text by using functions
  11. Objective group 5. Manage charts
    1. Objective 5.1: Create charts
    2. Objective 5.2: Modify charts
    3. Objective 5.3: Format charts
  12. Index
3.21.34.0