MOS 2016 Study Guide for Microsoft Excel

Name: MOS 2016 Study Guide for Microsoft Excel
Author: Joan Lambert
ISBN: 9780735699434

by Joan Lambert

an item in the MOS Study Guide Series

Paperback

MOS 2016 Study Guide for Microsoft Excel

by Joan Lambert

an item in the MOS Study Guide Series

Paperback

Overview

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.

FormatPaperback

LanguageEnglish

PublisherPearson Education

Publication DateOct. 27th, 2016

ISBN-139780735699434

Dimensions7.40 x 8.95 x 0.70 inches

ISBN-100735699437

Shipping Weight0.71 lbs

All Available Copies Find out more about shipping times from these sellers.

Condition	Price
Used Very Good (1 available) Used book that is in excellent condition.	{{localize.CurrencySymbol}}5.73 {{localize.CurrencyAbbrev}}	Shelf Steals®	Add To {{CartName}}	Ships directly from Better World Books
Used Good (2 available) Used book that is in clean, average condition without any missing pages.	{{localize.CurrencySymbol}}5.73 {{localize.CurrencyAbbrev}}	Shelf Steals®	Add To {{CartName}}	Ships directly from Better World Books
Used Very Good (1 available) Former library book; used book that is in excellent condition.	{{localize.CurrencySymbol}}11.28 {{localize.CurrencyAbbrev}}	Shelf Steals®	Add To {{CartName}}	Ships directly from Better World Books
eBook Obtain a digital book from our friends at eBooks.com. eBooks.com	{{ebooksDotComPrice}} {{ebooksDotComCurrency}}		eBooks.com	Digital edition from eBooks.com
Audio Book Obtain a digital book from our friends at AudiobooksNow.com. AudiobooksNow.com	{{audioBooksNowPrice}} {{audioBooksNowCurrency}}		AudiobooksNow.com	Digital edition from AudiobooksNow.com

Introduction	p. vii
Taking a Microsoft Office Specialist exam	p. xiii
Exam 77-727 Microsoft Excel 2016	p. 1
Prerequisites	p. 2
Create and manage worksheets and workbooks	p. 7
Create worksheets and workbooks	p. 8
Create blank and prepopulated workbooks	p. 8
Add worksheets to workbooks	p. 10
Move or copy worksheets	p. 11
Import data from delimited text files	p. 12
Practice tasks	p. 14
Navigate in worksheets and workbooks	p. 15
Search for data within a workbook	p. 15
Navigate to a named cell, range, or workbook element	p. 16
Link to internal and external locations and files	p. 18
Practice tasks	p. 24
Format worksheets and workbooks	p. 25
Manage worksheet attributes	p. 25
Manage rows and columns	p. 26
Change the appearance of workbook content	p. 29
Modify page setup	p. 30
Insert headers and footers	p. 31
Practice tasks	p. 35
Customize options and views for worksheets and workbooks	p. 36
Hide or unhide content	p. 36
Customize the Quick Access Toolbar	p. 38
Modify the display of worksheets	p. 41
Modify document properties	p. 45
Practice tasks	p. 47
Configure worksheets and workbooks for distribution	p. 48
Print all or part of a workbook	p. 48
Save workbooks in alternative file formats	p. 50
Set print scaling	p. 54
Print sheet elements	p. 54
Inspect a workbook for hidden properties or personal information	p. 56
Inspect a workbook for accessibility issues	p. 58
Inspect a workbook for compatibility issues	p. 60
Practice tasks	p. 63
Manage data cells and ranges	p. 65
Insert data in cells and ranges	p. 66
Create data	p. 66
Reuse data	p. 71
Replace data	p. 76
Practice tasks	p. 78
Format cells and ranges	p. 79
Merge cells	p. 79
Modify cell alignment, text wrapping, and indentation	p. 80
Apply cell formats and styles	p. 83
Apply number formats	p. 84
Reapply existing formatting	p. 87
Practice tasks	p. 89
Summarize and organize data	p. 90
Format cells based on their content	p. 90
Insert sparklines	p. 93
Outline data and insert subtotals	p. 95
Practice tasks	p. 98
Create tables	p. 99
Create and manage tables	p. 100
Create an Excel table from a cell range	p. 100
Add or remove table rows and columns	p. 104
Convert a table to a cell range	p. 106
Practice tasks	p. 107
Manage table styles and options	p. 108
Apply styles to tables	p. 108
Configure table style options	p. 109
Practice tasks	p. 112
Filter and sort tables	p. 113
Sort tables	p. 114
Filter tables	p. 115
Remove duplicate table entries	p. 117
Practice tasks	p. 118
Perform operations with formulas and functions	p. 119
Summarize data by using functions	p. 120
Reference cells and cell ranges in formulas	p. 120
Define order of operations	p. 123
Perform calculations by using functions	p. 124
Practice tasks	p. 129
Perform conditional operations by using functions	p. 131
Practice tasks	p. 135
Format and modify text by using functions	p. 136
Practice tasks	p. 141
Create charts and objects	p. 143
Create charts	p. 144
Practice tasks	p. 151
Format charts	p. 152
Practice tasks	p. 157
Insert and format objects	p. 158
Insert text boxes and shapes	p. 158
Insert images	p. 162
Provide alternative text for accessibility	p. 164
Practice tasks	p. 166
Index	p. 167
About the author	p. 175
Table of Contents provided by Ingram. All Rights Reserved.

Find at your local library from our friends at WorldCat	Find Libraries

Overview

Product Details

FormatPaperback

LanguageEnglish

PublisherPearson Education

Publication DateOct. 27th, 2016

ISBN-139780735699434

Dimensions7.40 x 8.95 x 0.70 inches

