没有合适的资源?快使用搜索试试~ 我知道了~
首页[Microsoft Press] MOS 2013 Study Guide for Microsoft Excel Expert.pdf
资源详情
资源评论
资源推荐
MOS 2013 Study Guide Microsoft Word Exam 77-418
Advance your everyday skills with Word 2013.
And earn the credential that proves it!
Demonstrate your expertise with Microsoft Word! Designed to
help you practice and prepare for Microsoft Ofce Specialist (MOS):
Word 2013 certication, this ofcial 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
•
Ready-made practice les
Sharpen the skills measured by these MOS exam
objectives:
•
Create and Manage Documents
•
Format Text, Paragraphs, and Sections
•
Create Tables and Lists
•
Apply References
•
Insert and Format Objects
Lambert
EXAM 77-418
About MOS
A Microsoft Ofce Specialist (MOS)
certication validates your prociency
with Microsoft Ofce programs,
demonstrating you can meet globally
recognized performance standards.
Hands-on experience with the tech-
nology is required to successfully pass
Microsoft Certication exams.
See full details at:
microsoft.com/learning/certication
Practice Files
Available at:
http://aka.ms/mosWord2013/les
MOS: Word 2013
microsoft.com/mspress
Certication/Microsoft Word
ISBN: 978-0-7356-6921-5
U.S.A. $19.99
Canada $20.99
[Recommended]
Microsoft
Excel Expert
EXAMS
77-427 & 77-428
Mark Dodge
MOS 2013
Study Guide
Celebrating 30 Years!
spine = .39”
PUBLISHED BY
Microsoft Press
A Division of Microsoft Corporation
One Microsoft Way
Redmond, Washington 98052-6399
Copyright © 2013 by Mark Dodge
All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any
means without the written permission of the publisher.
Library of Congress Control Number: 2013941818
ISBN: 978-0-7356-6921-5
Printed and bound in the United States of America.
First Printing
Microsoft Press books are available through booksellers and distributors worldwide. If you need support related
to this book, email Microsoft Press Book Support at mspinput@microsoft.com. Please tell us what you think of
this book at http://www.microsoft.com/learning/booksurvey.
Microsoft and the trademarks listed at http://www.microsoft.com/en-us/legal/intellectualproperty/trademarks/
en-us.aspx are trademarks of the Microsoft group of companies. All other marks are property of their respective
owners.
The example companies, organizations, products, domain names, email addresses, logos, people, places, and
events depicted herein are ctitious. No association with any real company, organization, product, domain name,
email address, logo, person, place, or event is intended or should be inferred.
This book expresses the author’s views and opinions. The information contained in this book is provided without
any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or
distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by
this book.
Acquisitions Editor: Rosemary Caperton
Editorial Production: Online Training Solutions, Inc. (OTSI)
Technical Reviewer: Rob Carr (OTSI)
Copyeditor: Jaime Odell (OTSI)
Indexer: Krista Wall (OTSI)
Cover: Microsoft Press Brand Team
iii
What do you think of this book? We want to hear from you!
Microsoft is interested in hearing your feedback so we can continually improve our books and learning resources for
you. To participate in a brief online survey, please visit:
microsoft.com/learning/booksurvey
Contents
Introduction ...............................................................vii
Who this book is for ......................................................vii
How this book is organized ................................................viii
Download the practice les ................................................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 Ofce Specialist exam .....................................xiii
Microsoft Ofce Specialist certication ......................................xiii
Selecting a certication path...............................................xiii
Test-taking tips...........................................................xiv
Certication benets..................................................... xvi
For more information .................................................... xvi
Exams 77-427 and 77-428 Microsoft Excel 2013 Expert
Prerequisites..............................................................1
1 Manage and share workbooks 3
1.1 Manage multiple workbooks ............................................3
Modifying workbook templates ........................................4
Managing workbook versions ..........................................6
Copying styles between templates......................................7
Sidebar: Merging styles that have the same name ........................8
Copying macros between workbooks ...................................9
iv Contents
Connecting to external data ..........................................10
Sidebar: About the Excel Data Model...................................11
Sidebar: Editing formula links .........................................12
Practice tasks .......................................................15
1.2 Prepare workbooks for review..........................................16
Tracking changes ....................................................16
Sidebar: Setting tracking options ......................................16
Protecting workbooks for sharing .....................................19
Sidebar: Properties vs. metadata.......................................24
Practice tasks .......................................................29
1.3 Manage workbook changes............................................30
Displaying all changes................................................30
Reviewing changes ..................................................31
Managing comments ................................................32
Merging workbooks .................................................33
Identifying errors....................................................35
Troubleshooting by using tracing......................................37
Sidebar: Tracing formulas in separate worksheets ........................39
Practice tasks .......................................................40
Objective review .........................................................40
2 Apply custom formats and layouts 41
2.1 Apply custom data formats ............................................41
Creating custom formats (number, time, date)...........................42
Using advanced Fill Series options .....................................51
Practice tasks .......................................................54
2.2 Apply advanced conditional formatting and ltering ......................55
Creating custom conditional formats ..................................56
Using functions to format cells ........................................58
Creating advanced lters .............................................60
Sidebar: Managing conditional formatting rules .........................61
Practice tasks .......................................................63
2.3 Apply custom styles and templates .....................................63
Creating custom templates ...........................................63
Creating and modifying cell styles ....................................65
Creating custom color and font formats ...............................66
Creating themes.....................................................68
Contents v
Creating form elds..................................................70
Sidebar: Controlling the tab order of objects ............................73
Practice tasks .......................................................75
2.4 Prepare workbooks for internationalization and accessibility ...............76
Modifying worksheets for use with accessibility tools ....................76
Displaying data in multiple international formats ........................79
Sidebar: Proong in other languages ...................................80
Sidebar: Managing multiple options for body and heading fonts ..........83
Practice tasks .......................................................83
Objective review .........................................................84
3 Create advanced formulas 85
3.1 Apply functions in formulas ...........................................85
Using nested functions ..............................................87
Using the IF, AND, and OR functions ...................................87
Using the SUMIFS, AVERAGEIFS, and COUNTIFS functions ................88
Using nancial functions .............................................90
Practice tasks .......................................................95
3.2 Look up data by using functions .......................................96
Using the VLOOKUP and HLOOKUP functions ..........................96
Using the LOOKUP function ..........................................98
Using the TRANSPOSE function .......................................98
Practice tasks ......................................................100
3.3 Apply advanced date and time functions ...............................100
Using the NOW and TODAY functions ................................101
Using functions to serialize dates and times ...........................102
Sidebar: Concatenating text in formulas ...............................103
Practice tasks ......................................................105
3.4 Create scenarios .....................................................105
Using what-if analysis tools ..........................................106
Sidebar: Enabling iterative calculations ................................107
Sidebar: Using the watch window .....................................110
Using the Scenario Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .111
Sidebar: Merging scenarios ..........................................112
Consolidating data .................................................113
Practice tasks ......................................................117
Objective review ........................................................117
剩余183页未读,继续阅读
hyyzxqh
- 粉丝: 1
- 资源: 17
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- stc12c5a60s2 例程
- Android通过全局变量传递数据
- c++校园超市商品信息管理系统课程设计说明书(含源代码) (2).pdf
- 建筑供配电系统相关课件.pptx
- 企业管理规章制度及管理模式.doc
- vb打开摄像头.doc
- 云计算-可信计算中认证协议改进方案.pdf
- [详细完整版]单片机编程4.ppt
- c语言常用算法.pdf
- c++经典程序代码大全.pdf
- 单片机数字时钟资料.doc
- 11项目管理前沿1.0.pptx
- 基于ssm的“魅力”繁峙宣传网站的设计与实现论文.doc
- 智慧交通综合解决方案.pptx
- 建筑防潮设计-PowerPointPresentati.pptx
- SPC统计过程控制程序.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论1