MS Excel 2.2 Quick Ref

Microsoft. Excel Microsoft. Excel Quick Reference Guide Complete Spreadsheet with Business Graphics and Database Version 2.2 for Apples Macintoshe Microsoft Corporation Information in this document is subject to change without notice and does not represent a commitment on the part of Microsoft Corporation. The software described in this document is furnished under a license agreement or nondisclosure agreement. The software may be used or copied only in accordance with the terms of the agreement. It is against the law to copy the software on any medium except as specifically allowed in the license or nondisclosure agree- ment. No part of this manual may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording, for any purpose without the express written permission of Microsoft. © Copyright Microsoft Corporation, 1989. All rights reserved. Simultaneously published in the U.S. and Canada. Printed in the United States of America. Microsoft and the Microsoft logo are registered trademarks of Microsoft ‘Corporation. Apple and Macintosh are registered trademarks of Apple Computer, Inc. Document No. ABO205-220-ROO-0289 Contents Microsoft Excel Quick Reference Guide 1 Version 1.5 to 2.2 1 Changed Commands 1 Starting and Quitting 2 To Start Microsoft Excel and Open a Document 2 To Open Microsoft Excel 1.5 Files 3 To Quit Microsoft Excel 3 Selecting Cells 3 Entering and Formatting Information 4 To Enter Text 4 To Enter Numbers 4 To Format Numbers 5 Building a Formula 5 Using Operators 6 Arithmetic Operators 6 Text Operator 6 Comparison Operators 6 Reference Operators 6 Editing Your Worksheet 7 To Copy Cells 7 To Move Cells 7 To Paste Worksheet Functions 7 To Use Notes 8 To Get Detailed Information ona Cell 8 Creating Names, Series, and Tables 9 To Createa Name 9 To Create a Series 10 To Create a Table 10 Entering an Array 11 To Enter an Array Formula 11 Recording a Macro 12 Creating a Database 13 To Enter Database Information 13 To Define the Database Range 13 To Enter Criteria 13 Combining Criteria 14 To Set the Criteria Range 15 To Find, Delete, or Extract Matching Records 15 To Use the Data Form 16 iv Contents Creating a Chart 17 To Create a Chart 17 To Format a Chart 18 Linking Documents 18 Saving Documents 19 To Save a Workspace 19 To Save a Document for Microsoft Excel 1.5 20 Printing Documents 20 To Preview a Worksheet Before Printing 20 To Print a Document 20 Using the Keyboard 21 To Choose Commands 21 | …