ISBN-100735699437

Shipping Weight0.71 lbs

Introduction	p. vii
Taking a Microsoft Office Specialist exam	p. xiii
Exam 77-727 Microsoft Excel 2016	p. 1
Prerequisites	p. 2
Create and manage worksheets and workbooks	p. 7
Create worksheets and workbooks	p. 8
Create blank and prepopulated workbooks	p. 8
Add worksheets to workbooks	p. 10
Move or copy worksheets	p. 11
Import data from delimited text files	p. 12
Practice tasks	p. 14
Navigate in worksheets and workbooks	p. 15
Search for data within a workbook	p. 15
Navigate to a named cell, range, or workbook element	p. 16
Link to internal and external locations and files	p. 18
Practice tasks	p. 24
Format worksheets and workbooks	p. 25
Manage worksheet attributes	p. 25
Manage rows and columns	p. 26
Change the appearance of workbook content	p. 29
Modify page setup	p. 30
Insert headers and footers	p. 31
Practice tasks	p. 35
Customize options and views for worksheets and workbooks	p. 36
Hide or unhide content	p. 36
Customize the Quick Access Toolbar	p. 38
Modify the display of worksheets	p. 41
Modify document properties	p. 45
Practice tasks	p. 47
Configure worksheets and workbooks for distribution	p. 48
Print all or part of a workbook	p. 48
Save workbooks in alternative file formats	p. 50
Set print scaling	p. 54
Print sheet elements	p. 54
Inspect a workbook for hidden properties or personal information	p. 56
Inspect a workbook for accessibility issues	p. 58
Inspect a workbook for compatibility issues	p. 60
Practice tasks	p. 63
Manage data cells and ranges	p. 65
Insert data in cells and ranges	p. 66
Create data	p. 66
Reuse data	p. 71
Replace data	p. 76
Practice tasks	p. 78
Format cells and ranges	p. 79
Merge cells	p. 79
Modify cell alignment, text wrapping, and indentation	p. 80
Apply cell formats and styles	p. 83
Apply number formats	p. 84
Reapply existing formatting	p. 87
Practice tasks	p. 89
Summarize and organize data	p. 90
Format cells based on their content	p. 90
Insert sparklines	p. 93
Outline data and insert subtotals	p. 95
Practice tasks	p. 98
Create tables	p. 99
Create and manage tables	p. 100
Create an Excel table from a cell range	p. 100
Add or remove table rows and columns	p. 104
Convert a table to a cell range	p. 106
Practice tasks	p. 107
Manage table styles and options	p. 108
Apply styles to tables	p. 108
Configure table style options	p. 109
Practice tasks	p. 112
Filter and sort tables	p. 113
Sort tables	p. 114
Filter tables	p. 115
Remove duplicate table entries	p. 117
Practice tasks	p. 118
Perform operations with formulas and functions	p. 119
Summarize data by using functions	p. 120
Reference cells and cell ranges in formulas	p. 120
Define order of operations	p. 123
Perform calculations by using functions	p. 124
Practice tasks	p. 129
Perform conditional operations by using functions	p. 131
Practice tasks	p. 135
Format and modify text by using functions	p. 136
Practice tasks	p. 141
Create charts and objects	p. 143
Create charts	p. 144
Practice tasks	p. 151
Format charts	p. 152
Practice tasks	p. 157
Insert and format objects	p. 158
Insert text boxes and shapes	p. 158
Insert images	p. 162
Provide alternative text for accessibility	p. 164
Practice tasks	p. 166
Index	p. 167
About the author	p. 175
Table of Contents provided by Ingram. All Rights Reserved.

All Available Copies

Condition	Source	Price
Used Very Good (1 available) Used book that is in excellent condition. Ships from	Ships directly from Better World Books	{{localize.CurrencySymbol}}5.73 {{localize.CurrencyAbbrev}} Shelf Steals®	Add To {{CartName}}
Used Good (2 available) Used book that is in clean, average condition without any missing pages. Ships from	Ships directly from Better World Books	{{localize.CurrencySymbol}}5.73 {{localize.CurrencyAbbrev}} Shelf Steals®	Add To {{CartName}}
Used Very Good (1 available) Former library book; used book that is in excellent condition. Ships from	Ships directly from Better World Books	{{localize.CurrencySymbol}}11.28 {{localize.CurrencyAbbrev}} Shelf Steals®	Add To {{CartName}}
eBook Obtain a digital book from our friends at eBooks.com. eBooks.com	Digital edition from eBooks.com	{{ebooksDotComPrice}} {{ebooksDotComCurrency}}	eBooks.com
Audio Book Obtain a digital book from our friends at AudiobooksNow.com. AudiobooksNow	Digital edition from AudiobooksNow.com	{{audioBooksNowPrice}} {{audioBooksNowCurrency}}	Audiobook

Search Results for "{{sharedState.searchQuery}}"

MOS 2016 Study Guide for Microsoft Excel

Paperback

See All Available Copies

MOS 2016 Study Guide for Microsoft Excel

Paperback

See All Available Copies

See All Available Copies

Overview

Categories

All Available Copies Find out more about shipping times from these sellers.

Table Of Contents

Overview

Product Details

Table Of Contents

All Available Copies

Availability

Featured

Condition

Format

Digital

Age

Grade

Categories

Print Size

Language

Search Results for "{{sharedState.searchQuery}}"

MOS 2016 Study Guide for Microsoft Excel

Paperback

See All Available Copies

MOS 2016 Study Guide for Microsoft Excel

Paperback

See All Available Copies

See All Available Copies

Overview

Categories

All Available Copies Find out more about shipping times from these sellers.

Table Of Contents

Overview

Overview

Product Details

Table Of Contents

All Available Copies