Microsoft excel 2016 - DIT

Microsoft Official Academic Course

MICROSOFT EXCEL 2016

Includes coverage of the following Microsoft Office Specialist (MOS) exam:

MOS EXAM 77-727: EXCEL 2016

II

This book was set in Garamond by Box Twelve Communications.

Copyright ? 2016 by Microsoft. 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, Danvers, 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 W iley & 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.

This document is provided "as-is". Information and views expressed in this document, including URL and other Internet Web site references, may change without notice. Some examples depicted herein are provided for illustration only and are fictitious. No real association or connection is intended or should be inferred.

?2016 Microsoft Corporation and/or its suppliers. All rights reserved. Microsoft and the trademarks listed at are trademarks of the Microsoft group of companies. All other marks are property of their respective owners.

ISBN: 978-1-11-927299-1

 III

WILEY END-USER LICENSE AGREEMENT

This End-User License Agreement (the "Agreement") is a legal agreement between you and John Wiley & Sons, Inc. ("Wiley") for the Wiley proprietary material (the "Licensed Material") that you may have licensed through a third party or from Wiley directly.

Your use of the Licensed Materials indicates your acceptance of the terms and conditions of this Agreement.

License

Wiley hereby grants you, and you accept, a non-exclusive and non-transferable license to view, use and display the Licensed Material on the following terms and conditions only:

a. You acknowledge that the Licensed Material is being licensed to you and use is subject to the terms and conditions of this Agreement.

b. The Licensed Material is for your personal use only.

c. You may use the Licensed Material only on the number of devices permitted by the license terms set forth elsewhere and/or the Digital Rights Management ("DRM"), if any.

d. You may not copy/paste/print the Licensed Material except as expressly permitted by the license terms set forth elsewhere and/or the DRM, if any.

e. You may not upload, copy, modify, print, transmit, transfer, sublicense, sell, make or distribute copies of the Licensed Material in whole or in part. If you transfer possession of any copy or modification of the Licensed Material to any third party, your license is automatically terminated and any attempt to sell or otherwise transfer the Licensed Material shall be null and void. Such termination will be in addition to and not in lieu of any equitable, civil, or other remedies available to Wiley.

f. If you accessed the Licensed Material from a third party website or using a device which requires you to accept any other user agreement, you are bound by both this Agreement and any third party website or device-specific agreement. In the event of a conflict between this Agreement and any third party agreement, the more restrictive terms will apply.

g. If the website or device applies any form of Digital Rights Management ("DRM") to the Licensed Material, you may not disable or remove that DRM.

h. You agree that any materials in print format that may be included with this license (for example, materials printed on demand) or portions thereof ordered or printed from any third party platform are licensed for your personal use only and may not be transferred or sold under any condition. All terms of this Agreement also apply to these print materials.

Term

This Agreement shall terminate upon the conditions discussed elsewhere in this Agreement, or if you fail to comply with any term or condition of this Agreement. Upon such termination, you agree to immediately discontinue all access to the Licensed Material.

IV

Wiley's Rights

You acknowledge that all rights (including without limitation, copyrights, patents and trade secrets) in the Licensed Material are the sole and exclusive property of Wiley and/or its licensors. By accepting this Agreement, you do not become the owner of the Licensed Material, but you do have a limited license to use it in accordance with the provisions of this Agreement. You agree to protect the Licensed Material from unauthorized use, upload, download, reproduction, or distribution. You further agree not to translate, decompile, disassemble or otherwise reverse engineer the Licensed Material.

DISCLAIMER

LICENSED MATERIAL(S) ARE PROVIDED "AS IS," WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS TO THE RESULTS OR PERFORMANCE, AND THE COST OF ALL NECESSARY SERVICING, REPAIR, OR CORRECTION OF THE LICENSED MATERIAL IS ASSUMED BY YOU. IN NO EVENT WILL WILEY OR ITS LICENSORS BE LIABLE TO YOU FOR ANY DAMAGES, INCLUDING WITHOUT LIMITATION LOST PROFITS, LOST SAVINGS, OR OTHER INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE LICENSED MATERIAL(S).

General

This Agreement represents the entire agreement between us and supersedes any prior Agreements, oral or written, and any other communication between us relating to the subject matter of this Agreement. This Agreement will be governed and construed as if wholly entered into and performed within the State of New York. You acknowledge that you have read this Agreement, and agree to be bound by its terms and conditions.

Preface

V

Welcome to the Microsoft Official Academic Course (MOAC) program for Microsoft Office 2016. MOAC represents the collaboration between Microsoft Learning and John Wiley & Sons, Inc. publishing company. Microsoft and Wiley teamed up to produce a series of textbooks that deliver compelling and innovative teaching solutions to instructors and superior learning experiences for students. Infused and informed by in-depth knowledge from the creators of Microsoft Office and Windows, and crafted by a publisher known worldwide for the pedagogical quality of its products, these textbooks maximize skills transfer in minimum time. Students are challenged to reach their potential by using their new technical skills as highly productive members of the workforce.

Because this knowledgebase comes directly from Microsoft, architect of the Office 2016 system and creator of the Microsoft Office Specialist (MOS) exams, you are sure to receive the topical coverage that is most relevant to students' personal and professional success. Microsoft's direct participation not only assures you that MOAC textbook content is accurate and current; it also means that students will receive the best instruction possible to enable their success on certification exams and in the workplace.

THE MICROSOFT OFFICIAL ACADEMIC COURSE PROGRAM The Microsoft Official Academic Course series is a complete program for instructors and institutions to prepare and deliver great courses on Microsoft software technologies. With MOAC, we recognize that, because of the rapid pace of change in the technology and curriculum developed by Microsoft, there is an ongoing set of needs beyond classroom instruction tools for an instructor to be ready to teach the course. The MOAC program endeavors to provide solutions for all these needs in a systematic manner in order to ensure a successful and rewarding course experience for both instructor and student--technical and curriculum training for instructor readiness with new software releases; the software itself for student use at home for building hands-on skills, assessment, and validation of skill development; and a great set of tools for delivering instruction in the classroom and lab. All are important to the smooth delivery of an interesting course on Microsoft software, and all are provided with the MOAC program.

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download