MOS Study Guide for Microsoft Excel Exam MO-200, 1st edition

1 Manage worksheets and workbooksObjective 1.1: Import data into workbooksObjective 1.2: Navigate within workbooksObjective 1.3: Format worksheets and workbooksObjective 1.4: Customize options and viewsObjective 1.5: Configure content for collaboration2 Manage data cells and rangesObjective 2.1: Manipulate data in worksheetsObjective 2.2: Format cells and rangesObjective 2.3: Define and reference named rangesObjective 2.4: Summarize data visually3 Manage tables and table dataObjective 3.1: Create and format tablesObjective 3.2: Modify tablesObjective 3.3: Filter and sort table data4 Perform operations by using formulas and functionsObjective 4.1: Insert references in formulasObjective 4.2: Calculate and transform data by using functionsObjective 4.3: Format and modify text by using functions5 Manage chartsObjective 5.1: Create chartsObjective 5.2: Modify chartsObjective 5.3: Format charts