MOS Study Guide for Microsoft Excel Exam MO-200

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