`
`Attachment 1b
`
`CiM Ex. 1062 Page 1
`
`CiM Ex. 1062 Page 1
`
`
`
`Attachment 1b
`
`Northern Illinois Uni\ ersity
`
`University Libraries
`
`nil BIacmc-ard Calendar Duran-5w MyNIIJ Nlulway
`Search NIU
`ail
`Advanced Search
`
`Quit Help
`New in the Catalog
`New Search I-Share Catalog Titles Renew Bookslfly Account Request History
`
`
`
`TH our new catalog interface now!
`Your session will expire in 09:20
`
`
`
`Now Searching: NTU
`You Searched: Title = maintenance planning and scheduling
`Search Results: Displaying 4 of5 entries.
`
`* previous
`
`next —p
`
`Full View
`
`Brief View
`
`I More Like This
`
`I Staff (MARC) View
`
`Click for more information on this title.
`Author: Palmer. Doc.
`Title: Maintenance planning and scheduling handbook :' Doc Palmer.
`Series: McG-raw-Hdl handbooks
`Published: NewYork : McG-raew—l-lill= 1999.
`Physical Description: 1 1:. (various pagings) : ill. ; 24 cm.
`Includes: Includes bibliogaphical references and index.
`Subject (LCSH): Plant maintenance.
`Production management.
`Production scheduling.
`ISBN: 0070448264
`Persistent link to this page: hflpszr'fiisharecarliiillinoisedu.proxy2.hhrary.illinois.em'nnh'cgiibinfpnebrecon.cgi?D3:10(:al&vl:l&BBR.ech:12 l 8 143
`
`11:sz NTU
`Location: shelved At NTUfiMain CollectionfiFounda's Lflirary
`CaHNumber: TS 1 92 .P355 1999 4» ETfit me this all umber
`Copy: 1
`5mm: c.l lnlransit to fill. a request, 0118-] 1" (Requests: 1) Find CQQICE in other I-Share libraries.
`
`next —»
`* previous
`
`
`Print or Email
`Select Download Format Full Reoord
`V
`Pn'nthave
`
`Enter your email address:
`I Email ‘
`
`
`
`
`
`
`
`Quit Help
`NEW in the Catalog
`New Search Iishare Catalog Titles Renew Bookslfly Account Request History
`
`
`
`
`CARL]
`
`l-Share includes the resources of 36 lllinois libraries belonging to CARLI, the Consortium ofAcadermc 8:. Research Libraries in Illinois.
`
`& I Share NeedhelpsearchingI—Share?SeetheHelppagesorcontactyouramforassistance.
`
`www‘carli.” linois.edufmem bershiptmem-Iibsfishare-map
`
`Y
`
`‘ " "‘
`
`'e Libraries | Map of Iishare Libraries l Search the catalog ofa particular Iishare hm
`
`CiM Ex. 1062 Page 2
`
`Attachment 1b
`
`CiM Ex. 1062 Page 2
`
`
`
`Attachment 1c
`
`Attachment 1c
`
`CiM Ex. 1062 Page 3
`
`CiM Ex. 1062 Page 3
`
`
`
`Attachment lc
`
`Statewide Illinois
`
`WorldCat Detailed Record
`- Click on a d'ledcbox In marka record to be mailed or primed in Marked Records.
`
`[lune
`
`Wm
`
`Saudim
`
`Results
`
`
`
`
`
`
`Maintenance planning and scheduling handbook I
`Doc PallI'EI
`1999
`English . Book 1 volume [various pagings) : iltislialiorls ; 24 cm.
`NewYodr: McGraew-HiL; ISBN: 0070482640 9700070482647
`
`Ioc um: I
`
`'2
`UNIV OF ILLINOIS
`| AskALIbIarian
`
`SlaffView | fizAccouni:
`
`i Oflons | Comments | m i Hideogs
`
`
`
`
`
`
`
`GEr Tins II'EM
`auriflrflity: Check me catalogs in yourlirrary.
`. Libraries worldwidefl'iat own item: 121
`- @ Seard'i 111a caiakiu at line lJbra'ir of Universitv of fllinois at Urbana—Cl'iampaiqn
`External Barium -
`Dismver UIUC Ful Text
`.
`Iritedibiaq Loan RegueSt
`- Cite Thi5 119m
`Fnro REIATEII
`Flue Lire 11E: Seam: for versions with same tiile and author | Advanced options ..
`True—_ and—_ I
`Aulhods): Paimer Doc.
`I’LIJlicz-Ifim: NewYork: MdSraew—Hil,
`Yea: 1999
`De-acrim'm: 1vdu’ne tvarious oag'ngs] : illelralions ; 24 cm.
`ng-age; English
`Eerie: MCGrawHil hammocks;
`overview— The ownpu erln
`— Considalalim ulnrevmlive
`. predclive
`and prq'eci work— Conlrol— Conclusion: slarl
`(Intent: Inimominn —_ [one too wine: omer looks are needed? —mares — fling — What makes me Iiiferenoe and pole it al to
`Slalliard N0: ISBN: 0070482640. 9700070482647
`SIIDECTIS)
`Baum M—Production maria erneni.
`Usmefi 7 Enlretien.
`Production *.
`Production — Geslion.
`F'lianl
`.
`Production maria erneni.
`Ordonnanoerneni IGestIon}
`Production *.
`Note(s): lnchdes bibiograpliical references and index.
`Elms mom: LC: T8192; Dewey: 658.202
`muonsilflity: Doc Parner.
`Vendor Info: Biker & Taylor YEP Lbrary Services (BKTY YANK) 79.95 Stains: aclive
`Dominant Type Book
`EulIy: 19990622
`Mate; 20170522
`Mansion No: OCLC: 41505981
`
`
`— Epikrgue; An aliernalive day 'nihe Ife— Mary 10. 2000.
`er — Basic- — Basil:_ — Forms and resouoes
`
`Wrmils for: CE: rrfiilturaum arll ti: planning) and (ti: sinking and ti: W) arllyr. 1999. Remrd 1 of“.
`
`
`
`
`
`
`
`ameemmm:
`OCLC Main-E
`
`English | Esgar’iol
`
`Frangai-s |
`
`.53};
`
`H41Kfi
`
`| EH .1
`
`14435.5 {333.
`
`|
`
`qJ_‘.'r_._ I?
`
`getion-s i Comments.
`
`| Brit
`
`CiM Ex. 1062 Page 4
`
`Attachment 1c
`
`CiM Ex. 1062 Page 4
`
`
`
`Attachment 1d
`
`Attachment 1d
`
`CiM Ex. 1062 Page 5
`
`CiM Ex. 1062 Page 5
`
`
`
`Attachment 1d
`
`ail
`
`Northern Illinois Uni\ ersity
`
`University Libraries
`
`Eli—113M303“! Calendar Duran-5w MyNIIJ Nlulway
`Search NIU
`Hill
`Advanced Search
`
`Quit Help
`New in the Catalog
`I-Share Catalog Titles Renew Bookslfly Account Request History
`
`
`
`Now Searching: NTU
`You Searched: Title = maintenance planning and scheduling
`Seanzh Results: Displaying 4 of5 entries.
`
`* previous
`
`next ‘-
`
`TH our new catalog interface now!
`Your session will expire in 09:11
`
`
`
`Full View
`
`Brief View
`
`I More Like This
`
`Staff (MARC) View
`
`l
`000 00749nam a22002531a 450
`00] 1218148
`005 2.002041516112010
`008 99062251999 nyub 0010 eng (1
`035 i la (OCoLC)ocm41585981
`035 i I9 DUX—8726
`040 _ Ia UMC IcUMC Id WA
`020 _ Ia 0070448264
`090 _ Ia T3192 lb P3551999
`049 _ |a JNAA
`100 17 la Palmer, Doc.
`245 10 la Maintenance planning and scheduling handbook I II: Doc Palmer.
`260 _ I: New York : lb McGIaew—Hill, It. 1999.
`300_|a 1 Y. (variouspag'ngs) : IbilL; II: 24 cm.
`440 _O |a MCG'I‘EW'eI‘Illl handbooks
`504 i la Includes bibliographical references and index.
`650 _0 la Plant maintenance.
`650 _0 In Production management.
`650 _0 la Production schedming.
`994 _ |a 0] |b INA
`Persistent link to this page: hflpsnfi—shate—catli—illinois—edu.prnxyllihraryillinois.eihn’niu’cgi—binz‘Pwebr‘econ.cgi?DB=loaJ&v4=l&BBRec]D= 12 l 8 14-8
`
`next ‘-
`afi previous
`
`
`Print or Email
`1' H PI'intISave I
`Select Download Formatl Full Renard
`
`Enter your email address:
`I Email ‘
`
`
`
`
`
`
`
`
`
`
`
`Quit Help
`New in the Catalog
`New Search I-Share Catalog Titles Renew Booksffly Account Request History
`
`
`
`
`
`I—Shareincludestheresourcesof86mitmislibrariesbelongingtoCARLI=theConsortiumofAcademic8:ResearchLibrariesinIllinois.
`CARL]
`Share Need help searching LShare? See the Help pages or contact xour Hm for assistance.
`7 '
`‘ " N 'e Libraries | Mia]: of I-Share Libraries ‘ Search the catalog ofa particular I—Share library
`www‘carli.” linui5.edw'n1em bershipfmem-libsfishare-map
`
`E E
`
`CiM Ex. 1062 Page 6
`
`Attachment 1d
`
`CiM Ex. 1062 Page 6
`
`
`
`Attachment 2a
`
`Attachment Za
`
`CiM Ex. 1062 Page 7
`
`CiM Ex. 1062 Page 7
`
`
`
`Attachment 2a
`
`W “Hill" l|||||ll| |l|||||||l||l|||
`
`
`
`WTS Number: 166869
`
`A R'l‘ l C L E D L l.
`
`I V lfi 10"
`
`Request Date: 07940201? 01:13pm
`
`Order #133433
`
`Standa rd
`
`Requester:
`
`Helen Sullivan — Prior Art Documentation Services LLC
`
`Estimated Delivery:
`
`Phone:
`Reference:
`
`21744653?0
`17?01
`
`Delivery email: helen@priorartdocs.com
`ISBN 0764532596
`
`07/26/2017 01:13pm
`
`Maxcost:
`
`We need the following pages scanned from the
`print:
`Front and back covers, table of contents, page
`indicating copyright date and publisher, 49,
`154-155, 253-57, 263-282, 399-401, 481-88, 511-30,
`540-43, 556, 631-33, 747-754.
`
`Instructions:
`
`Citation:
`
`John Walkenbach. 2000. Microsoft Excel 2000 Bible. John Wiley & Sons, Inc., New York. NY. USA.
`ISBN 0764532596
`
`We need the following pages scanned from the print:
`Front and back covers, table of contents, page indicating copyright date and publisher. 49. 154-155.
`253—57, 263-282, 399-401, 481—88, 511—30, 540-43, 556, 631-33, 741364:
`
`lam aware you will have to get this from off campus but would like to obtain as quickly as possible.
`Thanks!
`
`LibraryISupplier:
`
`(lei/(1.
`
`lo a it ill}? (1m)
`
`ISSNIISBNIDCLC:
`
`Base Service Fee: 515
`
`Rush fee: 50.00
`
`Copyright: WTS will pay copyright royalties and bill mes
`
`pages;
`
`Supplier: WTS staff may obtain materials from outside UW — Madison: 5
`
`Shipping: 5
`
`Research: 3
`An outreach service of the Wendt Commons Library, University of Wisconsin — Madison
`http:f_iwts.wlsc.edu l wts@engr.wi5c.edu t 608.262.5917
`
`11A
`
`CiM Ex. 1062 Page 8
`
`Attachment 2a
`
`CiM Ex. 1062 Page 8
`
`
`
`Attachment 2a
`
`Microsoft®
`
`Excel 2000 Bible
`
`John Walkenbach
`
`lllli
`TEE
`ma
`
`IDG Books Worldwide, Inc.
`An International Data Group Company
`
`Foster City. CA + Chicago, IL + Indianapolis, IN + New York, NY
`
`CiM Ex. 1062 Page 9
`
`Attachment 2a
`
`CiM Ex. 1062 Page 9
`
`
`
`Attachment 2a
`
`Micmsofi' Excel 2000 Bible
`
`Published by
`IDG Books Worldwide. Inc.
`An International Data Group Company
`919 E. Hillsdale Blvd. Suite 400
`Foster City. CA 94404
`NW. 1' dgboo k s . corn {IDG Books Worldwide Web site)
`Copyright is) 1999 IDG Books Worldwide. Inc. All
`rights reserved. No part of this book. including
`interior design. cover design, and icons, may be
`reproduced or transmitted in any form. by any means
`(electronic. photocopying, recording. or otherwise)
`without the prior written permission of the publisher.
`Library of Congress Catalog Card Number: 93-75379
`ISBN: 0-7645-3259-6
`Printed in the United States oi America
`10 1-} B 27 i5 5 4 3
`
`IBISUKQTIZZIFC
`Distributed in the United States by lDG Books
`Worldwide. Inc.
`Distributed by CD6 Books Canada inc. ior Canada; by
`Transworid Publishers Limited in the United
`Kingdom; by [DC Norge Books for Norway: by IDG
`Sweden Books for Sweden: by Woodslane Pty. Ltd. for
`Australia; by Woodsiane ( NZ) Ltd. for New Zealand:
`by TransQuest Publishers Pte Ltd. for Singapore.
`Malaysia. Thailand, Indonesia. and Hong Kong; by
`iCG Muse. inc. for Japan: by Norma Comunicaciones
`SA [or Colombia; by [ntersofl for South Africa; by Le
`Monde en Tique for France; by International
`Thomson Publishing for Germany. Austria and
`Switzerland; by Distribuidora Cus pide for Argentina;
`by Livraria Cultura for Brazil; by Ediciones ZETA
`SCR. Lida. for Peru; by WS Computer Publishing
`Corporation. [nc., for the Philippines; by
`Conteniporanea de Ediciorles ior Venezuela; by
`Express Computer Distributors for the Caribbean and
`West indies; by Micronesia Media Distributor. inc. tor
`
`Micronesia; by Grupo Editorial Norma SA. for
`Guatemala: by Chips Computadoras SA. de CV. for
`Mexico; by Editorial Norma de Panama SA for
`Panama; by American Bookshops for Finland.
`Authorized Sales Agent: Anthony Rudkin Associates
`for the Middle East and North Africa.
`
`For general information on "30 Books Worldwide's
`books in the 1.1.5.. please call our Consumer Customer
`Service department at 800-762-2974. For reseller
`Information. including discounts and premium sales.
`please call our Reseller Customer Service
`department at 300434—3422.
`For information on where to purchase IDG Books
`Worldwide‘s books outside the U.S.. please contact
`our International Sales department at 311595-5530 or
`iax 31?—596—5692.
`
`For consumer information on foreign language
`translations, please contact our Customer Service
`department at 800-434—3422. [ax 317-595-5592, or
`e-mail rights®idgbookscom
`For information on licensing foreign or domestic
`rights. please phone +1-65fl655-3109.
`For sales inquiries and special prices for bulk
`quantities, please contact our Sales department at
`650-655-3200 or write to the address above.
`For information on using lDG Books Worldwide‘s
`books in the classroom or for ordering examination
`copies, please contact our Educational Sales
`department at 300434-2085 or fax 317-596-5499.
`For press review copies. author interviews. or other
`publicity information, please contact our Public
`Relations department at 650-655-3000 or fax
`650-655-3299.
`
`For authorization to photocopy items for corporate,
`personal. or educational use, please contact
`Copyright Clearance Center. 222 Rosewood Drive.
`Danvers. MA 01923, or fax QYSTSMAYG.
`
`LIMIT OF LIAEILITYIIIISQ! AIMER !!F WARM! X: THE PUBLISHER AND AUTHOR HAVE USED THEIR
`BEST EFFORTS IN PREPARING THIS BOOK. THE PUBLISHER AND AUTHOR MAKE NO
`REPRESENTATIONS OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE
`CONTENTS OF THIS BOOK AND SPECIFICALLY DISCLAIM ANY IMPLIED WARRANTIES OF
`MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. THERE ARE NO WARRANTIES WHICH
`EXTEND BEYOND THE DESCRIPTIONS CONTAINED IN THIS PARAGRAPH. NO WARRANTY MAY BE
`CREATED OR EXTENDED BY SALES REPRESENTATIVES OR WRITTEN SALES MATERIALS. THE
`ACCURACY AND COMPLETENESS OF THE INFORMATION PROVIDED HEREIN AND THE OPINIONS
`STATED HEREIN ARE NOT GUARANTEED OR WARRANTED TO PRODUCE ANY PARTICULAR RESULTS.
`AND THE ADVICE AND STRATEGIES CONTAINED HEREIN MAY NOT BE SUITABLE FOR EVERY
`INDIVIDUAL. NEITHER THE PUBLISHER NOR AUTHOR SHALL BE LIABLE FOR ANY LOSS OF PROFIT OR
`ANY OTHER COMMERCIAL DAMAGES, INCLUDING BUT NOT LIMITED TO SPEClAL, INCIDENTAL,
`CONSEQUENTIAL. OR OTHER DAMAGES. FUIHILMENT' OF EACH COUPON OFFER is THE
`
` RESPONSIBILITY OF THE OFFEROR.
`
`
`Trademarks: All brand names and product names used in this book are trade names. service marks.
`trademarks. or registered trademarks oi their respective owners. lDG Books Worldwide is not associated with
`any product or vendor mentioned in this book.
`w
`
`it
`=65
`IDG
`BOOKS
`WOILDW'IIIE
`
`is registered trademark or trademark under exclusive license
`to IDG Books Worldwide. Inc.. from international Data Group. Inc.
`in the United States andfor other countries
`
`CiM Ex. 1062 Page 10
`
`Attachment 2a
`
`CiM Ex. 1062 Page 10
`
`
`
`Attachment 221
`
`Contents at a Glance
`
`tenofiaeuoeeauoooonoe—ooecgoo-ovoaeoeoennnoreoanoogu
`
`Preface ................................................................................................................................ ix
`
`Acknowledgments .......................................................................................................... xiii
`
`Part l: Getting Started1
`Chapter 1: A Bit of Background ........................................................................................ 3
`Chapter 2: What‘s New in Excel 2000? .......................................................................... 15
`Chapter 3: Getting Acquainted with Excel .................................................................... 21
`
`Part II: Introductory Concepts4]
`Chapter 4: Navigating Through Excel ............................................................................ 43
`Chapter 5: Working with Files and Workbooks ............................................................ 71
`Chapter 6: Entering and Editing Worksheet Data ........................................................ 93
`Chapter 7: Essential Spreadsheet Operations ............................................................ 121
`Chapter 8: Working with Cell Ranges .......................................................................... 139
`Chapter 9: Creating and Using Formulas .................................................................... 169I
`Chapter 10: Using Worksheet Functions .................................................................... 199
`Chapter 11: Worksheet Formatting ............................................................................... 235
`Chapter 12: Printing Your Work .................................................................................. 263
`Chapter 13: Chart-Making Basics ................................................................................ 283
`Chapter 14: Enhancing Your Work with Pictures and Drawings .............................. 317
`Chapter 15: Putting It All Together .............................................................................. 343
`
`Part III: Advanced Features
`
`...
`
`... .361
`
`...363
`Chapter 16: Advanced Charting.
`Chapter 1?: Creating Maps with Microsoft Map........................................................ 405
`Chapter 18: Creating and Using Worksheet Outlines ................................................ 429
`Chapter 19: Linking and Consolidating Worksheets .................................................. 441
`Chapter 20: Creating and Using Array Formulas
`...................................................... 457
`Chapter 21: Using Excel in a Workgroup .................................................................... 479
`
`Part IV: Analyzing Data489
`Chapter 22: Importing Data from Other Sources ...................................................... 491
`Chapter 23: Working With Lists .................................................................................... 511
`Chapter 24: Using External Database Files ................................................................ 539
`Chapter 25: Analyzing Data with Pivot Tables
`.......................................................... 559
`Chapter 26: Performing Spreadsheet What—If Analysis ............................................ 595
`Chapter 2?: Analyzing Data Using Goal Seeking and Solver .................................... 61?
`Chapter 28: Analyzing Data with Analysis ToolPak .................................................. 639
`
`CiM Ex. 1062 Page 11
`
`Attachment 2a
`
`CiM Ex. 1062 Page 11
`
`
`
`Attachment 2a
`
`XVIII
`
`Contents at a Glance
`
`Part it: Other Topics663
`Chapter 29: Sharing Data with Other Applications .................................................. 665
`Chapter 30: Excel and the Internet .............................................................................. 685
`Chapter 31: Making Your Worksheets Error-Free ...................................................... 699
`Chapter 32: Fun Stull715
`
`Part VI: Customizing Excel729
`Chapter 33: Customizing Toolbars and Menus .......................................................... 731
`Chapter 34: Using and Creating Templates ................................................................ 74?
`Chapter 35: Using Visual Basic for Applications
`...................................................... 755
`Chapter 36. Creating Custom Worksheet Functions
`................................................ 785
`Chapter 37: Creating Custom Dialog Boxes. 801
`Chapter 38: Using Dialog Box Controlsin Your Worksheet ...................................... 823
`Chapter 39: VBA Programming Examples .................................................................. 839
`Chapter 40: Creating Custom Excel Add-Ins .............................................................. 857
`
`Appendix A: Using Online Help: A Primer .................................................................. 871
`Appendix B: Worksheet Function Reference881
`Appendix C: Excel's Shortcut Keys89?
`Appendix D: What‘s on the CD—ROM905
`Index
`... 915
`End-User LicenseAgreement 937
`CD—ROM Installation instructions................................................................................944
`
`CiM Ex. 1062 Page 12
`
`Attachment 2a
`
`CiM Ex. 1062 Page 12
`
`
`
`Attachment 2a
`
`I'DOOIDOUOOIU.....ICOIIQOIQDUIIICICIIIIIOOICOOODB
`
`Contents
`
`Preface1):
`
`Acknowledgmentsxm
`
` Part 1: Getting Started
`
`Chapter 1: A Bit of Background3
`What Is Excel? ...........................................................................................................
`The Evolution of Excel
`Exce12
`Excel3
`Excel4
`Excelfi
`Excel? ..............................................................................................................
`ExcelS
`ExcelQH
`Excel’5 Competitors
`What Excel Has to Offer."
`Multisheet Files
`
`mmmwmmmuqqqmmmmmmaeeeeew
`
`Multiple Document Interface
`File Compatibility"
`Interactive Help
`Easy—to-Use Features
`List Management
`Built-in Functions
`Customizable Toolbars
`
`Flexible Text Handling
`Rich Text Formatting
`Great Charts
`
`IntegratedMapping
`DrawingToois
`Worksheet Outlining10
`Pivot Tables. 10
`Advanced Analytical Tools 10
`Flexible Printing and Print Preview"10
`Worksheet Auditing and Annotation .......................................................... 10
`Scenario Management.
`... 11
`Spell Checking and AutoCorrectm 11
`Templates. 11
`Database Management 11
`XLM Macro Compatibility”:11
`
`CiM EX. 1062 Page 13
`
`Attachment 2a
`
`CiM Ex. 1062 Page 13
`
`
`
`Attachment 2a
`
`XX
`
`Contents
`
`Visual Basic for Applications (VBA) ......................................................... 12
`Custom Dialog Boxes .................................................................................. 12
`Worksheet Controls ..................................................................................... 12
`Protection Options ....................................................................................... 13
`Add-In Capability .......................................................................................... 13
`OLE Support ................................................................................................. 13
`Internet Support ........................................................................................... 14
`Cross-Platform Consistency ........................................................................ 14
`
`........... 15
`...........................
`Chapter 2: What's New in Excel 2000?
`Installation Improvements .................................................................................... 15
`New Internet Features .......................................................................................... 16
`New File Dialog Boxes .......................................................................................... 16
`PivotTable Enhancements .................................................................................. 17
`Automatic Formula Adjustment ........................................................................... 1?
`See-Through Cell Selection .................................................................................. 17
`Personalized Menus ............................................................................................... 1?
`Easier Toolbar Customization .............................................................................. 18
`Documents on the Windows Taskbar .................................................................. 18
`Enhanced Clipboard ........................................................................................... 18
`Euro Currency Symbol
`.......................................................................................... 19
`New Image Import Options ................................................................................... 19
`A New Help System ............................................................................................... 19
`Office Assistant
`...................................................................................................... 19
`Multilingual Features ............................................................................................. 20
`ModeLess UserForms ............................................................................................ 20
`
`..............................21
`Chapter 3: Getting Acquainted with Excel
`Starting Excel ......................................................................................................... 21
`Excel‘s Parts ............................................................................................................ 21
`Title Bar ......................................................................................................... 22
`Window Control Menu Button .................................................................... 23
`Minimize Button ........................................................................................... 23
`Restore Button .............................................................................................. 23
`Close Button ................................................................................................. 23
`Menu Bar ...................................................................................................... 23
`Toolbars ....................................................................................................... 23
`Formula Bar ................................................................................................... 23
`Name Box ...................................................................................................... 24
`Status Bar ..................................................................................................... 24
`Parts of a Workbook Window ............................................................................... 24
`Title Bar ......................................................................................................... 24
`Window Control Menu Button .................................................................... 24
`Minimize Button ........................................................................................... 24
`Maximize Button ........................................................................................... 25
`Close Button .................................................................................................. 25
`Select All Button ........................................................................................... 26
`Active Cell Indicator .................................................................................... 26
`Row Headings ............................................................................................... 26
`CiM Ex. 1062 Page 14
`
`Attachment 2a
`
`CiM Ex. 1062 Page 14
`
`
`
`Attachment 221
`
`Contents
`
`xxi
`
`Column Headings ......................................................................................... 26
`Tab Scroll Buttons26
`Sheet Tabs ..................................................................................................... 26
`Tab Split Bar .................................................................................................. 26
`Horizontal Scrollbar26
`Vertical Scrollbar2?
`A Hands—on Excel Session27
`
`Getting Ready27
`Entering the Headings28
`Entering the Data .......................................................................................... 30
`Creating a Formula ....................................................................................... 3i
`Formatting the Table .................................................................................... 31
`Adding aTitle ................................................................................................ 34
`Creating a Chart35
`Saving the Workbook ................................................................................... 37
`Printing the Report38
`Quitting Excel38
`
`Part II: Introductory Concepts
`
`4]
`
`Chapter 4: Navigating Through Excel43
`
`Working with Excel's Windows43
`Moving and Resizing Windows44
`Switching Among Windows45
`Closing Windows. 47
`Mouseless Window Manlpulation .............................................................. 47
`Moving Around a Worksheet ................................................................................ 48
`Using the Keyboard...49
`Using a Mou5e. 50
`Giving Commands to Excel. 51
`Using Excel5 Menus51
`UsingaMouse... 52
`Using the Keyboard 55
`Moving the Menu" 56
`Using Shortcut Menus5?
`Excels Toolbars 58
`Hiding or Showing Toolbars 61
`Moving Toolbars" 62
`Learning More About Toolbars ...................................................................63
`Shortcut Keys" 64
`Working with Dialog Boxes". 64
`About Dialog Boxes ...................................................................................... 64
`Dialog Box Controls ..................................................................................... 65
`Tabbed Dialog Boxes63
`
`Chapter 5: Working with Files and Workbooks71
`
`Some Background on Files71
`How Excel Uses Flies CIMEXRMZ Page 15
`
`Attachment 2a
`
`CiM Ex. 1062 Page 15
`
`
`
`Attachment 2a
`
`XXi i
`
`Contents
`
`Excel‘s Data Files ........................................................................................ 72
`Foreign File Formats Supported ................................................................. 73
`Essential Workbook File Operations .................................................................. 74
`Creating a New Workbook ........................................................................... 74
`Opening an Existing Workbook ................................................................. 75
`Opening Workbooks Automatically ...........................................................80
`Saving Workbooks ........................................................................................80
`Closing Workbooks ......................................................................................87
`Using Workspace Files ................................................................................ 88
`Sharing Workbooks with Others ................................................................88
`Using Template Files .............................................................................................88
`Protecting Your Work ............................................................................................90
`
`Chapter 6: Entering and Editing Worksheet Data93
`Types of Worksheet Data ......................................................................................93
`Values ............................................................................................................. 93
`Text ................................................................................................................. 94
`Formulas ........................................................................................................ 95
`Entering Values ....................................................................................................... 96
`Entering Text
`.........................................................................................................96
`Dates and Times ..................................................................................................... 97
`Working with Date Values ............................................................................9?
`Working with Time Values ...........................................................................98
`Changing or Erasing Values and Text
`..................................................................99
`Erasing the Contents of a Cell ..................................................................... 99
`Replacing the Contents of a Cell
`................................................................99
`Editing the Contents of a Cell
`.....................................................................99
`Formatting Values ................................................................................................ 102
`Automatic Number Formatting ................................................................. 103
`Formatting Numbers Using the Toolbar .................................................. 103
`Formatting Numbers by Using Shortcut Keys .................................................. 104
`Other Number Formats ............................................................................. 104
`Custom Number Formats .......................................................................... 108
`Basic Cell Formatting ........................................................................................... 112
`Alignment
`.................................................................................................... 112
`Font and Text Size ...................................................................................... 113
`Attributes .................................................................................................... 113
`Borders ........................................................................................................ 113
`Colors ........................................................................................................... 114
`Data Entry Tips ..................................................................................................... 114
`Validating Data Entry ................................................................................. 114
`Move the Cell Pointer After Entering Data? ............................................ 115
`Use Arrows Instead of Enter ..................................................................... 116
`Selecting Cells Before Entering Data ....................................................... 116
`Use Ctrl+Enter for Repeated Information ................................................ 116
`Automatic Decimal Points ......................................................................... 116
`Using AutoFill .............................................................................................. 117
`Using AutoComplete .................................................................................. 117
`Entering the Current Date or Time into a Cell ........................................ 117
`CiM Ex. 1062 Page 16
`
`Attachment 2a
`
`CiM Ex. 1062 Page 16
`
`
`
`Attachment 2a
`
`Contents
`
`XXIII
`
`...................................................................... 118
`Forcing a New Line in a Cell
`Entering Fractions ...................................................................................... 118
`Using a Data Ent