Muutke küpsiste eelistusi

MOS 2016 Study Guide for Microsoft Excel [Pehme köide]

4.17/5 (26 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 192 pages
  • Sari: MOS Study Guide
  • Ilmumisaeg: 13-Feb-2017
  • Kirjastus: Microsoft Press,U.S.
  • ISBN-10: 0735699437
  • ISBN-13: 9780735699434
Teised raamatud teemal:
MOS 2016 Study Guide for Microsoft ExcelSuurem pilt
  • Formaat: Paperback / softback, 192 pages
  • Sari: MOS Study Guide
  • Ilmumisaeg: 13-Feb-2017
  • Kirjastus: Microsoft Press,U.S.
  • ISBN-10: 0735699437
  • ISBN-13: 9780735699434
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780735699434.html
Märksõnad:

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.

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