Excel 2007 for Dummies P1

Excel documents are known as workbooks. A single workbook can store as manysheets as will fit into memory, and these sheets are stacked like the pages in anotebook. Sheets can be either worksheets (a normal spreadsheet-type sheet withrows and columns) or chart sheets (a special sheet that holds a single chart).
Nội dung trích xuất từ tài liệu:
Excel 2007 for Dummies P1 ® Excel 2007 FOR DUMmIES ‰ QUICK REFERENCEby John Walkenbach and Colin Banfield ® Excel 2007 FOR DUMmIES ‰ QUICK REFERENCEby John Walkenbach and Colin BanfieldExcel® 2007 For Dummies® Quick ReferencePublished byWiley Publishing, Inc.111 River StreetHoboken, NJ 07030-5774www.wiley.comCopyright © 2007 by Wiley Publishing, Inc., Indianapolis, IndianaPublished by Wiley Publishing, Inc., Indianapolis, IndianaPublished simultaneously in CanadaNo 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 ofthe 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization throughpayment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978)750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Legal Department, WileyPublishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, (317) 572-3447, fax (317) 572-4355, or online at http://www.wiley.com/go/permissions.Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, TheDummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, and related trade dress are trademarks or registeredtrademarks of John Wiley & Sons, Inc. and/or its affiliates in the United States and other countries, and may not be usedwithout written permission. Excel is a registered trademark of Microsoft Corporation in the United States and/or othercountries. All other trademarks are the property of their respective owners. Wiley Publishing, Inc., is not associated withany product or vendor mentioned in this book.LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: THE PUBLISHER AND THE AUTHOR MAKE NO REPRESENTATIONSOR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS WORK ANDSPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITHOUT LIMITATION WARRANTIES OF FITNESS FOR APARTICULAR PURPOSE. NO WARRANTY MAY BE CREATED OR EXTENDED BY SALES OR PROMOTIONAL MATERIALS.THE ADVICE AND STRATEGIES CONTAINED HEREIN MAY NOT BE SUITABLE FOR EVERY SITUATION. THIS WORK ISSOLD WITH THE UNDERSTANDING THAT THE PUBLISHER IS NOT ENGAGED IN RENDERING LEGAL, ACCOUNTING,OR OTHER PROFESSIONAL SERVICES. IF PROFESSIONAL ASSISTANCE IS REQUIRED, THE SERVICES OF A COMPE-TENT PROFESSIONAL PERSON SHOULD BE SOUGHT. NEITHER THE PUBLISHER NOR THE AUTHOR SHALL BE LIABLEFOR DAMAGES ARISING HEREFROM. THE FACT THAT AN ORGANIZATION OR WEBSITE IS REFERRED TO IN THISWORK AS A CITATION AND/OR A POTENTIAL SOURCE OF FURTHER INFORMATION DOES NOT MEAN THAT THEAUTHOR OR THE PUBLISHER ENDORSES THE INFORMATION THE ORGANIZATION OR WEBSITE MAY PROVIDE ORRECOMMENDATIONS IT MAY MAKE. FURTHER, READERS SHOULD BE AWARE THAT INTERNET WEBSITES LISTED INTHIS WORK MAY HAVE CHANGED OR DISAPPEARED BETWEEN WHEN THIS WORK WAS WRITTEN AND WHEN IT ISREAD.For general information on our other products and services, please contact our Customer Care Department within the U.S.at 800-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002.For technical support, please visit www.wiley.com/techsupport.Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available inelectronic books.Library of Congress Control Number: 2006934839ISBN-13: 978-0-470-04671-5ISBN-10: 0-470-04671-6Manufactured in the United States of America10 9 8 7 6 5 4 3 2 11O/RT/RS/QW/INAbout the Authors John Walkenbach is a leading authority on spreadsheet software and is principal of JWalk and Associates Inc., a small San Diego–based consulting firm that specializes in spreadsheet application development. He is the author of approximately three dozen spreadsheet books and has written hundreds of articles and reviews for a variety of publications, including PC World, InfoWorld, Windows magazine, and PC/Computing. John graduated from the University of Missouri and earned a master’s and a PhD from the University of Montana. Visit his Web site at www.j-walk.com. Colin Banfield has been working in the telecommunications field for more than twenty-five years and has been using spreadsheet programs for more than two decades. Colin’s largest Excel project to date is a comprehensive tool that is designed for telephone central office equipment configuration, pricing, and manufac- turing and used by sales, engineering, and manufacturing personnel. In between his telecom consulting duties, ...