MOS 2016 Study Guide for Microsoft Excel

Exam 77-727. Microsoft Excel 2016

Microsoft Office Specialist

This book covers the skills you need to have for certification as a Microsoft Office Specialist in Excel 2016. Specifically, you need to be able to complete tasks that demonstrate the following skill sets:

1 Create and manage worksheets and workbooks

2 Manage data cells and ranges

3 Create tables

4 Perform operations with formulas and functions

5 Create charts and objects

With these skills, you can create and populate Excel workbooks, and format, organize, and present the types of data most commonly used in a business environment.

Prerequisites

We assume that you have been working ...