MOS Study Guide for Microsoft Excel Exam MO-200

Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997, guiding 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 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 10 and Office 2016, and GO! series books for Outlook. 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. She is also certified in Adobe InDesign and Intuit QuickBooks. A native of the Pacific Northwest and enthusiastic world traveler, Joan is now blissfully based in America’s Finest City with her simply divine daughter Trinity, Thai host daughter Thopad, and their faithful canine, feline, and aquatic companions.

1 Manage worksheets and workbooks
Objective 1.1: Import data into workbooks
Objective 1.2: Navigate within workbooks
Objective 1.3: Format worksheets and workbooks
Objective 1.4: Customize options and views
Objective 1.5: Configure content for collaboration
2 Manage data cells and ranges
Objective 2.1: Manipulate data in worksheets
Objective 2.2: Format cells and ranges
Objective 2.3: Define and reference named ranges
Objective 2.4: Summarize data visually
3 Manage tables and table data
Objective 3.1: Create and format tables
Objective 3.2: Modify tables
Objective 3.3: Filter and sort table data
4 Perform operations by using formulas and functions
Objective 4.1: Insert references in formulas
Objective 4.2: Calculate and transform data by using functions
Objective 4.3: Format and modify text by using functions
5 Manage charts
Objective 5.1: Create charts
Objective 5.2: Modify charts
Objective 5.3: Format charts