Table Of Content

Microsoft Official Academic Course Microsoft excel 2013 ii Editor Bryan gambrel Publisher Don fowley Director of Sales Mitchell Beaton Technical Editor Joyce nielsen Executive Marketing Manager Chris ruel Assistant Marketing Manager Debbie Martin Microsoft Strategic relationships Manager gene longo of Microsoft learning Editorial Program Assistant Allison winkle Content Manager Kevin holm Production Editor Jill Spikereit Creative Director harry nolan Cover Designer Tom nery Product Designer Jennifer welter Content Editor wendy Ashenberg This book was set in garamond by BoxTwelve. and printed and bound by Courier/Kendallville. The covers were printed by Courier/Kendallville. Copyright © 2014 by John wiley & Sons, Inc. All rights reserved. no part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, Inc. 222 rosewood Drive, Dan- vers, MA 01923, (978) 750-8400, fax (978) 646-8600. requests to the Publisher for permission should be addressed to the Permissions Department, John wiley & Sons, Inc., 111 river Street, hoboken, nJ 07030-5774, (201) 748-6011, fax (201) 748-6008. To order books or for customer service, please call 1-800-CAll wIlEY (225-5945). Microsoft, ActiveX, Excel, InfoPath, Microsoft Press, MSDn, Onenote, Outlook, PivotChart, PivotTable, PowerPoint, SharePoint, SQl Server, Visio, windows, windows Mobile, and windows Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Other product and company names mentioned herein may be the trademarks of their respective owners. The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. no association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred. The 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, John wiley & Sons, Inc., Microsoft Corporation, nor their resellers or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book. ISBn 978-0-470-13308-8 Printed in the United States of America 10 9 8 7 6 5 4 3 2 1 www.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only) iii Foreword from the Publisher wiley’s publishing vision for the Microsoft Official Academic Course series is to provide students and instructors with the skills and knowledge they need to use Microsoft technology effectively in all aspects of their personal and professional lives. Quality instruction is required to help both ed- ucators and students get the most from Microsoft’s software tools and to become more productive. Thus our mission is to make our instructional programs trusted educational companions for life. To accomplish this mission, wiley and Microsoft have partnered to develop the highest quality educational programs for Information workers, IT Professionals, and Developers. Materials cre- ated by this partnership carry the brand name “Microsoft Official Academic Course,” assuring instructors and students alike that the content of these textbooks is fully endorsed by Microsoft, and that they provide the highest quality information and instruction on Microsoft products. The Microsoft Official Academic Course textbooks are “Official” in still one more way—they are the officially sanctioned courseware for Microsoft IT Academy members. The Microsoft Official Academic Course series focuses on workforce development. These programs are aimed at those students seeking to enter the workforce, change jobs, or embark on new careers as information workers, IT professionals, and developers. Microsoft Official Academic Course programs address their needs by emphasizing authentic workplace scenarios with an abun- dance of projects, exercises, cases, and assessments. The Microsoft Official Academic Courses are mapped to Microsoft’s extensive research and job- task analysis, the same research and analysis used to create the Microsoft Office Specialist (MOS) exams. The textbooks focus on real skills for real jobs. As students work through the projects and exercises in the textbooks they enhance their level of knowledge and their ability to apply the latest Microsoft technology to everyday tasks. These students also gain resume-building credentials that can assist them in finding a job, keeping their current job, or in furthering their education. The concept of life-long learning is today an utmost necessity. Job roles, and even whole job categories, are changing so quickly that none of us can stay competitive and productive without continuously updating our skills and capabilities. The Microsoft Official Academic Course of- ferings, and their focus on Microsoft certification exam preparation, provide a means for people to acquire and effectively update their skills and knowledge. wiley supports students in this en- deavor through the development and distribution of these courses as Microsoft’s official academic publisher. Joe Heider Senior Vice President, wiley global Education www.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only) iv Illustrated Book Tour Lesson Skill Matrix Key Terms Business Scenario Software Orientation Easy-to-Read Tables Bottom Line www.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only) v Illustrated Book Tour Screen Images with Callouts Workplace Ready Take Note Reader Aids Step by Step Exercises Another Way Reader Aids Troubleshooting Reader Aids www.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only) vi Illustrated Book Tour Data Files Icon Microsoft Office Specialist Certification Objective Alert Cross Reference Reader Aid Skill Summary Knowledge Assessment Questions www.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only) vii Illustrated Book Tour Competency Assessment Proficiency Assessment Project Mastery Assessment Projects Circling Back Exercises www.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only) viii www.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only)