MOS 2016 Study Guide for Microsoft Excel
1st Edition
Published on 10. October 2016
192 pages
978-0-7356-9997-7 (ISBN)
Description
This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book.
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.
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.
More details
Series
Language
English
Place of publication
Redmond
United States
Target group
Professional and scholarly
ISBN-13
978-0-7356-9997-7 (9780735699977)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Joan Lambert
MOS 2016 Study Guide for Microsoft Excel
Book
02/2017
1st Edition
Microsoft Press
€20.99
Shipment within 10-20 days
Person
Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997. As President and CEO of Online Training Solutions, Inc. (OTSI), Joan guides 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 know how 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), five generations of Microsoft Office Specialist certification study guides, video-based training courses for SharePoint and OneNote, QuickStudy guides for Windows and Office, and the GO! series book for Outlook 2016.
Blissfully based in America's Finest City, 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.
Joan is the author or coauthor of more than four dozen books about Windows and Office (for Windows, Mac, and iPad), five generations of Microsoft Office Specialist certification study guides, video-based training courses for SharePoint and OneNote, QuickStudy guides for Windows and Office, and the GO! series book for Outlook 2016.
Blissfully based in America's Finest City, 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.
Content
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
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
