Muutke küpsiste eelistusi

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

3.60/5 (26 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 176 pages, kõrgus x laius x paksus: 230x190x10 mm, kaal: 306 g
  • Sari: MOS Study Guide
  • Ilmumisaeg: 15-Aug-2013
  • Kirjastus: Microsoft Press,U.S.
  • ISBN-10: 0735669201
  • ISBN-13: 9780735669208
Teised raamatud teemal:
MOS 2013 Study Guide for Microsoft ExcelSuurem pilt
  • Formaat: Paperback / softback, 176 pages, kõrgus x laius x paksus: 230x190x10 mm, kaal: 306 g
  • Sari: MOS Study Guide
  • Ilmumisaeg: 15-Aug-2013
  • Kirjastus: Microsoft Press,U.S.
  • ISBN-10: 0735669201
  • ISBN-13: 9780735669208
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780735669208.html
Märksõnad:
Presents information to practice and prepare for the Microsoft Office Specialist Excel 2013 certification, covering each MOS objective, offering detailed procedures, and providing practice files.

Demonstrate your expertise with Microsoft Office! Designed to help you practice and prepare for the 2013 Excel Microsoft Office Specialist (MOS) exam, this all-in-one study guide features:

  • Full, objective-by-objective exam coverage
  • Easy-to-follow procedures and illustrations to review essential skills
  • Hands-on practice tasks to apply what you’ve learned; files included

Use the in-depth exam prep, practice, and review to help advance your proficiency with Microsoft Office—and earn the credential that proves it!



Introduction vii
Who this book is for vii
How this book is organized viii
Download the practice files viii
Sidebar: Adapting exercise steps x
Ebook edition xi
Get support and give feedback xi
Errata xi
We want to hear from you xii
Stay in touch xii
Taking a Microsoft Office Specialist exam xiii
Microsoft Office Specialist certification xiii
Selecting a certification path xiii
Test-taking tips xiv
Certification benefits xv
For more information xvi
Exam 77-420 Microsoft Excel 2013
Prerequisites
1(4)
Managing worksheets
2(1)
Managing worksheet content
2(1)
Managing Excel tables
3(1)
Managing data entries
3(2)
1 Create and manage workbooks and worksheets
5(48)
1.1 Create workbooks and worksheets
6(4)
Creating new workbooks and worksheets
6(1)
Reusing existing content
7(3)
Practice tasks
10(1)
1.2 Navigate through worksheets and workbooks
10(6)
Locating data and worksheet elements
10(3)
Inserting hyperlinks
13(3)
Practice tasks
16(1)
1.3 Format worksheets and workbooks
16(13)
Modifying page setup
16(2)
Inserting page elements
18(3)
Changing workbook themes and colors
21(2)
Modifying rows and columns
23(2)
Configuring data validation
25(3)
Practice tasks
28(1)
1.4 Customize options and views for worksheets and workbooks
29(15)
Displaying different views of worksheets
29(1)
Displaying multiple parts of a workbook
30(3)
Hiding and displaying workbook content
33(2)
Customizing the Quick Access Toolbar
35(2)
Customizing the ribbon
37(2)
Working with macros
39(2)
Modifying workbook properties
41(2)
Practice tasks
43(1)
1.5 Configure worksheets and workbooks to print or save
44(8)
Printing workbook content
44(2)
Saving workbooks
46(6)
Practice tasks
52(1)
Objective review
52(1)
2 Manage cells and ranges
53(34)
2.1 Insert data in cells and ranges
54(10)
Creating data
54(5)
Reusing data
59(4)
Practice tasks
63(1)
2.2 Format cells and ranges
64(10)
Formatting cell structure
64(2)
Formatting cell content
66(3)
Applying number formats
69(3)
Copying formatting
72(1)
Practice tasks
73(1)
2.3 Order and group cells and ranges
74(11)
Modeling data
74(5)
Creating named ranges
79(2)
Working with data groups and summaries
81(3)
Practice tasks
84(1)
Objective review
85(2)
3 Manage tables
87(14)
3.1 Create tables
88(5)
Practice tasks
92(1)
3.2 Modify tables
93(3)
Practice tasks
95(1)
3.3 Filter and sort tables
96(4)
Practice tasks
99(1)
Objective review
100(1)
4 Apply formulas and functions
101(20)
4.1 Utilize cell ranges and references in formulas and functions
102(5)
Referencing cells and cell ranges in formulas
102(3)
Defining order of operations
105(1)
Practice tasks
106(1)
4.2 Summarize data by using functions
107(5)
Practice tasks
112(1)
4.3 Utilize conditional logic in functions
112(4)
Practice tasks
115(1)
4.4 Format and modify text by using functions
116(4)
Practice tasks
120(1)
Objective review
120(1)
5 Create charts and objects
121(18)
5.1 Create charts
122(5)
Practice tasks
127(1)
5.2 Format charts
127(5)
Practice tasks
131(1)
5.3 Insert and format objects
132(6)
Adding pictures to sheets
132(2)
Adding text boxes to sheets
134(1)
Adding SmartArt graphics to sheets
135(2)
Practice tasks
137(1)
Objective review
138(1)
Index 139(10)
About the author 149(1)
Survey page 150
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 get things done efficiently.

 

Joan is the author or coauthor of more than three dozen books about Windows and Office (for the Windows, Mac, and iPad platforms) and three generations of Microsoft Office Specialist certification study guides. Joan is a Microsoft Certified Professional, Microsoft Office Specialist Master (for Office 2013, Office 2010, and Office 2007), Microsoft Certified Technology Specialist (for Windows and Windows Server), Microsoft Certified Technology Associate (for Windows), Microsoft Dynamics Specialist, and Microsoft Certified Trainer.