Home > Topics > Microsoft Office > Excel
9780735699991Register your book to access additional benefits.
- By Joan Lambert
- Part of the MOS Study Guide series.
Successful candidates for the Microsoft Office Specialist Excel 2016 certification exam have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They know and demonstrate the correct application of the principle features of Excel 2016. MOS 2016 certification exams introduce a new performance-based format for improved testing of a candidate’s knowledge, skills and abilities using the MOS 2016 programs:. MOS 2016 exam task instructions generally do not include the command name as in previous versions. For example, function names are avoided, and are replaced with descriptors. TEST4U MOS 2016 Excel Expert 77-728 Test is an interactive, highly customizable tool that meets your personal learning needs. During the media-rich TEST4U experience, you will amplify your understanding of MS Excel, the most famous and flexible spreadsheet software, part of Microsoft Office Suite.
This eBook includes the following formats, accessible from your Account page after purchase:
EPUBThe open industry format known for its reflowable content and usability on supported mobile devices.
Hone your advanced Excel 2016 skills. 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 Expert 2016 certification, this official Study Guide.
MOBIThe eBook format compatible with the Amazon Kindle and Amazon Kindle applications.
PDFThe popular standard, which reproduces the look and layout of the printed page.
This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
- Published 10/10/2016
- 1st Edition
- eBook 978-0-7356-9999-1
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
Mos Excel 2016 Objectives
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.
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
Downloads
Follow the instructions to download this book's practice files.
- Click the Download button below to start the download.
- If prompted, click Save.
- Locate the .zip file on your computer. Right-click the file, click Extract All, and then follow the instructions.
Mos Excel 2016 Certification
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.
If you find an error, you can report it to us through our Submit errata page.
Other titles you might like
- Book $39.99
- eBook (Watermarked) $31.99
Mos Excel 2016 77-727
- Book $24.99