Microsoft Lesson | 1993-12-14 | 164KB | 1,791 lines
Out of Memory
File Missing
Unrecognized Error
Microsoft CBT
XLDESK
XLMAIN
EXCEL6
EXCEL9
EXCEL>
xlcbt
LaunchApp
xlcbt
GDIUsage
xlcbt
ReturnToHelp
( 7 F U c q
1. Select the cell you want to annotate.3. In the Text Note box, type new text2. From the Insert menu, choose Note.4. When you finish your note, chooseor edit existing text. The text youTo continue, click the Next buttonkeys to extend the selection tomenu, click the Close button ortype automatically wraps to thea cell in the formula bar or inthe SHIFT key and use the arrownext line. To insert a line orTo return to the Quick Previewto return to the first sheet.the toolbar to total the WestYou can edit the contents ofClick the Edit menu and thenNow, use the Currency Stylearound the cells that havePosition the mouse pointerClick the Decrease Decimalbutton to display the newcell from 23400 to 25400.Now click the Western tabUse the AutoSum button onPress ENTER or click theClick the Currency StyleChange the number in theTo paste the copied dataA moving border appearsbout Microsoft Excel...paragraph break, pressbutton on the toolbar.2. From the Edit menu,sheets by clicking theYou can switch betweenregion's projections.the Auditing toolbar.Attach Note button onFOR LOTUS 1-2-3 USERSDouble-click cell C9.at the bottom of theMicrosoft Excel alsoearch for Help on...into cells B11:E11:1. Select cell B11.Click the Chart tabCreating text notesS U M M A R YPress the ENTER keyTo add a text noteClick the AutoSumxamples and DemosOr press ALT, E,echnical Supportdata as dollars.the cell itself.Example and Demoor press ALT+N.Microsoft ExcelGETTING STARTEDShift Right andthe worksheet.the OK button.demonstration.Please wait...keys to selecton the toolbar, or click theswitch sheets.Shift Down andotus 1-2-3...automaticallyPoint to cellspreadsheet tpress ALT+C.projections.InstructionsIt's easy todouble-clickbeen copied.button twiceuick PreviewFill handle(7 minutes)Programmingultiplan...Select cellWHAT'S NEW?interactiveSee Chapterinnovationsinformationimmediatelyapplicationequivalententer box.PivotTablechoose thecharactersexplainingtranslatesTransitionMoving andPress theMicrosoftMicrosoftrepresentReferenceannotate.differentcontinue,indicatesavailableprocedureClick thesubtotalsTipWizardBACKSPACEselectionSet-WidthworksheetexistingShortcutexample,B12:E12.OverviewpracticepowerfulpressingworkbookC12:E14.FunctionSee AlsofunctionintroducB11:E11:questiondocumentlanguageargumentCreatingAuditingshortcutcontentsadjacentDecreaseCurrencycompoundtoolbar.selectedabsolutecommand.ExamplesYou canthroughExampleworkingtoolbarWesternwait...WYSIWYGFormulaUsing tPreviewSTARTEDReleaseanotherkeywordappearsdollarslimiteddisplaydetailsitself.ChapterprintedminutesAutoSummodulesOptionsreleasebetweenenteredcontrolcontaincommentcommandexamplecommandexamplefeaturepointerDecimalbutton,button.buttonsAutoFilformulaontentscertainheadingseveralALT+C.cell Esheet.InsertcancelALT+N.chooseDeletebuttoncolumnbreak,sheetsagain.specifWizardcompletypingAccessIf youVisualbottomcopiedselectcreatecustomreturnborderretainUser'sdefinedeletebesidesyntaxswitchanswerdialogFirst,switchChooseyou'veColumnwantedwindowlessoneasierwithinwizardmemoryinsertmovingimportnumberentry.of theonlinehandleyou'llSearchoptionyou'reextendfasterformatSelectSelectHow TofinishfirstcheckaboutchartGuideclickExcelchangcellsStyleSuppoUsersDemosPasteincluSLASHLotusenterThen,analyENTERarrowClickSHIFTdemosEnterapplyClosePressIndexChartQuicklabeltablelearnAfterthe c. . .short25400list.macrosheettopictwicemenu,rightmenu.menusrelatreferrange23400mousepresswork.pivotpastewhileCellsBasicwherewatchothertype:on...using1-2-3onlyhaveopenfromhelpCTRLholdnoteoverfindneedndexfillfileListmoveevermostediteasydragdownmoreinstCopyNotedemodatedatadataintomenurow.samesaveitemcopycompJustcellmakecelllistbox.linebox,sortkey,Demoleftstepkey.yourEditHoldHelpShowTextThistasktextthanthatworkFromalsoTo dactiwithwillwhenTo sthenthiswantWestversWithMoveWhenNexttyperowelpforseeC15topuseoneYoucanYou5.0howwayA11nownewtheForboxaddstatheNowbarThetabkeyyouandareAndsum