<div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w0 h0" alt="" src="https://files.passeidireto.com/8a7a628b-5234-488c-b421-0cbbe050defd/bg1.png"></div><div class="pi" data-data='{"ctm":[1.000000,0.000000,0.000000,1.000000,0.000000,0.000000]}'></div></div> <div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w0 h0" alt="" src="https://files.passeidireto.com/8a7a628b-5234-488c-b421-0cbbe050defd/bg2.png"></div><div class="pi" data-data='{"ctm":[1.000000,0.000000,0.000000,1.000000,0.000000,0.000000]}'></div></div> <div id="pf3" class="pf w0 h0" data-page-no="3"><div class="pc pc3 w0 h0"><img fetchpriority="low" loading="lazy" class="bi x0 y0 w0 h0" alt="" src="https://files.passeidireto.com/8a7a628b-5234-488c-b421-0cbbe050defd/bg3.png"><div class="t m0 x1 h1 y1 ff1 fs0 fc0 sc0 ls1 ws3">Contributing Author</div><div class="t m0 x2 h2 y2 ff2 fs0 fc1 sc0 ls1 ws3">Raymond E. Enger</div><div class="t m0 x3 h3 y3 ff3 fs1 fc1 sc0 ls1 ws3">Steven M. Fr<span class="_0 blank"></span>eund</div><div class="t m0 x3 h3 y4 ff3 fs1 fc1 sc0 ls1 ws3">Mali B. Jones</div><div class="t m0 x3 h3 y5 ff3 fs1 fc1 sc0 ls1 ws3">Joy L. Starks</div><div class="t m0 x3 h2 y6 ff2 fs0 fc1 sc0 ls1 ws3">Indiana University Purdue University Indianapolis</div><div class="t m0 x4 h4 y7 ff4 fs2 fc2 sc0 ls0 ws3">Australia \u2022 Brazil \u2022 Japan \u2022 Korea \u2022 Me<span class="_0 blank"></span>xico \u2022 Singapore \u2022 Spain \u2022 United K<span class="_0 blank"></span>ingdom \u2022 United States</div><div class="t m0 x5 h5 y8 ff5 fs3 fc3 sc0 ls2 ws0">Micr<span class="_1 blank"></span>osoft<span class="fs4 ls1 ws1 v1">®<span class="fs5 fc4 ws3 v2"> </span></span></div><div class="t m0 x5 h6 y9 ff6 fs6 fc4 sc0 ls3 ws2">EX<span class="_2 blank"></span>CEL</div><div class="t m0 x6 h7 ya ff5 fs4 fc4 sc0 ls1">®</div><div class="t m0 x7 h6 y9 ff6 fs6 fc4 sc0 ls3 ws3"> 2013</div><div class="t m0 x8 h8 yb ff7 fs7 fc5 sc0 ls4">COMPLETE</div></div><div class="pi" data-data='{"ctm":[1.000000,0.000000,0.000000,1.000000,0.000000,0.000000]}'></div></div> <div id="pf4" class="pf w0 h0" data-page-no="4"><div class="pc pc4 w0 h0"><img fetchpriority="low" loading="lazy" class="bi x0 y0 w0 h0" alt="" src="https://files.passeidireto.com/8a7a628b-5234-488c-b421-0cbbe050defd/bg4.png"><div class="t m0 x9 h9 yc ff8 fs8 fc2 sc0 ls1 ws3">© <span class="ff9">2014</span> Cengage L<span class="_0 blank"></span>earning</div><div class="t m0 x9 h9 yd ff8 fs8 fc2 sc0 ls1 ws3">ALL RIGHTS RESERVED. No part of this work co<span class="_0 blank"></span>vered by the copyright herein </div><div class="t m0 x9 h9 ye ff8 fs8 fc2 sc0 ls1 ws3">may be reproduced, transmitted, stored or used in any f<span class="_0 blank"></span>orm or by any means </div><div class="t m0 x9 h9 yf ff8 fs8 fc2 sc0 ls1 ws3">graphic, electronic, or mechanical, including but not limited to photocopying, </div><div class="t m0 x9 h9 y10 ff8 fs8 fc2 sc0 ls1 ws3">recording, scanning, digitizing<span class="_0 blank"></span>, taping, W<span class="_0 blank"></span>eb distribution, information networks, </div><div class="t m0 x9 h9 y11 ff8 fs8 fc2 sc0 ls1 ws3">or information storage and retrieval syst<span class="_0 blank"></span>ems, except as permitted under </div><div class="t m0 x9 h9 y12 ff8 fs8 fc2 sc0 ls1 ws3">Section <span class="ff9">107</span> or <span class="ff9">108</span> of the <span class="ff9">1976</span> United States Copyright A<span class="_0 blank"></span>ct, without the prior </div><div class="t m0 x9 h9 y13 ff8 fs8 fc2 sc0 ls1 ws3">written permission of the publisher<span class="_2 blank"></span>.</div><div class="t m0 x9 h9 y14 ff8 fs8 fc2 sc0 ls1 ws3">Library of Congress Control N<span class="_0 blank"></span>umber: <span class="ff9">2013941391</span></div><div class="t m0 x9 h9 y15 ff8 fs8 fc2 sc0 ls1">ISBN-<span class="ff9">13</span><span class="ws3">: <span class="ff9">978</span>-<span class="ff9">1</span>-<span class="ff9">285</span>-<span class="ff9">16844</span>-<span class="ff9">9</span></span></div><div class="t m0 x9 h9 y16 ff8 fs8 fc2 sc0 ls1">ISBN-<span class="ff9">10</span><span class="ws3">: <span class="ff9">1</span>-<span class="ff9">285</span>-<span class="ff9">16844</span>-<span class="ff9">5</span></span></div><div class="t m0 x9 ha y17 ffa fs8 fc2 sc0 ls1 ws3">Cengage L<span class="_0 blank"></span>earning </div><div class="t m0 x9 h9 y18 ff9 fs8 fc2 sc0 ls1">20<span class="ff8 ws3"> Channel Center Street </span></div><div class="t m0 x9 h9 y19 ff8 fs8 fc2 sc0 ls1 ws3">Boston, MA <span class="ff9">02210</span> </div><div class="t m0 x9 h9 y1a ff8 fs8 fc2 sc0 ls1 ws4">USA</div><div class="t m0 x9 h9 y1b ff8 fs8 fc2 sc0 ls1 ws3">Cengage L<span class="_0 blank"></span>earning is a leading provider of customized learning solutions with </div><div class="t m0 x9 h9 y1c ff8 fs8 fc2 sc0 ls1">o<span class="ff9">\ufb03</span><span class="ws3">ce locations around the globe, including Singapore, the United K<span class="_0 blank"></span>ingdom, </span></div><div class="t m0 x9 h9 y1d ff8 fs8 fc2 sc0 ls1 ws3">Australia, Mexico, Brazil, and Japan. L<span class="_0 blank"></span>ocate your local o<span class="ff9">\ufb03</span>ce at: </div><div class="t m0 x9 ha y1e ffa fs8 fc2 sc0 ls1 ws5">international.cengage.c<span class="_0 blank"></span>om/<span class="_0 blank"></span>region</div><div class="t m0 x9 h9 y1f ff8 fs8 fc2 sc0 ls5 ws3">Cen<span class="_3 blank"> </span>gag<span class="_3 blank"> </span>e <span class="_3 blank"> </span>Lea<span class="_3 blank"> </span>rn<span class="_3 blank"> </span>in<span class="_3 blank"> </span>g <span class="_3 blank"> </span>pr<span class="_3 blank"> </span>od<span class="_3 blank"> </span>uc<span class="_3 blank"> </span>t<span class="_3 blank"> </span>s <span class="_3 blank"> </span>are<span class="_3 blank"> </span> r<span class="_3 blank"> </span>ep<span class="_3 blank"> </span>re<span class="_3 blank"> </span>se<span class="_3 blank"> </span>nte<span class="_3 blank"> </span>d <span class="_3 blank"> </span>in<span class="_3 blank"> </span> C<span class="_3 blank"> </span>an<span class="_3 blank"> </span>ad<span class="_3 blank"> </span>a <span class="_3 blank"> </span>by<span class="_3 blank"> </span> N<span class="_3 blank"> </span>el<span class="_3 blank"> </span>so<span class="_3 blank"> </span>n <span class="_3 blank"> </span>Ed<span class="_3 blank"> </span>uc<span class="_3 blank"> </span>at<span class="_3 blank"> </span>io<span class="_3 blank"> </span>n,<span class="_3 blank"> </span> Lt<span class="_3 blank"> </span>d.</div><div class="t m0 x9 ha y20 ff8 fs8 fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o learn more about Cengage Learning, visit <span class="ffa ws5">www<span class="_0 blank"></span>.cengag<span class="_0 blank"></span>e.com</span></div><div class="t m0 x9 h9 y21 ff8 fs8 fc2 sc0 ls1 ws3">Purchase any o<span class="_0 blank"></span>f our products at your local college bookstore or at our </div><div class="t m0 x9 ha y22 ff8 fs8 fc2 sc0 ls1 ws3"> <span class="_1 blank"></span>preferred online store at <span class="ffa ws5">www<span class="_0 blank"></span>.cengag<span class="_0 blank"></span>ebrain.com</span></div><div class="t m0 xa hb y23 ffa fs8 fc2 sc0 ls1 ws5">Microsoft<span class="fs9 ws6 v3">®</span><span class="ws3 v0"> Ex<span class="_0 blank"></span>cel<span class="fs9 ws6 v3">®</span> <span class="ffb">\ue021\ue022\ue023\ue024</span>: Complete</span></div><div class="t m0 xa ha y24 ffa fs8 fc2 sc0 ls1 ws3">Stev<span class="_0 blank"></span>en M. Fr<span class="_0 blank"></span>eund, Mali B. Jones, Joy L. Starks</div><div class="t m0 xa h9 y25 ff8 fs8 fc2 sc0 ls1 ws3">Executive Editor: Ka<span class="_0 blank"></span>thleen McMahon</div><div class="t m0 xa h9 y26 ff8 fs8 fc2 sc0 ls1 ws3">Senior Product Manager: Emma F<span class="_0 blank"></span>. Newsom</div><div class="t m0 xa h9 y27 ff8 fs8 fc2 sc0 ls1 ws3">Associate Product Manager: Crystal Parenteau</div><div class="t m0 xa h9 y28 ff8 fs8 fc2 sc0 ls1 ws3">Editorial Assistant: Sarah Ryan</div><div class="t m0 xa h9 y29 ff8 fs8 fc2 sc0 ls1 ws3">Print Buyer: Julio Esperas</div><div class="t m0 xa h9 y2a ff8 fs8 fc2 sc0 ls1 ws3">Director of Production: Pa<span class="_0 blank"></span>tty Stephan</div><div class="t m0 xa h9 y2b ff8 fs8 fc2 sc0 ls1 ws3">Content Project Manager: Matthew Hutchinson</div><div class="t m0 xa h9 y2c ff8 fs8 fc2 sc0 ls1 ws3">Development Editor: L<span class="_0 blank"></span>yn Markowicz</div><div class="t m0 xa h9 y2d ff8 fs8 fc2 sc0 ls1 ws3">Senior Brand Manager: Elinor Gregory</div><div class="t m0 xa h9 y2e ff8 fs8 fc2 sc0 ls1 ws3">Market Development Manager: Kristie Clark</div><div class="t m0 xa h9 y2f ff8 fs8 fc2 sc0 ls1 ws3">Market Development Manager: </div><div class="t m0 xb h9 y30 ff8 fs8 fc2 sc0 ls1 ws4">Gretchen<span class="ff9">\ue02c</span>Swann</div><div class="t m0 xa h9 y31 ff8 fs8 fc2 sc0 ls1 ws3">Marketing Coordinator: Amy McGregor</div><div class="t m0 xa h9 y32 ff8 fs8 fc2 sc0 ls1 ws3">QA Manuscript R<span class="_0 blank"></span>eviewers: Je<span class="ff9">\ufb00</span>rey Schwartz, </div><div class="t m0 xb h9 y33 ff8 fs8 fc2 sc0 ls1 ws3">John Freitas, Serge P<span class="_0 blank"></span>alladino, Susan Pedicini, </div><div class="t m0 xb h9 y34 ff8 fs8 fc2 sc0 ls1 ws3">Danielle Shaw<span class="_0 blank"></span>, Susan Whalen</div><div class="t m0 xa h9 y35 ff8 fs8 fc2 sc0 ls1 ws3">Art Director: GEX Publishing Services, Inc.</div><div class="t m0 xa h9 y36 ff8 fs8 fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>ext Design: Joel Sadagursky</div><div class="t m0 xa h9 y37 ff8 fs8 fc2 sc0 ls1 ws3">Cover Design: L<span class="_0 blank"></span>isa Kuhn, Curio Pr<span class="_0 blank"></span>ess, LLC</div><div class="t m0 xa h9 y38 ff8 fs8 fc2 sc0 ls1 ws3">Cover Photo: T<span class="_2 blank"></span>om Kates Photography</div><div class="t m0 xa h9 y39 ff8 fs8 fc2 sc0 ls1 ws3">Compositor: PreMediaGlobal</div><div class="t m0 xa h9 y3a ff8 fs8 fc2 sc0 ls1 ws3">Copyeditor: Harold Johnson</div><div class="t m0 xa h9 y3b ff8 fs8 fc2 sc0 ls1 ws3">Proofr<span class="_0 blank"></span>eader: Karen Annett</div><div class="t m0 xa h9 y3c ff8 fs8 fc2 sc0 ls1 ws3">Indexer: Rich Carlson</div><div class="t m0 xa h9 y3d ff8 fs8 fc2 sc0 ls1 ws3">Microsoft and the Office logo are either </div><div class="t m0 xa h9 y3e ff8 fs8 fc2 sc0 ls1 ws3">registered trademarks or trademarks of </div><div class="t m0 xa h9 y3f ff8 fs8 fc2 sc0 ls1 ws3">Microsoft Corporation in the U<span class="_0 blank"></span>nited States </div><div class="t m0 xa h9 y40 ff8 fs8 fc2 sc0 ls1 ws3">and/<span class="_0 blank"></span>or other countries. C<span class="_0 blank"></span>engage Learning is </div><div class="t m0 xa h9 y41 ff8 fs8 fc2 sc0 ls1 ws3">an independent entity from the Microsoft </div><div class="t m0 xa h9 y42 ff8 fs8 fc2 sc0 ls1 ws3">Corporation, and not affiliated with M<span class="_0 blank"></span>icrosoft </div><div class="t m0 xa h9 y43 ff8 fs8 fc2 sc0 ls1">in<span class="ff9">\ue02c</span><span class="ws3">any manner<span class="_2 blank"></span>.</span></div><div class="t m0 xc hc y44 ff8 fsa fc2 sc0 ls1 ws3">For product information and technology assistance, contact us at </div><div class="t m0 xc hd y45 ffa fsa fc2 sc0 ls1 ws3">Cengage L<span class="_0 blank"></span>earning Customer & Sales Support, <span class="ffb">\ue025</span>-<span class="ffb">\ue026\ue027\ue027</span>-<span class="ffb">\ue024\ue028\ue029</span>-<span class="ffb">\ue02a\ue02b\ue027\ue02c</span></div><div class="t m0 xd hc y46 ff8 fsa fc2 sc0 ls1 ws3">For permission to use material f<span class="_0 blank"></span>rom this text or product, </div><div class="t m0 xd hd y47 ff8 fsa fc2 sc0 ls1 ws3">submit all requests online at <span class="ffa">cengage.c<span class="_0 blank"></span>om/<span class="_0 blank"></span>permissions </span></div><div class="t m0 x6 hc y48 ff8 fsa fc2 sc0 ls1 ws3">Further permissions questions can be emailed to </div><div class="t m0 xe hd y49 ffa fsa fc2 sc0 ls1 ws7">permissionrequest@cengag<span class="_0 blank"></span>e.com</div><div class="t m0 xf he y4a ffc fsb fc2 sc0 ls1 ws3">Printed in the United States of <span class="_2 blank"></span>America </div><div class="t m0 xf he y4b ffc fsb fc2 sc0 ls1 ws3">1 2 3 4 5 6 7 17 16 15 14 13</div></div><div class="pi" data-data='{"ctm":[1.000000,0.000000,0.000000,1.000000,0.000000,0.000000]}'></div></div> <div id="pf5" class="pf w0 h0" data-page-no="5"><div class="pc pc5 w0 h0"><img fetchpriority="low" loading="lazy" class="bi x0 y0 w0 h0" alt="" src="https://files.passeidireto.com/8a7a628b-5234-488c-b421-0cbbe050defd/bg5.png"><div class="t m0 x10 hf y4c ff2 fsc fc2 sc0 ls1">iii</div><div class="t m0 x4 h10 y4d ff2 fsc fc1 sc0 ls1 ws3">Microsoft <span class="ff1 fsd ls7">Of<span class="ffd">\ue021</span>ce 2013 and Windows 8</span></div><div class="t m0 x4 h11 y4e ff1 fsb fc6 sc0 ls1">Of<span class="ffd">\ue021</span><span class="ws3">ce 2013 and Windows<span class="ffd">\ue022</span>8: </span></div><div class="t m0 x4 h11 y4f ff1 fsb fc6 sc0 ls1">Essential<span class="ffd">\ue022</span><span class="ws3">Concepts and Skills</span></div><div class="t m0 x4 hf y50 ff3 fsc fc2 sc0 ls1 ws3">Objectives <span class="_4 blank"> </span>OFF 1</div><div class="t m0 x11 hf y51 ff2 fsc fc2 sc0 ls1 ws3">Roadmap <span class="_5 blank"> </span>OFF 2</div><div class="t m0 x4 hf y52 ff3 fsc fc2 sc0 ls1 ws3">Introduction to the Windows 8 Operating<span class="ffe">\ue021</span> </div><div class="t m0 x12 hf y53 ff3 fsc fc2 sc0 ls1 ws3">System <span class="_6 blank"> </span>OFF 2</div><div class="t m0 x11 hf y54 ff2 fsc fc2 sc0 ls1 ws3">Using a T<span class="_2 blank"></span>ouch Screen and a Mouse <span class="_7 blank"> </span>OFF 3</div><div class="t m0 x11 hf y55 ff2 fsc fc2 sc0 ls1 ws3">Scrolling <span class="_8 blank"> </span>OFF 5</div><div class="t m0 x11 hf y56 ff2 fsc fc2 sc0 ls1 ws3">Keyboard Shortcuts <span class="_9 blank"> </span>OFF 6</div><div class="t m0 x11 hf y57 ff2 fsc fc2 sc0 ls1 ws3">Starting Windows <span class="_a blank"> </span>OFF 6</div><div class="t m0 x11 hf y58 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Sign In to an Account <span class="_b blank"> </span>OFF 7</div><div class="t m0 x11 hf y59 ff2 fsc fc2 sc0 ls1 ws3">The Windows Start Screen <span class="_c blank"> </span>OFF 8</div><div class="t m0 x4 hf y5a ff3 fsc fc2 sc0 ls1 ws3">Introduction to Micr<span class="_0 blank"></span>osoft Of<span class="ffe">\ue022</span>ce 2013 <span class="_d blank"> </span>OFF 9</div><div class="t m0 x11 hf y5b ff2 fsc fc2 sc0 ls1 ws3">Microsoft Of<span class="fff">\ue021</span>ce 2013 Apps <span class="_e blank"> </span>OFF 9</div><div class="t m0 x11 hf y5c ff2 fsc fc2 sc0 ls1 ws3">Microsoft Of<span class="fff">\ue021</span>ce 2013 Suites <span class="_f blank"> </span>OFF 9</div><div class="t m0 x4 hf y5d ff3 fsc fc2 sc0 ls1 ws3">Running and Using an App <span class="_10 blank"> </span>OFF 10</div><div class="t m0 x11 hf y5e ff2 fsc fc2 sc0 ls1">Excel<span class="ls8 ws3"> <span class="_11 blank"> </span></span><span class="ws3">OFF 10</span></div><div class="t m0 x11 hf y5f ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Run an App from the Start Screen <span class="_12 blank"> </span>OFF 11</div><div class="t m0 x11 hf y60 ff2 fsc fc2 sc0 ls1 ws3">Windows Desktop <span class="_13 blank"> </span>OFF 13</div><div class="t m0 x11 hf y61 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Switch between an App </div><div class="t m0 x13 hf y62 ff2 fsc fc2 sc0 ls1 ws3">and the Start Screen <span class="_14 blank"> </span>OFF 13</div><div class="t m0 x11 hf y63 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Maximize a Window <span class="_15 blank"> </span>OFF 14</div><div class="t m0 x11 hf y64 ff2 fsc fc2 sc0 ls1 ws3">Excel Workbook Window<span class="_2 blank"></span>, Ribbon, and </div><div class="t m0 x13 hf y65 ff2 fsc fc2 sc0 ls1 ws3">Elements Common to Of<span class="fff">\ue021</span>ce Apps <span class="_16 blank"> </span>OFF 14</div><div class="t m0 x11 hf y66 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Display a Different T<span class="_2 blank"></span>ab on the Ribbon <span class="_17 blank"> </span>OFF 19</div><div class="t m0 x11 hf y67 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Collapse and Expand the Ribbon </div><div class="t m0 x13 hf y68 ff2 fsc fc2 sc0 ls1 ws3">and Use Full Screen Mode <span class="_18 blank"> </span>OFF 19</div><div class="t m0 x11 hf y69 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Use a Shortcut Menu to Relocate </div><div class="t m0 x13 hf y6a ff2 fsc fc2 sc0 ls1 ws3">the Quick Access T<span class="_2 blank"></span>oolbar <span class="_19 blank"> </span>OFF 21</div><div class="t m0 x11 hf y6b ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Customize the Quick Access T<span class="_0 blank"></span>oolbar <span class="_1a blank"> </span>OFF 22</div><div class="t m0 x11 hf y6c ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter a Worksheet T<span class="_0 blank"></span>itle <span class="_1b blank"> </span>OFF 22</div><div class="t m0 x4 hf y6d ff3 fsc fc2 sc0 ls1 ws3">Saving and Organizing Files <span class="_b blank"> </span>OFF 23</div><div class="t m0 x11 hf y6e ff2 fsc fc2 sc0 ls1 ws3">Organizing Files and Folders <span class="_1c blank"> </span>OFF 24</div><div class="t m0 x11 hf y6f ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Create a Folder <span class="_13 blank"> </span>OFF 25</div><div class="t m0 x11 hf y70 ff2 fsc fc2 sc0 ls1 ws3">Folder Windows <span class="_1d blank"> </span>OFF 26</div><div class="t m0 x11 hf y71 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Create a Folder within a Folder <span class="_1e blank"> </span>OFF 27</div><div class="t m0 x14 hf y72 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Expand a Folder<span class="_2 blank"></span>, Scroll through Folder </div><div class="t m0 x15 hf y73 ff2 fsc fc2 sc0 ls1 ws3">Contents, and Collapse a Folder <span class="_1f blank"> </span>OFF 28</div><div class="t m0 x14 hf y74 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Switch from One App to Another <span class="_20 blank"> </span>OFF 29</div><div class="t m0 x14 hf y75 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Save a File in a Folder <span class="_21 blank"> </span>OFF 29</div><div class="t m0 x14 hf y76 ff2 fsc fc2 sc0 ls1 ws3">Navigating in Dialog Boxes <span class="_22 blank"> </span>OFF 32</div><div class="t m0 x14 hf y77 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Minimize and Restore a Window <span class="_23 blank"> </span>OFF 32</div><div class="t m0 x14 hf y78 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Save a File on SkyDrive <span class="_24 blank"> </span>OFF 33</div><div class="t m0 x16 hf y79 ff3 fsc fc2 sc0 ls1 ws3">Screen Resolution <span class="_25 blank"> </span>OFF 36</div><div class="t m0 x14 hf y7a ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Change the Screen Resolution <span class="_26 blank"> </span>OFF 37</div><div class="t m0 x14 hf y7b ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Exit an App with One Document Open <span class="_27 blank"> </span>OFF 38</div><div class="t m0 x14 hf y7c ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Copy a Folder to a USB Flash Drive <span class="_28 blank"> </span>OFF 39</div><div class="t m0 x16 hf y7d ff3 fsc fc2 sc0 ls1 ws3">Additional Common Features of Of<span class="ffe">\ue022</span>ce Apps<span class="_0 blank"></span> <span class="_29 blank"> </span>OFF 40</div><div class="t m0 x14 hf y7e ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Run an App Using the Search Box <span class="_2a blank"> </span>OFF 41</div><div class="t m0 x14 hf y7f ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Open an Existing File <span class="_2b blank"> </span>OFF 42</div><div class="t m0 x14 hf y80 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Create a New Workbook </div><div class="t m0 x15 hf y81 ff2 fsc fc2 sc0 ls1 ws3">from the Backstage View <span class="_2c blank"> </span>OFF 43</div><div class="t m0 x14 hf y82 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Close a File Using the Backstage View <span class="_2d blank"> </span>OFF 45</div><div class="t m0 x14 hf y83 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Open a Recent File Using the </div><div class="t m0 x15 hf y84 ff2 fsc fc2 sc0 ls1 ws3">Backstage View <span class="_2e blank"> </span>OFF 45</div><div class="t m0 x14 hf y85 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Create a New Blank Workbook </div><div class="t m0 x15 hf y86 ff2 fsc fc2 sc0 ls1 ws3">from File Explorer <span class="_2f blank"> </span>OFF 46</div><div class="t m0 x14 hf y87 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Run an App from File Explorer </div><div class="t m0 x15 hf y88 ff2 fsc fc2 sc0 ls1 ws3">and Open a File <span class="_30 blank"> </span>OFF 47</div><div class="t m0 x14 hf y89 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Save an Existing File with </div><div class="t m0 x15 hf y8a ff2 fsc fc2 sc0 ls1 ws3">the Same File Name <span class="_31 blank"> </span>OFF 48</div><div class="t m0 x16 hf y8b ff3 fsc fc2 sc0 ls1 ws3">Renaming, Moving, and Deleting Files <span class="_32 blank"> </span>OFF 50</div><div class="t m0 x14 hf y8c ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Rename a File <span class="_33 blank"> </span>OFF 50</div><div class="t m0 x14 hf y8d ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Move a File <span class="_34 blank"> </span>OFF 51</div><div class="t m0 x14 hf y8e ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Delete a File <span class="_35 blank"> </span>OFF 52</div><div class="t m0 x16 hf y8f ff3 fsc fc2 sc0 ls1 ws3">Microsoft Of<span class="ffe">\ue022</span>ce and Windows Help<span class="_0 blank"></span> <span class="_36 blank"> </span>OFF 53</div><div class="t m0 x14 hf y90 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Open the Help Window in an </div><div class="t m0 x15 hf y91 ff2 fsc fc2 sc0 ls1">Of<span class="fff">\ue021</span><span class="ws3">ce App <span class="_13 blank"> </span>OFF 53</span></div><div class="t m0 x14 hf y92 ff2 fsc fc2 sc0 ls1 ws3">Moving and Resizing Windows <span class="_37 blank"> </span>OFF 53</div><div class="t m0 x14 hf y93 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Move a Window by Dragging <span class="_2c blank"> </span>OFF 53</div><div class="t m0 x14 hf y94 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Resize a Window by Dragging <span class="_18 blank"> </span>OFF 54</div><div class="t m0 x14 hf y95 ff2 fsc fc2 sc0 ls1 ws3">Using Of<span class="fff">\ue021</span>ce Help <span class="_38 blank"> </span>OFF 55</div><div class="t m0 x14 hf y96 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Obtain Help Using the \u2018Search online </div><div class="t m0 x15 hf y97 ff2 fsc fc2 sc0 ls1 ws3">help\u2019 T<span class="_2 blank"></span>ext Box <span class="_39 blank"> </span>OFF 55</div><div class="t m0 x14 hf y98 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Obtain Help Using Help Links <span class="_3a blank"> </span>OFF 56</div><div class="t m0 x4 hf y99 ff2 fsc fc2 sc0 ls1 ws3">Preface <span class="_3b blank"> </span>ix</div><div class="t m0 x5 h12 y9a ff5 fse fc3 sc0 ls9 ws8">Micr<span class="_3c blank"></span>osoft<span class="fsf ls1 v4">®</span></div><div class="t m0 x5 h13 y9b ff6 fs10 fc4 sc0 lsa ws9">EX<span class="_0 blank"></span>CEL</div><div class="t m0 x17 h14 y9c ff5 fsf fc4 sc0 ls6">®<span class="ff6 fs10 lsa ws3 v5"> 2013</span></div><div class="t m0 x5 h15 y9d ff7 fs11 fc5 sc0 lsb">COMPLETE</div><div class="t m0 x4 h16 y9e ff10 fs12 fc0 sc0 ls1 wsa">Contents</div></div><div class="pi" data-data='{"ctm":[1.000000,0.000000,0.000000,1.000000,0.000000,0.000000]}'></div></div> <div id="pf6" class="pf w0 h0" data-page-no="6"><div class="pc pc6 w0 h0"><img fetchpriority="low" loading="lazy" class="bi x0 y0 w0 h0" alt="" src="https://files.passeidireto.com/8a7a628b-5234-488c-b421-0cbbe050defd/bg6.png"><div class="t m0 x18 h17 y9f ff2 fsc fc2 sc0 ls1 ws3">iv <span class="ff1">Contents</span> <span class="ff1 fc7">Microsoft Excel 2013 Complete</span></div><div class="t m0 x19 hf ya0 ff3 fsc fc2 sc0 ls1 ws3">Using the Fill Handle to Copy a </div><div class="t m0 x7 hf ya1 ff3 fsc fc2 sc0 ls1 ws3">Cell to<span class="ffe">\ue021</span>Adjacent<span class="ffe">\ue021</span>Cells <span class="_3d blank"> </span>EX 15</div><div class="t m0 x1a hf ya2 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Copy a Cell to Adjacent Cells in a Row <span class="_3e blank"> </span>EX 16</div><div class="t m0 x1a hf ya3 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Determine Multiple T<span class="_0 blank"></span>otals </div><div class="t m0 x1b hf ya4 ff2 fsc fc2 sc0 ls1 ws3">at the Same T<span class="_0 blank"></span>ime <span class="_15 blank"> </span>EX 18</div><div class="t m0 x1a hf ya5 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter a Formula Using the Keyboard <span class="_3f blank"> </span>EX 20</div><div class="t m0 x19 hf ya6 ff3 fsc fc2 sc0 ls1 ws3">Formatting the Worksheet <span class="_40 blank"> </span>EX 22</div><div class="t m0 x1a hf ya7 ff2 fsc fc2 sc0 ls1 ws3">Font Style, Size, and Color <span class="_41 blank"> </span>EX 23</div><div class="t m0 x1a hf ya8 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Change a Cell Style <span class="_42 blank"> </span>EX 24</div><div class="t m0 x1a hf ya9 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Change the Font <span class="_43 blank"> </span>EX 25</div><div class="t m0 x1a hf yaa ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Bold a Cell <span class="_44 blank"> </span>EX 26</div><div class="t m0 x1a hf yab ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Increase the Font Size of a Cell Entry <span class="_3f blank"> </span>EX 27</div><div class="t m0 x1a hf yac ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Change the Font Color of a Cell Entry <span class="_45 blank"> </span>EX 28</div><div class="t m0 x1a hf yad ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Center Cell Entries across Columns </div><div class="t m0 x1b hf yae ff2 fsc fc2 sc0 ls1 ws3">by Merging Cells <span class="_46 blank"> </span>EX 29</div><div class="t m0 x1a hf yaf ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Format Rows Using Cell Styles <span class="_d blank"> </span>EX 30</div><div class="t m0 x1a hf yb0 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Format Numbers in the Worksheet <span class="_2a blank"> </span>EX 32</div><div class="t m0 x1a hf yb1 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Adjust the Column Width <span class="_47 blank"> </span>EX 34</div><div class="t m0 x1a hf yb2 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Use the Name Box to Select a Cell <span class="_48 blank"> </span>EX 35</div><div class="t m0 x1a hf yb3 ff2 fsc fc2 sc0 ls1 ws3">Other Ways to Select Cells <span class="_41 blank"> </span>EX 36</div><div class="t m0 x19 hf yb4 ff3 fsc fc2 sc0 ls1 ws3">Adding a Pie Chart to the Worksheet <span class="_49 blank"> </span>EX 37</div><div class="t m0 x1a hf yb5 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Add a 3-D Pie Chart <span class="_4a blank"> </span>EX 38</div><div class="t m0 x1a hf yb6 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Apply a Style to a Chart <span class="_4b blank"> </span>EX 40</div><div class="t m0 x19 hf yb7 ff3 fsc fc2 sc0 ls1 ws3">Changing the Sheet T<span class="_2 blank"></span>ab Names <span class="_4b blank"> </span>EX 41</div><div class="t m0 x1a hf yb8 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Move a Chart to a New Sheet <span class="_49 blank"> </span>EX 41</div><div class="t m0 x1a hf yb9 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Change the Worksheet T<span class="_2 blank"></span>ab Name <span class="_48 blank"> </span>EX 42</div><div class="t m0 x1a hf yba ff2 fsc fc2 sc0 ls1 ws3">Document Properties <span class="_4c blank"> </span>EX 44</div><div class="t m0 x19 hf ybb ff3 fsc fc2 sc0 ls1 ws3">Printing a Worksheet <span class="_35 blank"> </span>EX 45</div><div class="t m0 x1a hf ybc ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Preview and Print a Worksheet </div><div class="t m0 x1b hf ybd ff2 fsc fc2 sc0 ls1 ws3">in Landscape Orientation <span class="_36 blank"> </span>EX 46</div><div class="t m0 x19 hf ybe ff3 fsc fc2 sc0 ls1 ws3">AutoCalculate <span class="_4d blank"> </span>EX 48</div><div class="t m0 x1a hf ybf ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Use the AutoCalculate Area to </div><div class="t m0 x1b hf yc0 ff2 fsc fc2 sc0 ls1 ws3">Determine a Maximum <span class="_4e blank"> </span>EX 48</div><div class="t m0 x19 hf yc1 ff3 fsc fc2 sc0 ls1 ws3">Correcting Err<span class="_0 blank"></span>ors <span class="_4f blank"> </span>EX 49</div><div class="t m0 x1a hf yc2 ff2 fsc fc2 sc0 ls1 ws3">Correcting Errors while Entering Data </div><div class="t m0 x1b hf yc3 ff2 fsc fc2 sc0 ls1 ws3">into a Cell <span class="_1d blank"> </span>EX 50</div><div class="t m0 x1a hf yc4 ff2 fsc fc2 sc0 ls1 ws3">Correcting Errors after Entering Data </div><div class="t m0 x1b hf yc5 ff2 fsc fc2 sc0 ls1 ws3">into a Cell <span class="_1d blank"> </span>EX 50</div><div class="t m0 x1a hf yc6 ff2 fsc fc2 sc0 ls1 ws3">Undoing the Last Cell Entry <span class="_50 blank"> </span>EX 51</div><div class="t m0 x1a hf yc7 ff2 fsc fc2 sc0 ls1 ws3">Clearing a Cell or Range of Cells <span class="_37 blank"> </span>EX 52</div><div class="t m0 x1a hf yc8 ff2 fsc fc2 sc0 ls1 ws3">Clearing the Entire Worksheet <span class="_4e blank"> </span>EX 52</div><div class="t m0 x19 hf yc9 ff3 fsc fc2 sc0 ls1 ws3">Chapter Summary <span class="_51 blank"> </span>EX 54</div><div class="t m0 x19 hf yca ff3 fsc fc2 sc0 ls1 ws3">Apply Y<span class="_2 blank"></span>our Knowledge <span class="_52 blank"> </span>EX 55</div><div class="t m0 x19 hf ycb ff3 fsc fc2 sc0 ls1 ws3">Extend Y<span class="_2 blank"></span>our Knowledge <span class="_53 blank"> </span>EX 57</div><div class="t m0 x19 hf ycc ff3 fsc fc2 sc0 ls1 ws3">Analyze, Correct, Impr<span class="_0 blank"></span>ove <span class="_54 blank"> </span>EX 58</div><div class="t m0 x19 hf ycd ff3 fsc fc2 sc0 ls1 ws3">In the Labs <span class="_55 blank"> </span>EX 59</div><div class="t m0 x19 hf yce ff3 fsc fc2 sc0 ls1 ws3">Consider This: Y<span class="_2 blank"></span>our T<span class="_2 blank"></span>urn <span class="_9 blank"> </span>EX 63</div><div class="t m0 x19 hf ycf ff3 fsc fc2 sc0 ls1 ws3">Learn Online <span class="_56 blank"> </span>EX 64</div><div class="t m0 x19 h11 yd0 ff1 fsb fc8 sc0 ls1 ws3">CHAPTER TWO</div><div class="t m0 x19 h11 yd1 ff1 fsb fc6 sc0 ls1 ws3">Formulas, Functions, and Formatting </div><div class="t m0 x19 hf yd2 ff3 fsc fc2 sc0 ls1 ws3">Objectives <span class="_4 blank"> </span>EX 65</div><div class="t m0 x19 hf yd3 ff3 fsc fc2 sc0 ls1 ws3">Introduction <span class="_57 blank"> </span>EX 66</div><div class="t m0 x19 hf yd4 ff3 fsc fc2 sc0 ls1 ws3">Project \u2014 W<span class="_0 blank"></span>orksheet with Formulas </div><div class="t m0 x7 hf yd5 ff3 fsc fc2 sc0 ls1 ws3">and Functions <span class="_35 blank"> </span>EX 66</div><div class="t m0 x1a hf yd6 ff2 fsc fc2 sc0 ls1 ws3">Roadmap <span class="_5 blank"> </span>EX 68</div><div class="t m0 x19 hf yd7 ff3 fsc fc2 sc0 ls1 ws3">Entering the Titles and Numbers into </div><div class="t m0 x7 hf yd8 ff3 fsc fc2 sc0 ls1 ws3">the Worksheet <span class="_58 blank"> </span>EX 70</div><div class="t m0 x1c hf ya0 ff2 fsc fc2 sc0 ls1 ws3">Obtaining Help while Working in an </div><div class="t m0 x1d hf ya1 ff2 fsc fc2 sc0 ls1">Of<span class="fff">\ue021</span><span class="ws3">ce App <span class="_13 blank"> </span>OFF 56</span></div><div class="t m0 x1c hf ya2 ff2 fsc fc2 sc0 ls1 ws3">Using Windows Help and Support <span class="_59 blank"> </span>OFF 57</div><div class="t m0 x1c hf ya3 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Use Windows Help and Support <span class="_5a blank"> </span>OFF 57</div><div class="t m0 x18 hf ya4 ff3 fsc fc2 sc0 ls1 ws3">Chapter Summary <span class="_5b blank"> </span>OFF 58</div><div class="t m0 x18 hf ya5 ff3 fsc fc2 sc0 ls1 ws3">Apply Y<span class="_2 blank"></span>our Knowledge <span class="_5c blank"> </span>OFF 60</div><div class="t m0 x18 hf ya6 ff3 fsc fc2 sc0 ls1 ws3">Extend Y<span class="_2 blank"></span>our Knowledge <span class="_5d blank"> </span>OFF 61</div><div class="t m0 x18 hf ya7 ff3 fsc fc2 sc0 ls1 ws3">Analyze, Correct, Impr<span class="_0 blank"></span>ove <span class="_39 blank"> </span>OFF 61</div><div class="t m0 x18 hf ya8 ff3 fsc fc2 sc0 ls1 ws3">In the Labs <span class="_5e blank"> </span>OFF 62</div><div class="t m0 x18 hf ya9 ff3 fsc fc2 sc0 ls1 ws3">Consider This: Y<span class="_2 blank"></span>our T<span class="_2 blank"></span>urn <span class="_5f blank"> </span>OFF 63</div><div class="t m0 x18 hf yaa ff3 fsc fc2 sc0 ls1 ws3">Learn Online <span class="_60 blank"> </span>OFF 64</div><div class="t m0 x18 h18 yd9 ff2 fsc fc1 sc0 ls1 ws3">Microsoft <span class="ff1 fs13">Of<span class="ffd">\ue021</span>ce 365</span></div><div class="t m0 x18 h11 yda ff1 fsb fc6 sc0 ls1">Of<span class="ffd">\ue021</span><span class="ws3">ce 365 Essentials</span></div><div class="t m0 x18 hf ydb ff3 fsc fc2 sc0 ls1 ws3">Objectives <span class="_61 blank"> </span>CLD 1</div><div class="t m0 x18 hf ydc ff3 fsc fc2 sc0 ls1 ws3">Introduction to Of<span class="ffe">\ue022</span>ce 365<span class="_0 blank"></span> <span class="_62 blank"> </span>CLD 2</div><div class="t m0 x1c hf ydd ff2 fsc fc2 sc0 ls1 ws3">Cloud Computing <span class="_63 blank"> </span>CLD 2</div><div class="t m0 x18 hf yde ff3 fsc fc2 sc0 ls1 ws3">What Is Of<span class="ffe">\ue022</span>ce 365? <span class="_64 blank"> </span>CLD 3</div><div class="t m0 x1c hf ydf ff2 fsc fc2 sc0 ls1 wsb">Of<span class="fff">\ue021</span><span class="ws3">ce 2013 and Of<span class="fff">\ue021</span>ce 365 Features </span></div><div class="t m0 x1d hf ye0 ff2 fsc fc2 sc0 ls1 ws3">Comparison <span class="_65 blank"> </span>CLD 4</div><div class="t m0 x1c hf ye1 ff2 fsc fc2 sc0 ls1 ws3">Subscription-Based Of<span class="fff">\ue021</span>ce 365 Plans <span class="_66 blank"> </span>CLD 5</div><div class="t m0 x18 hf ye2 ff3 fsc fc2 sc0 ls1 ws3">First look at Of<span class="ffe">\ue022</span>ce 365 <span class="_58 blank"> </span>CLD 6</div><div class="t m0 x1c hf ye3 ff2 fsc fc2 sc0 ls1 ws3">Productivity T<span class="_2 blank"></span>ools <span class="_67 blank"> </span>CLD 6</div><div class="t m0 x1c hf ye4 ff2 fsc fc2 sc0 ls1 ws3">Email and Calendars <span class="_53 blank"> </span>CLD 7</div><div class="t m0 x1c hf ye5 ff2 fsc fc2 sc0 ls1 ws3">Online Meetings <span class="_68 blank"> </span>CLD 7</div><div class="t m0 x1c hf ye6 ff2 fsc fc2 sc0 ls1 ws3">File Sharing <span class="_69 blank"> </span>CLD 7</div><div class="t m0 x1c hf ye7 ff2 fsc fc2 sc0 ls1 ws3">Website Creation <span class="_6a blank"> </span>CLD 8</div><div class="t m0 x18 hf ye8 ff3 fsc fc2 sc0 ls1 ws3">Synchronization <span class="_6b blank"> </span>CLD 8</div><div class="t m0 x1c hf ye9 ff2 fsc fc2 sc0 ls1 ws3">Multiple Device Access to Of<span class="fff">\ue021</span>ce 365 <span class="_6c blank"> </span>CLD 8</div><div class="t m0 x18 hf yea ff3 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>eams Using Of<span class="ffe">\ue022</span>ce 365 in Business<span class="_0 blank"></span> <span class="_1c blank"> </span>CLD 9</div><div class="t m0 x1c hf yeb ff2 fsc fc2 sc0 ls1 ws3">Email Communication Using Exchange <span class="_6d blank"> </span>CLD 10</div><div class="t m0 x1c hf yec ff2 fsc fc2 sc0 ls1 ws3">Collaboration Using SharePoint <span class="_6e blank"> </span>CLD 10</div><div class="t m0 x1c hf yed ff2 fsc fc2 sc0 ls1 ws3">Website Design Using SharePoint <span class="_6f blank"> </span>CLD 11</div><div class="t m0 x1c hf yee ff2 fsc fc2 sc0 ls1 ws3">Real-T<span class="_0 blank"></span>ime Communications Using L<span class="_0 blank"></span>ync <span class="_6d blank"> </span>CLD 11</div><div class="t m0 x18 hf yef ff3 fsc fc2 sc0 ls1 ws3">Chapter Summary <span class="_70 blank"> </span>CLD 15</div><div class="t m0 x18 hf yf0 ff3 fsc fc2 sc0 ls1 ws3">Consider This: Y<span class="_2 blank"></span>our T<span class="_2 blank"></span>urn <span class="_71 blank"> </span>CLD 15</div><div class="t m0 x18 h10 yc9 ff2 fsc fc1 sc0 ls1 ws3">Microsoft <span class="ff1 fsd">Excel 2013</span></div><div class="t m0 x18 h11 ycb ff1 fsb fc8 sc0 ls1 ws3">CHAPTER ONE</div><div class="t m0 x18 h11 yf1 ff1 fsb fc6 sc0 ls1 ws3">Creating a W<span class="_0 blank"></span>orksheet and a Chart </div><div class="t m0 x18 hf yf2 ff3 fsc fc2 sc0 ls1 ws3">Objectives <span class="_72 blank"> </span>EX 1</div><div class="t m0 x18 hf yf3 ff3 fsc fc2 sc0 ls1 ws3">Introduction <span class="_73 blank"> </span>EX 2</div><div class="t m0 x18 hf yf4 ff3 fsc fc2 sc0 ls1 ws3">Project \u2014 W<span class="_0 blank"></span>orksheet and a Chart <span class="_74 blank"> </span>EX 2</div><div class="t m0 x1c hf yf5 ff2 fsc fc2 sc0 ls1 ws3">Roadmap <span class="_75 blank"> </span>EX 4</div><div class="t m0 x18 hf yd0 ff3 fsc fc2 sc0 ls1 ws3">Selecting a Cell <span class="_60 blank"> </span>EX 6</div><div class="t m0 x18 hf yf6 ff3 fsc fc2 sc0 ls1 ws3">Entering T<span class="_2 blank"></span>ext <span class="_5e blank"> </span>EX 6</div><div class="t m0 x1c hf yf7 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter the Worksheet T<span class="_0 blank"></span>itles <span class="_31 blank"> </span>EX 7</div><div class="t m0 x1c hf yf8 ff2 fsc fc2 sc0 ls1 ws3">AutoCorrect <span class="_76 blank"> </span>EX 9</div><div class="t m0 x1c hf yf9 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter Column Titles <span class="_54 blank"> </span>EX 9</div><div class="t m0 x1c hf yfa ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter Row Titles <span class="_77 blank"> </span>EX 11</div><div class="t m0 x18 hf yfb ff3 fsc fc2 sc0 ls1 ws3">Entering Numbers <span class="_78 blank"> </span>EX 12</div><div class="t m0 x1c hf yfc ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter Numbers <span class="_79 blank"> </span>EX 12</div><div class="t m0 x18 hf yfd ff3 fsc fc2 sc0 ls1 ws3">Calculating a Sum <span class="_7a blank"> </span>EX 14</div><div class="t m0 x1c hf yfe ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Sum a Column of Numbers <span class="_7b blank"> </span>EX 14</div></div><div class="pi" data-data='{"ctm":[1.000000,0.000000,0.000000,1.000000,0.000000,0.000000]}'></div></div> <div id="pf7" class="pf w0 h0" data-page-no="7"><div class="pc pc7 w0 h0"><img fetchpriority="low" loading="lazy" class="bi x0 y0 w0 h0" alt="" src="https://files.passeidireto.com/8a7a628b-5234-488c-b421-0cbbe050defd/bg7.png"><div class="t m0 x1e h17 yff ff1 fsc fc7 sc0 ls1 ws3">Microsoft Excel 2013 Complete<span class="ff2 fc2"> <span class="ff1">Contents</span> v</span></div><div class="t m0 x16 h11 y100 ff1 fsb fc8 sc0 ls1 ws3">CHAPTER THREE</div><div class="t m0 x16 h11 y101 ff1 fsb fc6 sc0 ls1 ws3">Working with Large W<span class="_0 blank"></span>orksheets, </div><div class="t m0 x16 h11 y102 ff1 fsb fc6 sc0 ls1">Charting,<span class="ffd">\ue022</span><span class="ws3">and What-If Analysis</span></div><div class="t m0 x16 hf y103 ff3 fsc fc2 sc0 ls1 ws3">Objectives <span class="_7c blank"> </span>EX 129</div><div class="t m0 x16 hf y104 ff3 fsc fc2 sc0 ls1 ws3">Introduction <span class="_7d blank"> </span>EX 130</div><div class="t m0 x16 hf y105 ff3 fsc fc2 sc0 ls1 ws3">Project \u2014 Financial Pr<span class="_0 blank"></span>ojection Worksheet </div><div class="t m0 x1f hf y106 ff3 fsc fc2 sc0 ls1 ws3">with What-If Analysis and Chart <span class="_7e blank"> </span>EX 130</div><div class="t m0 x14 hf y107 ff2 fsc fc2 sc0 ls1 ws3">Roadmap <span class="_69 blank"> </span>EX 134</div><div class="t m0 x16 hf y108 ff3 fsc fc2 sc0 ls1 ws3">Rotating T<span class="_2 blank"></span>ext and Using the Fill Handle </div><div class="t m0 x1f hf y109 ff3 fsc fc2 sc0 ls1 ws3">to Create a Series <span class="_7f blank"> </span>EX 135</div><div class="t m0 x14 hf y10a ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Rotate T<span class="_0 blank"></span>ext in a Cell <span class="_80 blank"> </span>EX 135</div><div class="t m0 x14 hf y10b ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Use the Fill Handle to Create </div><div class="t m0 x15 hf y10c ff2 fsc fc2 sc0 ls1 ws3">a Series of Month Names <span class="_6f blank"> </span>EX 137</div><div class="t m0 x14 hf y10d ff2 fsc fc2 sc0 ls1 ws3">Using the Auto Fill Options Menu <span class="_59 blank"> </span>EX 138</div><div class="t m0 x14 hf y10e ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Increase Column Widths <span class="_47 blank"> </span>EX 139</div><div class="t m0 x14 hf y10f ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter and Indent Row Titles <span class="_81 blank"> </span>EX 140</div><div class="t m0 x16 hf y110 ff3 fsc fc2 sc0 ls1 ws3">Copying a Range of Cells to a Nonadjacent </div><div class="t m0 x1f hf y111 ff3 fsc fc2 sc0 ls1 ws3">Destination Area <span class="_82 blank"> </span>EX 141</div><div class="t m0 x14 hf y112 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Copy a Range of Cells to a </div><div class="t m0 x15 hf y113 ff2 fsc fc2 sc0 ls1 ws3">Nonadjacent Destination Area <span class="_83 blank"> </span>EX 141</div><div class="t m0 x14 hf y114 ff2 fsc fc2 sc0 ls1 ws3">Using the Paste Options Menu <span class="_84 blank"> </span>EX 142</div><div class="t m0 x14 hf y115 ff2 fsc fc2 sc0 ls1 ws3">Using Drag and Drop to Move or </div><div class="t m0 x15 hf y116 ff2 fsc fc2 sc0 ls1 ws3">Copy Cells <span class="_85 blank"> </span>EX 143</div><div class="t m0 x14 hf y117 ff2 fsc fc2 sc0 ls1 ws3">Using Cut and Paste to Move Cells <span class="_6c blank"> </span>EX 144</div><div class="t m0 x16 hf y118 ff3 fsc fc2 sc0 ls1 ws3">Inserting and Deleting Cells in a Worksheet <span class="_45 blank"> </span>EX 144</div><div class="t m0 x14 hf y119 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Insert a Row <span class="_86 blank"> </span>EX 144</div><div class="t m0 x14 hf y11a ff2 fsc fc2 sc0 ls1 ws3">Inserting Columns <span class="_87 blank"> </span>EX 145</div><div class="t m0 x14 hf y11b ff2 fsc fc2 sc0 ls1 ws3">Inserting Single Cells or a Range of Cells <span class="_88 blank"> </span>EX 145</div><div class="t m0 x14 hf y11c ff2 fsc fc2 sc0 ls1 ws3">Deleting Columns and Rows <span class="_1c blank"> </span>EX 146</div><div class="t m0 x14 hf y11d ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter Numbers with Format Symbols <span class="_29 blank"> </span>EX 147</div><div class="t m0 x14 hf y11e ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter and Format the System Date <span class="_89 blank"> </span>EX 148</div><div class="t m0 x16 hf y11f ff3 fsc fc2 sc0 ls1 ws3">Absolute V<span class="_0 blank"></span>ersus Relative Addr<span class="_0 blank"></span>essing <span class="_2c blank"> </span>EX 151</div><div class="t m0 x14 hf y120 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter a Formula Containing </div><div class="t m0 x15 hf y121 ff2 fsc fc2 sc0 ls1 ws3">Absolute Cell References <span class="_8a blank"> </span>EX 153</div><div class="t m0 x16 hf y122 ff3 fsc fc2 sc0 ls1 ws3">Making Decisions \u2014 The IF Function <span class="_8b blank"> </span>EX 154</div><div class="t m0 x14 hf y123 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter an IF Function <span class="_80 blank"> </span>EX 156</div><div class="t m0 x14 hf y124 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Copy Formulas with Absolute Cell </div><div class="t m0 x15 hf y125 ff2 fsc fc2 sc0 ls1 ws3">References Using the Fill Handle <span class="_29 blank"> </span>EX 158</div><div class="t m0 x14 hf y126 ff2 fsc fc2 sc0 ls1 ws3">Nested Forms of the IF Function <span class="_19 blank"> </span>EX 159</div><div class="t m0 x16 hf y127 ff3 fsc fc2 sc0 ls1 ws3">Adding and Formatting Sparkline Charts <span class="_20 blank"> </span>EX 160</div><div class="t m0 x14 hf y128 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Add a Sparkline Chart to </div><div class="t m0 x15 hf y129 ff2 fsc fc2 sc0 ls1 ws3">the Worksheet <span class="_10 blank"> </span>EX 160</div><div class="t m0 x14 hf y12a ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Change the Sparkline Style </div><div class="t m0 x15 hf y12b ff2 fsc fc2 sc0 ls1 ws3">and Copy the Sparkline Chart <span class="_8c blank"> </span>EX 162</div><div class="t m0 x14 hf y12c ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Change the Sparkline T<span class="_0 blank"></span>ype <span class="_8d blank"> </span>EX 162</div><div class="t m0 x16 hf y12d ff3 fsc fc2 sc0 ls1 ws3">Formatting the Worksheet <span class="_8e blank"> </span>EX 163</div><div class="t m0 x14 hf y12e ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Assign Formats to Nonadjacent Ranges <span class="_8f blank"> </span>EX 164</div><div class="t m0 x14 hf y12f ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Copy a Cell\u2019<span class="_0 blank"></span>s Format Using </div><div class="t m0 x15 hf y130 ff2 fsc fc2 sc0 ls1 ws3">the Format Painter Button <span class="_1e blank"> </span>EX 168</div><div class="t m0 x16 hf y131 ff3 fsc fc2 sc0 ls1 ws3">Adding a Clustered Column Chart </div><div class="t m0 x1f hf y132 ff3 fsc fc2 sc0 ls1">to<span class="ffe">\ue021</span>the<span class="ffe">\ue021</span><span class="ws3">Workbook <span class="_54 blank"> </span>EX 170</span></div><div class="t m0 x14 hf y133 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Draw a Clustered Column Chart on </div><div class="t m0 x15 hf y134 ff2 fsc fc2 sc0 ls1 ws3">a Separate Chart Sheet Using </div><div class="t m0 x15 hf y135 ff2 fsc fc2 sc0 ls1 ws3">the Recommended Charts Feature <span class="_90 blank"> </span>EX 171</div><div class="t m0 x14 hf y136 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Insert a Chart Title <span class="_91 blank"> </span>EX 172</div><div class="t m0 x14 hf y137 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Add Data Labels <span class="_92 blank"> </span>EX 173</div><div class="t m0 x14 hf y138 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Apply Chart Filters <span class="_91 blank"> </span>EX 174</div><div class="t m0 x14 hf y139 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Add an Axis Title to the Chart <span class="_26 blank"> </span>EX 174</div><div class="t m0 x4 hf y13a ff3 fsc fc2 sc0 ls1 ws3">Entering Formulas <span class="_44 blank"> </span>EX 73</div><div class="t m0 x11 hf y13b ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter a Formula Using the Keyboard <span class="_3f blank"> </span>EX 73</div><div class="t m0 x11 hf y13c ff2 fsc fc2 sc0 ls1 ws3">Arithmetic Operations <span class="_93 blank"> </span>EX 75</div><div class="t m0 x11 hf y13d ff2 fsc fc2 sc0 ls1 ws3">Order of Operations <span class="_94 blank"> </span>EX 75</div><div class="t m0 x11 hf y13e ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter Formulas Using Point Mode <span class="_48 blank"> </span>EX 76</div><div class="t m0 x4 hf y13f ff3 fsc fc2 sc0 ls1 ws3">Option Buttons <span class="_95 blank"> </span>EX 79</div><div class="t m0 x4 hf y140 ff3 fsc fc2 sc0 ls1 ws3">Using the A<span class="_0 blank"></span>VERAGE, MAX, and MIN Functions <span class="_96 blank"> </span>EX 81</div><div class="t m0 x11 hf y141 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Determine the Highest Number in </div><div class="t m0 x13 hf y142 ff2 fsc fc2 sc0 ls1 ws3">a Range of Numbers Using the </div><div class="t m0 x13 hf y143 ff2 fsc fc2 sc0 ls1 ws3">Insert Function Box <span class="_97 blank"> </span>EX 82</div><div class="t m0 x11 hf y144 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Determine the Lowest Number </div><div class="t m0 x13 hf y145 ff2 fsc fc2 sc0 ls1 ws3">in a Range of Numbers Using </div><div class="t m0 x13 hf y146 ff2 fsc fc2 sc0 ls1 ws3">the Sum Menu <span class="_40 blank"> </span>EX 84</div><div class="t m0 x11 hf y147 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Determine the Average of a Range of </div><div class="t m0 x13 hf y148 ff2 fsc fc2 sc0 ls1 ws3">Numbers Using the Keyboard <span class="_98 blank"> </span>EX 86</div><div class="t m0 x4 hf y149 ff3 fsc fc2 sc0 ls1 ws3">V<span class="_0 blank"></span>erifying Formulas Using Range Finder <span class="_99 blank"> </span>EX 89</div><div class="t m0 x11 hf y14a ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Verify a Formula Using Range Finder <span class="_9a blank"> </span>EX 89</div><div class="t m0 x4 hf y14b ff3 fsc fc2 sc0 ls1 ws3">Formatting the Worksheet <span class="_40 blank"> </span>EX 89</div><div class="t m0 x11 hf y14c ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Change the Workbook Theme <span class="_9b blank"> </span>EX 91</div><div class="t m0 x11 hf y14d ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Change the Background Color </div><div class="t m0 x13 hf y14e ff2 fsc fc2 sc0 ls1 ws3">and Apply a Box Border to </div><div class="t m0 x13 hf y14f ff2 fsc fc2 sc0 ls1 ws3">the Worksheet T<span class="_2 blank"></span>itle and Subtitle <span class="_9c blank"> </span>EX 93</div><div class="t m0 x11 hf y150 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Format Dates and Center </div><div class="t m0 x13 hf y151 ff2 fsc fc2 sc0 ls1 ws3">Data in Cells <span class="_94 blank"> </span>EX 96</div><div class="t m0 x11 hf y152 ff2 fsc fc2 sc0 ls1 ws3">Formatting Numbers Using the Ribbon <span class="_9d blank"> </span>EX 97</div><div class="t m0 x11 hf y153 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Apply an Accounting Number Format </div><div class="t m0 x13 hf y154 ff2 fsc fc2 sc0 ls1 ws3">and Comma Style Format Using </div><div class="t m0 x13 hf y155 ff2 fsc fc2 sc0 ls1 ws3">the Ribbon <span class="_9e blank"> </span>EX 97</div><div class="t m0 x11 hf y156 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Apply a Currency Style Format with </div><div class="t m0 x13 hf y157 ff2 fsc fc2 sc0 ls1 ws3">a Floating Dollar Sign Using the </div><div class="t m0 x13 hf y158 ff2 fsc fc2 sc0 ls1 ws3">Format Cells Dialog Box <span class="_9f blank"> </span>EX 98</div><div class="t m0 x11 hf y159 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Apply a Percent Style Format and </div><div class="t m0 x13 hf y15a ff2 fsc fc2 sc0 ls1 ws3">Use the Increase Decimal Button <span class="_9c blank"> </span>EX 99</div><div class="t m0 x11 hf y15b ff2 fsc fc2 sc0 ls1 ws3">Conditional Formatting <span class="_a0 blank"> </span>EX 100</div><div class="t m0 x11 hf y15c ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Apply Conditional Formatting <span class="_26 blank"> </span>EX 100</div><div class="t m0 x11 hf y15d ff2 fsc fc2 sc0 ls1 ws3">Conditional Formatting Operators <span class="_a1 blank"> </span>EX 103</div><div class="t m0 x11 hf y15e ff2 fsc fc2 sc0 ls1 ws3">Changing Column Width and </div><div class="t m0 x13 hf y15f ff2 fsc fc2 sc0 ls1 ws3">Row Height <span class="_94 blank"> </span>EX 103</div><div class="t m0 x11 hf y160 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Change Column Width <span class="_24 blank"> </span>EX 103</div><div class="t m0 x11 hf y161 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Change Row Height <span class="_30 blank"> </span>EX 106</div><div class="t m0 x4 hf y162 ff3 fsc fc2 sc0 ls1 ws3">Checking Spelling <span class="_a2 blank"> </span>EX 107</div><div class="t m0 x11 hf y163 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Check Spelling on the Worksheet <span class="_a3 blank"> </span>EX 108</div><div class="t m0 x11 hf y164 ff2 fsc fc2 sc0 ls1 ws3">Additional Spell Checker Considerations <span class="_a4 blank"> </span>EX 109</div><div class="t m0 x4 hf y165 ff3 fsc fc2 sc0 ls1 ws3">Printing the Worksheet <span class="_a5 blank"> </span>EX 110</div><div class="t m0 x11 hf y166 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Change the Worksheet\u2019<span class="_0 blank"></span>s Margins, </div><div class="t m0 x13 hf y167 ff2 fsc fc2 sc0 ls1 ws3">Header<span class="_2 blank"></span>, and Orientation in Page </div><div class="t m0 x13 hf y168 ff2 fsc fc2 sc0 ls1 ws3">Layout View <span class="_5d blank"> </span>EX 110</div><div class="t m0 x11 hf y169 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Print a Section of the Worksheet <span class="_a6 blank"> </span>EX 114</div><div class="t m0 x4 hf y16a ff3 fsc fc2 sc0 ls1 ws3">Displaying and Printing the Formulas V<span class="_0 blank"></span>ersion </div><div class="t m0 x12 hf y16b ff3 fsc fc2 sc0 ls1 ws3">of the Worksheet <span class="_54 blank"> </span>EX 115</div><div class="t m0 x11 hf y16c ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Display the Formulas in the </div><div class="t m0 x13 hf y16d ff2 fsc fc2 sc0 ls1 ws3">Worksheet and Fit the Printout </div><div class="t m0 x13 hf y16e ff2 fsc fc2 sc0 ls1 ws3">on One Page <span class="_5f blank"> </span>EX 115</div><div class="t m0 x4 hf y16f ff3 fsc fc2 sc0 ls1 ws3">Chapter Summary <span class="_5b blank"> </span>EX 118</div><div class="t m0 x4 hf y170 ff3 fsc fc2 sc0 ls1 ws3">Apply Y<span class="_2 blank"></span>our Knowledge <span class="_a7 blank"> </span>EX 119</div><div class="t m0 x4 hf y171 ff3 fsc fc2 sc0 ls1 ws3">Extend Y<span class="_2 blank"></span>our Knowledge <span class="_5d blank"> </span>EX 121</div><div class="t m0 x4 hf y172 ff3 fsc fc2 sc0 ls1 ws3">Analyze, Correct, Impr<span class="_0 blank"></span>ove <span class="_39 blank"> </span>EX 122</div><div class="t m0 x4 hf y173 ff3 fsc fc2 sc0 ls1 ws3">In the Labs <span class="_5e blank"> </span>EX 123</div><div class="t m0 x4 hf y174 ff3 fsc fc2 sc0 ls1 ws3">Consider This: Y<span class="_2 blank"></span>our T<span class="_2 blank"></span>urn <span class="_92 blank"> </span>EX 127</div><div class="t m0 x4 hf y175 ff3 fsc fc2 sc0 ls1 ws3">Learn Online <span class="_60 blank"> </span>EX 128</div></div><div class="pi" data-data='{"ctm":[1.000000,0.000000,0.000000,1.000000,0.000000,0.000000]}'></div></div> <div id="pf8" class="pf w0 h0" data-page-no="8"><div class="pc pc8 w0 h0"><img fetchpriority="low" loading="lazy" class="bi x0 y0 w0 h0" alt="" src="https://files.passeidireto.com/8a7a628b-5234-488c-b421-0cbbe050defd/bg8.png"><div class="t m0 x18 h17 y9f ff2 fsc fc2 sc0 ls1 ws3">vi <span class="ff1">Contents</span> <span class="ff1 fc7">Microsoft Excel 2013 Complete</span></div><div class="t m0 x1c hf y176 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Change the Chart Style <span class="_74 blank"> </span>EX 176</div><div class="t m0 x1c hf y177 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Modify the Chart Axis Number Format <span class="_90 blank"> </span>EX 177</div><div class="t m0 x18 hf y178 ff3 fsc fc2 sc0 ls1 ws3">Organizing the Workbook <span class="_a8 blank"> </span>EX 179</div><div class="t m0 x1c hf y179 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Reorder the Sheet T<span class="_0 blank"></span>abs <span class="_a9 blank"> </span>EX 180</div><div class="t m0 x18 hf y17a ff3 fsc fc2 sc0 ls1 ws3">Changing the View of the Worksheet <span class="_18 blank"> </span>EX 182</div><div class="t m0 x1c hf y17b ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Shrink and Magnify the View </div><div class="t m0 x1d hf y17c ff2 fsc fc2 sc0 ls1 ws3">of a Worksheet or Chart <span class="_8b blank"> </span>EX 182</div><div class="t m0 x1c hf y17d ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Split a Window into Panes <span class="_aa blank"> </span>EX 184</div><div class="t m0 x1c hf y17e ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Freeze Worksheet Columns and Rows <span class="_17 blank"> </span>EX 185</div><div class="t m0 x18 hf y17f ff3 fsc fc2 sc0 ls1 ws3">What-If Analysis <span class="_7a blank"> </span>EX 187</div><div class="t m0 x1c hf y180 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Analyze Data in a Worksheet </div><div class="t m0 x1d hf y181 ff2 fsc fc2 sc0 ls1 ws3">by Changing V<span class="_0 blank"></span>alues <span class="_47 blank"> </span>EX 187</div><div class="t m0 x1c hf y182 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Goal Seek <span class="_a2 blank"> </span>EX 188</div><div class="t m0 x1c hf y183 ff2 fsc fc2 sc0 ls1 ws3">Goal Seeking <span class="_ab blank"> </span>EX 190</div><div class="t m0 x18 hf y184 ff3 fsc fc2 sc0 ls1 ws3">Chapter Summary <span class="_ac blank"> </span>EX 192</div><div class="t m0 x18 hf y185 ff3 fsc fc2 sc0 ls1 ws3">Apply Y<span class="_2 blank"></span>our Knowledge <span class="_71 blank"> </span>EX 193</div><div class="t m0 x18 hf y186 ff3 fsc fc2 sc0 ls1 ws3">Extend Y<span class="_2 blank"></span>our Knowledge <span class="_4c blank"> </span>EX 195</div><div class="t m0 x18 hf y187 ff3 fsc fc2 sc0 ls1 ws3">Analyze, Correct, Impr<span class="_0 blank"></span>ove <span class="_39 blank"> </span>EX 196</div><div class="t m0 x18 hf y188 ff3 fsc fc2 sc0 ls1 ws3">In the Labs <span class="_5e blank"> </span>EX 198</div><div class="t m0 x18 hf y189 ff3 fsc fc2 sc0 ls1 ws3">Consider This: Y<span class="_2 blank"></span>our T<span class="_2 blank"></span>urn <span class="_92 blank"> </span>EX 204</div><div class="t m0 x18 hf y18a ff3 fsc fc2 sc0 ls1 ws3">Learn Online <span class="_60 blank"> </span>EX 207</div><div class="t m0 x18 h11 y18b ff1 fsb fc8 sc0 ls1 ws3">CHAPTER FOUR</div><div class="t m0 x18 h11 y18c ff1 fsb fc6 sc0 ls1 ws3">Financial Functions, Data T<span class="_3c blank"></span>ables, and </div><div class="t m0 x18 h11 y18d ff1 fsb fc6 sc0 ls1 ws3">Amortization Schedules</div><div class="t m0 x18 hf y18e ff3 fsc fc2 sc0 ls1 ws3">Objectives <span class="_ad blank"> </span>EX 209</div><div class="t m0 x18 hf y18f ff3 fsc fc2 sc0 ls1 ws3">Introduction <span class="_ae blank"> </span>EX 210</div><div class="t m0 x18 hf y190 ff3 fsc fc2 sc0 ls1 ws3">Project \u2014 Mortgage Payment Calculator </div><div class="t m0 x20 hf y191 ff3 fsc fc2 sc0 ls1 ws3">with Data T<span class="_2 blank"></span>able and Amortization </div><div class="t m0 x20 hf y192 ff3 fsc fc2 sc0 ls1 ws3">Schedule <span class="_af blank"> </span>EX 210</div><div class="t m0 x1c hf y193 ff2 fsc fc2 sc0 ls1 ws3">Roadmap <span class="_95 blank"> </span>EX 213</div><div class="t m0 x18 hf y194 ff3 fsc fc2 sc0 ls1 ws3">Creating Cell Names <span class="_6a blank"> </span>EX 216</div><div class="t m0 x1c hf y195 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Create Names Based on Row Titles <span class="_b0 blank"> </span>EX 218</div><div class="t m0 x1c hf y196 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter the Loan Amount </div><div class="t m0 x1d hf y197 ff2 fsc fc2 sc0 ls1 ws3">Formula Using Names <span class="_b1 blank"> </span>EX 220</div><div class="t m0 x1c hf y198 ff2 fsc fc2 sc0 ls1 ws3">The PMT Function <span class="_b2 blank"> </span>EX 221</div><div class="t m0 x1c hf y199 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter the PMT Function <span class="_b3 blank"> </span>EX 221</div><div class="t m0 x1c hf y19a ff2 fsc fc2 sc0 ls1 ws3">Other Financial Functions <span class="_b4 blank"> </span>EX 222</div><div class="t m0 x18 hf y19b ff3 fsc fc2 sc0 ls1 ws3">Using a Data T<span class="_2 blank"></span>able to Analyze </div><div class="t m0 x20 hf y19c ff3 fsc fc2 sc0 ls1 ws3">Worksheet Data <span class="_b5 blank"> </span>EX 224</div><div class="t m0 x1c hf y19d ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Create a Percent Series </div><div class="t m0 x1d hf y19e ff2 fsc fc2 sc0 ls1 ws3">Using the Fill Handle <span class="_b6 blank"> </span>EX 226</div><div class="t m0 x1c hf y19f ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o De<span class="fff">\ue021</span>ne a Range </div><div class="t m0 x1d hf y1a0 ff2 fsc fc2 sc0 ls1 ws3">as a Data T<span class="_2 blank"></span>able <span class="_b7 blank"> </span>EX 228</div><div class="t m0 x1c hf y1a1 ff2 fsc fc2 sc0 ls1 ws3">More about Data T<span class="_2 blank"></span>ables <span class="_b8 blank"> </span>EX 230</div><div class="t m0 x18 hf y1a2 ff3 fsc fc2 sc0 ls1 ws3">Creating an Amortization Schedule <span class="_b9 blank"> </span>EX 230</div><div class="t m0 x1c hf y1a3 ff2 fsc fc2 sc0 ls1 ws3">Formulas in the Amortization Schedule <span class="_45 blank"> </span>EX 233</div><div class="t m0 x1c hf y1a4 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter the Formulas in </div><div class="t m0 x1d hf y1a5 ff2 fsc fc2 sc0 ls1 ws3">the Amortization Schedule <span class="_a1 blank"> </span>EX 234</div><div class="t m0 x1c hf y1a6 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Copy the Formulas to Fill </div><div class="t m0 x1d hf yd1 ff2 fsc fc2 sc0 ls1 ws3">the Amortization Schedule <span class="_a1 blank"> </span>EX 236</div><div class="t m0 x1c hf yd2 ff2 fsc fc2 sc0 ls1 ws3">Formatting the Worksheet <span class="_ba blank"> </span>EX 238</div><div class="t m0 x1c hf yd3 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Add Custom Borders to a Range <span class="_bb blank"> </span>EX 239</div><div class="t m0 x1c hf yd4 ff2 fsc fc2 sc0 ls1 ws3">Adding a Pointer to the Data T<span class="_2 blank"></span>able </div><div class="t m0 x1d hf yd5 ff2 fsc fc2 sc0 ls1 ws3">Using Conditional Formatting <span class="_bc blank"> </span>EX 243</div><div class="t m0 x1c hf yd6 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Add a Pointer to the Data T<span class="_0 blank"></span>able </div><div class="t m0 x1d hf yd7 ff2 fsc fc2 sc0 ls1 ws3">Using Conditional Formatting <span class="_bc blank"> </span>EX 243</div><div class="t m0 x18 hf yd8 ff3 fsc fc2 sc0 ls1 ws3">Printing Sections of the Worksheet <span class="_bd blank"> </span>EX 247</div><div class="t m0 x1c hf y1a7 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Set Up a Worksheet to Print <span class="_37 blank"> </span>EX 247</div><div class="t m0 x1a hf ya0 ff2 fsc fc2 sc0 ls1 ws3">More about Print Options <span class="_be blank"> </span>EX 248</div><div class="t m0 x1a hf ya1 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Set the Print Area <span class="_40 blank"> </span>EX 248</div><div class="t m0 x1a hf ya2 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Name and Print Sections </div><div class="t m0 x1b hf ya3 ff2 fsc fc2 sc0 ls1 ws3">of a Worksheet <span class="_bf blank"> </span>EX 249</div><div class="t m0 x19 hf ya4 ff3 fsc fc2 sc0 ls1 ws3">Protecting and Hiding W<span class="_0 blank"></span>orksheets </div><div class="t m0 x7 hf ya5 ff3 fsc fc2 sc0 ls1 ws3">and Workbooks <span class="_53 blank"> </span>EX 252</div><div class="t m0 x1a hf ya6 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Protect a Worksheet <span class="_80 blank"> </span>EX 252</div><div class="t m0 x1a hf ya7 ff2 fsc fc2 sc0 ls1 ws3">More about Worksheet Protection <span class="_c0 blank"> </span>EX 255</div><div class="t m0 x1a hf ya8 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Hide and Unhide a Sheet <span class="_c1 blank"> </span>EX 255</div><div class="t m0 x1a hf ya9 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Hide and Unhide a Workbook <span class="_26 blank"> </span>EX 257</div><div class="t m0 x19 hf yaa ff3 fsc fc2 sc0 ls1 ws3">Formula Checking <span class="_25 blank"> </span>EX 258</div><div class="t m0 x1a hf yab ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enable Background </div><div class="t m0 x1b hf yac ff2 fsc fc2 sc0 ls1 ws3">Formula Checking <span class="_4b blank"> </span>EX 258</div><div class="t m0 x1a hf yad ff2 fsc fc2 sc0 ls1 ws3">More about Background Formula </div><div class="t m0 x1b hf yae ff2 fsc fc2 sc0 ls1 ws3">Checking <span class="_c2 blank"> </span>EX 259</div><div class="t m0 x19 hf yaf ff3 fsc fc2 sc0 ls1 ws3">Chapter Summary <span class="_5b blank"> </span>EX 261</div><div class="t m0 x19 hf yb0 ff3 fsc fc2 sc0 ls1 ws3">Apply Y<span class="_2 blank"></span>our Knowledge <span class="_a7 blank"> </span>EX 262</div><div class="t m0 x19 hf yb1 ff3 fsc fc2 sc0 ls1 ws3">Extend Y<span class="_2 blank"></span>our Knowledge <span class="_5d blank"> </span>EX 263</div><div class="t m0 x19 hf yb2 ff3 fsc fc2 sc0 ls1 ws3">Analyze, Correct, Impr<span class="_0 blank"></span>ove <span class="_39 blank"> </span>EX 265</div><div class="t m0 x19 hf yb3 ff3 fsc fc2 sc0 ls1 ws3">In the Labs <span class="_5e blank"> </span>EX 266</div><div class="t m0 x19 hf yb4 ff3 fsc fc2 sc0 ls1 ws3">Consider This: Y<span class="_2 blank"></span>our T<span class="_2 blank"></span>urn <span class="_92 blank"> </span>EX 271</div><div class="t m0 x19 hf yb5 ff3 fsc fc2 sc0 ls1 ws3">Learn Online <span class="_60 blank"> </span>EX 272</div><div class="t m0 x19 h11 y1a8 ff1 fsb fc8 sc0 ls1 ws3">CHAPTER FIVE</div><div class="t m0 x19 h11 y18d ff1 fsb fc6 sc0 ls1 ws3">Working with Multiple W<span class="_0 blank"></span>orksheets and </div><div class="t m0 x19 h11 y18e ff1 fsb fc6 sc0 ls1 wsc">Workbooks</div><div class="t m0 x19 hf y18f ff3 fsc fc2 sc0 ls1 ws3">Objectives <span class="_ad blank"> </span>EX 273</div><div class="t m0 x19 hf y190 ff3 fsc fc2 sc0 ls1 ws3">Introduction <span class="_ae blank"> </span>EX 274</div><div class="t m0 x19 hf y191 ff3 fsc fc2 sc0 ls1 ws3">Project \u2014 Consolidated Expenses W<span class="_0 blank"></span>orksheet <span class="_c3 blank"> </span>EX 274</div><div class="t m0 x1a hf y192 ff2 fsc fc2 sc0 ls1 ws3">Roadmap <span class="_c4 blank"> </span>EX 277</div><div class="t m0 x19 hf y193 ff3 fsc fc2 sc0 ls1 ws3">Creating the Consolidated W<span class="_0 blank"></span>orksheet <span class="_18 blank"> </span>EX 278</div><div class="t m0 x1a hf y194 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter Sample Data in the </div><div class="t m0 x1b hf y195 ff2 fsc fc2 sc0 ls1 ws3">Consolidated Worksheet </div><div class="t m0 x1b hf y196 ff2 fsc fc2 sc0 ls1 ws3">Using the Fill Handle <span class="_b6 blank"> </span>EX 280</div><div class="t m0 x1a hf y197 ff2 fsc fc2 sc0 ls1 ws3">The ROUND Function and Entering </div><div class="t m0 x1b hf y198 ff2 fsc fc2 sc0 ls1 ws3">Formulas in the T<span class="_2 blank"></span>emplate <span class="_c5 blank"> </span>EX 282</div><div class="t m0 x1a hf y199 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter Formulas Using </div><div class="t m0 x1b hf y19a ff2 fsc fc2 sc0 ls1 ws3">the ROUND Function and </div><div class="t m0 x1b hf y19b ff2 fsc fc2 sc0 ls1 ws3">Determine T<span class="_2 blank"></span>otals in the </div><div class="t m0 x1b hf y19c ff2 fsc fc2 sc0 ls1 ws3">Consolidated Worksheet <span class="_6f blank"> </span>EX 282</div><div class="t m0 x19 hf y19d ff3 fsc fc2 sc0 ls1 ws3">Formatting the Consolidated Worksheet <span class="_c6 blank"> </span>EX 286</div><div class="t m0 x1a hf y19e ff2 fsc fc2 sc0 ls1 ws3">Format Codes <span class="_c7 blank"> </span>EX 289</div><div class="t m0 x1a hf y19f ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Create and Assign a Custom </div><div class="t m0 x1b hf y1a0 ff2 fsc fc2 sc0 ls1 ws3">Format Code and a Comma </div><div class="t m0 x1b hf y1a1 ff2 fsc fc2 sc0 ls1 ws3">Style Format <span class="_82 blank"> </span>EX 290</div><div class="t m0 x1a hf y1a2 ff2 fsc fc2 sc0 ls1 ws3">Cell Styles <span class="_76 blank"> </span>EX 291</div><div class="t m0 x1a hf y1a3 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Create a New Style <span class="_a8 blank"> </span>EX 292</div><div class="t m0 x1a hf y1a4 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Apply a New Style <span class="_c8 blank"> </span>EX 295</div><div class="t m0 x19 hf y1a5 ff3 fsc fc2 sc0 ls1 ws3">Working with Multiple W<span class="_0 blank"></span>orksheets <span class="_6e blank"> </span>EX 296</div><div class="t m0 x1a hf y1a6 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Add a Worksheet to a W<span class="_0 blank"></span>orkbook <span class="_c9 blank"> </span>EX 297</div><div class="t m0 x1a hf yd1 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Copy the Contents of </div><div class="t m0 x1b hf yd2 ff2 fsc fc2 sc0 ls1 ws3">One Worksheet to Another </div><div class="t m0 x1b hf yd3 ff2 fsc fc2 sc0 ls1 ws3">Worksheet in a W<span class="_0 blank"></span>orkbook <span class="_66 blank"> </span>EX 297</div><div class="t m0 x1a hf yd4 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Add a Copy of a </div><div class="t m0 x1b hf yd5 ff2 fsc fc2 sc0 ls1 ws3">Worksheet to a W<span class="_0 blank"></span>orkbook <span class="_59 blank"> </span>EX 299</div><div class="t m0 x1a hf yd6 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Drill an Entry through Worksheets <span class="_28 blank"> </span>EX 300</div><div class="t m0 x1a hf yd7 ff2 fsc fc2 sc0 ls1 ws3">Referencing Cells in Other Worksheets </div><div class="t m0 x1b hf yd8 ff2 fsc fc2 sc0 ls1 ws3">in a Workbook <span class="_8e blank"> </span>EX 305</div></div><div class="pi" data-data='{"ctm":[1.000000,0.000000,0.000000,1.000000,0.000000,0.000000]}'></div></div> <div id="pf9" class="pf w0 h0" data-page-no="9"><div class="pc pc9 w0 h0"><img fetchpriority="low" loading="lazy" class="bi x0 y0 w0 h0" alt="" src="https://files.passeidireto.com/8a7a628b-5234-488c-b421-0cbbe050defd/bg9.png"><div class="t m0 x21 h17 yff ff1 fsc fc7 sc0 ls1 ws3">Microsoft Excel 2013 Complete<span class="ff2 fc2"> <span class="ff1">Contents</span> vii</span></div><div class="t m0 x14 hf y1a9 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Search a T<span class="_0 blank"></span>able Using AutoFilter <span class="_a1 blank"> </span>EX 377</div><div class="t m0 x14 hf y1aa ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter Custom Criteria </div><div class="t m0 x15 hf y1ab ff2 fsc fc2 sc0 ls1 ws3">Using AutoFilter <span class="_ca blank"> </span>EX 378</div><div class="t m0 x14 hf y1ac ff2 fsc fc2 sc0 ls1 ws3">More about AutoFilters <span class="_a0 blank"> </span>EX 380</div><div class="t m0 x14 hf y1ad ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o T<span class="_0 blank"></span>urn Off AutoFilter <span class="_8e blank"> </span>EX 380</div><div class="t m0 x16 hf y1ae ff3 fsc fc2 sc0 ls1 ws3">Using Criteria and Extract Ranges <span class="_cb blank"> </span>EX 381</div><div class="t m0 x14 hf y1af ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Query Using a Criteria Range <span class="_9b blank"> </span>EX 382</div><div class="t m0 x14 hf y1b0 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Extract Records <span class="_13 blank"> </span>EX 383</div><div class="t m0 x14 hf y1b1 ff2 fsc fc2 sc0 ls1 ws3">More about the Criteria Range <span class="_37 blank"> </span>EX 384</div><div class="t m0 x16 hf y1b2 ff3 fsc fc2 sc0 ls1 ws3">Using Database Functions <span class="_39 blank"> </span>EX 385</div><div class="t m0 x14 hf y1b3 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Use the DAVERAGE and DCOUNT </div><div class="t m0 x15 hf y1b4 ff2 fsc fc2 sc0 ls1 ws3">Database Functions <span class="_cc blank"> </span>EX 386</div><div class="t m0 x16 hf y1b5 ff3 fsc fc2 sc0 ls1 ws3">Using the SUMIF<span class="_3c blank"></span>, COUNTIF<span class="_2 blank"></span>, MA<span class="_2 blank"></span>TCH, </div><div class="t m0 x1f hf y1b6 ff3 fsc fc2 sc0 ls1 ws3">and INDEX Functions <span class="_15 blank"> </span>EX 388</div><div class="t m0 x14 hf y1b7 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Use the SUMIF Function <span class="_cc blank"> </span>EX 388</div><div class="t m0 x14 hf y1b8 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Use the COUNTIF Function <span class="_cd blank"> </span>EX 389</div><div class="t m0 x14 hf y1b9 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Use the MA<span class="_0 blank"></span>TCH and </div><div class="t m0 x15 hf y1ba ff2 fsc fc2 sc0 ls1 ws3">INDEX Functions <span class="_ce blank"> </span>EX 389</div><div class="t m0 x16 hf y1bb ff3 fsc fc2 sc0 ls1 ws3">Summarizing Data <span class="_c7 blank"> </span>EX 391</div><div class="t m0 x14 hf y1bc ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Convert a T<span class="_0 blank"></span>able to a Range <span class="_cf blank"> </span>EX 391</div><div class="t m0 x14 hf y1bd ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Display Subtotals <span class="_54 blank"> </span>EX 392</div><div class="t m0 x14 hf y1be ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Use the Outline Feature <span class="_d0 blank"> </span>EX 393</div><div class="t m0 x16 hf y1bf ff3 fsc fc2 sc0 ls1 ws3">Chapter Summary <span class="_5b blank"> </span>EX 395</div><div class="t m0 x16 hf y1c0 ff3 fsc fc2 sc0 ls1 ws3">Apply Y<span class="_2 blank"></span>our Knowledge <span class="_a7 blank"> </span>EX 396</div><div class="t m0 x16 hf y1c1 ff3 fsc fc2 sc0 ls1 ws3">Extend Y<span class="_2 blank"></span>our Knowledge <span class="_5d blank"> </span>EX 398</div><div class="t m0 x16 hf y1c2 ff3 fsc fc2 sc0 ls1 ws3">Analyze, Correct, Impr<span class="_0 blank"></span>ove <span class="_39 blank"> </span>EX 400</div><div class="t m0 x16 hf y1c3 ff3 fsc fc2 sc0 ls1 ws3">In the Labs <span class="_5e blank"> </span>EX 401</div><div class="t m0 x16 hf y1c4 ff3 fsc fc2 sc0 ls1 ws3">Consider This: Y<span class="_2 blank"></span>our T<span class="_2 blank"></span>urn <span class="_92 blank"> </span>EX 405</div><div class="t m0 x16 hf y1c5 ff3 fsc fc2 sc0 ls1 ws3">Learn Online <span class="_60 blank"> </span>EX 407</div><div class="t m0 x16 h11 y1c6 ff1 fsb fc8 sc0 ls1 ws3">CHAPTER SEVEN</div><div class="t m0 x16 h11 y194 ff1 fsb fc6 sc0 ls1 ws3">Creating T<span class="_3c blank"></span>emplates, Importing Data, </div><div class="t m0 x16 h11 y195 ff1 fsb fc6 sc0 ls1 ws3">and Working with SmartArt, </div><div class="t m0 x16 h11 y196 ff1 fsb fc6 sc0 ls1 ws3">Images, and Screen Shots</div><div class="t m0 x16 hf y197 ff3 fsc fc2 sc0 ls1 ws3">Objectives <span class="_ad blank"> </span>EX 409</div><div class="t m0 x16 hf y198 ff3 fsc fc2 sc0 ls1 ws3">Introduction <span class="_ae blank"> </span>EX 410</div><div class="t m0 x16 hf y199 ff3 fsc fc2 sc0 ls1 ws3">Project \u2014 Clear Pools Sales Analysis <span class="_36 blank"> </span>EX 410</div><div class="t m0 x14 hf y19a ff2 fsc fc2 sc0 ls1 ws3">Roadmap <span class="_95 blank"> </span>EX 413</div><div class="t m0 x16 hf y19b ff3 fsc fc2 sc0 ls1 ws3">Creating T<span class="_3c blank"></span>emplates <span class="_d1 blank"> </span>EX 414</div><div class="t m0 x14 hf y19c ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Save the T<span class="_0 blank"></span>emplate <span class="_d2 blank"> </span>EX 418</div><div class="t m0 x14 hf y19d ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Open a T<span class="_0 blank"></span>emplate and </div><div class="t m0 x15 hf y19e ff2 fsc fc2 sc0 ls1 ws3">Save It as a Workbook <span class="_aa blank"> </span>EX 420</div><div class="t m0 x16 hf y19f ff3 fsc fc2 sc0 ls1 ws3">Importing Data <span class="_d3 blank"> </span>EX 422</div><div class="t m0 x14 hf y1a0 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Import Data from a T<span class="_0 blank"></span>ext File </div><div class="t m0 x15 hf y1a1 ff2 fsc fc2 sc0 ls1 ws3">into a Worksheet <span class="_21 blank"> </span>EX 423</div><div class="t m0 x14 hf y1a2 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Import Data from an Access </div><div class="t m0 x15 hf y1a3 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>able into a Worksheet <span class="_b9 blank"> </span>EX 426</div><div class="t m0 x14 hf y1a4 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Format the Access Data <span class="_a9 blank"> </span>EX 428</div><div class="t m0 x14 hf y1a5 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Import Data from a Webpage </div><div class="t m0 x15 hf y1a6 ff2 fsc fc2 sc0 ls1 ws3">into a Worksheet <span class="_21 blank"> </span>EX 429</div><div class="t m0 x14 hf yd1 ff2 fsc fc2 sc0 ls1 ws3">Using Word Data <span class="_9e blank"> </span>EX 432</div><div class="t m0 x14 hf yd2 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Paste Special <span class="_67 blank"> </span>EX 432</div><div class="t m0 x14 hf yd3 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o T<span class="_0 blank"></span>ranspose <span class="_64 blank"> </span>EX 434</div><div class="t m0 x14 hf yd4 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Convert T<span class="_0 blank"></span>ext to Columns <span class="_14 blank"> </span>EX 436</div><div class="t m0 x14 hf yd5 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Replicate Formulas <span class="_a8 blank"> </span>EX 437</div><div class="t m0 x16 hf yd6 ff3 fsc fc2 sc0 ls1 ws3">Using the Quick Analysis T<span class="_2 blank"></span>ool <span class="_c blank"> </span>EX 438</div><div class="t m0 x14 hf yd7 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Format with the Quick </div><div class="t m0 x15 hf yd8 ff2 fsc fc2 sc0 ls1 ws3">Analysis T<span class="_2 blank"></span>oolbar <span class="_15 blank"> </span>EX 439</div><div class="t m0 x14 hf y1a7 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o T<span class="_0 blank"></span>otal Data with the Quick </div><div class="t m0 x15 hf y1c7 ff2 fsc fc2 sc0 ls1 ws3">Analysis T<span class="_2 blank"></span>oolbar <span class="_15 blank"> </span>EX 440</div><div class="t m0 x11 hf ya0 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter and Copy 3-D References Using </div><div class="t m0 x13 hf ya1 ff2 fsc fc2 sc0 ls1 ws3">the Paste Gallery <span class="_b8 blank"> </span>EX 306</div><div class="t m0 x11 hf ya2 ff2 fsc fc2 sc0 ls1 ws3">More about Pasting <span class="_82 blank"> </span>EX 309</div><div class="t m0 x11 hf ya3 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Move a Chart <span class="_c2 blank"> </span>EX 311</div><div class="t m0 x11 hf ya4 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Resize a Chart <span class="_d4 blank"> </span>EX 312</div><div class="t m0 x11 hf ya5 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Explode the 3-D Pie Chart <span class="_d5 blank"> </span>EX 313</div><div class="t m0 x11 hf ya6 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Rotate the 3-D Pie Chart <span class="_47 blank"> </span>EX 314</div><div class="t m0 x4 hf ya7 ff3 fsc fc2 sc0 ls1 ws3">Adding a Header and Footer<span class="_2 blank"></span>, Changing </div><div class="t m0 x12 hf ya8 ff3 fsc fc2 sc0 ls1 ws3">the Margins, and Printing </div><div class="t m0 x12 hf ya9 ff3 fsc fc2 sc0 ls1 ws3">the Workbook <span class="_d4 blank"> </span>EX 316</div><div class="t m0 x11 hf yaa ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Change Margins and Center </div><div class="t m0 x13 hf yab ff2 fsc fc2 sc0 ls1 ws3">the Printout Horizontally <span class="_2c blank"> </span>EX 317</div><div class="t m0 x11 hf yac ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Add a Header and Footer <span class="_b1 blank"> </span>EX 318</div><div class="t m0 x11 hf yad ff2 fsc fc2 sc0 ls1 ws3">Selecting and Deselecting Sheets <span class="_d6 blank"> </span>EX 322</div><div class="t m0 x11 hf yae ff2 fsc fc2 sc0 ls1 ws3">Inserting and Removing Page Breaks <span class="_d7 blank"> </span>EX 322</div><div class="t m0 x11 hf yaf ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Insert and Remove a Manual Page Break <span class="_d8 blank"> </span>EX 323</div><div class="t m0 x11 hf yb0 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Hide Page Breaks <span class="_5f blank"> </span>EX 324</div><div class="t m0 x4 hf yb1 ff3 fsc fc2 sc0 ls1 ws3">Consolidating Data by Linking Workbooks <span class="_83 blank"> </span>EX 325</div><div class="t m0 x11 hf yb2 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Search for and Open Workbooks <span class="_23 blank"> </span>EX 326</div><div class="t m0 x11 hf yb3 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Consolidate Data by </div><div class="t m0 x13 hf yb4 ff2 fsc fc2 sc0 ls1 ws3">Linking Workbooks <span class="_cc blank"> </span>EX 328</div><div class="t m0 x4 hf yb5 ff3 fsc fc2 sc0 ls1 ws3">Chapter Summary <span class="_5b blank"> </span>EX 332</div><div class="t m0 x4 hf yb6 ff3 fsc fc2 sc0 ls1 ws3">Apply Y<span class="_2 blank"></span>our Knowledge <span class="_a7 blank"> </span>EX 334</div><div class="t m0 x4 hf yb7 ff3 fsc fc2 sc0 ls1 ws3">Extend Y<span class="_2 blank"></span>our Knowledge <span class="_5d blank"> </span>EX 335</div><div class="t m0 x4 hf yb8 ff3 fsc fc2 sc0 ls1 ws3">Analyze, Correct, Impr<span class="_0 blank"></span>ove <span class="_39 blank"> </span>EX 336</div><div class="t m0 x4 hf yb9 ff3 fsc fc2 sc0 ls1 ws3">In the Labs <span class="_5e blank"> </span>EX 337</div><div class="t m0 x4 hf yba ff3 fsc fc2 sc0 ls1 ws3">Consider This: Y<span class="_2 blank"></span>our T<span class="_2 blank"></span>urn <span class="_92 blank"> </span>EX 341</div><div class="t m0 x4 hf ybb ff3 fsc fc2 sc0 ls1 ws3">Learn Online <span class="_60 blank"> </span>EX 343</div><div class="t m0 x4 h11 y1c8 ff1 fsb fc8 sc0 ls1 ws3">CHAPTER SIX</div><div class="t m0 x4 h11 y193 ff1 fsb fc6 sc0 ls1 ws3">Creating, Sorting, and Querying </div><div class="t m0 x4 h11 y194 ff1 fsb fc6 sc0 ls1 ws3">a T<span class="_3c blank"></span>able</div><div class="t m0 x4 hf y195 ff3 fsc fc2 sc0 ls1 ws3">Objectives <span class="_ad blank"> </span>EX 345</div><div class="t m0 x4 hf y196 ff3 fsc fc2 sc0 ls1 ws3">Introduction <span class="_ae blank"> </span>EX 346</div><div class="t m0 x4 hf y197 ff3 fsc fc2 sc0 ls1 ws3">Project \u2014 Coastal Realty Agent </div><div class="t m0 x12 hf y198 ff3 fsc fc2 sc0 ls1 ws3">Commission T<span class="_2 blank"></span>able <span class="_d9 blank"> </span>EX 346</div><div class="t m0 x11 hf y199 ff2 fsc fc2 sc0 ls1 ws3">Roadmap <span class="_95 blank"> </span>EX 350</div><div class="t m0 x11 hf y19a ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>able Guidelines <span class="_c2 blank"> </span>EX 351</div><div class="t m0 x4 hf y19b ff3 fsc fc2 sc0 ls1 ws3">Creating a T<span class="_3c blank"></span>able <span class="_da blank"> </span>EX 351</div><div class="t m0 x11 hf y19c ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Format a Range as a T<span class="_0 blank"></span>able <span class="_db blank"> </span>EX 352</div><div class="t m0 x11 hf y19d ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Name the T<span class="_0 blank"></span>able <span class="_a5 blank"> </span>EX 354</div><div class="t m0 x11 hf y19e ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Remove Duplicates <span class="_a8 blank"> </span>EX 355</div><div class="t m0 x11 hf y19f ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Enter a New Record into a T<span class="_0 blank"></span>able <span class="_dc blank"> </span>EX 356</div><div class="t m0 x11 hf y1a0 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Center Across Selection <span class="_74 blank"> </span>EX 357</div><div class="t m0 x4 hf y1a1 ff3 fsc fc2 sc0 ls1 ws3">Adding Calculated Fields to the T<span class="_2 blank"></span>able <span class="_c5 blank"> </span>EX 358</div><div class="t m0 x11 hf y1a2 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Create Calculated Fields <span class="_d0 blank"> </span>EX 358</div><div class="t m0 x4 hf y1a3 ff3 fsc fc2 sc0 ls1 ws3">Using a Lookup T<span class="_2 blank"></span>able <span class="_a blank"> </span>EX 360</div><div class="t m0 x11 hf y1a4 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Use the VLOOKUP Function <span class="_bd blank"> </span>EX 362</div><div class="t m0 x4 hf y1a5 ff3 fsc fc2 sc0 ls1 ws3">Conditional Formatting <span class="_a5 blank"> </span>EX 363</div><div class="t m0 x11 hf y1a6 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Add a Conditional Formatting </div><div class="t m0 x13 hf yd1 ff2 fsc fc2 sc0 ls1 ws3">Rule with an Icon Set <span class="_7b blank"> </span>EX 363</div><div class="t m0 x4 hf yd2 ff3 fsc fc2 sc0 ls1 ws3">Working with T<span class="_3c blank"></span>ables in Excel <span class="_dd blank"> </span>EX 365</div><div class="t m0 x11 hf yd3 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Insert a T<span class="_0 blank"></span>otal Row <span class="_de blank"> </span>EX 366</div><div class="t m0 x4 hf yd4 ff3 fsc fc2 sc0 ls1 ws3">Sorting a T<span class="_2 blank"></span>able <span class="_df blank"> </span>EX 368</div><div class="t m0 x11 hf yd5 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Sort Ascending <span class="_77 blank"> </span>EX 369</div><div class="t m0 x11 hf yd6 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Sort Descending <span class="_5c blank"> </span>EX 370</div><div class="t m0 x11 hf yd7 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Custom Sort a T<span class="_0 blank"></span>able <span class="_2e blank"> </span>EX 370</div><div class="t m0 x4 hf yd8 ff3 fsc fc2 sc0 ls1 ws3">Querying a T<span class="_2 blank"></span>able Using AutoFilter <span class="_cd blank"> </span>EX 373</div><div class="t m0 x11 hf y1a7 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Sort a T<span class="_0 blank"></span>able Using AutoFilter <span class="_8b blank"> </span>EX 374</div><div class="t m0 x11 hf y1c7 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Query a T<span class="_0 blank"></span>able Using AutoFilter <span class="_59 blank"> </span>EX 375</div><div class="t m0 x11 hf y1c9 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Remove Filters <span class="_52 blank"> </span>EX 377</div></div><div class="pi" data-data='{"ctm":[1.000000,0.000000,0.000000,1.000000,0.000000,0.000000]}'></div></div> <div id="pfa" class="pf w0 h0" data-page-no="a"><div class="pc pca w0 h0"><img fetchpriority="low" loading="lazy" class="bi x0 y0 w0 h0" alt="" src="https://files.passeidireto.com/8a7a628b-5234-488c-b421-0cbbe050defd/bga.png"><div class="t m0 x18 h17 y9f ff2 fsc fc2 sc0 ls1 ws3">viii <span class="ff1">Contents</span> <span class="ff1 fc7">Microsoft Excel 2013 Complete</span></div><div class="t m0 x19 hf y176 ff3 fsc fc2 sc0 ls1 ws3">Using Screen Shots on a W<span class="_0 blank"></span>orksheet <span class="_e0 blank"> </span>EX 459</div><div class="t m0 x1a hf y177 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Insert a Screen Shot </div><div class="t m0 x1b hf y178 ff2 fsc fc2 sc0 ls1 ws3">on a Worksheet <span class="_b blank"> </span>EX 460</div><div class="t m0 x19 hf y179 ff3 fsc fc2 sc0 ls1 ws3">Chapter Summary <span class="_5b blank"> </span>EX 462</div><div class="t m0 x19 hf y17a ff3 fsc fc2 sc0 ls1 ws3">Apply Y<span class="_2 blank"></span>our Knowledge <span class="_a7 blank"> </span>EX 463</div><div class="t m0 x19 hf y17b ff3 fsc fc2 sc0 ls1 ws3">Extend Y<span class="_2 blank"></span>our Knowledge <span class="_5d blank"> </span>EX 465</div><div class="t m0 x19 hf y17c ff3 fsc fc2 sc0 ls1 ws3">Analyze, Correct, Impr<span class="_0 blank"></span>ove <span class="_39 blank"> </span>EX 467</div><div class="t m0 x19 hf y17d ff3 fsc fc2 sc0 ls1 ws3">In the Labs <span class="_5e blank"> </span>EX 468</div><div class="t m0 x19 hf y17e ff3 fsc fc2 sc0 ls1 ws3">Consider This: Y<span class="_2 blank"></span>our T<span class="_2 blank"></span>urn <span class="_92 blank"> </span>EX 471</div><div class="t m0 x19 hf y17f ff3 fsc fc2 sc0 ls1 ws3">Learn Online <span class="_60 blank"> </span>EX 472</div><div class="t m0 x19 hf y1ca ff3 fsc fc2 sc0 ls1">Index<span class="lsc ws3"> <span class="_e1 blank"> </span></span><span class="ws3">IND 1</span></div><div class="t m0 x19 hf y1cb ff3 fsc fc2 sc0 ls1 ws3">Quick Reference Summary <span class="_5d blank"> </span>QR 1</div><div class="t m0 x19 hf y1cc ff3 fsc fc2 sc0 ls1 ws3">Important Notes for Windows 7 Users <span class="_8b blank"> </span>W7 1</div><div class="t m0 x18 hf y1cd ff3 fsc fc2 sc0 ls1 ws3">Using the Find and Replace Commands <span class="_c0 blank"> </span>EX 441</div><div class="t m0 x1c hf y1ce ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Find Data <span class="_70 blank"> </span>EX 441</div><div class="t m0 x1c hf y1cf ff2 fsc fc2 sc0 ls1 ws3">Working with the Find and Replace Dialog Box <span class="_e2 blank"> </span>EX 442</div><div class="t m0 x1c hf y1d0 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Find and Replace <span class="_54 blank"> </span>EX 443</div><div class="t m0 x18 hf y1d1 ff3 fsc fc2 sc0 ls1 ws3">Inserting a 3-D Cone Chart <span class="_a8 blank"> </span>EX 444</div><div class="t m0 x1c hf y1d2 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Insert a Chart Using the Quick </div><div class="t m0 x1d hf y1d3 ff2 fsc fc2 sc0 ls1 ws3">Analysis T<span class="_2 blank"></span>oolbar <span class="_15 blank"> </span>EX 445</div><div class="t m0 x1c hf y1d4 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Format the Chart <span class="_54 blank"> </span>EX 446</div><div class="t m0 x1c hf y1d5 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Add a Chart Title Using </div><div class="t m0 x1d hf y1d6 ff2 fsc fc2 sc0 ls1 ws3">the WordArt T<span class="_2 blank"></span>ool <span class="_41 blank"> </span>EX 448</div><div class="t m0 x18 hf y1d7 ff3 fsc fc2 sc0 ls1 ws3">Working with SmartArt Graphics <span class="_1c blank"> </span>EX 449</div><div class="t m0 x1c hf y1d8 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Insert a SmartArt Graphic <span class="_1c blank"> </span>EX 451</div><div class="t m0 x1c hf y1d9 ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Color and Resize the </div><div class="t m0 x1d hf y1da ff2 fsc fc2 sc0 ls1 ws3">SmartArt Graphic <span class="_e3 blank"> </span>EX 452</div><div class="t m0 x1c hf y1db ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Add Shapes to a SmartArt Graphic <span class="_28 blank"> </span>EX 453</div><div class="t m0 x1c hf y1dc ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Add T<span class="_0 blank"></span>ext to a SmartArt Graphic <span class="_c0 blank"> </span>EX 453</div><div class="t m0 x1c hf y1dd ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Add Pictures to a SmartArt Graphic <span class="_e4 blank"> </span>EX 454</div><div class="t m0 x1c hf y1de ff2 fsc fc2 sc0 ls1 ws3">T<span class="_2 blank"></span>o Add a Style to a SmartArt Graphic <span class="_e5 blank"> </span>EX 457</div></div><div class="pi" data-data='{"ctm":[1.000000,0.000000,0.000000,1.000000,0.000000,0.000000]}'></div></div>
Compartilhar