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

Published by Microsoft Press (March 11, 2020) © 2020

  • Joan Lambert
Products list
$23.99
Buy nowOpens in a new tab
Sold by InformIT and ebook resellers
  • Available for purchase from all major ebook resellers, including InformIT.com
Products list
$19.99

Price Reduced From: $24.99

Details

  • A print text
  • Free shipping
  • Also available for purchase as an ebook from all major ebook resellers, including InformIT.com

This product is expected to ship within 3-6 business days for US and 5-10 business days for Canadian customers.

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
  • 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

Need help? Get in touch