This eBook includes the following formats, accessible from your Account page after purchase:
EPUB The open industry format known for its reflowable content and usability on supported mobile devices.
PDF The popular standard, used most often with the free Acrobat® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
Also available in other formats.
Register your product to gain access to bonus material or receive a coupon.
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:
Sharpen the skills measured by these objectives:
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.
Follow the instructions to download this book's practice files.
Download the sample pages (includes Chapter 5 and the Index.)
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
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 4.1c practice file
Download the 4.1c Results file
Download the 4.2 practice file