MOS 2016 Study Guide for Microsoft Excel

About

Features

• Full, objective-by-objective exam coverage
• Easy-to-follow procedures and illustrations to review essential skills
• Hands-on practice tasks

Description

Advance your everyday proficiency with Excel 2016.

And earn the credential that proves it!

Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Excel 2016 Core 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
• Practice files and sample solutions

 Sharpen the skills measured by these objectives:

• Create and manage worksheets and workbooks
• Manage data cells and ranges
• Create tables
• Perform operations with formulas and functions
• Create charts and objects

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.

Downloads

Downloads

Follow the instructions to download this book's practice files.

1. Click the Download button below to start the download.
2. If prompted, click Save.
3. Locate the .zip file on your computer. Right-click the file, click Extract All, and then follow the instructions.

Sample Content

Sample Pages

Download the sample pages (includes Chapter 5 and the Index.)

Table of Contents

• Introduction
• Taking a Microsoft Office Specialist exam
• Exam 77-727: Microsoft Excel 2016 Core Prerequisites
• Objective group 1: Create and manage worksheets and workbooks
• Objective 1.1: Create worksheets and workbooks
• Objective 1.2: Navigate in worksheets and workbooks
• Objective 1.3: Format worksheets and workbooks
• Objective 1.4: Customize options and views for worksheets and workbooks
• Objective 1.5: Configure worksheets and workbooks for distribution
• Objective group 2: Manage data cells and ranges
• Objective 2.1: Insert data in cells and ranges
• Objective 2.2: Format cells and ranges
• Objective 2.3: Summarize and organize data
• Objective group 3: Create tables
• Objective 3.1: Create and manage tables
• Objective 3.2: Manage table styles and options
• Objective 3.3: Filter and sort tables
• Objective group 4: Perform operations by using formulas and functions
• Objective 4.1: Summarize data by using functions
• Objective 4.2: Perform conditional operations by using functions
• Objective 4.3: Format and modify text by using functions
• Objective group 5: Create charts and objects
• Objective 5.1: Create charts
• Objective 5.2: Format charts
• Objective 5.3: Insert and format objects

Updates

Errata

We've made every effort to ensure the accuracy of this book and its companion content. Any errors that have been confirmed since this book was published can be downloaded below.

Download the errata

Follow the instructions below to download this book's updated practice and results files.

1. Click the Download button below to start the download.
2. If prompted, click Save.
3. Locate the .zip file on your computer. Right-click the file, click Extract All, and then follow the instructions.

Submit Errata