book

MOS 2016 Study Guide for Microsoft Excel

Name: MOS 2016 Study Guide for Microsoft Excel
ISBN: 9780735699984

by Steve Lambert, Joan Lambert

October 2016

Beginner

192 pages

3h 55m

English

Microsoft Press

Read now

Unlock full access

Cover
Title Page
Copyright Page
Contents
Introduction
Who this book is forHow this book is organizedDownload the practice filesEbook editionErrata, updates, & book supportWe want to hear from youStay in touch
Taking a Microsoft Office Specialist exam
Microsoft Office Specialist certificationSelecting a certification pathTest-taking tipsCertification benefitsFor more information
Exam 77-727. Microsoft Excel 2016
PrerequisitesSelect contentManage data entryManage worksheetsReuse contentAccess program commands and options
Objective group 1. Create and manage worksheets and workbooks
Objective 1.1: Create worksheets and workbooksCreate blank and prepopulated workbooksAdd worksheets to workbooksMove or copy worksheetsImport data from delimited text filesObjective 1.1 practice tasksObjective 1.2: Navigate in worksheets and workbooksSearch for data within a workbookNavigate to a named cell, range, or workbook elementLink to internal and external locations and filesObjective 1.2 practice tasksObjective 1.3: Format worksheets and workbooksManage worksheet attributesManage rows and columnsChange the appearance of workbook contentModify page setupInsert headers and footersObjective 1.3 practice tasksObjective 1.4: Customize options and views for worksheets and workbooksHide or unhide contentCustomize the Quick Access ToolbarModify the display of worksheetsModify document propertiesObjective 1.4 practice tasksObjective 1.5: Configure worksheets and workbooks for distributionPrint all or part of a workbookSave workbooks in alternative file formatsSet print scalingPrint sheet elementsInspect a workbook for hidden properties or personal informationInspect a workbook for accessibility issuesInspect a workbook for compatibility issuesObjective 1.5 practice tasks
Objective group 2. Manage data cells and ranges
Objective 2.1: Insert data in cells and rangesCreate dataReuse dataReplace dataObjective 2.1 practice tasksObjective 2.2: Format cells and rangesMerge cellsModify cell alignment, text wrapping, and indentationApply cell formats and stylesApply number formatsReapply existing formattingObjective 2.2 practice tasksObjective 2.3: Summarize and organize dataFormat cells based on their contentInsert sparklinesOutline data and insert subtotalsObjective 2.3 practice tasks
Objective group 3. Create tables
Objective 3.1: Create and manage tablesCreate an Excel table from a cell rangeAdd or remove table rows and columnsConvert a table to a cell rangeObjective 3.1 practice tasksObjective 3.2: Manage table styles and optionsApply styles to tablesConfigure table style optionsObjective 3.2 practice tasksObjective 3.3: Filter and sort tablesSort tablesFilter tablesRemove duplicate table entriesObjective 3.3 practice tasks

Objective group 4. Perform operations with formulas and functions
Objective 4.1: Summarize data by using functionsReference cells and cell ranges in formulasDefine order of operationsPerform calculations by using functionsObjective 4.1 practice tasksObjective 4.2: Perform conditional operations by using functionsObjective 4.2 practice tasksObjective 4.3: Format and modify text by using functionsObjective 4.3 practice tasks
Objective group 5. Create charts and objects
Objective 5.1: Create chartsObjective 5.1 practice tasksObjective 5.2: Format chartsObjective 5.2 practice tasksObjective 5.3: Insert and format objectsInsert text boxes and shapesInsert imagesProvide alternative text for accessibilityObjective 5.3 practice tasks
Index
About the author
Acknowledgments
Survey

Content preview from MOS 2016 Study Guide for Microsoft Excel

Objective group 2. Manage data cells and ranges

The skills tested in this section of the Microsoft Office Specialist exam for Microsoft Excel 2016 relate to managing cells and cell content in worksheets. Specifically, the following objectives are associated with this set of skills:

2.1 Insert data in cells and ranges

2.2 Format cells and ranges

2.3 Summarize and organize data

Excel stores data in individual cells of the worksheets within a workbook. You can process or reference the data in each cell in many ways; either individually or in logical groups. An organized set of contiguous data is a data range. A data range can be as small as a list of dates, or as large as a multicolumn table that has thousands of rows of data.

You might populate ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

MOS 2016 Study Guide for Microsoft Excel Expert

Publisher Resources

ISBN: 9780735699984Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

MOS 2016 Study Guide for Microsoft Excel

by Steve Lambert, Joan Lambert

Objective group 2. Manage data cells and ranges

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.