IMD 1.18: 15/05/2012 9:57:59 solution designer tutorial sd-3 3 of 7 71-03155-07  SD-3monetc0fg/ILysSD 9|M^2am d JHPN  ONO CHANGE!+NY- Question -How To Get Help in Solution DesignerPFILLINTHEBLANKNNNN 1  To return to your worksheet from any  Help screen, press the ~~ key.  1NNNNN(Type your answer and press GO when ready)$P .O*2am cY JHPN  NO CHANGE!+FN.How To Get Help in Solution DesignerPp$Ppq  ~NO CHANGE!NHow To Get Help in Solution DesignerPRVery good!To return to your worksheet from any Help screen,just press the Cancel key.Note that the Finish key works just as well.$P2am $c P Gintro>help>FIB2.a000&$Lintro>help>FIB2.common.path 2amch!pPCancel*aPFinish2am cE JHPN  8NO CHANGE!+NHow To Get Help in Solution DesignerPOThat's incorrect.To return to your worksheet from any Help screen,press either the Cancel key or the Finish key.$P2am $c P Gintro>help>FIB2.a999&$Lintro>help>FIB2.common.path2am c P Gintro>help>rev.1"Gintro>help>rev.2;Nintro>menu 2am f JHPN   NO CHANGE!+N  @ OMNO CHANGE!_[Na1 DWorksheet RDCopy one or D a D1 D2 D3 LLDDDD11 H12 H13 H14 H15 H16 D17 DDDDDDDlc  Graph    ONO CHANGE!NUa1 3Worksheet Range Copy Move 3Copy one or more cells 3 a b c 31 32 33 gLL444ore information411 about a wor312 313 314 H15 H16 317 g4444444ry Table  Calc  Graph   ONO CHANGE!Na1 #Worksheet Range Copy Move File 2am c P ZCarla.fontZSD.font,GIntro>Help>getCXIntro>help>tw1ZGintro>help>segqXintro>help>tocXintro>help>tw2ZSD.fontZCarla.fontGintro>help>qseg1 intro>help>FIB22am c9 JHPN  NO CHANGE!+N9;I T ' S T I M E T O S E EW H A T Y O U H A V E L E A R N E D . . .;.33332am ng  JHPN  NO CHANGE!+=NSolution Designer Help Copying Cell Contentsp COMMAND PATH: /c (or Copy) DESCRIPTION: The Copy command copies the entire contents FROM a cell or group of cells TO another selected location.< 5  PROCEDURE: To copy a ceTo get help on5 1 Make sure you arother subjects in5 2 Move the cursor Solution Designer,f range of cells) you want to copy. 5 press the appropriate 3 Type: /c 5 function key.% The cursor is anied before selecting the Copy command. p 4 Select the range of cells you want to copy FROM.p If your cursor is not on the beginning of the range you want to copy, type the beginning cell address followed by a period (.), then move the cursor to indicate ending cell address in the range and press Press NEXT PAGE for more information.+ CONTENTUSEHELPCOMMAND RANGE  MOVE  FILE  CURSOR CELLREF   5 %h  uNO CHANGE!nNSolution Designer Help 2  Copying Cell Contents2 COMMAND PATH: /c (or Copy) 2 DESCRIPTION: The Copy command copies the entire contents FROM a cell or group of cells TO another selected location.< 5  PROCEDURE: To copy a ceTo get help on5 1 Make sure you arother subjects in5 2 Move the cursor Solution Designer,f range of cells) you want to copy. 5 press the appropriate 3 Type: /c 5 function key.% The cursor is anied before selecting the Copy command. p 4 Select the range of cells you want to copy FROM.p If your cursor is not on the beginning of the range you want to copy, type the beginning cell address followed by a period (.), then move the cursor to indicate ending cell address in the range and press Press NEXT PAGE for more information.+ CONTENTUSEHELPCOMMAND RANGE  MOVE  FILE  CURSOR CELLREF  p 5 5555555555%+  6 NO CHANGE! nNSolution Designer Help 2  Copying Cell Contents2 COMMAND PATH: /c (or Copy) 2 DESCRIPTION: The Copy command copies the entire contents FROM a cell or group of cells TO another selected location.< 5  PROCEDURE: To copy a ceTo get help on5 1 Make sure you arother subjects in5 2 Move the cursor Solution Designer,f range of cells) you want to copy. 5 press the appropriate 3 Type: /c 5 function key.% The cursor is anied before selecting the Copy command. p 4 Select the range of cells you want to copy FROM.p If your cursor is not on the beginning of the range you want to copy, type the beginning cell address followed by a period (.), then move the cursor to indicate ending cell address in the range and press Press NEXT PAGE for more information.+ CONTENTUSEHELPCOMMAND RANGE  MOVE  FILE  CURSOR CELLREF  p 5 5555555555%+  ONO CHANGE!nNSolution Designer Help 2  Copying Cell Contents2 COMMAND PATH: /c (or Copy) 2 DESCRIPTION: The Copy command copies the entire contents FROM a cell or group of cells TO another selected location.< 5  PROCEDURE: To copy a ceTo get help on5 1 Make sure you arother subjects in5 2 Move the cursor Solution Designer,f range of cells) you want to copy. 5 press the appropriate 3 Type: /c 5 function key.% The cursor is anied before selecting the Copy command. p 4 Select  the range of cells you want to copy FROM.p If your cursor is not on the beginning of the range you want to copy, type the beginning cell address followed by a period (.), then move the cursor to indicate ending cell address in the range and press Press NEXT PAGE for more information.+ CONTENTUSEHELPCOMMAND RANGE  MOVE  FILE  CURSOR CELLREF  p 5 5555555555%+ NO CHANGE!.MNSolution Designer Help 2  Copying Cell Contents2 COMMAND PATH: /c (or Copy) 2 DESCRIPTION: The Copy command copies the entire contents FROM a cell or group of cells TO another selected location.< 5  PROCEDURE: To copy a ceTo get help on5 1 Make sure you arother subjects in5 2 Move the cursor Solution Designer,f range of cells) you want to copy. 5 press the appropriate 3 Type: /c 5 function key.% The cursor is anied before selecting the Copy command. , * 4 Select $ But for now, just press Next Page. If your you want to copy, type th*d (.), then move the cursor to indicate ending cell address in the range and press Press NEXT PAGE for more information.+ CONTENTUSEHELPCOMMAND RANGE  MOVE  FILE  CURSOR CELLREF  p 5 5555555555,$*$*$*$c%+2am cg JHPN  =NO CHANGE!+Na1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Copy one or more cellsA a b c d e f g h i1 2 3 4 5 36 7 For example, Copy is currently highlighted.8 9 To find out more information on what Copy does,10 11 press the Help key.12 13 314 15 16 17 Do that right now.18 19 20 Press Help.21 22 23 Fri 05-Feb-88 10:05 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] NO CHANGE!N   NO CHANGE!NcSolution Designer Help Copying Cell Contentsp COMMAND PATH: /c (or Copy) DESCRIPTION: The Copy command copies the entire contents FROM a cell or group of cells TO another selected location. PROCEDURE: To copy a cell or group of cells:v 1 Make sure you are in READY mode.{ 2 Move the cursor to the cell (or beginning of range of cells) you want to copy. 3 Type: /c The cursor is anchored on the cell it occupied before selecting the Copy command. 4  Select the range of cells you want to copy FROM.p If your cursor is not on the beginning of the range you want to copy, type the beginning cell address followed by a period (.), then move the cursor to indicate ending cell address in the range and press Press NEXT PAGE for more information.+ CONTENTUSEHELPCOMMAND RANGE  MOVE  FILE  CURSOR CELLREF   5 D%  NO CHANGE! cNSolution Designer Help Copying Cell Contentsp COMMAND PATH: /c (or Copy)J ! DESCRIPTION: The Copy FROM a cell or group of cells TO anot This is the Help screen- - for the Copy command. PROCEDURE: To copy a - In general, Help provides 1 Make sure you - a thorough description 2 Move the cursoe of cells) you want to copy. of all available commands-  3 Type: /c and functions.-  The cursor is fore selecting the Copy command. (Press Next Page to Continue)-   4 Select the ran!o If your cursor is not on the beginning of the range you want to copy, type the beginning cell address followed by a period (.), then move the cursor to indicate ending cell address in the range and press Press NEXT PAGE for more information.+ CONTENTUSEHELPCOMMAND RANGE  MOVE  FILE  CURSOR CELLREF   !! !!!!!!!!x% ~ To get help, you must press the Help key. ~ ~~ ~~ ~ Dismiss this message and press the Help key. ~ ~~ Help time time time2am g| JHPN   NO CHANGE!+NcSolution Designer Help Copying Cell Contentsp COMMAND PATH: /c (or Copy) DESCRIPTION: The Copy command copies the entire contents FROM a cell or group of cells TO another selected location. PROCEDURE: To copy a cell or group of cells:v 1 Make sure you are in READY mode.{ 2 Move the cursor to the cell (or beginning of range of cells) you want to copy. 3 Type: /c The cursor is anchored on the cell it occupied before selecting the Copy command. 4 Select the range of cells you want to copy FROM.p If your cursor is not on the beginning of the range you want to copy, type the beginning cell address followed by a period (.), then move the cursor to indicate ending cell address in the range and press Press NEXT PAGE for more information.+ CONTENTUSEHELPCOMMAND RANGE  MOVE  FILE  CURSOR CELLREF   5 D% +NO CHANGE!NSolution  Designer Help Copying Cell Contentsp COMMAND PATH: /c (or Copy) DESCRIPTION: The Copy command copies the entire contents FROM a cell or group of cells TO ano . . To return to your worksheet, PROCEDURE: To copy a. press the Cancel key or the  1 Make sure you. Finish key at any time. 2 Move the cursnge of cells) you want to copy. l 3 Type: /c''  The cursorLet's return to your worksheet.re selecting the Copy comma'  4 Select theTo do this, press Cancel .'  If your cu' you want to copy, type the beginning cell address followed by a period (.), then move the cursor to indicate ending cell address in the range and press Press NEXT PAGE for more information.+ CONTENTUSEHELPCOMMAND RANGE  MOVE  FILE  CURSOR CELLREF   5 B%  NO CHANGE! N  $ 91 NO CHANGE!C Na1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Copy one or more cellsA a b c d e f g h i1 2 3 4 5 6 7 8 Remember:9 10 The Help key is your friend!11 12 13 Press Next Page to continue14 15 16 17 18 19 20 21 22 23 Fri 05-Feb-88 10:05 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]&&&&&Print Gr#Copy one or more cells # a b c d e #1 #2 #3 FLL#$##nytime you need more information#11 about a worksheet command, #12 #13  #14  H15 H16 #17 F####### To  Window Query Table  Calc  Graph - $$$   ONO CHANGE!Na1 Worksheet Range Copy Move File Print Graph Data Advanced Copy one or more cells,  a b c d e f g 1 2 3 LL9You can get Help anytime you need more information11 about a worksheet command, function, or concept.12 13 514 H15 H16 17 10:05 AM  Name Abs  Go To  Window Query Table  Calc  Graph B 99955(  A NO CHANGE! NNa1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit  Copy one or more cellsA a b c d e f g h i1 2 3 4 5 D6 D7 :8 9 You can get Help anytime you need more information10 11 about a worksheet command, function, or concept.12 13 :14 D15 D16 17 18 19 20 21 22 23 Fri 05-Feb-88 10:05 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]:::::0   3NO CHANGE!+NSolution Designer Help Copying Cell Contentsp COMMAND PATH: /c (or Copy) DESCRIPTION: The Copy command copies the entire contents FROM a cell or group of cells TO another selected location. $ PROCEDURE: To copy* To return to your worksheet, 1 Make sure y* press Cancel at any time. 2 Move the cue of cells) you want to copy. * Do that right now. 3 Type: /c * $ The cursor is anchored on the cell it occupied before selecting the Copy command. 4 Select the range of cells you want to copy FROM.p If your cursor is not on the beginning of the range you want to copy, type the beginning cell address followed by a period (.), then move the cursor to indicate ending cell address in the range and press Press NEXT PAGE for more information.+ CONTENTUSEHELPCOMMAND RANGE  MOVE  FILE  CURSOR CELLREF   5 $$$$$$$$!L%B ONO CHANGE!aN  v 9NO CHANGE!Na1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Copy one or more cellsA a b c d e f g h i1 2 3 4 5 6 7 8 Remember:9 10 The Help key is your friend!11 12 13 Press Next Page to continue14 15 16 17 18 19 20 21 22 23 Fri 05-Feb-88 10:05 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]&&&&&time  ~ You are returning to your worksheet. To do ~ ~~ ~ this, you can press either Finish or Cancel. ~ ~~ ~ Dismiss this message and press Cancel. ~ Cancel time time2am c_ JHPN  NO CHANGE!+N  @  MNO CHANGE!_NExecutive11.2 (OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP CommandYou will return to .The ExecutivePG0 C2am e  JHPN  NO CHANGE!+N  @ MNO CHANGE!_N N)StatusContextsyoucanreturntoApplicationsyoucanstart)Art DesignerDocument DesignerExecutiveMailSolution Designer)PressGOtoreturntothiscontext.Exec   A D  S D   D D  Mail N 2(  K5NO CHANGE!GN N)StatusContextsyoucanreturntoApplicationsyoucanstart)Art Designer. orDocument DesignerExecutiveMailSolution DesignerContext Manager)PressGOtoreturntothiscontext.Exec   A D  S D   D D  Mail N ~\22am d JHPN  NO CHANGE!+N  @ )MNO CHANGE!_NSignOn 11.2 (OS t1ClstrLfsMp-9.8)Mon Feb 15, 19888:03AMPUser name(e.g. Allen) PasswordDate/Time (e.g. Fri Sep 9 1983 8:00 am) . orthe SignOn ScreenP(  2am en JHPN   NO CHANGE!+N,a1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Copy one or more cellsA a b c d e f g h i1 2 3 94 95 +6 7 There are two ways that you can8 9  finish from Solution Designer:10 11 +12 913 914 15 16 17 18 19 20 21 22 23 Fri 05-Feb-88 10:05 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]+++++( 2am Tf JHPN   NO CHANGE!+ N8a1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Copy one or more cellsA a b c d e f g h i1 2 3 94 95 +6 7 There are two ways that you can8 9  finish from Solution Designer:10 11 12 +13 914 915 16 17 18 19 20 21 22 23 Fri 05-Feb-88 10:05 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]++++++(4  ANO CHANGE!STNja1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Copy one or more cellsA a b c d e f g h i1 2 3 94 95 +6 7 There are two ways that you can8 9  finish from Solution Designer: 10 11 12 Use the Quit command13 14 +15 916 917 18 19 20 21 22 23 Fri 05-Feb-88 10:05 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]+++++++(2am f JHPN   NO CHANGE!+lNua1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Copy one or more cellsA a b c d e f g h i1 2 3 94 95 +6 7 There are two ways that you can8 9  finish from Solution Designer:10 11 12 Use the Quit command13 14 15 +16 917 918 19 20 21 22 23 Fri 05-Feb-88 10:05 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]++++++ +(  NO CHANGE!Na1 MENU Worksheet Range Copy Move File Print Graph Data  Advanced Quit Copy one or more cellsA a b c d e f g h i1 2 3 94 95 +6 7 There are two ways that you can8 9  finish from Solution Designer:10 11 12 Use the Quit command13 14 Press the Finishkey15 16 +17 918 919 20 21 22 23 Fri 05-Feb-88 10:05 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]++++++ +(2am d* JHPN  ONO CHANGE!+Nt- Question -How To Finish From Solution DesignerPFILLINTHEBLANKNNNN;  In order to use the Finish key when finishing from  Solution Designer, you must be in~~ mode.  ; NNNNN(Type your answer and press GO when ready)$P 3J*2am c@ JHPN  5NO CHANGE!+FN.How To Finish From Solution DesignerPp$Ppq  $~NO CHANGE!NHow To Finish From Solution DesignerPPThat's correct.You must be in READY mode in order to use theFinish key when finishing from Solution Designer.$P{2am &c P Gintro>finish>FIB1.a000(&Lintro>finish>FIB1.common.path 2am cB JHPN   $NO CHANGE!+NHow To Finish From Solution DesignerPPThat's incorrect.You must be in READY mode in order to use theFinish key when finishing from Solution Designer.$P{2am &c P Gintro>finish>FIB1.a999(&Lintro>finish>FIB1.common.path2amch!p<READY2am c P  intro>finish>FIB2 2am d JHPN  NO CHANGE!+Ne- Question -How To Finish From Solution DesignerPFILLINTHEBLANKNNNN 6 The command you use to finish from Solution  Designer is called the~~ command. 6 NNNNN(Type your answer and press GO when ready)$Pc 0M*2am c/ JHPN  ONO CHANGE!+FN.How To Finish From Solution DesignerPp$Ppq  )~NO CHANGE!NHow To Finish From Solution DesignerPQThat's right!The command you use to finish from Solution Designeris called the Quit command.{$P2am &c P Gintro>finish>FIB2.a000(&Lintro>finish>FIB2.common.path2am c3 JHPN  'NO CHANGE!+NHow To Finish From Solution DesignerPThat's incorrect.The command you use to finish from Solution Designeris called the Quit command.$P 2am &c P Gintro>finish>FIB2.a999(&Lintro>finish>FIB2.common.path2amch!p<Quit2am c P Gintro>finish>Rev.1$Gintro>finish>Rev.2?NIntro>menu2am c P ZCarla.fontZSD.font,GIntro>Finish>F.1EGIntro>Finish>F.2^GIntro>Finish>F.3wGintro>finish>twsegXintro>finish>tw1Gintro>finish>tw1aseg.1Gintro>finish>tw1aseg.2Xintro>finish>tw1aXintro>finish>tw2Gintro>finish>e.15Gintro>finish>e.2NGintro>finish>e.3gZSD.fontwZCarla.fontGintro>finish>qseg1 intro>finish>FIB1 2am c9 JHPN  NO CHANGE!+N9;I T ' S T I M E T O S E EW H A T Y O U H A V E L E A R N E D . . .;.33332am e JHPN  NO CHANGE!+N'!  !NO CHANGE!NHow To Finish From Solution Designer5To finish from Solution Designer,1)Select the Quit command, OR2)Press the Finish key when'worksheet is in READY mode!Depending on how you invokedSolution Designer, you will return toone of the following screens:-the Executive-the Context Manager-the SignOn Screen$5 2am &f JHPN  NO CHANGE!+&N[HowToFinishFromSolutionDesigner5To finish from Solution Designer, You have reached the end1)SelecttheQuitcommand,ORofthislesson, and the2)PresstheFinishkeywhenend of the Intro section.worksheetisinREADYmode We suggest you proceedtothenextsection,Dependingonhowyouinvoked Creating and ModifyingSolutionDesigner,youwillreturnto a Worksheet.oneofthefollowingscreens:PressNextPagetoreturn-theExecutivetotheIntromenu.-theContextManager-theSignOnScreen5555   555555555555 55555555555 2am f: JHPN  NO CHANGE!+ NRa1MENU WorksheetRangeCopyMoveFilePrintGraphDataAdvancedQuitCopyoneormorecells a b c d e f g h i1 2 3 4 5 6 7 '8 9 Let's use the Quit command first. 10 11 '12 13 !14 15 It's real simple:16 17 18 Just press qto Quit.19 20 !21 22 23 Fri05-Feb-8810:05AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]   4  OANO CHANGE!SNJa1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit  a b c d e f g h i1O 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Fri 05-Feb-88 2:54 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]5 BNO CHANGE!TN  i  -vNO CHANGE!NFThat's all there is to it!(Press Next Page to Continue)D'''''''u 'NO CHANGE!.N3a1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1O 2 3 4 5 6 !7 8 Now let's use the Finish key. 9 10 First, locate the Finish key11 12 on your keyboard.13 14 !15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:30 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] 8 NO CHANGE! BNa1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1O 2 3 4 5 6 !7 8 Now let's use the Finish key. 9 10 First, locate the Finish key11 12 on your keyboard.13 14 !15 16 #17 18 After you've done so,19 20 Press Next Page to Continue21 22 #23 Mon 08-Feb-88 12:30 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]#####X eNO CHANGE!wN    #NO CHANGE!Na1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit  Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1L 2 #3 4 Notice your mode indicator.5 6 You are currently in MENU m ode.7 8 #9 !10 11 You can use the Finish key 12 13 if you're in READY mode only.14 15 !16 #17 18 Therefore, press Cancel 19 20 to remove the command menu.21 22 #23 Mon 08-Feb-88 12:30 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]##########l OyNO CHANGE!Na1READY a b c d e f g h i1234567891011121314151617181920212223Thu 04-Feb-88 4:26 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]   #NO CHANGE!,Na1READY a b c d e f g h i1234The mode indicator5 6now displays READY.789101112Go ahead and finish.13141516!1718Press theFinishkey.1920!212223Thu 04-Feb-88 4:26 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  NO CHANGE!WNa1MENU Yes NoSave changes to worksheet; then exit Spreadsheet a b c d e f g h i1 2 3 14 5 If you made changes to a worksheet, andyou6 7 did not save your worksheet before finishing,8 9 then this screen will be displayed.10 11 Let's say you did make changes. Go ahead and12 13 save them.14 15 116 17 '18 19 To do this, type y for Yes.20 21 '22 23 Thu 04-Feb-88 4:26 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]5 BNO CHANGE!TNYa1MENU Yes NoSave changes to worksheet; then exit Spreadsheet a b c d e f g h i1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:26 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]C  PNO CHANGE!bN  w ENO CHANGE!N8range>Int.1#Gusing>range>Int.2=ZCarla.fontPZSD.font`Gusing>range>Def.1zGusing>range>def.2Gusing>range>def.3Gusing>range>def.4Gusing>range>def.5Gusing>range>def.6Gusing>range>def.7Gusing>range>def.80Xusing>range>egGGusing>range>seg1`Xusing>range>nameyZSD.fontZCarla.fontGusing>range>qseg2using>range>mc12am d JHPN   NO CHANGE!+N  @ OMNO CHANGE!_7NWhat Is a Range?P@0Pp ONO CHANGE!NWhat Is a Range?P3When creating or modifying a worksheet,you can choose to work with one cell at a time,PPpe OrNO CHANGE!NWhat Is a Range?P3When creating or modifying a worksheet,you can choose to w2am cH JHPN  NO CHANGE!+NWhat Is a Range?PIn this lesson, you will learnwhat a range iswhat ranges are used forhow to define a rangeP~2am d  JHPN   ONO CHANGE!+NQuestion What Is a Range?P@MWhich of the following define ranges?UCLF1 - a1..a1HTF2 - g8..g4OIF3 - a1..b3IPF4 - All of the aboveCLF5 - None of the aboveEE(Select your answer by pressing one of the indicated selections)P/// )@  2am c P using>range>TF22am dI JHPN  ONO CHANGE!+N&What Is a Range?PUWhich of the following define ranges?"F1 - a1..a1F2 - g8..g4That's correct.F3 - a1..b3a1..a1, g8..g4,F4 - All of the aboveand a1..b3 allF5 - None of the abovedefine ranges.4P///          : must select Yes. ~ ~~ ~ Dismiss this message and type 'y'. ~ y time time time2am $c P "Gusing>range>MC1.incorrect+$Lusing>range>MC1.common.path2am $c   P "Gusing>range>MC1.incorrect+$Lusing>range>MC1.common.path2am $c P "Gusing>range>MC1.incorrect+$Lusing>range>MC1.common.path2am $c P  Gusing>range>MC1.correct)$Lusing>range>MC1.common.path2am $c P $Gusing>range>MC1.f5incorrect-$Lusing>range>MC1.common.path2am e   JHPN  NNO CHANGE!+NeWhat Is a Range?PUWhich of the following define ranges?"F1 - a1..a1F2 - g8..g4F3 - a1..b3F4 - All of the aboveF5 - None of the aboveThat's incorrect. The correct answer is F4. a1..a1,g8..g4, and a1..b3all define ranges.P///          2am d_ JHPN  "NO CHANGE!+NSWhat Is a Range?PUWhich of the following define ranges?"F1 - a1..a1F2 - g8..g4F3 - a1..b3F4 - All of the aboveF5 - None of the above-That's correct, however, the appropriateanswer is F4. a1..a1, g8..g4, and a1..b3all define ranges.-P///          -------2am 2c N 2 F1  F2  F3  F4  F5 2am cA JHPN  'NO CHANGE!+NFL E T ' S T E S TY O U R K N O W L E D G EB Y A N S W E R I N GA F E W Q U E S T I O N S!F   2am d> JHPN  NO CHANGE!+N'!  =NO CHANGE!NWhat Is a Range?5A range is a rectangular block of cells.It can be a single cell or a group ofcontiguous, or adjacent, cells.'Several commands, for instance, the Copy!command, require you to define a rangeon which to perform the command.52am dY JHPN   FNO CHANGE!+NWhat Is a Range?5To define a range:1)Move the cell pointer to the beginning cell, or anchor cell'2)Type a period to "anchor" theޱ!cell pointer at the beginningof the range3)Highlight the rest of the rangeby moving the cell pointer tothe last cell in the range52am e. JHPN   FNO CHANGE!+NWhat Is a Range?5To define a range:1)Move the cell pointer to the Youhavereachedthebeginning cell, or anchor cellendofthislesson.Wesuggestyouproceed2)Type a period to "anchor" thetothenextlesson,cell pointer at the beginningCreating a Worksheet.of the rangePressNextPagetoreturn3)Highlight the rest of the rangetotheUsingmenu.by moving the cell pointer to the last cell in the range%5555 555555555555555555555552am Md JHPN   NO CHANGE!+MNQuestion What Is a Range?PT R U E o r F A L S E&((Cells, d4, f4 and g4 make up a((range of three cells.((&U (Select your answer by pressing one of the indicated selections)P"@2am c P Gusing>range>rev.1#Gusing>range>rev.2=Gusing>range>rev.3WNUsing>menu2am $c P Gusing>range>TF2.true&$Lusing>range>TF2.common.path2am $c  P Gusing>range>TF2.false'$Lusing>range>TF2.common.path2am dT JHPN  NO CHANGE!+NbWhat Is a Range?PT R U E o r F A L S E&((Cells, d4, f4 and g4 make up a((range of three cells.(( "Correct. This statement is false.""Cells, d4, f4 and g4 do not make "up a range of three cells becausethey are not contiguous, or adjacentto each other.cP..........2am !c N ! TRUE  FALSE 2am d^ JHPN  NO CHANGE!+NlWhat Is a Range?PT R U E o r F A L S E&((Cells, d4, f4 and g4 make up a((range of three cells.(( That's incorrect. This statement is false. Cells, d4, f4 and g4 do not make up a range of three cells becausethey are not contiguous, or adjacentto each other.cP0000000002am !d  JHPN  NO CHANGE!+!NIYou have just learnedsome of the basic steps needed to create a worksheet.*But you're still not finished with your expense report.The next lesson teaches youhow to modify the worksheet you have just created!Press Next Page to Continuea 2am dL JHPN  ONO CHANGE!+N- Question -Creating a WorksheetPFILLINTHEBLANKNNN:  Let's say you want to enter the number, 10, into  6 adjacent cells. A good way to do this is to use  the ~~ command.  : NNNN(Type your answer and press GO when ready)P 2*2am c0 JHPN   6NO CHANGE!+NCreating a WorksheetPThat's right!To enter the same number into 6 adjacent cells,a good way to do this is to use the Copy command.PS2am &c P Gusing>create>FIB6.a000(&Lusing>create>FIB6.common.path 2am .d JHPN  'NO CHANGE!+.NCreating a WorksheetPThat's incorrect.To enter the same number into 6 adjacent cells,a good way to do this is to use the Copy command. The Copy command lets you copy worksheet data from acell or cell range to another location in the worksheet.-PS2am &c P Gusing>create>FIB6.a999(&Lusing>create>FIB6.common.path2amch!pPCopy2am c P ZCarla.fontZSD.font,Gusing>create>Seg3FXusing>create>SER_Gusing>create>seg4yZSD.fontZCarla.fontGusing>create>qseg1 using>create>FIB7 2am d JHPN  NO CHANGE!+NQ- Question -Creating a WorksheetPFILLINTHEBLANKNNNN 2  The keystroke combination to use if you  want to save your worksheet is~~ .  2NNNNN(Type your answer and press GO when ready)P .O*2am c$ JHPN   ONO CHANGE!+6NCreating a WorksheetPpPpa %nNO CHANGE!NCreating a WorksheetPThat's correct!To save your worksheet,the keystroke combination is/fs .P582am &c P Gusing>create>FIB7.a000(&Lusing>create>FIB7.common.path2am &d JHPN  ONO CHANGE!+6NCreating a WorksheetPpPpa %nNO CHANGE!&NCreating a WorksheetP\That's almost correct.You forgot to include the slash (/).To save your worksheet,the keystroke combination to use is/fs.Remember to type a slash firstto display the command menu.P 2am &c P Gusing>create>FIB7.a002(&Lusing>create>FIB7.common.path2am Xd JHPN   %NO CHANGE!+XN8Creating a WorksheetPThat's incorrect.To save your worksheet,the keystroke combination to use is/fs . / displays the command menu,f displays the File command menu, ands selects the Save command.Px2am &c P Gusing>create>FIB7.a999(&Lusing>create>FIB7.common.path2amch!pP/fs'afs 2am c P using>create>TF82am d JHPN   NO CHANGE!+N  @ OMNO CHANGE!_N 0 y ONO CHANGE!#NNN  ONO CHANGE!Nto produce reports filled with numbers and calculations.A simple example would be an Expense Report.@NNN888=u ONO CHANGE!qN$2am ed JHPN  NO CHANGE!+NCreatingaWorksheetPLet's say you are a customer service representative whomakes frequent trips servicing customers across the countryand you need to fill out an expense report for each trip.NEXPENSE REPORTTotal1/6/881/7/881/8/88ExpensesCAir, rail, bus$450.00$450.00Rental car$45.00$45.00 $45.00$135.00Daily lodging$89.00$89.00 $89.00$267.00Meals$25.00$25.00 $25.00$75.00Entertainment$75.00$75.00CTotal Expenses$609.00$234.00 $159.00$1002.00Less Advances$1200.00Balance Due To EmployeeBalance Due From Employee$198.00N P;;;;;2am e  JHPN  NO CHANGE!+NdCreatingaWorksheetPYou are going to use Solution Designerto create an Expense Report such as the one shown below.NEXPENSEREPORTTotal1/6/881/7/881/8/88ExpensesCAir,rail,bus$450.00$450.00Rentalcar$45.00$45.00$45.00$135.00Dailylodging$89.00$89.00$89.00$267.00Meals$25.00$25.00$25.00$75.00Entertainment$75.00$75.00CTotalExpenses$609.00$234.00$159.00$1002.00LessAdvances$1200.00BalanceDueToEmployeeBalanceDueFromEmployee$198.00N P&72am iL JHPN  NO CHANGE!+N Creatinga WorksheetPYou aegog to ue Soluion Designerto cre teian Expen,e Report such as thetone shown below.teelinuroh s o EXPNSEREPOTeTotal1/6/881/7/881/8/88Expenses$or ir,ral,us$450.0$450.00RntaarSu$45.0e$4.0$45.00$135.00Dailylodgin$80089.00$89006700Meals $2e.0o$25.02.75.00Entertainmen$75.0$75.0n oe TotalEpenses09.00$23.00$15.00$100200LessAdaces120.0BalanceDueToEmployeeBaanceDueFromEmployee$19800  P 7   3 !NO CHANGE!3oNaCreating a WorksheetPYou aeggto u Soluion Deinert cre teian expen,eyRe ort uch as thetonehown blow.ntrtelbel,inourohe Us Go tkEXPNSREPOTne ,it oweTotal1/6/881/7/81/8/8Expensesiiyo rheirral,u$0.0$40.0RntrSu$45.0et$4.0$45.0$135.00ailydgin$0089.00$8900700Meals $re.0o$250.00Entetainme$7.$75.0On xng ohetaEpenses09.0$23.0$15.00$000LessAdae120.0alnceDueToEmplyeeBaanceDueFroEmplee$980P)    1  NO CHANGE! N:Creating a WorksheetPou aegto u Soluin Deinert cre teian espen, yRu ort lch ashowetonehown blEntrter lbels, intoour wohe Us t Go To5 futikEXSREPTnber v,int o woeTotl1/6/881/7/88ExpensesCifiyou rshetia,u$0.0.RntrSu$45.0et$4.0$5.0.0ailydg$009.00$89700Mealss e$re 0o$25.0tetainme$7$75.Opnn xng orhetapens9.23..00$000LessAde10.alceueTEmplyenceDuroEmplee$980P)     1 NO CHANGE!kNCreating a WorksheetPugt uin Dinet rn thia espon, yRu ort lch ashowetoneowblEntrtet or labels, intoour woheUse t Go To(5) futiokyEXSREnmber o v,into our wokeetTtl1/6/881/7/8xseCpifori your rksheti,u.0RntSa uror45.0et$4.0$00ildg$0.00890MeasEas et$re worse$25.0tam$775Opnn xsing worhetapns9.3..000LssAde0.aleelynceDuomle$80P'         1 +NO CHANGE!=cNCreating a WorksheetPun Dintrn this lesson, you oill lca ashow tonEnter text, or labels, into your worksheetUse th Go To (F5)  funtion keyEnter numbers, o vlues,into your worksheet81/sCopyinformtin your orksheetRSave yourorks.0et00$0sEras an ent$re worsheet.Opnn exising worheetpns..elleDo,P&    62  F4  %1 NO CHANGE!NgCreating a WorksheetPnIn this lesson, you will learn how toEnter text, or labels, into your worksheetUse the Go To (F5) function keyEnter numbers, or vlues, into your worksheet8sCopy informtin n your worksheetSave your worksheetsErase an entire wor2am c P ZCarla.fontZSD.font,Gusing>create>i.1EGusing>create>i.2^Gusing>create>i.3wGusing>create>i.4GUsing>Create>Seg1.1GUsing>Create>Seg1.2GUsing>Create>Seg1.3GUsing>Create>Seg1.4GUsing>Create>Seg1.5GUsing>Create>Seg1.68GUsing>Create>Seg1.7TGUsing>Create>Seg1.8pGUsing>Create>Seg1.9GUsing>Create>Seg1.10GUsing>Create>Seg1.11GUsing>Create>Seg1.12ZSD.fontZCarla.fontGusing>create>qseg1!using>create>MC12am d: JHPN  NO CHANGE!+N;Question Creating a WorksheetP@MBefore entering labels and values, Ua worksheet must be inCL HTF1 - MENU modeOIF2 - READY modeIPF3 - LABEL modeCLF4 - VALUE modeEEF5 - None of the above(Select your answer by pressing one of the indicated selections)P6,', !,@2am c  P using>create>TF22am be JHPN  5NO CHANGE!+bNCreating a WorksheetPVBefore entering labels and values, a worksheet must be in F1 - MENU modeThat's right. F2 is theF2 - READY modecorrect answer. AF3 - LABEL modeworksheet must be in F4 - VALUE modeREADY mode before youF5 - None of the abovecan enter labels andvalues.P6,', !,2am %c P #Gusing>create>MC1.incorrect,%Lusing>create>MC1.common.path2am %c P !Gusing>create>MC1.correct*%Lusing>create>MC1.common.path2am %c  P %Gusing>create>MC1.f3incorrect.%Lusing>create>MC1.common.path2am %c P %Gusing>create>MC1.f4incorrect.%Lusing>create>MC1.common.path2am %c P #Gusing>create>MC1.incorrect,%Lusing>create>MC1.common.path2am e JHPN   GNO CHANGE!+NCreating a WorksheetPVBefore entering labels and values, a worksheet must be in F1 - MENU modeF3 is incorrect. TheF2 - READY modecorrect answer is F2,F3 - LABEL modeREADY mode. The modeF4 - VALUE modechanges from READY toF5 - None of the aboveLABEL the moment youstart to enter the label.P6,', !, 2am e  JHPN   2NO CHANGE!+NCreating a WorksheetPVBefore entering labels and values, a worksheet must be in F1 - MENU modeF4 is incorrect. TheF2 - READY modecorrect answer is F2,F3 - LABEL modeREADY mode. The modeF4 - VALUE modechanges from READY toF5 - None of the aboveVALUE the moment youstart to enter thevalue.P6,', !,2am Ee JHPN  INO CHANGE!+ENCreating a WorksheetPVBefore entering labels and values, a worksheet must be in F1 - MENU modeThat's incorrect. TheF2 - READY modecorrect answer is F2.F3 - LABEL modeYou must be in READYF4 - VALUE modemode in order to enterF5 - None of the abovelabels and values.P6,', !,2am 2c N 2 F1  F2  F3  F4  F5 2am "e  JHPN  NO CHANGE!+"NQuestion Creating a WorksheetPThe cell pointer is at cell b2 and you want Mto enter the label, "Expenses", in cell b5.U The first thing to do isCLHTF1 - Press ReturnOIF2 - Display the command menuIPF3 - Move cell pointer to desired cellCLF4 - Type in the labelEEF5 - None of the above(Select your answer by pressing one of the indicated selections)P5555555&&&&&&&&&@2am c P using>create>MC42am e JHPN  HNO CHANGE!+NCreating a WorksheetPThe cell pointer is at cell b2 and you want to enter the label, "Expenses", in cell b5. The first thing to do is!F1 - Press ReturnF2 - Display the command menuF3 - Move cell pointer to desired cellF4 - Type in the labelF5 - None of the aboveVery good. The correct answer is F3. You must first move thecell pointer to cell b5 beforeyou enter the label, "Expenses".$P5555555   &&&$$$$$$$$$2am %c  P #Gusing>create>MC3.incorrect,%Lusing>create>MC3.common.path2am %c P #Gusing>create>MC3.incorrect,%Lusing>create>MC3.common.path2am %c P !Gusing>create>MC3.correct*%Lusing>create>MC3.common.path2am %c P #Gusing>create>MC3.incorrect,%Lusing>create>MC3.common.path2am %c  P #Gusing>create>MC3.incorrect,%Lusing>create>MC3.common.path2am e JHPN  +NO CHANGE!+NCreating a WorksheetPThe cell pointer is at cell b2 and you want to enter the label, "Expenses", in cell b5. The first thing to do is!F1 - Press ReturnF2 - Display the command menu(F3 - Move cell pointer to desired cell(F4 - Type in the labelF5 - None of the above3That's incorrect. The correct answer is F3.You must first move the cell pointer to cell b5before you enter the label, "Expenses".3P5555555   &&&333332am 2c N 2 F1  F2  F3  F4  F5 2am Ge JHPN   ONO CHANGE!+GNQuestion Creating a WorksheetP Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph Here is the function key menu. What function key canbe used to move the cell pointer to a new location?MUF1 - the F3 keyCLF2 - the F5 keyHTF3 - the F7 keyOIF4 - None of the aboveIPCL(Select your answer by pressing one of the indicated selections)EE?P 6]5 555   @2am c P ZCarla.fontZSD.font,Xusing>create>NosEZSD.fontUZCarla.fonthGusing>create>qseg1 using>create>Fib62am e JHPN  :NO CHANGE!+NCreating a WorksheetP Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph Here is the function key menu. What function key canbe used to move the cell pointer to a new location?F1 - the F3 keyThat's correct. TheF2 - the F5 keyF5 key, Go To, is F3 - the F7 keyused to move the cellF4 - None of the abovepointer to a newlocation.P 6 )]5555 2am %c P #Gusing>create>MC4.incorrect,%Lusing>create>MC4.common.path 2am %c P !Gusing>create>MC4.correct*%Lusing>create>MC4.common.path2am %c P #Gusing>create>MC4.incorrect,%Lusing>create>MC4.common.path2am %c P #Gusing>create>MC4.incorrect,%Lusing>create>MC4.common.path2am ed JHPN  4NO CHANGE!+NCreating a WorksheetP Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph Here is the function key menu. What function key canbe used to move the cell pointer to a new location?F1 - the F3 keyThat's incorrect. TheF2 - the F5 keycorrect answer is theF3 - the F7 keyF5 key, Go To.F4 - None of the aboveGo To is used to move the cell pointer toa new location.P 6 )]5555 2am +c N + F1  F2  F3  F4 2am hg JHPN  NO CHANGE!+N  @ $MNO CHANGE!_NAc6 READY a b c d e f g h i1 EXPENSE REPORT 2 %3 4 Now let's enter numbers into your5 6 Air, rail, bus worksheet. By now you should be7 Rental car 8 Daily lodging familiar with entering text into9 Meals 10 Entertainment your worksheet. Entering numbers11 12 is done in the same way.13 14 Total Expenses The cell pointer is currently at15 Less Advances 16 BalDueToEmp cell c6. 17 BalDueFromEmp18 %19 20 21 Type in the number 450.22 23 Mon 08-Feb-88 12:44 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T @ MNO CHANGE!_NWc6 VALUE45 O  a b c d e f  g h i1 EXPENSE REPORT  2'  3' Since you are entering a value,  4' #  5' the mode indicator changes from  6 Air, rail, bus #  7 Rental car READY to VALUE.  8 Daily lodging  9 Meals # 10 Entertainment= 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:45 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T#### ###t  NO CHANGE! NXc6 VALUE455 O  a b c d e f  g h i1 EXPENSE REPORT   2'  3' Since you are entering a value,  4' #  5' the mode indicator changes from  6 Air, rail, bus #  7 Rental car READY to VALUE.  8 Daily lodging  9 Meals # 10 Entertainment= 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:45 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T#### ###  NO CHANGE! uNc6 VALUE4505 O  a b c d e f  g h i1 EXPENSE REPORT  2'  3' Since you are entering a value,  4' #  5' the mode indicator changes from  6 Air, rail, bus #  7 Rental car READY to VALUE. 8 Daily lodging 9 Meals #10 Entertainment 11 12 )13 14 Total Expenses Press Return to enter the number.15 Less Advances 16 BalDueToEmp )17 BalDueFromEmp 18 19 20 21 22 23 Mon 08-Feb-88 12:45 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T#### ###!= !JNO CHANGE!\zNc6 450 READY a b c d e f g h i1 EXPENSE REPORT 2 "3 4 Good job.5 6 Air, rail, bus 450 Remember, if you forget7 Rental car 8 Daily lodging  how to do something,9 Meals 10 Entertainment don't worry. Just press Help.11 12 "13 14 Total Expenses !15 Less Advances 16 BalDueToEmp Now move the cell pointer17 BalDueFromEmp18 down one cell.19 20 !21 22 23 Mon 08-Feb-88 12:45 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   ENO CHANGE!Nc7 VALUE a b c d e f g h i1 EXPENSE REPORT 2 3 4 5 6 Air, rail, bus 450 7 Rental car 8 Daily lodging 9 Meals 10 Entertainment 11 12 13 14 Total Expenses 15 Less Advances 016 BalDueToEmp 17 BalDueFromEmp Enter the number 40 into your worksheet.18  19 020 21 22 23 Mon 08-Feb-88 12:45 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ) NO CHANGE!wNc7 VALUE4 a b c d e f g h i1 EXPENSE REPORT 2 3 4 5 6 Air, rail, bus 450 7 Rental car 8 Daily lodging 9 Meals 10 Entertainment 11 12 13 14 Total Expenses 15 Less Advances 16 BalDueToEmp 17 BalDueFromEmp 18 19 20 21 22 23 Mon 08-Feb-88 12:45 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T I VNO CHANGE!hwNc7 VALUE40 a b c d e f g h i1 EXPENSE REPORT 2 3 4 5 6 Air, rail, bus 450 7 Rental ca r 8 Daily lodging 9 Meals 10 Entertainment 11 12 13 14 Total Expenses 15 Less Advances 16 BalDueToEmp 17 BalDueFromEmp 18 19 20 21 22 23 Mon 08-Feb-88 12:45 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!ZNc7 40 READY a b c d e f g h i1 EXPENSE REPORT 2 3 4 5 6 Air, rail, bus 450 7 Rental car 40 8 Daily lodging 9 Meals 10 Entertainment 11 !12  13 Excellent. Now you're going to learn something new.14 To15 LeUse the Copy command to copy the value 40 into cells, d7 and e7.16 Ba17 BaD18 319 20 To do this, first display the command menu.21 22 323 Mon 08-Feb-88 12:45 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T +X =eNO CHANGE!wNc7 40 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 EXPENSE REPORT 2 3 4 5 6 Air, rail, bus 450 7 Rental car 40 8 Daily lodging 9 Meals )10 Entertainment 11 Good! Next, select the Copy command.12 13 )14 Total Expenses 15 Less Advances (16 BalDueToEmp 17 BalDueFromEmp18 To do this, typecfor Copy.19 20 21 (22 23 Mon 08-Feb-88 12:46 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T    :# !G#NO CHANGE!Y#Nc7 40 POINTEnter range to copy FROM: c7..c7 O / a b c d  e f g h i1 EXPENSE REPORT 2 -3 4 A prompt displays the range of cells that5 6 Air, rail, bus 450 you want to copy. In this case, the 7 Rental car 40 8 Daily lodging range consists of just one cell, c7.9 Meals 10 Entertainment -11 12 *13 14 Total Expenses You don't need to change anything,15 Less Advances 16 BalDueToEmp so just press Return.17 BalDueFromEmp18 *19 20 21 22 23 Mon 08-Feb-88 12:47 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T---- ---"""9' F'NO CHANGE!X'hNc7 40 POINTEnter range to copy FROM: c7..c7 Enter range to copy TO: c7 O  a b c d e f g h i1 EXPENSE REPORT &2 Another prompt displays the range of cells3  4 that you will copy to.5 .6 Air, rail, bus 450 7 Rental car 40 8 Daily lodging 9 Meals .10 Entertainment 11 In this case, the range consists of cells,12 13 d7 and e7. So, the next step is to14 Total Expenses 15 Less Advances define the range.16 BalDueToEmp17 BalDueFromEmp.18 19 6 20  21  To do this, first press the Right Arrow key.22  23  Mon 08-Feb-88 12:47 PM6 Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T... !" "+ O+NO CHANGE!+NMc7 40 POINTEnter range to copy FROM: c7..c7 Enter range to copy TO: d7  C  a b c d e f g h i1 EXPENSE REPORT 2 3 4 The cell pointer moves to5 6 Air, rail, bus 450 cell d7 and the prompt is7 Rental car 40 8 Daily lodging updated. 9 Meals 10 Entertainment 11 12 '13 d7 is the first cell of the range.14 Total Expenses 15 Less Advances Anchor the cell pointer at cell d7.16 BalDueToEmp'17 BalDueFromEmp18 "19 20 To do this, type a period.21 22 "23 Mon08-Feb-8812:47PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T /  !0NO CHANGE!0N/d7 POINTEnter range to copy FROM: c7..c7 Enter range to copy TO: d7..d7 O  a b c d e f g h  i1 EXPENSE REPORT 2& 3& The prompt is updated once more.4& 5& $6 Air, rail, bus 450 7 Rental car 40 8 Daily lodging 9 Meals '10 Entertainment  11 Next, define the rest of the range, 12  13 which in this case is e7.14 Total Expenses  15 Less Advances '16 BalDueToEmp "17 BalDueFromEmp 18 To do this, press the19 20 Right Arrow key once more.21 22 "23& Mon 08-Feb-88 12:48 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$$$    4 "4NO CHANGE!+4DNce7 POINTEnter range to copy FROM: c7..c7 Enter range to copy TO: d7..e7 O  a b c d e f g h  i1 EXPENSE REPORT2 3 The prompt is updated4 5 to reflect the new6 Air, rail, bus 450 7 Rental car 40 range and cell e7 is8 Daily lodging 9 Meals highlighted.10 Entertainment 11 12 .13 14 Total Expenses The range to copy to has now been defined.15 Less Advances 16 BalDueToEmp.17 BalDueFromEmp%18 19 To complete the Copy command,20 21 press Return.22 23 %Mon 08-Feb-88 12:48 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T%%%%%o8 H|8NO CHANGE!8Nc7 40 READY a b c d e f g h i1 EXPENSE REPORT 20 30 Great! You've just 40 50 learned how to use6 Air, rail, bus 450 7 Rental car 40 40 40 the Copy command.8 Daily lodging 9 Meals 10 Entertainment 11 12 '13  14 Total Expenses Use the Down Arrow key to move15 Less Advances 16 BalDueToEmp the cell pointer down one cell.17 BalDueFromEmp18 '19 20 21 22 23 Mon 08-Feb-88 12:49 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T )#'').< 1;<NO CHANGE!M<N+c8 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 9 Meals 10 Entertainment 11 312 13 14 Total Expenses Enter the value68into your worksheet.15 Less Advances 16 BalDueToEmp17 BalDueFromEmp318 19 20 21 22 23 Mon 08-Feb-88 12:49 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 33?? L?NO CHANGE!^?wNc8 VALUE6 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 9 Meals 10 Entertainment 11 12 13 14 Total Expenses 15 Less Advances 16 BalDueToEmp 17 BalDueFromEmp 18 19 20 21 22 23 Mon 08-Feb-88 12:49 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T A ANO CHANGE!AwNc8 VALUE68 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 9 Meals 10 Entertainment 11 12 13 14 Total Expenses 15 Less Advances 16 BalDueToEmp 17 BalDueFromEmp 18 19 20 21 22 23 Mon 08-Feb-88 12:49 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T kD  xDNO CHANGE!DNd8 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 682 9 Meals 10 Entertainment -11  12 Good! Now use the Copy command to copy13  14 Total Expenses the value 68 to cells, d8 and e8.15 Less Advances  16 BalDueToEmp-17 BalDueFromEmp/18  19  What is the first thing you need to do?20  21  Press Help if you don't remember.22  23 /Mon 08-Feb-88 12:50 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ""*** H -HNO CHANGE!?HNc8 68 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 9 Meals 10 Entertainment (11 12 That's right. The first thing to do13 14 Total  Expenses is display the command menu.15 Less Advances 16 BalDueToEmp(17 BalDueFromEmp18 ,19  20  You want to copy, so what do you do?21  22 ,23 Mon 08-Feb-88 12:54 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T K %KNO CHANGE!LNc8 68 POINTEnter range to copy FROM: c8..c8  O ' a b c d e  f g h i1 EXPENSE REPORT 2 Right. Type c for Copy and the first prompt displays.3  *  4 Cell c8 is the cell that you want to copy from.  5 :6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 9 Meals 10 Entertainment 111 12 You want to copy cell c8 to cells, d8 and e8.13 14 Total Expenses 115 Less Advances 16 BalDueToEmp(17 BalDueFromEmp 18 Do you remember what to do next?19 20 (21 22 23 Mon 08-Feb-88 12:54 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T::: (((O 8ONO CHANGE!ONc8 68 POINTEnter range to copy FROM: c8..c8 Enter range to copy TO: c8 O  a b c d e f g  h i1 EXPENSE REPORT #2 That's right. Press Return and3 4 the second prompt displays.5 #6 Air, rail, bus 4507 Rental car 40 40 40 8 Daily lodging 68 9 Meals 10 Entertainment 11 "12 13 Define the range to copy TO.14 Total Expenses 15 Less Advances "16 BalDueToEmp17 BalDueFromEmp 18 19  Remember how to do that?20  21 22 23 Mon 08-Feb-88 12:54 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T###    S *SNO CHANGE!SNd8 POINTEnter range to copy FROM: c8..c8 Enter range to copy TO: d8j a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 #9 Meals 10 Entertainment That's right. You had to press11  12  the Right Arrow to move13  14 Total Expenses the cell pointer to cell d8.15 Less Advances 16 BalDueToEmp #17 BalDueFromEmp18 $19  20  Now anchor the cell pointer. 21  22 $23 Mon 08-Feb-88 12:55 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T $$$RW ._WNO CHANGE!qWNd8 POINTEnter range to copy FROM: c8..c8 Enter range to copy TO: d8..d8f a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 682 9 Meals $10 Entertainment 11 Right again. You anchor the12  13 cell pointer by typing a period.14 Total Expenses 15 Less Advances $16 BalDueToEmp17 BalDueFromEmp18 You're almost there.19 20 What do you do next?21 22 23 Mon 08-Feb-88 12 :55 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T [ K[NO CHANGE!#[Ne8 POINTEnter range to copy FROM: c8..c8 Enter range to copy TO: d8..e8f a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 682 9 Meals 10 Entertainment (11 12 Right. You define the rest of your13  14 Total Expenses range by moving the cell pointer to15 Less Advances 16 BalDueToEmp cell e8, the last cell in the range.17 BalDueFromEmp18 (19 "20 21 Finally, perform the copy.22 23 "Mon 08-Feb-88 12:55 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T^ K^NO CHANGE!^BNc8 68 READY a b c d e f g h i1 EXPENSE REPORT 2/ 3/ 4/ 5/ 6 Air, rail, bus 450 EXCELLENT!7 Rental car 40 40 408 Daily lodging 68 68 68Pressing Return9 Meals 10 Entertainment performed the Copy.11 12 13 14 Total Expenses 15 Less Advances ,16 BalDueToEmp 17 BalDueFromEmp Now move the cell pointer down once.18 19 ,20 21 22 23 Mon 08-Feb-88 12:55 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  ('b I4bNO CHANGE!FbNEc9 VALUE a b c d e f g h i1 EXPENSE REPORT!  22  32 Enter another row of 42  52 values. This time, 6 Air, rail, bus 450  7 Rental car 40 40 40 you're not going to 8 Daily lodging 68 68 68  9 Meals use Copy.10 Entertainment 11 12 13 '14 Total Expenses 15 Less Advances First, enter the value 25 ,16 BalDueToEmp 17 BalDueFromEmpbut instead of pressing Return,18 19 press the Right Arrow.20  21 22 '23 Mon 08-Feb-88 12:56 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T    Xf efNO CHANGE!wfeNc9 VALUE2 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 MealsE 10 Entertainment= 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:56 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T h hNO CHANGE!hN!c9 VALUE25 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 10 Entertainment 11 12 13 14  Total Expenses 15 Less Advances Press the Right Arrow.16 BalDueToEmp 17 BalDueFromEmp 18 19 20 21 22 23 Mon 08-Feb-88 12:56 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T k 9kNO CHANGE!kNd9 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 252 10 Entertainment 11 /12  13 Using the Arrow keys instead of Returnwill14 Total Expenses  15 Less Advances automatically advance you to the next cell.16 BalDueToEmp 17 BalDueFromEmp/18 /19  20  Enter the value 25 into your worksheet, 21  22  using the Right Arrow again. 23  Mon 08-Feb-88 12:56 PM / Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T /////|o oNO CHANGE!ojNd9 VALUE2 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 252 10 Entertainment= 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:57 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T r rNO CHANGE!$rNd9 VALUE25 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 252 10 Entertainment 11 12 13 14 Total Expenses 15 Less Advances 16 BalDueToEmp 17 BalDueFromEmp 18 19 20 21 22 23 Mon 08-Feb-88 12:57 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T t MtNO CHANGE!tNae9 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25) 10 Entertainment= 11N 12N 13 + 14 Total Expenses # 15 Less Advances  And enter 25 one last time. 16 BalDueToEmp  17 BalDueFromEmp  18  This time, use the Down Arrow . 19  20 + 21N 22N 23N Mon 08-Feb-88 12:57 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  w wNO CHANGE!woNe9 VALUE2 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25) 10 Entertainment= 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:57 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  fz szNO CHANGE!zNe9 VALUE25 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25) 10 Entertainment 11 12 13 14 Total Expenses 15 Less Advances 16 BalDueToEmp17 BalDueFromEmp18 19 20 21 22 23 Mon 08-Feb-88 12:57 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  } }NO CHANGE!(}vNe10 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment= 11 12 #13 Finally, you are going to enter14 Total Expenses 15 Less Advances a value into cell d10.16 BalDueToEmp#17 BalDueFromEmp-18  19  Press the appropriate arrow key 20  21  to move the cell pointer to cell d10. 22  23 -Mon 08-Feb-88 12:57 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ----- 9NO CHANGE!NNd10 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment= 11 12 13 314 Total Expenses  15 Less Advances  Enter the value75into your worksheet,16 BalDueToEmp 17 BalDueFromEmp18  19  this time usingReturn .20  21 322 23 Mon 08-Feb-88 12:58 PM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!*uNd10 VALUE7 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment= 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:58 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!tNd10 VALUE75 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment= 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:58 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2  O?NO CHANGE!QNd10 75 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lod ging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances 16 BalDueToEmp 17 BalDueFromEmp 18 19 20 21 22 23 Mon 08-Feb-88 12:58 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  ANO CHANGE!N5d10 75 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances 16 BalDueToEmp  A job well done!17 BalDueFromEmp  18 (Press Next Page to continue)19 20 21 22 23 Mon 08-Feb-88 12:58 PM Macro   time 4 ~ You are practicing entering numbers ~ ~ ~ ~ into your worksheet. ~ ~~ ~ Dismiss this message and type '4' ... ~ 4 5 ~ You are practicing entering numbers ~ ~~ ~ into your worksheet. ~ ~~ ~ Dismiss this message and type '5' ... ~ 5 0 ~ You are practicing entering numbers ~ ~~ ~ into your worksheet. ~ ~~ ~  Dismiss this message and type '0'. ~ 0 0x0A ~You just typed in a value. Now, to enter it into ~ ~~ ~ your worksheet, you must press Return. ~ ~~ ~ Dismiss this message and press Return. ~ Return ~If you pressed the f5 key, Go To, you had the ~ ~right idea. However, since you're just moving ~ ~one cell down, use the Down Arrow key instead. ~ ~ ~ ~Dismiss this message and press Down Arrow. ~ DownArrow 4 ~ The number to enter is 40. ~ ~ ~ ~~ ~~ ~ Dismiss this message and type '4' ... ~ 4 0 ~The value you are currently typing in is 40. ~ ~~ ~~ ~~ ~Dismiss this message and type '0'. ~ 0 0x0A ~ You just finished typing the number 40. ~ ~ To enter this number into your worksheet, ~ ~ press Return. ~ ~~ ~ Dismiss this message and press Return. ~ Return / ~To display the command menu, type a slash. The ~ ~command menu must first be displayed in order ~ ~to use any of the commands. ~ ~~ ~Dismiss this message and type '/'. ~ Slash c ~To select a command, type in the first letter ~ ~~ ~of the command name. ~ ~~ ~Dismiss this message and press 'c' for Copy. ~ c 0x0A Return  RightArrow . Period  RightArrow 0x0A Return DownArrow 6 ~The number to enter is 68.  ~ ~ ~ ~~ ~~ ~Dismiss this message and type '6' ... ~ 6 8 ~The number you are currently typing in is 68. ~ ~~ ~~ ~~ ~Dismiss this message and type '8'. ~ 8 0x0A ~You just finished typing in the value. To enter ~ ~ ~ ~the value into your worksheet, press Return. ~ ~~ ~Dismiss this message and press Return. ~ Return / ~In order to use the Copy comm and, or any other ~ ~command, you must first display the command menu. ~ ~~ ~ ~ ~Dismiss this message and type '/'. ~ c ~Select the Copy command by typing in the first ~ ~letter of the command name. ~ ~~ ~ ~ ~Dismiss this message and type 'c'. ~ 0x0A ~Since your range to copy FROM is what you want, ~ ~press RETURN to display the next Copy command  ~ ~prompt. ~ ~~ ~Dismiss this message and press Return. ~  ~To copy cell c8 to the cells, d8 and e8, define ~ ~the COPY TO range to be d8..e8. ~ ~First, set the beginning cell to d8. ~ ~ ~ ~Dismiss this message and press Right Arrow. ~ . ~The beginning cell is now set to d8. To anchor ~ ~the cell pointer at cell d8, type a period (.). ~ ~~ ~~ ~Dismiss this message and type '.' . ~  ~Define the rest of your range. In this case, ~ ~move the cell pointer to highlight one more ~ ~cell, e8. ~ ~~ ~Dismiss this message and press Right Arrow. ~ 0x0A ~Your range is now defined. To perform the copy, ~ ~~ ~press Return. ~ ~~ ~Dismiss this message and press Return. ~ DownArrow 2 ~The value to enter is 25. ~ ~~ ~~ ~~ ~Dismiss this message and type '2' ... ~ 5 ~The value you are currently typing in is 25. ~ ~~ ~~ ~~ ~Dismiss this message and type '5'. ~  RightArrow 2 ~The value to enter is 25. ~ ~~ ~~ ~~ ~Dismiss this message and type '2' ... ~ 5 ~The value you are currently typing in is 25. ~ ~~ ~~ ~~ ~Dismiss this message and type '5'. ~  ~You just finished typing in a value. To enter it ~ ~~ ~ into your worksheet, press the Right Arrow. ~ ~~ ~ Dismiss this message and press the Right Arrow. ~ 2 2 5 5 ~ Use Down Arrow instead of Return to enter the ~ ~~ ~ value into your worksheet. ~ ~~ ~ Dismiss this message and press Down Arrow. ~ DownArrow  ~ Use Left Arrow to move the ~ ~ ~ ~ cell pointer to cell d10. ~ ~~ ~ Dismiss this message and press Left Arrow. ~ 7 ~The value to type in is 75.  ~ ~~ ~~ ~~ ~Dismiss this message and type '7' ... ~ 5 ~The value you are currently typing in is 75. ~ ~~ ~~ ~~ ~Dismiss this message and type '5'. ~ 0x0A ~ To enter the value you just typed in, ~ ~ ~ ~ press Return. ~ ~~ ~ Dismiss this message and press Return. ~ time time2am c9 JHPN  NO CHANGE!+N9;I T ' S T I M E T O S E EW H A T Y O U H A V E L E A R N E D . . .;.3333 2am fe JHPN  ONO CHANGE!+N'! BNO CHANGE!fNCreatingaWorksheet5Entering text or numbers is basicallya three-step process:1)Move cell pointer to desired cell,2)Type in your text or numbers,'3)Press Return!To move the cell pointer,1)Use the Arrow keys, OR2)Use the Go To function (F5)To Copy the contents of one or morecells to a different location,type c for the Copy command. 5.%h#2am re JHPN   NO CHANGE!+rNCreatingaWorksheet5To enter text or numbers and automaticallyadvance the cell pointer to the next cell,press one of the Arrow keys rather thanpressing Return.'To Save your worksheet,!type f to display the File commands, thentype s to select Save.To Erase your entire worksheet,type w to display the Worksheet commands,then type e to select Erase.  5.*):2am dM JHPN  GNO CHANGE!+NCreatingaWorksheet5To Retrieve a worksheet,type f to display the File commands, thentype r to select Retrieve.'Another way to move the cell pointerܱ!is to press the Go To function key, F5,and type the cell address to go to. 5$w 2am e/ JHPN   NO CHANGE!+NCreatingaWorksheet5To Retrieve a worksheet,typeftodisplaytheFilecommands,thenYouhavereachedthetypertoselectRetrieve.endofthislesson.We suggest you proceedAnother way to move the cell pointer to the next lesson,istopresstheGoTofunctionkey,F5, Modifying an Existingandtypethecelladdresstogoto. Worksheet. Press Next Page to return to the Using menu.! 555 5&5&555 $555 21 5555555552am 0d JHPN   NO CHANGE!+N  @ MNO CHANGE!_N"D DDD DDhing you wilDDer text and D")77"DDDDDDDDDDD" t   %q< INO CHANGE![ N888888irst thing you will lear8how to enter text and numbers.)77888888888h!%qf sNO CHANGE!$N,$,,,$,The first thing you will learn ishow to enter text and numbers.)77,,,,,,,$]!!!%q NO CHANGE!0NCreat2_7)The first thing you will learn ishow to enter text and numbers.)772V!!!%q NO CHANGE!NCreating a WorksheetP77)The first thing you will learn ishow to enter text and numbers.)77PG!!!%q 2am e JHPN   NO CHANGE!+Ntc2 READYHelloG O a b c d e f g h i1 2 Hello 3 4 5 6 7 8 9 10 11 12 Let's review that again.13 14 15 16 17 18 19 20 21 22 23 Mon08-Feb-8812:29PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am f~ JHPN   NO CHANGE!+.N~c2 READYHelloM a b c d e f g h i1 2 Hello 3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12  .13 14 15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&.Y fNO CHANGE!x7Nc2 READYHelloM a b c d e f g h i1 2 Hello 3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 .13 14 15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&. NO CHANGE!CNc2 READYHelloM a b c d e f g h i1 2 Hello 3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 .13 14 15 16 17 18 19 20 21 22 23  Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&.  NO CHANGE!0 LNc2 READYHelloM a b c d e f g h i1 2 Hello 3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 .13 14 15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&.|   NO CHANGE! MNc2 READYHelloM a b c d e f g h i1 2 Hello  3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 .13 14 15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&.  NO CHANGE!HNd2 READYM a b c d e f g h i1 2 Hello  3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 .13 14 15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&.O \NO CHANGE!nHNe2 READYM a b c d e f g h i1 2 Hello  3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 .13 14 15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&. 4NO CHANGE!gNe2 READYM a b c d e f g h i1 2 Hello 3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 2)Type in your label or value.13 14 .15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&.! .< INO CHANGE![jNe2 READYM a b c d e f g h i1 2 Hello 3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 2)Type in your label or value.13 14 .15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table   Calc  Graph T .&.! . %NO CHANGE!wNe2 READYM   a b c d e f g h i1 2 Hello 3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 2)Type in your label or value.13 14 .15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&.! .[ %hNO CHANGE!zNe2 READYM a b c d e f g h i1 2 Hello 3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 2)Type in your label or value.13 14 .15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&.! .  % NO CHANGE!Ne2 READY D a b c d e f g h i1 2 Hello 3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 2)Type in your label or value.13 14 .15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&.! . NO CHANGE!Ne2 VALUE1 D a b c d e f g h i1 2 Hello 3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 2)Type in your label or value.13 14 .15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&.! .m" z"NO CHANGE!"Ne2 VALUE12 D a b c d e f g h i1 2 Hello 3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 2)Type in your label or value.13 14 .15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&.! .%%  2%NO CHANGE!D%Ne2 VALUE123 D a b c d e f g h i1 2 Hello 3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 2)Type in your label or value.13 14 .15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&.! .'  'NO CHANGE!' Ne2 VALUE123 D a b c d e f g h i1 2 Hello 3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 2)Type in your label or value.13 14 3)Press Return.15 16 .17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&.! ..* *NO CHANGE!*Ne2 VALUE123 D a b c d e f g h i1 2 Hello 3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 2)Type in your label or value.13 14 3)Press Return.15 16 .17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&.! ..h- u-NO CHANGE!-Ne2 VALUE123 D a b c d e f g h i1 2 Hello 3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 2)Type in your label or value.13 14 3)Press Return.15 16 .17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&.! ..D0 Q0NO CHANGE!c0Ne2 VALUE123 D a b c d e f g h i1 2 Hello 3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 2)Type in your label or value.13 14 3)Press Return.15 16 .17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&.! ..,3  93NO CHANGE!K3Ne2 VALUE123 D a b c d e f g h i1 2 Hello 3 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 2)Type in your label or value.13 14 3)Press Return.15 16 .17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&.! ..6  "6NO CHANGE!46Ne2 READY123 D a b c d e f g h i1 2 Hello 1233 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 2)Type in your label or value.13 14 3)Press Return.15 16 .17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit   Name Abs  Go To  Window Query Table  Calc  Graph T .&.! ..9 %9NO CHANGE!"9N+e2 READY123 D a b c d e f g h i1 2 Hello 1233 4 5 6 7 8 .9 10 1)Move cell pointer to desired cell.11 12 2)Type in your label or value.13 14 3)Press Return.15 16 (Press Next Page to Continue.)17 18 .19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .&.! ....2am d JHPN  ONO CHANGE!+<NCreatingaWorksheetPp Ppg OtNO CHANGE!N.CreatingaWorksheetP???1Along with this basic three-step process,you will learn alternate ways to move thecell pointer and enter labels and values.1???) P11111112am d= JHPN  ONO CHANGE!+NNCreatingaWorksheetP77)The first thing you will learn ishow to enter text and numbers.(Text will also be referred to aslabels, and numbers as values.))77 PG!!!!!%2am fy   JHPN  ONO CHANGE!+N#a1 READY a b c d e f g h i1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] <NO CHANGE!Na1 READY a b c d e f g h i1 2 3 4 5 6 (7 8 When you open a new worksheet,9 10 the worksheet is in READY mode,11 12 in other words, ready to accept13 14 labels and values that you enter.15 16 (17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ](       ( :NO CHANGE!Na1 READY a b c d e f g h i1 2 3 4 5 6 (7 8 When you open a new worksheet,9 10 the worksheet is in READY mode,11 12 in other words, ready to accept13 14 labels and values that you enter.15 16 (17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ](       ( : NO CHANGE! Na1 READY a b c d e f g h i1 2 3 4 5 6 (7 8 When you open a new worksheet,9 10 the worksheet is in READY mode, 11 12 in other words, ready to accept13 14 labels and values that you enter.15 16 (17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ](       ( : NO CHANGE! Na1 READY a b c d e f g h i1 2 3 4 5 6 (7 8 When you open a new worksheet,9 10 the worksheet is in READY mode,11 12 in other words, ready to accept13 14 labels and values that you enter.15 16 (17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ](       ( :NO CHANGE!Na1 READY a b c d e f g h i1 2 3 4 5 6 (7 8 When you open a new worksheet,9 10 the worksheet is in READY mode,11 12 in other words, ready to accept13 14 labels and values that you enter.15 16 (17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc    Graph ](       ( :NO CHANGE! Na1 READYM O a b c d e f g h i1 2 3 4 5 6 (7 8 When you open a new worksheet,9 10 the worksheet is in READY mode,11 12 in other words, ready to accept13 14 labels and values that you enter.15 16 (17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ](       (2am e JHPN  NO CHANGE!+Na1 READYM O a b c d e f g h i1 2 3 4 5 26 7 Solution Designer uses the first character8 9 you type to determine whether you are10 11 typing a label or a value.12 13 214 15 16 17 18 19 20 21 22 23 Mon08-Feb-8812:29PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]22222222am f JHPN  =NO CHANGE!+N 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances 16 BalDueToEmp 17 BalDueFromEmp 18 19 20 21 22 23 Mon 08-Feb-88 1:07 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph KTLLLLLLLLL (LLLLLLLLLLLL ONO CHANGE!Nd10 75 MENU  a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4 @ 5 @ 6 Air, r@ 7 Rental2 8 Daily  9 Meals You've done quite a bit of work so far 10 Entert 11 and you sure don't want to lose any of it.12 13 Therefore, it's a good idea14 Total 15 Less Ato save your worksheet at this time.16 BalDu17 BalDu218 @19 @20 @21 22 23 Mon 08-Feb-88 1:07 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph KTLLL2222222222++LLsheetOpenan existing worksheetn P% F=L )#VO%(3 70  NO CHANGE! NRCreating a WorksheetPNIn this lesson, you will learn how toEnter text, or labels, into your worksheetUse the Go To (F5) function keyEnter numbers, or values, into your worksheetCopy information in your worksheetSave your worksheetErase an entire worksheetOpen an existing worksheetRPN%BBBBB0,# 0NN@Solution Designer makes it easy for anyoneto produce reports filled with numbers and calculations.A simple example would be an Expense Report.@NNN,88888=ub oNO CHANGE!NACreating a WorksheetPNNN@Solution Designer makes it easy for anyoneto produce reports filled with numbers and calculations.A simple example would be an Expense Report.@NNNP88888=u2am i JHPN  :NO CHANGE!+NySolution Designer Help Copying Cell Contentsp COMMAND PATH: /c (or Copy) DESCRIPTION: T/ cell or group of cells  The name and title of every Help window is  PROCEDURE: To displayed in the Help Table of Contents.  1 Make suTo display the Table of Contents, press the  2 Move thCONTENT (F1) function key.lls) you want to copy / 3 Type: /c The curso* selecting the Copy comm$ Do this right now. Press f1 . 4 Select th$ * If your cursor is not on the beginning of the range you want to copy, type the beginning cell address followed by a period (.), then move the cursor to indicate ending cell address in the range and press Press NEXT PAGE for more information.+ CONTENTUSEHELPCOMMAND RANGE  MOVE  FILE  CURSOR CELLREF  p  $ $$$$%+F  SNO CHANGE!eNTable of Contents? Using Help - How to Use the HELP Facility Topics - Main Solution Designer Help Topics Move Cursor - Moving within a Worksheet Cell References - Using Cell References$ Formulas - Entering Formulas( Functions - Using Functions* Menu Mode - Using MENU Mode* Modes - Mode Indicators* Saving - Saving the Worksheet% Exiting - Exiting from the program! Commands - Using Solution Designer Commands Worksheet - Using Worksheet Commands! Global - Using Worksheet Global Commands G.Format - Using the Global Format Command G.Label-Prefix - Using the Global Label-Prefix Command G.Column-Width - Using the Global Column-Width Command Recalculation - Using the Global Recalculation Command Protection - Using Worksheet Global Protection Global Default - Using the Global Default Command Insert - Inserting Blank Columns and Rows Delete - Deleting Columns and Rows Column-Width - Changing the Width of Selected Columns Erase - Erasing the Entire Worksheet Titles - Using the Worksheet Titles Command Window - Splitting Worksheet Windows Status - Displaying Worksheet Status Select desired topic and press RETURN{ 3%C OP NO CHANGE!b NTable of Contents, Using Help - How to Use the HELP Facility Topics - Main Solution Designer Help Topics Move Cursor - Moving within a Worksheet Cell References - Using Cell References These are the Formulas - Entering Formulas Functions - Using Functions different HelpMenu Mode - Using MENU Mode Modes - Mode Indicators topics. PressSaving - Saving the Worksheet Exiting - Exiting from the program Commands - Using Solution Designer Commands Next PageWorksheet - Using Worksheet Commands Global - Using Worksheet Global Commands G.Format - Using the Global Format Command to display G.Label-Prefix - Using the Global Label-Prefix Command G.Column-Width - Using the Global Column-Width Command the next pageRecalculation - Using the Global Recalculation CommandProtection - Using Worksheet Global Protection of topics.Global Default - Using the Global Default Command Insert - Inserting Blank Columns and Rows Delete - Deleting Columns and Rows Column-Width - Changing the Width of Selected ColumnsErase - Erasing the Entire Worksheet Titles - Using the Worksheet Titles Command Window - Splitting Worksheet Windows Status - Displaying Worksheet Status Select desired topic and press RETURN = 3 1%}  :NO CHANGE!NTable of Contents? Status - Displaying Worksheet Status Range - Using Range Commands% Range Format - Using the Range Format Command Label-Prefix - Using the Range Label-Prefix Command Range Erase - Erasing the Contents of a Cell or Group of Cells Name - Using Range Names( Protect - Using the Range Protect Command Unprotect - Using the Range Unprotect Command Input - Using the Range Input Command Justify - Using the Range Justify CommandCopy - Copying Cell Contents Move - Using the Move Command File - Using File Commands Retrieve - Retrieving Worksheet Files Combine - Combining Worksheets Xtract - Using the File Xtract Command Import - Using the File Import Command Print - Using Print Commands Print Range - Selecting a Range to Print Print Options - Using Print Options Header/Footer - Using the Headers and Footers Print Options Data - Using Data Commands& Data Ranges - Creating Data Ranges% Criterion - Using the Criterion Range Data Fill - Using the Data Fill Command Data Table $ - Using the Data Table Commands Select desired topic and press RETURN{ 2%] OjNO CHANGE!|N)Table of Contents? Status - Displaying Worksheet Status Range - Using Range Commands% Range Format - Using the Range Format Command Label-Prefix - Using the Range Label-Prefix Command Range Erase - Erasing the Contents of a Cell or Group of Cells Name - Using Range Names( Protect - Using the Range Protect Command  Unprotect - Using the Range Unprotect Command Input - Using the Range Input Command And pressJustify - Using the Range Justify CommandCopy - Copying Cell Contents Next Page onceMove - Using the Move Command File - Using File Commands moreto displayRetrieve - Retrieving Worksheet Files Combine - Combining Worksheets the last pageXtract - Using the File Xtract Command Import - Using the File Import Command of topics.Print - Using Print Commands Print Range - Selecting a Range to Print Print Options - Using Print Options Header/Footer - Using the Headers and Footers Print Options Data - Using Data Commands& Data Ranges - Creating Data Ranges% Criterion - Using the Criterion Range Data Fill - Using the Data Fill Command Data Table - Using the Data Table Commands Select desired topic and press RETURN{ 29%  O NO CHANGE!LN/Table of Contents? Import - Using the File Import Command Print - Using Print Commands% Print Range - Selecting a Range to Print Print Options - Using Print Options& Header/Footer - Using the Headers and Footers Print Options Data - Using Data Commands Data Ranges - Creating Data Ranges Criterion - Using the Criterion Range Data Fill - Using the Data Fill Command Data Table - Using the Data Table Commands Data Sort - Using the Data Sort Command Data Query - Using the Data Query Commands Data Find - Using the Data Query Find Command Data Xtract - Using the Data Query Extract Command Data Unique - Using the Data Query Unique Command Data Delete - Using the Data Query Delete Command Distribution - Using the Data Distribution Command Advanced Commands - Using Advanced Commands Macro - Using the Advanced Record-Macro Command Link - Using the Advanced Link Command Goal-Seeking - Using the Advanced Goal-Seeking Command Advanced Automatic - Using the Advanced Automatic Cursor Command Advanced Move - Using the Advanced Move Command Advanced Defaults - Using Advanced Defaults" Advanced Width - Using the Advanced Width Command Quit - Using the Quit Command# Select desired topic and press RETURN{ 4%g!  Bt!NO CHANGE!!N`Table of Contents? Import - Using the File Import Command Print - Using Print Commands% Print Range - Selecting a Range to Print Print Options - Using Print Options& Header/Footer - Using the Headers and Footers Print Options Data - Using Data Commands Data Ranges - Creating Data Ranges Criterion - Using the Criterion Range Data Fill - Using the Data Fill Command  Press Data Table - Using the Data Table Commands Data Sort - Using the Data Sort Command Next PageData Query - Using the Data Query Commands Data Find - Using the Data Query Find Command when readyData Xtract - Using the Data Query Extract Command Data Unique - Using the Data Query Unique Command to continueData Delete - Using the Data Query Delete Command Distribution - Using the Data Distribution Command Advanced Commands - Using Advanced Commands Macro - Using the Advanced Record-Macro Command Link - Using the Advanced Link Command Goal-Seeking - Using the Advanced Goal-Seeking Command Advanced Automatic - Using the Advanced Automatic Curso% r Command Advanced Move - Using the Advanced Move Command Advanced Defaults - Using Advanced Defaults" Advanced Width - Using the Advanced Width Command Quit - Using the Quit Command# Select desired topic and press RETURN{ 49"%2am cY JHPN  %NO CHANGE!+NHow To Get Help in Solution DesignerPRVery good!To return to your worksheet from any Help screen,just press the Finish key.Note that the Cancel key works just as well.$P2am $c P Gintro>help>FIB2.a002&$Lintro>help>FIB2.common.pathork with one cell at a time,or you can work with a group of cells known as a cell range.3pP=. ONO CHANGE! NWhat Is a Range?P3When creating or modifying a worksheet,you can choose to work with one cell at a time,or you can work with a group of cells known as a cell range.3P=. NO CHANGE!NWhat Is a Range?P3When creating or modifying a worksheet,you can choose to work with one cell at a time,or you can work with a group of cells known as a cell range.3~P=. Edit  Name Abs  Go To  Window Query Table  Calc  Graph T #  ###% 2am f JHPN   NO CHANGE!+Na1MENU WorksheetRangeCopyMoveFilePrintGraphDataAdvancedQuitCopyoneormorecells a b c d e f g h i1 2 3 94 95 +6 7 There are two ways that you can8 9  finish from Solution Designer:10 11 12 Use the Quit command13 14 Press the Finishkey15 16 +17 918 919 20 21 22 23 Fri05-Feb-8810:05AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]++++++++++( JHPN  1NO CHANGE!+NQuestion 2Modifying an Existing WorksheetPCell c9 contains the following information: c9 [W14] 150Which of the following statements is true?eF1 - The cell pointer is at column w, row 14.F2 - Cell c9 contains the value, 150, currently displayed in monetary form.F3 - The width of column c is 14.F4 - None of the above(Select your answer by pressing one of the indicated selections)P3333333--------@mfd.syslog.sysfileHeaders.sysmfd.syslog.sys sysImage.sys badBlk.sys crashDump.sysOCID??& ySD-3monetc0fw*g/% LysSD 9|M^SysSD 9{8nfileHeaders.sys Sys30f0f0f mfd.sys Sys30f0fgdlog.sysSys0f0f0fY sysImage.sysSys0f0f0f@ badBlk.sysSys0f0f0f& " crashDump.sysSys0f0f0fIntro>Help>FIB2 sd30fEfEfintro>help>FIB2.a000 sd30fffp intro>help>FIB2.a000.path sd 30fffJ k intro>help>FIB2.answers sd 30fffFi intro>help>FIB2.a999 sd 30fffm intro>help>FIB2.a999.path sd 30fffJ( intro>help>FIB2.common.path sd 30fffN' F>Intro>Help>Get sd30fff  h intro>help>initial.path sd30f`Ef`Ef&@intro>help>qseg1 sd30fiFfBf*D!intro>help>seg sd31fFff{..>intro>help>tw1 sd31f1f1f,Hintro>help>tw1.pedal sd31f1f1fXintro>help>tw2 sd3 1fWf>f Zintro>help>tw2.pedal sd31fWf>fx' tintro>finish>e.1 sd31f8f'gEzintro>finish>e.2 sd31f8fwAf`~߼intro>finish>e.3 sd31f8fyAfn%intro>finish>F.1 sd31f1fg 6intro>finish>F.2 sd31f!1fg intro>finish>F.3 sd3"1f$1fgT  intro>finish>FIB1 sd3%1fEfAfJintro>finish>fib1.a000 sd3(1f2f>fW( 6'intro>finish>FIB1.A000.Path sd3+1f-1f?fNintro>finish>fib1.a999 sd3.1ffAf intro>finish>FIB1.A999.Path sd 321f41fAfN_ !intro>finish>FIB1.answers sd!351f71fAf)*\"intro>finish>fib1.common.path sd"371f91fAf#5#intro>finish>FIB2 sd#3:1fEfAf$intro>finish>fib2.a000 sd$3=1ff?fF%intro>finish>FIB2.A000.Path sd%3@1fC1fA?fN( X&intro>finish>fib2.a999 sd&3C1ffAf' 'intro>finish>FIB2.A999.Path sd'3G1fI1fAfN(intro>finish>FIB2.answers sd(3I1fL1fAf(.)intro>finish>fib2.common.path sd)3M1fO1fAfR;*intro>finish>initial.path sd*3P1f7g)g+intro>finish>qseg1 sd+3S1fU1f}Af,intro>finish>rev.1 sd,3V1f@fAfƟ-intro>finish>rev.2 sd-3Y1fCfAfQ) ˘.intro>finish>tw1.pedal etsd.3sgԗgg A/intro>finish>tw1 etsd/3pgїgg  > *0using>range>def.1 sd03c1fEfEfc$ʗ1using>range>def.2 sd13f1fEfEf*[2using>range>def.3 sd23i1fEfEf0т3using>range>def.4 sd33m1fEfEf64using>range>def.5 sd43o1fEfEf>q5using>range>def.6 sd53s1fEfEfD ) 6using>range>def.7 sd63v1fEfEfN7using>range>def.8 sd73y1fEfEfTF^8using>range>eg sd83}1fff-Z9using>range>eg.pedal sd931fffn:using>range>initial.path sd:31fEfEfpT;using>range>Int.1 sd;31fEfEft5<using>range>Int.2 sd<31fEfEfx];=using>range>MC1 sd=31fVf=f|* ]>using>range>mc1.common.path sd>31f1f~f!?using>range>mc1.correct sd?31f-f5f1~@using>range>MC1.F001.Path sd@31f1ffOAusing>range>MC1.F002.Path sdA31f1ffO҃Busing>range>MC1.F003.Path sdB31f1ffOzCusing>range>MC1.F004.Path sdC31f1f5fMqsDusing>range>MC1.F005.Path sdD31f1fMfQEusing>range>mc1.f5incorrect sdE31f1fCf?p* bFusing>range>mc1.incorrect sdF31f6ff\Gusing>range>MC1.legend sdG31f1f;f;ƻHusing>range>qseg2 sdH31f1ffsIusing>range>rev.1 sdI31fEfEf/Jusing>range>rev.2 sdJ31fEfEf VKusing>range>rev.3 sdK31fEfEfXLusing>range>TF2 sdL31f;f{fxUlMusing>range>tf2.common.path sdM31f1ffj+ uNusing>range>TF2.F001.Path sdN31f1frfJiOusing>range>TF2.F002.Path sdO31f1ffKPusing>range>TF2.false sdP31fAffrQusing>range>TF2.legend sdQ31f1fyf*Rusing>range>TF2.true sdR31fFfqftSUsing>Create>Ending sdS31f1f>fLaTusing>create>FIB6 sdT31fEfgP)Uusing>create>FIB6.a000 sdU31ff f+ g9Vusing>create>FIB6.A000.Path sdV31f1f fNWusing>create>FIB6.a999 sdW31ffgYXusing>create>FIB6.A999.Path sdX31f1fgNYusing>create>FIB6.answers sdY31f1fg(Zusing>create>fib6.common.path sdZ31ffg[using>create>FIB7 sd[31fEfEf\using>create>FIB7.a000 sd\31fɀf f++.]using>create>FIB7.A000.Path sd]31f1f fN, :_^using>create>FIB7.a002 sd^31f̀f f J_using>create>FIB7.A002.Path sd_31f1f fNm`using>create>FIB7.a999 sd`31fҀf fausing>create>FIB7.A999.Path sda31f1f fNbusing>create>FIB7.answers sdb31f1f f?_cusing>create>fib7.common.path sdc31f2f f" *dusing>create>i.1 sdd32fhEfg$veusing>create>i.2 sde32fjEfg(, Tfusing>create>i.3 sdf32fmEfg.Ɋgusing>create>i.4 sdg3 2fpEf!g{"4j Xhusing>create>initial.path sdh32ff:g:Txiusing>create>MC1 sdi32fKf9gZE^jusing>create>mc1.common.path sdj32f2fBg"^+kusing>create>MC1.correct sdk32f݀ffbt Slusing>create>MC1.F001.Path sdl32f2f<gQfsmusing>create>MC1.F002.Path sdm32f2ffOj- 8knusing>create>MC1.F003.Path sdn3 2f"2ffSn_ousing>create>MC1.F004.Path sdo3#2f%2ffSr]pusing>create>MC1.F005.Path sdp3%2f'2f&fQvFqusing>create>MC1.f3incorrect sdq3(2fffz%rusing>create>MC1.f4incorrect sdr3+2fffMsusing>create>MC1.incorrect sds3.2ff<gpYtusing>create>MC1.legend sdt312f32f8g;Nuusing>create>MC3 sdu342fOf_gM- qvusing>create>MC3.common.path sdv372f92fjg"twusing>create>MC3.correct sdw3:2ffYflBxusing>create>MC3.F001.Path sdx3=2f@2fcgQ_yusing>create>MC3.F002.Path sdy3A2fB2f9fQVUzusing>create>MC3.F003.Path sdz3C2fF2fYfO)c{using>create>MC3.F004.Path sd{3F2fI2f{fQW|using>create>MC3.F005.Path sd|3I2fK2ffQ}using>create>MC3.incorrect sd}3L2ffcg. ]K~using>create>MC3.legend sd~3O2fQ2f^g;busing>create>mc4 sd3R2fSfhgr̀using>create>mc4.common.path sd3U2fW2fgsTusing>create>mc4.correct sd3X2ff fAusing>create>MC4.F001.Path sd3[2f\2fmgQnRusing>create>MC4.F002.Path sd3]2f_2f fO=Xusing>create>MC4.F003.Path sd3_2fa2f fQ!Tusing>create>MC4.F004.Path sd3b2fd2f fQ. Mrusing>create>mc4.incorrect sd3e2fflgVusing>create>MC4.legend sd3h2fj2fgg4Rusing>create>Nos sd3k2fSggusing>create>Nos.pedal sd3p2f-SggvQusing>create>qseg1 sd3s2fu2fgusing>create>rev.1 sd3v2fyEfyEflusing>create>rev.2 sd3y2f|Ef|Ef|Kusing>create>rev.3 sd3|2fEfEf/ lfusing>create>rev.4 sd32fEfEfOWusing>create>seg1.1 sd32ff"g( Gusing>create>seg1.10 sd32f f1gEcusing>create>seg1.11 sd32ff3g'<>Kuusing>create>seg1.12 sd32ff4g nusing>create>seg1.2 sd32ff%g{using>create>seg1.3 sd32f!f)g Εusing>create>seg1.4 sd32ff*g/ 7using>create>seg1.5 sd32ff+gHusing>create>seg1.6 sd32ff,gl"using>create>seg1.7 sd32ff-g (susing>create>seg1.8 sd32ff/g6using>create>seg1.9 sd32ff0gL using>create>seg2.1 sd32f2fGg1V[using>create>seg2.2 sd32f2fHg\using>create>seg3 sd32f2fg` 0 \>using>create>SER sd32fu*gu*gywbjusing>create>SER.pedal sd32fx*gx*g6}using>create>Text sd32f*SgYg>Dusing>create>Text.pedal sd32f3SgZgBusing>create>TF2 sd32f fAgeusing>create>tf2.common.path sd32f2fagusing>create>TF2.F001.Path sd32f2fDgL (using>create>TF2.F002.Path sd32f2fZfM0 Cusing>create>TF2.false sd32ffWf9+using>create>TF2.legend sd32f2f@g*%using>create>TF2.true sd32ffDgBթusing>create>TF8 sd32ff f"Vƪusing>create>tf8.common.path sd32f2f f&%using>create>TF8.F001.Path sd32f2f fL*using>create>TF8.F002.Path sd32f2f fM.using>create>TF8.false sd32f f f21 3using>create>TF8.legend sd32f2f f*8using>create>TF8.true sd32f%f f_<BOCIDsysB4fF4fg@using>range>name sd3f1f1fm1|2ƀusing>range>name.pedal sd3f1f1f  using>range>seg1 sd35f8ff busing>create>seg4 sd3fEfEf  #intro>help>tf1.false sd3FfFfFf1 intro>help>TF1.F002.Path sd3$Ff'Ff'FfIintro>help>tf1 sd39Ff=Ff=FfZ#intro>help>tf1.common.path sd3@FfFFfFFf`1intro>help>TF1.legend sd3GFfJFfJFf*intro>help>tf1.true sd3KFfPFfPFf intro>finish>tw1a etsd3g@gg7  Ointro>help>TF1.F001.Path sd3jFfnFfnFfHP intro>help>rev.1 sd3VfbEfbEf?T 2 intro>help>rev.2 sd3VfeEfeEf]Z Fintro>help>seg.1 sd3VfWfWf{` 1intro>help>seg.2 sd3Wf Wf Wfyz intro>help>toc.pedal sd3 WfWf-f _zintro>help>toc sd3WfWf,f3'z(intro>help>FIB2.a002 sd3Tpf f f intro>help>FIB2.A002.Path sd3epfffJintro>finish>twseg sd3FfFfg2 Iintro>finish>tw1aseg.1 etsd3wgEg gj intro>finish>tw1aseg.2 etsd3|gIgg Eintro>finish>tw1a.pedal etsd3gBgg( intro>finish>tw2 etsd3g֗g#g* intro>finish>tw2.pedal etsd3gٗg$g : sersdC*gC*gC*gx @ Rpp4 ml3 kjihgfed3 cba`_^]\4 [ZYXWVUT4 SRQPONML5 KJIHGFED5 CBA@{Intro>Help>FIB2intro>help>tw2intro>finish>qseg1+intro>finish>rev.2-using>range>def.43using>range>Int.2<using>range>mc1.common.path>using>range>TF2.legendQusing>create>FIB6.answersYusing>create>i.3fusing>create>MC3.F004.Path{using>create>mc4using>create>mc4.correctusing>create>MC4.F003.Pathusing>create>Nosusing>create>seg1.10using>create>seg1.11using>create>seg1.3using>create>seg1.4using>create>SER.pedalusing>create>TF8using>create>tf8.common.pathusing>range>def.54using>range>eg.pedal9using>range>MC1.F002.PathAusing>range>tf2.common.pathMusing>range>TF2.F001.PathNusing>create>FIB6Tusing>create>FIB6.A000.PathVusing>create>FIB7.a002^using>create>FIB7.answersbusing>create>i.4gusing>create>MC4.F004.Pathusing>create>MC4.legendusing>create>seg1.12using>create>seg1.5using>create>TF8.falseusing>range>seg1intro>help>tf1.common.pathintro>help>seg.1intro>help>seg.2intro>help>FIB2.a002intro>finish>tw1.pedal.intro>finish>F.1intro>finish>fib1.a000intro>finish>FIB1.answers!intro>finish>fib2.common.path)intro>finish>initial.path*using>range>def.65using>range>initial.path:using>range>MC1=using>range>MC1.F003.PathBusing>create>FIB6.A999.PathXusing>create>FIB7[using>create>FIB7.A000.Path]using>create>MC1.F002.Pathmusing>create>MC1.f4incorrectrusing>create>seg1.6using>create>seg3using>create>TF2.F001.Pathusing>create>TF2.trueintro>finish>tw1aseg.1intro>finish>tw1aseg.2intro>finish>e.1intro>finish>F.2intro>finish>fib1.a999using>range>def.76using>range>qseg2Husing>range>TF2.trueRUsing>Create>EndingSusing>create>FIB7.A999.Pathausing>create>MC1.F003.Pathnusing>create>MC3.correctwusing>create>seg1.7using>create>TF8.F001.Pathusing>create>seg4intro>help>TF1.F002.Pathintro>help>TF1.legendintro>help>toc.pedalintro>help>tocintro>help>FIB2.A002.Pathintro>finish>twsegintro>finish>tw1a6 intro>help>FIB2.common.path intro>finish>e.2intro>finish>F.3using>range>def.87using>range>mc1.f5incorrectEusing>range>TF2.falsePusing>create>FIB6.a000Uusing>create>fib7.common.pathcusing>create>MC3.F002.Pathyusing>create>mc4.common.pathusing>create>MC4.F001.Pathusing>create>rev.1using>create>seg1.8using>create>SERusing>create>TF2using>create>TF8.trueintro>help>tf1.trueintro>finish>tw1a.pedalintro>finish>e.3using>range>mc1.incorrectFusing>range>MC1.legendGusing>create>FIB6.a999Wusing>create>mc1.common.pathjusing>create>MC1.correctkusing>create>MC1.f3incorrectqusing>create>MC3.common.pathvusing>create>MC3.F005.Path|using>create>MC4.F002.Pathusing>create>rev.2using>create>seg1.9using>create>Text.pedalusing>create>TF2.falseintro>help>tf1.falseintro>help>rev.1intro>finish>tw1/intro>help>FIB2.a000.path intro>help>FIB2.a999 intro>help>qseg1intro>help>tw2.pedalusing>range>MC1.F001.Path@using>range>TF2.F002.PathOusing>create>FIB7.a999`using>create>MC1.incorrectsusing>create>MC1.legendtusing>create>rev.3using>create>seg2.1using>create>tf2.common.pathusing>range>nameusing>range>name.pedalintro>help>rev.2intro>finish>tw2intro>help>FIB2.a999.path intro>finish>FIB1intro>finish>FIB1.A000.Pathintro>finish>fib1.common.path"intro>finish>fib2.a000$using>range>def.10using>range>eg8using>range>MC1.F004.PathCusing>range>rev.1Iusing>create>initial.pathhusing>create>MC1iusing>create>MC1.F001.Pathlusing>create>rev.4using>create>seg1.1using>create>seg2.2using>create>Textusing>create>TF2.F002.Pathusing>create>TF2.legendusing>create>TF8.F002.Pathusing>create>TF8.legendintro>help>initial.pathintro>help>segintro>finish>FIB1.A999.Path intro>finish>FIB2#intro>finish>FIB2.A000.Path%intro>finish>fib2.a999&using>range>def.21using>range>mc1.correct?using>range>MC1.F005.PathDusing>range>rev.2Jusing>create>FIB7.A002.Path_using>create>i.1dusing>create>MC1.F004.Pathousing>create>MC3.incorrect}using>create>MC3.legend~using>create>Nos.pedalusing>create>seg1.2intro>help>tf1intro>help>TF1.F001.Pathintro>finish>tw2.pedalintro>help>FIB2.a000intro>help>FIB2.answers Intro>Help>Getintro>help>tw1intro>help>tw1.pedalintro>finish>FIB2.A999.Path'intro>finish>FIB2.answers(intro>finish>rev.1,using>range>def.32using>range>Int.1;using>range>rev.3Kusing>range>TF2Lusing>create>fib6.common.pathZusing>create>FIB7.a000\using>create>i.2eusing>create>MC1.F005.Pathpusing>create>MC3uusing>create>MC3.F001.Pathxusing>create>MC3.F003.Pathzusing>create>mc4.incorrectusing>create>qseg12am g JHPN  ONO CHANGE!+Nd10 75 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances 16 BalDueToEmp 17 BalDueFromEmp 18 19 20 21 22 23 Mon 08-Feb-88 1:07 PM Macro  Edit  Name Ab6 s  Go To  Window Query Table  Calc  Graph T  NO CHANGE!?Nd10 75 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 713  14 Total Expenses To save a worksheet, select the File commands menu.15 Less Advances  16 BalDueToEmp717 BalDueFromEmp 18 .19 20 First,display the main commands menu. 21 22 .23 Mon 08-Feb-88 1:07 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T #.## C0NO CHANGE!BNd10 75 MENU WorksheetRangeCopyMoveFilePrintGraphDataAdvancedQuitGlobal,Insert,Delete,Column-Width,Erase,Titles,Window,Status a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances 416 BalDueToEmp 17 BalDueFromEmp Typefto select the File commands menu.18 19 420 21 22 23 Mon 08-Feb-88 1:07 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T " 7 NO CHANGE! N d10 75 MENU Retrieve Save Combine Xtract Erase List Import Directory  Read in a spreadsheet file)  a b c d e f g h i1 EXPENSE REPORT#2 3 This is the File commandsmenu.4 5 #6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses "15 Less Advances 16 Balance Due To Employee Typesto select Save.17 Balance Due From Employee18 "19 20 21 22 23 Mon 08-Feb-88 1:07 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T###  NO CHANGE!aNd10 75 EDIT Enter save filename:   5 a b 1 EXPENSE REPORTA prompt displays asking you to enter a filename.2 3 54 5 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 115 Less Advances  16 BalDueToEmpType in the filename,ExpenseReport.17 BalDueFromEmp 18 119 20 21 22 23 Mon 08-Feb-88 1:07 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 555  " /NO CHANGE!ANd10 75 EDIT Enter save filename: E   3 Any time you enter  a b c d e  i1 EXPENSE REPORT characters that are  7  20   30 neither labels nor  40   50 values, the mode  6 Air, rail, bus 450  7 Rental car 40 40 40 indicator changes  8 Daily lodging 68 68 68   9 Meals 25 25 25 from READY to EDIT. 10 Entertainment 75  11/  12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 1:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 1   !NO CHANGE!3Nd10 75 EDIT Enter save filename: Ex   3 Any time you enter  a b c d e  i1 EXPENSE REPORT characters that are  20   30 neither labels nor  40   50 values, the mode  6 Air, rail, bus 450  7 Rental car 40 40 40 indicator changes  8 Daily lodging 68 68 68   9 Meals 25 25 25 from READY to EDIT. 10 Entertainment 75  11/  12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 1:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 1   NO CHANGE!&Nd10 75 EDIT Enter save filename: Exp   3 Any time you enter  a b c d e  i1 EXPENSE REPORT characters that are  20   30 neither labels nor  40   50 values, the mode  6 Air, rail, bus 450  7 Rental car 40 40 40 indicator changes  8 Daily lodging 68 68 68   9 Meals 25 25 25 from READY to EDIT. 10 Entertainment 75  11/  12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 1:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 1   NO CHANGE!Nd10 75 EDIT Enter save filename: Expe   3 Any time you enter  a b c d e  i1 EXPENSE REPORT characters that are  20   30 neither labels nor  40   50 values, the mode  6 Air, rail, bus 450  7 Rental car 40 40 40 indicator changes  8 Daily lodging 68 68 68   9 Meals 25 25 25 from READY to EDIT. 10 Entertainment 75  11/  12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 1:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 1  " "NO CHANGE!#Nd10 75 EDIT Enter save filename: Expen   3 Any time you enter  a b c d e  i1 EXPENSE REPORT characters that are  20   30 neither labels nor 7  40   50 values, the mode  6 Air, rail, bus 450  7 Rental car 40 40 40 indicator changes  8 Daily lodging 68 68 68   9 Meals 25 25 25 from READY to EDIT. 10 Entertainment 75  11/  12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 1:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 1  & &NO CHANGE!'Nd10 75 EDIT Enter save filename: Expens   3 Any time you enter  a b c d e  i1 EXPENSE REPORT characters that are  20   30 neither labels nor  40   50 values, the mode  6 Air, rail, bus 450  7 Rental car 40 40 40 indicator changes  8 Daily lodging 68 68 68   9 Meals 25 25 25 from READY to EDIT. 10 Entertainment 75  11/  12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 1:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 1  * *NO CHANGE!*Nd10 75 EDIT Enter save filename: Expense   3 Any time you enter  a b c d e  i1 EXPENSE REPORT characters that are  20   30 neither labels nor  40   50 values, the mode  6 Air, rail, bus 450  7 Rental car 40 40 40 indicator changes  8 Daily lodging 68 68 68   9 Meals 25 25 25 from READY to EDIT. 10 Entertainment 75   11/  12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 1:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 1  . .NO CHANGE!.Nd10 75 EDIT Enter save filename: ExpenseR   3 Any time you enter  a b c d e  i1 EXPENSE REPORT characters that are  20   30 neither labels nor  40   50 values, the mode  6 Air, rail, bus 450  7 Rental car 40 40 40 indicator changes  8 Daily lodging 68 68 68   9 Meals 25 25 25 from READY to EDIT. 10 Entertainment 75  11/  12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 1:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 1  2 2NO CHANGE!2Nd10 75 EDIT Enter save filename: ExpenseRe   3 Any time you enter  a b c d e  i1 EXPENSE REPORT characters that are  20   30 neither labels nor  40   50 8  values, the mode  6 Air, rail, bus 450  7 Rental car 40 40 40 indicator changes  8 Daily lodging 68 68 68   9 Meals 25 25 25 from READY to EDIT. 10 Entertainment 75  11/  12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 1:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 1  6 6NO CHANGE!6Nd10 75 EDIT Enter save filename: ExpenseRep   3 Any time you enter  a b c d e  i1 EXPENSE REPORT characters that are  20   30 neither labels nor  40   50 values, the mode  6 Air, rail, bus 450  7 Rental car 40 40 40 indicator changes  8 Daily lodging 68 68 68   9 Meals 25 25 25 from READY to EDIT. 10 Entertainment 75  11/  12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 1:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 1  :  :NO CHANGE!:Nd10 75 EDIT Enter save filename: ExpenseRepo   3 Any time you enter  a b c d e  i1 EXPENSE REPORT characters that are  20   30 neither labels nor  40   50 values, the mode  6 Air, rail, bus 450  7 Rental car 40 40 40 indicator changes  8 Daily lodging 68 68 68   9 Meals 25 25 25 from READY to EDIT. 10 Entertainment 75  11/  12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 1:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 1  > !>NO CHANGE!>Nd10 75 EDIT Enter save filename: ExpenseRepor   3 Any time you enter  a b c d e  i1 EXPENSE REPORT characters that are  20   30 neither labels nor  40   50 values, the mode  6 Air, rail, bus 450  7 Rental car 40 40 40 indicator changes  8 Daily lodging 68 68 68   9 Meals 25 25 25 from READY to EDIT. 10 Entertainment 75  11/  12N 13N 14 Total Expenses< 15 Less Advances= 16 BalDueToEmp3 17 BalDueFromEmp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 1:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 1  B "BNO CHANGE!BDNYd10 75 EDIT Enter save filename: ExpenseReport  3 Any time you enter a b c d e  i1 EXPENSE REPORT characters that are 20  30 neither labels nor 40   50 values, the mo8 de 6 Air, rail, bus 450  7 Rental car 40 40 40 indicator changes  8 Daily lodging 68 68 68   9 Meals 25 25 25 from READY to EDIT.10 Entertainment 75  11 12 13 ,14 Total Expenses 15 Less Advances Press Return to enter your filename.16 BalDueToEmp17 BalDueFromEmp,18 19 20 21 22 23 Mon 08-Feb-88 1:07 PM Macro  Edit   Name Abs  Go To  Window Query Table  Calc  Graph 1  ,,,G K,GNO CHANGE!>GNd10 75 MENU Cancel Replace   Cancel operation; don't overwrite file a b c d e f  g h i1 EXPENSE REPORT2 3 4 This prompt displays whenever you5 6 Air, rail, bus 450 want to save your changes to a  7 Rental car 40  8 Daily lodging 68 file. Select Cancel if you decide 9 Meals 25  10 Entertainment not to save your changes. Select 11 12 Replace if you want to save your13 14 Total Expenses changes to a new or existing file.15 Less Advances 16 BalDueToEmp &17 BalDueFromEmp18 %19 20 Typerto select Replace.21 22 %23 Mon 08-Feb-88 1:08 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T&&&&&&&&&&&&&K  KNO CHANGE!KNd1075READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances 16 BalDueToEmp17 BalDueFromEmp18 19 20 21 22 23 Mon 08-Feb-88 1:08 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T yN NNO CHANGE!NNd10 75 READY a b c d e f g h i1 EXPENSE REPORT 2 13 4 Good! Now, let's say you decided not to keep5 6 Air, rail, bus this worksheet after all.7 Rental car 8 Daily lodging Well, you can erase your entire worksheet9 Meals 10 Entertainment at any time.11 12 Let's do it. Erase your entire worksheet.13 14 Total Expenses 115 Less Advances 16 BalDueToEmp.17 BalDueFromEmp18 First, display the main commands menu.19 20 .21 22 23 Mon 08-Feb-88 1:08 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T(*( 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total E9 xpenses 15 Less Advances 16 BalDueToEmp17 BalDueFromEmp18 919 20 Typewto select the Worksheet commands menu.21 22 923 Mon 08-Feb-88 12:59 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T &U !UNO CHANGE!U^Nd10 [W12] 75 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Specify global worksheet parameters4 a b c d e f g h 1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75& 11 12 13 14 Total Expenses #15 Less Advances  16 BalDueToEmp Typeeto select Erase.17 BalDueFromEmp18 #19 20 21 22 23 Mon 08-Feb-88 1:26 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ]Y KjYNO CHANGE!|YN d10 [W12] 75 MENU No Yes*  Do not erase the spreadsheet; return to READY mode ! a b c d e  f g h 1 EXPENSE REPORT  2 A prompt displays giving you one last chance 3 4 to change your mind about erasing your worksheet.5 5 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75& 11 12 13 !14 Total Expenses 15 Less Advances Typeyto select Yes.16 BalDueToEmp17 BalDueFromEmp!18 19 20 21 22 23 Mon 08-Feb-88 1:26 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T555 @] M]NO CHANGE!_]N[d10 [W12] 75 MENU No YesI Erase the spreadsheet (Remember to save it first)  a b c d e f g h 1 EXPENSE REPORT2 3 You are reminded about saving your worksheet.4 5 16 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75& 11 12 313  14 Total Expenses Remember: When you erase your worksheet, you15 Less Advances 16 BalDueToEmplose any work that you did not previously save.17 BalDueFromEmp18 319 -20  21  Press Return to erase your worksheet.22  23 -Mon 08-Feb-88 1:27 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T111 ")"ua OaNO CHANGE!aN!a1 READY a b c d e f g h i1O 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 1:27 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]Kc XcNO CHANGE!jcUN{a1 READY a b c d e f g h i1O 2 23 4 Excellent!5 6 7 Now,9  you really did not lose any of your work,8 9 since you saved your worksheet in a file10 11 previous to erasing it.12 13 Let's read in, or retrieve, your file,14 15 ExpenseReport.16 17 218 '19 20 Display the main commands menu.21 22 '23 Mon 08-Feb-88 1:27 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]!#!f >fNO CHANGE!fNCd10 75 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 2 3 4 5 26 7 Now, to retrieve a file, use the File command.8 9 210 11 12 &13 14 Select the File commands menu.15 16 &17 18 19 20 21 22 23 Mon 08-Feb-88 12:59 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] " i <iNO CHANGE!iNd10 75 MENUtime / ~ To display the command menu, type the slash. ~ ~~ ~~ ~~ ~ Dismiss this message and type '/'. ~ f ~ To select a command, type the first letter ~ ~ ~ ~ of the command name. ~ ~~ ~ Dismiss this message and type 'f' for File. ~ s s E ~ The filename to type is ExpenseReport. ~ ~~ ~~ ~~ ~ Dismiss this message and type 'E' ... ~ ShiftLeft e x ~ The filename you are currently typing in is ~ ~~ ~ ExpenseReport. ~ ~~ ~ Dismiss this message and type 'x' ... ~ x p ~ The filename you are currently typing in is ~ ~~ ~ ExpenseReport ~ ~~ ~ Dismiss this message and type 'p' ... ~ p e ~ The filename you are currently typing in is ~ ~~ ~ ExpenseReport ~ ~~ ~ Dismiss this message and type 'e' ... ~ e n ~ The filename you are currently typing in is ~ ~~ ~ ExpenseReport ~ ~~ ~ Dismiss this message and type 'n' ... ~ n s ~ The filename you are currently typing in is ~ ~~ ~ ExpenseReport ~ ~~ ~ Dismiss this message and type 's' ... ~ s e ~ The filename you are currently typing in is ~ ~~ ~ ExpenseReport ~ ~~ ~ Dismiss this message and press 'e' ... ~ e R ~ The filename you are currently typing in is ~ ~~ ~ ExpenseReport ~ ~~ ~ Dismiss this message and type 'R' ... ~ ShiftLeft r e p o r t 0x0A Return r r time / Slash W ShiftLeft w E ShiftLeft e y y 0x0A Return time / Slash f ~ To select a command, type the first letter ~ ~~ ~ of the command name. ~ ~~ ~ Dismiss this message and type 'f' for File. ~ r r 0x0A Return time time2am f":  JHPN   NO CHANGE!+N  @ MNO CHANGE!_eN!A A A d e A AAAAtering a label AAA 9 10 11 12 Typeinthelabel,13 14 !EXPENSEREPORAAAAAAAAA AGo To  Window  NO CHANGE!Nm 1 1 1c d e f 1 1111rt by entering a label in the c6 7 =8 9 10 11 12 Typeinthelabel,13 14 15 EXPENSEREPORT.16 17 111111 1 Abs  Go To  Window Query   NO CHANGE!fN 3 3  b c d e f g 3 3 =4 5 Let's start by entering a label in the current cell, a1.6 7 =8 9 10 11 12 Typeinthelabel,13 14 15 EXPENSEREPORT.16 17 18 19 20 2:29 PM,  Name Abs  Go To  Window Query Table  3 M  ZNO CHANGE!lNa1 READY a b c d e f g h i1O 2 3 =4 5 Let's start by entering a label in the current cell, a1.6 7 =8 9 10 11 12 Typeinthelabel,13 14 15 EXPENSEREPORT.16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  NO CHANGE!( N3a1 LABELE)  8  a b c d e f  g h i1%  2%   3% Note that as soon as you type 4%   5% in the first character, themode6%   7% changes from READY to LABEL.8%   9% (Continue typing in the label,10$   11$ EXPENSE REPORT.)12$  13$ $14, 15, 16, 17, 18, 19N 20N 21N 22N 23N Mon 08-Feb-88 12:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]$     $$$$$< INO CHANGE![N>a1 LABELEX     a b c d e f  g h i1 2  3 Note that as soon as you type 4  5 in the first character, themode6  7 changes from READY to LABEL.8  9% (Continue typing in the label, 10$   11$ EXPENSE REPORT.) 12$   13$ $ 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]$     $$$$$z NO CHANGE!"NAa1 LABELEXP     a b c d e f  g h i1 : 2  3 Note that as soon as you type 4  5 in the first character, themode6  7 changes from READY to LABEL.8  9 (Continue typing in the label,10  11$ EXPENSE REPORT.) 12$   13$ $ 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]$     $$$$$ NO CHANGE!#NBa1 LABELEXPE     a b c d e f  g h i1 2  3 Note that as soon as you type 4  5 in the first character, themode6  7 changes from READY to LABEL.8  9 (Continue typing in the label,10  11$ EXPENSE REPORT.) 12$   13$ $ 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]$     $$$$$  NO CHANGE!&NEa1 LABELEXPEN      a b c d e f  g h i1 2  3 Note that as soon as you type 4  5 in the first character, themode6  7 changes from READY to LABEL.8  9% (Continue typing in the label, 10$   11$ EXPENSE REPORT.) 12$   13$ $ 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]$     $$$$$B ONO CHANGE!a'NFa1 LABELEXPENS      a b c d e f  g h i1 2  3 Note that as soon as you type 4  5 in the first character, themode6  7 changes from READY to LABEL.8  9% (Continue typing in the label, 10$   11$ EXPENSE REPORT.) 12$   13$ $ 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]$     $$$$$ NO CHANGE!*NIa1 LABELEXPENSE      a b c d e f  g h i1 2  3 Note that as soon as you type 4  5 in the first character, themode6  7 changes from READY to LABEL.8  9 (Continue typing in the label,10  11$ EXPENSE REPORT.) 12$   13$ $ 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]$     $$$$$! !NO CHANGE!!NDa1 ; LABELEXPENSE .  6 a b c d e f g h i1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23N Mon 08-Feb-88 12:31 PM; Macro  Edit   Name Abs  Go To  Window Query Table  Calc  Graph ]#  #NO CHANGE!#ONa1 LABELEXPENSE R  0  8 a b c  d e f g h i1 1 2  3  4 Also notice how the label 5  6 displays as you type it in. 7  8  9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]8&  E&NO CHANGE!W&TNa1 LABELEXPENSE RE  0  8 a b c  d e f g h i1  2  3  4 Also notice how the label 5  6 displays as you type it in. 7  8  9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ](  (NO CHANGE!(=Na1 LABELEXPENSE REP  0  8 a b c  d e f g h i1 2 3 4 Also notice how the label5 6 displays as you type it in.7 8 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]+  +NO CHANGE!&+jNa1 LABELEXPENSE REPO  0  8 a b c  d e f g h i1 2 3 4 Also notice how the label5 6 displays as you type it in.7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]-  -NO CHANGE!-QNa1 LABELEXPENSE REPOR  0  8 a b c  d e f g h i1 2 3 4 Also notice how the label5 6 displays as you type it in.7 8 9 10 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]0  0NO CHANGE!0]Na1 LABELEXPENSE REPORT  6  8 a b c  d e f g h i1 2 3 4 Also notice how the label5 6 displays as you type it in.7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]; |2 2NO CHANGE!2Na1 LABELEXPENSE REPORT  a b c d e f g h i1 2 3 4 5 6 7 8 /9 10 To enter the label into your worksheet,11 12 13 pressReturn .14 15 16 /17 18 19 20 21 22 23 Mon 08-Feb-88 12:31 PM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]''%5  25NO CHANGE!D5-NVa1 'EXPENSE REPORT READY a b c d e f g h i1 EXPENSE REPORT  2 &3 4 Good!5 6 The cell pointer is currently at7 8 cell a1. Move it down to cell a6.9 10 &11 12 013 14 To do this, press the Down Arrowkey15 16 17 until you reach cell a6.18 19 020 21 22 23 Mon 08-Feb-88 12:32 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]     ((q8  ~8NO CHANGE!8Na2 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 9 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:32 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T C:  P:NO CHANGE!b:Na3 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 9 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:33 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T <  "<NO CHANGE!4<N"a3 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3 C 4O 5O 6 9 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:33 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T =  =NO CHANGE! >N'a3 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3 C 4 C 5O 6 9 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:33 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ?  /?NO CHANGE!?XNa6 LABEL  a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 7 8 Type in another label:9 10 11 Air, rail, bus .12 13 14 15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:34 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T < ?B LBNO CHANGE!^BNa6 LABEL A a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:34 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  D DNO CHANGE!,DNa6 LABEL Ai a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:34 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T E ENO CHANGE!ENa6 LABEL Air a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:34 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T G GNO CHANGE!GNa6 LABEL Air, a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:34 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T }I INO CHANGE!INa6 LABEL Air, a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:34 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T OK \KNO CHANGE!nKNa6 LABEL Air, r a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:34 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T "M  /MNO CHANGE!AMNa6 LABEL Air, ra a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:34 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T N  ONO CHANGE!ON a6 LABEL Air, rai a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:34 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T P  PNO CHANGE!PN!a6 LABEL Air, rail a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:34 PM; Macro  Edit  Name Abs  Go To  Window Query Ta< ble  Calc  Graph T R  RNO CHANGE!RN"a6 LABEL Air, rail, a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:34 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T xT  TNO CHANGE!TN#a6 LABEL Air, rail, a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:34 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T PV ]VNO CHANGE!oVN$a6 LABEL Air, rail, b a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:34 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T )X 6XNO CHANGE!HXN%a6 LABEL Air, rail, bu a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:34 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T Z ZNO CHANGE!"ZNa6 LABEL Air, rail, bus a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4 . 5 ,  6 Then, enter the label into your worksheet. 7 8 .9 10 11 12 '13 14 Do you remember how to do this?15 16 If not, just press Help.17 18 '19 20 21 22 23 Mon 08-Feb-88 12:34 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T \  N\NO CHANGE!\Na6 ' Air, rail, bus READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4 5 , 6 Air, rail, bus % 7 Now move the cell pointer down one cell. 8 9 ,10 11 12 For display purposes,You should know how to13 14 two spaces are typeddo this. If not, just15 16 in front of eachpress Help.17 18 label for you.19 20 21 22 23 Mon 08-Feb-88 12:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T l` y`NO CHANGE!`ZNa7 LABEL a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7 8 9 10 Type in one more label:11 12 13 Rental car14 15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:35 PM;=  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  b bNO CHANGE!cN*a7 LABEL R a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T d dNO CHANGE!dN+a7 LABEL Re a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T f fNO CHANGE!fN,a7 LABEL Ren a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T h hNO CHANGE!hN-a7 LABEL Rent a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T gj tjNO CHANGE!jN.a7 LABEL Renta a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T Jl WlNO CHANGE!ilN/a7 LABEL Rental a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .n  ;nNO CHANGE!MnN0a7 LABEL Rental a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T p   pNO CHANGE!2pN1a7 LABEL Rental c a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T q =  rNO CHANGE!rN2a7 LABEL Rental ca a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T s  sNO CHANGE!s)Na7 LABEL Rental car a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7O 8 09 10 And enter the label into your worksheet.11 12 013 14 15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ((v /5vNO CHANGE!GvN@a7 ' Rental car READY a b c d e f g h i1 EXPENSE REPORT 2 3 4 #5 6 Air, rail, busGood!7 Rental car8 Now I'll give you a little help9 10 and enter the remaining labels11 12 for you.13 14 #15 16 17 18 Please press the19 20 Down Arrow key.21 22 23 Mon 08-Feb-88 12:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 6y  CyNO CHANGE!UyNka8 LABEL a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7 Rental car@ 8  9   10  Thank you!  11   12  13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:36 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  [{ h{NO CHANGE!z{4Nya8 LABEL Daily lodging? W a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7 Rental car@ 8  9   10  Thank you!  11   12  13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:36 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T } }NO CHANGE!}ANa8 'Daily lodging READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7 Rental car@ 8 Daily lodging9   10  Thank you!  11   12  13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:37 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!-:Na9 LABEL Meals a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7 Rental car@ 8 Daily lodging  9   10  Thank you!  11   12  13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:37 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T > g tNO CHANGE!ENa9 ' Meals READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7 Rental car@ 8 Daily lodging  9 Meals   10  Thank you!  11   12  13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:38 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ˄ ؄NO CHANGE!KNa10 LABEL Entertainment a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7 Rental car@ 8 Daily lodging  9 Meals   10  Thank you!  11   12  13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:38 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 5 BNO CHANGE!T^Na10 ' Entertainment READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7 Rental car@ 8 Daily lodging  9 Meals   10 Entertainment  Thank you!  11   12  13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:39 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T  NO CHANGE!щ\Na14 LABEL Total Expenses a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7 Rental car@ 8 Daily lodging  9 Meals   10 Entertainment  Thank you!  11   12  13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:40 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T - :NO CHANGE!LpNa14 ' Total Expenses READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7 Rental car@ 8 Daily lodging  9 Meals   10 Entertainment  Thank you!  11   12  13N 14 Total Expenses< 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:40 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  ɎNO CHANGE!ێlNa15 LABEL Less Advances a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7 Rental car@ 8 Daily lodging  9 Meals   10 Entertainment  Thank you!  11   12  13N 14 Total Expenses< 15N 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:40 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T G TNO CHANGE!fNa15 ' Less Advances READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7 Rental car@>  8 Daily lodging  9 Meals   10 Entertainment  Thank you!  11   12  13N 14 Total Expenses< 15 Less Advances= 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:41 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!pNa16 LABEL a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7 Rental car@ 8 Daily lodging  9 Meals   10 Entertainment  Thank you!  11   12  13N 14 Total Expenses< 15 Less Advances= 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:41 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T t NO CHANGE!Na16 LABEL Bal Due To Emp 1 W a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7 Rental car@ 8 Daily lodging  9 Meals   10 Entertainment  Thank you!  11   12  13N 14 Total Expenses< 15 Less Advances= 16N 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:41 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  %NO CHANGE!7Na16 ' Bal Due To EmpREADY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7 Rental car@ 8 Daily lodging  9 Meals   10 Entertainment  Thank you!  11   12  13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp3 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:42 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T Ǜ ԛNO CHANGE!Na17 LABEL  a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7 Rental car@ 8 Daily lodging  9 Meals   10 Entertainment  Thank you!  11   12  13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp3 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:42 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T i vNO CHANGE!Na17 LABEL Bal Due From Emp+ W a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7 Rental car@ 8 Daily lodging  9 Meals   10 Entertainment  Thank you!  11   12  13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp3 17N 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:42 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  +NO CHANGE!=Na17 ' Bal Due From EmpREADY a b c d e f g h i1 EXPENSE REPORT 2 3 4 5 6 Air, rail, bus7 Rental car 8 Daily lodging 9?  Meals 10 Entertainment Thankyou!11 12 13 14 Total Expenses15 Less Advances 16 Bal Due To Emp 17 Bal Due From Emp 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:42 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE! \Na17 ' Bal Due From EmpREADY a b c d e f g h i1 EXPENSE REPORT 2 3 4 5 6 Air, rail, bus7 Rental car 8 Daily lodging 9 Meals 10 Entertainment 11 12 13 14 Total Expenses15 Less Advances 16 Bal Due To Emp 17 Bal Due From Emp 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:42 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T e  8rNO CHANGE!Na17 ' Bal Due From EmpREADY a b c d e f g h i1 EXPENSE REPORT 2 (3 4 There! Now move the cell pointer to5 6 Air, rail, buscell c6. But, instead of using the7 Rental car 8 Daily lodging arrow keys, you are going to use9 Meals 10 Entertainment the Go To (F5) function.11 12 (13 14 Total Expenses.15 Less Advances 16 BalDue To Emp  17 Bal Due From Emp Press f5, the Go To function key. 18  19 . 20 .21 22 23N Mon 08-Feb-88 12:42 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  - >:NO CHANGE!LPNa17 ' Bal Due From EmpPOINTEnter address to go to: a17 O 8 a b c  d e f g h i1 EXPENSE REPORT 2 /3 4 Notice the prompt to enter the cell to Go To.5 6 Air, rail, bus 37 Rental car 8 Daily lodging 9 Meals 10 Entertainment 11 12 13 Type c6.14 Total Expenses time time time time E ~ You are practicing entering labels ~ ~ ~ ~ into your worksheet. ~ ~~ ~ Dismiss this message and type 'E' ... ~ ShiftLeft e X ~  You are practicing entering labels ~ ~~ ~ into your worksheet. ~ ~~ ~ Dismiss this message and type 'X' ... ~ ShiftLeft x P ~ You are practicing enter labels ~ ~~ ~ into your worksheet. ~ ~~ ~ Dismiss this message and type 'P' ... ~ ShiftRight p E ~ You are practicing entering labels ~ ~~ ~ into your worksheet. ~ ~~ ~ Dismiss this message and type 'E' ... ~ ShiftLeft e N ~ You are practicing entering labels ~ ~~ ~ into your worksheet. ~ ~~ ~ Dismiss this message and type 'N' ... ~ ShiftRight n S ShiftLeft s E ShiftLeft e 0x20 Space R ShiftLeft r E ShiftLeft e P ShiftRight p O ShiftRight o R ShiftLeft r T ShiftLeft t time 0x0A ~You just typed in a label. Now, to enter it into ~ ~~ ~ your worksheet, you must press Return. ~ ~~ ~ Dismiss this message and press Return. ~ Return ~To move the cell pointer, you use the Arrow keys. ~ ~To move down, use the Down Arrow key. ~ ~ ~ ~Dismiss this message and press the Down Arrow ~ ~until you reach cell a6. ?  ~ DownArrow ~ Continue to press the Down Arrow key ~ ~~ ~ until you reach cell a6. ~ ~~ ~ Dismiss this message and press Down Arrow. ~ ~ Continue to press the Down Arrow ~ ~~ ~ until you reach cell a6. ~ ~~ ~ Dismiss this message and press Down Arrow. ~ DownArrow DownArrow A ~ The label you are to type in is ~ ~~ ~ Air, rail, bus ~ ~~ ~  Dismiss this message and type 'A' ... ~ ShiftLeft a i ~ The label you are currently typing in is ~ ~~ ~ Air, rail, bus ~ ~~ ~ Dismiss this message and type 'i' ... ~ i r ~ The label you are currently typing in is ~ ~~ ~ Air, rail, bus ~ ~~ ~ Dismiss this message and type 'r' ... ~ r , ~ The label you are currently typing in is ~ ~~ ~ Air, rail, bus ~ ~~ ~ Dismiss this message and type ',' ... ~ Comma 0x20 ~ The label you are currently typing in is ~ ~~ ~ Air, rail, bus ~ ~~ ~ Dismiss this message and press the spacebar ... ~ Space r ~ The label you are currently typing in is ~ ~~ ~ Air, rail, bus ~ ~~ ~ Dismiss this message and type 'r' ... ~ r a ~ The label you are currently typing in is ~ ~~ ~ Air, rail, bus  ~ ~~ ~ Dismiss this message and type 'a' ... ~ a i l , 0x20 b u s 0x0A ~ To enter a label into your worksheet, ~ ~~ ~ press Return. ~ ~~ ~ Dismiss this message and press Return. ~  ~ To move the cell pointer down one cell, ~ ~ ~ ~ use the Down Arrow key. ~ ~~ ~ Dismiss this message and press the Down Arrow. ~ R ~ The label you are to type in is ~ ~~ ~ Rental car ~ ~~ ~ Dismiss this message and type 'R' ... ~ ShiftLeft r e ~ The label you are currently typing in is ~ ~~ ~ Rental car ~ ~~ ~ Dismiss this message and type 'e' ... ~ e n ~ The label you are currently typing in is ~ ~~ ~ Rental car ~ ~~ ~ Dismiss this message and type 'n' ... ~ n t ~ The label you are currently typing in is ~ ~~ ~ Rental car ~ ~~ ~ Dismiss this message and type 't' ... ~ t a ~ The label you are currently typing in is ~ ~~ ~ Rental car ~ ~~ ~  Dismiss this message and type 'a' ... ~ a l ~ The label you are currently typing in is ~ ~~ ~ Rental car ~ ~~ ~ Dismiss this message and type 'l' ... ~ l 0x20 c a r 0x0A ~ To enter the label you just typed in, ~ ~~ ~ press Return. ~ ~~ ~ Dismiss this message and press Return. ~ time time time time time time time time time time time time time time time time time time  ~The Go To function (f5) is another way of moving ~ ~ the cell pointer. Get familiar with th f5 key ~ ~ since you will be using it frequently. ~ ~ ~ ~ Dismiss this message and press f5. ~ F5 c ~ You must type in the cell address that you want ~ ~ ~ ~ to go to. In this case, it is c6. ~ ~~ ~ Dismiss this message and type 'c' ... ~ c 6 ~ The cell address to go to is c6. ~ ~~ ~ You already typed the 'c'. ~ ~~ ~ Dismiss this message and type '6'. ~ 6 0x0A ~You typed in the cell address. Now, to actually ~ ~~ ~ go to the cell, press Return. ~ ~~ ~ @  Dismiss this message and press Return. ~ Return time time2am d# JHPN   NO CHANGE!+NKQuestion Creating a WorksheetPT R U E o r F A L S E0Solution Designer knows whetheryou are entering a label or a valueby examining each character you type in.0 (Select your answer by pressing one of the indicated selections)P((((('@2am c P ZCarla.fontZSD.font,Gusing>create>Seg2.1HGusing>create>Seg2.2dXusing>create>Text~ZSD.fontZCarla.fontGusing>create>qseg1using>create>MC32am %c P Gusing>create>TF2.true'%Lusing>create>TF2.common.path2am %c@  P Gusing>create>TF2.false(%Lusing>create>TF2.common.path2am e JHPN  MNO CHANGE!+NCreating a WorksheetPT R U E o r F A L S E0Solution Designer knows whetheryou are entering a label or a valueby examining each character you type in. $Correct. This statement is false.$$Solution Designer does not look at each character. It looks at the first character only.P(((((, ,,,,,, ,D2am !c N ! TRUE  FALSE 2am e JHPN  NO CHANGE!+NCreating a WorksheetPT R U E o r F A L S E0Solution Designer knows whetheryou are entering a label or a valueby examining each character you type in. $That's incorrect. This statement$$is false. Solution Designer doesnot look at each character. It looks at the first character only.P(((((A , ,,,,,,,D2am d JHPN   NO CHANGE!+N+Question Creating a WorksheetPT R U E o r F A L S E7When you erase your worksheet, you lose allyour edits since you last saved your worksheet.7L (Select your answer by pressing one of the indicated selections)P77777+@2am c P Gusing>create>rev.1$Gusing>create>rev.2?Gusing>create>rev.3ZGusing>create>rev.4uNUsing>menu2am %c P Gusing>create>TF8.true'%Lusing>create>TF8.common.path2am %cA  P Gusing>create>TF8.false(%Lusing>create>TF8.common.path2am Ye JHPN  9NO CHANGE!+YNCreating a WorksheetPT R U E o r F A L S E7When you erase your worksheet, you lose allyour edits since you last saved your worksheet.$That's incorrect. This statement$$is true. When you erase your $ worksheet, you lose all your editssince you last saved. It is goodpractice to always save your worksheet before you erase it.P77777+++++++!,&&&,2am !c N ! TRUE  FALSE 2am 4e JHPN  LNO CHANGE!+4NCreating a WorksheetPT R U E o r F A L S E7When you erase your worksheet, you lose allyour edits since you last saved your worksheet.$Correct. This statement is true.$$When you erase your worksheet, you$ lose all your edits since you lastsaved. It is good practice toalways save your worksheet beforeyou erase it.P777B SD77,,,,,,,,,,,,,15 Less Advances 16 Bal Due To Emp 17 Bal Due From Emp 18 19 20 21 22 23N Mon 08-Feb-88 12:43 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T3-3  NO CHANGE!gNa17 ' Bal Due From EmpEDIT Enter address to go to: c a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus< 7 Rental car@ 8 Daily lodging= 9 MealsE 10 Entertainment= 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp3 17 Bal Due From Emp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:43 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T " /NO CHANGE!ANa17 ' Bal Due From EmpEDIT Enter address to go to: c6 a b c d e f g h i1 EXPENSE REPORT 2 3 4 5 6 Air, rail, bus7 Rental car 8 Daily lodging Press Return.9 Meals 10 Entertainment 11 12 13 14 Total Expenses15 Less Advances 16 Bal Due To Emp3 17 Bal Due From Emp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:44 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T     NO CHANGE! [Nc6 READY a b c d e f g h i1 EXPENSE REPORT 2 3 4 5 6 Air, rail, bus 7 Rental car 8 Daily lodging 9 Meals 10 Entertainment 11 12 13 14 Total Expenses 15 Less Advances 16 Bal Due To Emp 17 Bal Due From Emp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:44 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T h  !uNO CHANGE!Nc6 READY a b c d e f g h i1 EXPENSE REPORT 2 3 4 Excellent!5 6 Air, rail, bus The cell pointer is now at7 Rental car 8 Daily lodging cell c6.9 Meals 10 Entertainment (Press Next Page to continue)11 12 13 14 Total Expenses 15 Less Advances 16 Bal Due To Emp 17 Bal Due From Emp1 18N 19N 20N 21N 22N 23N Mon 08-Feb-88 12:44 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T% B %%%6 7 There two wahat yon8 9  finiss usom SolQuitn Desind.:10 11 12 e the comma13 14 ess thnishk15 16 17 18 19 20 21 22 23 Fri05-Feb-8810:05AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]&%&  8 NO CHANGE! lNa1MENU WorksheetRangeCopyMoveFilePrintGraphDataAdvancedQuitCopyoneormorecells a b c d e f g h i1 2 3 4 5 6 7 ere o wat yo8 9 iniss use SolQuit cDesind.10 11 12 the omma13 14 s thshk15 16 17 18 19 20 21 22 23 Fri05-Feb-8810:05AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]&#&?  2LNO CHANGE!^Nka1MENU WorksheetRangeCopyMoveFilePrintGraphDataAdvancedQuitCopyoneormorecells a b c d e f g h i1 2 3 4 5 6 7 e wayo8 9 Leiss use tholQuit comsind.10 11 12 e ma13 14 thk15 16 17 18 19 20 21 22 23 Fri05-Feb-8810:05AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]&#&  )NO CHANGE!;]Na1MENU WorksheetRangeCopyMoveFilePrintGraphDataAdvancedQuitCopyoneormorecells a b c d e f g h i1 2 3 4 5 6 7 '8 9 Let's use the Quit command first.10 11 '12 13 14 15 16 17 18 19 20 21 22 23 Fri05-Feb-8810:05AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  C Graph ] Retrieve Save Combine Xtract Erase List Import Directory Read in a spreadsheet file= a b c d e f g h i1 2 3 4 5 6 *7 8 9 And typer to select Retrieve.10  11 12 *13 14 15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 1:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph Tkl  xlNO CHANGE!lNXd10 75 MENU Enter filename of new spreadsheet: *.wk? ExpenseReport.wkt   a b c d e  f g h i1 2 A list of all existing worksheet files is3 4 displayed. Note that the suffix, .wkt, is5 6 automatically appended to a worksheet filename.7 38 9 C10 11 To retrieve a file, highlight the desired filename by using the12 13 Right Arrow or Left Arrow keys. Since ExpenseReport.wkt is the14 15 only file, it is already highlighted.16 17 C18 /19 20 Press Return to retrieve ExpenseReport.21 22 /23 Mon 08-Feb-88 1:25 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T33333'p  "pNO CHANGE!pNd10 75 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances 16 BalDueToEmp 17 BalDueFromEmp18 19 20 21 22 23 Mon 08-Feb-88 12:59 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T s EsNO CHANGE!sNd10 75 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses  And here is your file!!15 Less Advances  16 BalDueToEmp  17 BalDueFromEmp(Press Next Page to continue)18 19 20 21 22 23 Mon 08-Feb-88 12:59 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T %%%%%C !To Erase the contents of one or more cells,select the Range/Erase command.To change the column width of a singlecolumn,select the Worksheet/Column-Width/Setcommand.  5&*&2am d JHPN   -NO CHANGE!+N\ModifyinganExistingWorksheet5To insert one or more columns or rows,select the Worksheet/Insert command.To remove one or more columns or rows,'select the Worksheet/Delete command.ܱ!  5%%2am Be JHPN  ONO CHANGE!+BNModifyinganExistingWorksheet5To insert one or more columns or rows,selecttheWorksheet/Insertcommand.YouhavereachedtheTo remove one or more columns or rows,endofthislesson.selecttheWorksheet/Deletecommand.PressNextPagetoreturntotheUsingmenu.  555 %55555 %5555555555555555552am f JHPN   NO CHANGE!+zNa1 1READY a b c d e f g h i1 1 2 2 3 3 4 4 5 5 6 7 8 Let's name this range.9 10 11 12 13 14 15 616 17 First, type / to display the command menu.18 19 620 21 22 23 Wed 23-Mar-88 9:21 PM; Macro  Edit  Name Abs  Go To  Window Query Table  CaD lc  Graph ]      ;NO CHANGE!N+a1 1MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 1 2 2 3 3 4 4 5 5 6 7 "8 9 Good. Then, type r to 10 11 select the Range commands.12 13 "14 15 16 17 18 19 20 21 22 23 Wed 23-Mar-88 9:21 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  ;NO CHANGE!Na1 1MENU Format Label Erase Name Justify Protect Unprotect Input Value TransposeFormat one or more cells? a b c d e f g h i1 1 2 2 3 3 4 4 5 5 6 7 "8 9 Then, type n to select10 11 the Name command.12 13 "14 15 16 17 18 19 20 21 22 23 Wed 23-Mar-88 9:22 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  ^  k NO CHANGE!} Na1 1MENU Create Delete Labels Reset Table, Create or modify a range name: a b c d e f g h i1 1 2 2 3 3 4 4 5 5 6 7 $8 9 To create a range name,10 11 type c to select Create.12 13 $14 15 16 17 18 19 20 21 22 23 Wed 23-Mar-88 9:22 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]   NO CHANGE!% nNa1 1EDIT Enter name: a b c d e f g h i1 1 2 2 3 3 4 4 5 5 6 7 8 9 10 11 12 Name the range, Items.13 14 To do this, type the15 16 name, Items .17 18 19 20 21 22 23 Wed 23-Mar-88 9:22 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  NO CHANGE!N'a1 1EDIT Enter name: I a b c d e f g h i1 1D 2 2D 3 3D 4 4D 5 5D 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 23-Mar-88 9:23 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]o |NO CHANGE!N(a1 1EDIT Enter name: It a b c d e f g h i1 1D 2 2D 3 3D 4 4D 5 5D 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 23-Mar-88 9:23 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]L YNO CHANGE!kN)a1 1EDIT Enter name: Ite a b c d e f g h i1 1D 2 2D 3 3D 4 4D 5 5D 6O 7O 8O 9O 10N 11N 12N D 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 23-Mar-88 9:23 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]* 7NO CHANGE!IN*a1 1EDIT Enter name: Item a b c d e f g h i1 1D 2 2D 3 3D 4 4D 5 5D 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 23-Mar-88 9:23 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  NO CHANGE!(7Na1 1EDIT Enter name: Items a b c d e f g h i1 1 2 2 3 3 4 4 5 5 6 7 8 9 10 11 And press Return .12 13 14 15 16 17 18 19 20 21 22 23 Wed 23-Mar-88 9:23 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] _  :lNO CHANGE!~%Na1 1POINTEnter name: Items Enter range: a1..a1y a b c d e f g h i1 1 2 2 3 3 4 4 $5 5 6 Now define the range to be 7 8 associated with the name, Items.9 10 This range will include cells11 12 a1 to a5.13 14 $15 16 ,17 18 To do this, press the Down Arrow 19 20 to highlight cells, a2 to a5.21 22 ,23 Wed 23-Mar-88 9:23 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  NO CHANGE!N=a2 2POINTEnter name: Items Enter range: a1..a2y a b c d e f g h i1 1D 2 2D 3 3D 4 4D 5 5D 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 23-Mar-88 9:23 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  NO CHANGE!N=a3 3POINTEnter name: Items Enter range: a1..a3y a b c d e f g h i1 1D 2 2D 3 3D 4 4D 5 5D 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 23-Mar-88 9:23 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]    NO CHANGE! N=a4 4POINTEnter name: Items Enter range: a1..a4y a b c d e f g h i1 1D 2 2D 3 3D 4 4D 5 5D 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 23-Mar-88 9:23 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]   y"  H"NO CHANGE!"`Na5 5POINTEnter name: Items Enter range: a1..a5y a b c d e f g h i1 1 2 2 3 3 4 4 5 5 6 47 8 To define the range name, press Return .9 10 411 12 13 14 15 16 17 18 19 20 21 22 23 Wed 23-ME ar-88 9:23 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]    $ %NO CHANGE!%Na1 1READY a b c d e f g h i1 1D 2 2D 3 3D 4 4D 5 5D 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 23-Mar-88 9:24 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]& &NO CHANGE!&vNa1 1POINTEnter range to copy FROM: a1..a1 a b c d e f g h i1 1D 2 2D 3 3D 4 4 * 5 5 * 6 You can now use the range name, Items, 7 * 8 in commands that require a range to be 9 * 10 entered, such as the Copy command. 11 * 12 * 13 14 / 15 / 16 To use the name, Items, in the Copy 17 18  command prompt, press the Name function 19    20  key, f3 . 21   22 / 23N Wed 23-Mar-88 9:27 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]'''Z* ;g*NO CHANGE!y*VNa1 1MENU Enter range to copy FROM:7 ITEMS 1 a b c d  e f g h i1 1 2 2 3 3 4 4 A list of all the range names5 5 6 are displayed. You currently7 8 have one range name, ITEMS.9 10 !11 12 13 /14 15 To enter the range name, ITEMS, in the16 17 Copy command prompt, press Return .18 19 /20 21 22 23 Wed 23-Mar-88 9:27 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]!!!!!!!&- 7-NO CHANGE!-Na1 1POINTEnter range to copy FROM: ITEMS Enter range to copy TO: a1  a b c  d e f g h i1 1 2 2 3 3 4 4 5 5 And the range name is entered6 7 into the Copy command prompt.8 9 !10 11 -12 13 You are not going to actually perform the 14 15 Copy command. You will have a chance to16 17 use Copy in the upcoming exercises.18 19 -20 21 22 Press Next Page to continue23 Wed 23-Mar-88 9:27 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]!!!!!%%%/ ~ To display the command menu, type the slash. ~ ~~ ~~ ~~ ~ Dismiss this message and type '/'. ~ Slash r ~ To name a range, use ~ ~~ ~ the Range/Name command. ~ ~~ ~ Dismiss this message and type 'r' for Range. ~ r n ~ The Range command menu is currently displayed. ~ ~~ ~ To name a range, select the Name command. ~ ~~ ~ Dismiss this message and type 'n' for Name. ~ n c ~You are currently in the Range/Name command mE enu. ~ ~~ ~To create a range name, select the Create command.~ ~~ ~ Dismiss this message and type 'c' for Create. ~ c I ~ You are currently typing in the range name, ~ ~~ ~ Items ~ ~~ ~ Dismiss this message and type 'I' ... ~ ShiftRight i t ~ You are currently typing in the range name, ~ ~~ ~ Items ~ ~~ ~ Dismiss this message and type 't' ... ~ t e ~ You are currently typing in the range name, ~ ~~ ~ Items ~ ~~ ~ Dismiss this message and type 'e' ... ~ e m ~ You are currently typing in the range name, ~ ~~ ~ Items ~ ~~ ~ Dismiss this message and type 'm' ... ~ m s ~ You are currently typing in the range name, ~ ~~ ~ Items ~ ~~ ~ Dismiss this message and type 's' . ~ s 0x0A ~ To enter the name Items, press Return. ~ ~~ ~ ~ ~~ ~ Dismiss this message and press Return. ~ Return ~ You are currently defining the range, ~ ~ which includes cells, a1 to a5. To include a ~ ~ cell in the range, you must highlight that cell. ~ ~~ ~ Dismiss this message and press Down Arrow. ~ DownArrow ~ You are currently defining the range, ~ ~ which includes cells, a1 to a5. To include a ~ ~ cell in the range, you must highlight that cell. ~ ~ Dismiss this message and press Down Arrow ~ ~ until you reach cell a5. ~ DownArrow ~ You are currently defining the range, ~ ~ which includes cells, a1 to a5. To include a ~ ~ cell in the range, you must highlight that cell. ~ ~ Dismiss this message and press Down Arrow ~ ~ until you reach cell a5. ~ DownArrow ~ You are currently defining the range, ~ ~ which includes cells, a1 to a5. To include a ~ ~ cell in the range, you must highlight that cell. ~ ~ Dismiss this message and press Down Arrow ~ ~ until you reach cell a5. ~ DownArrow 0x0A ~ To enter the range, press Return. ~ ~~ ~~ ~~ ~ Dismiss this message and press Return. ~ Return time  ~ The Name (F3) function key displays ~ ~~ ~ all existing range names. ~ ~~ ~ Dismiss this message and press f3. ~ F3 0x0A Return time2am eY JHPN  :NO CHANGE!+NEa11READY a b c d e f g h i1 1 2 23 34 45 576 7 You can name a cell range that you use frequently.8 9 This saves you time when indicating the range10 11 wherever it is needed, such as in a command prompt.12 13 14 To name a range, use the Range/Name command.15 16 717 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] F 2am Wg JHPN  ONO CHANGE!+7Nd10 75 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 EXPENSE REPORT2 3 4 5 6 Air, rail, bus 450 7 Rental car 40 40 408 Daily lodging 68 68 689 Meals 25 25 2510 Entertainment 75 11 12 13 14 Total Expenses 15 Less Advances 16 BalDueToEmp 17 BalDueFromEmp18 19 20 21 22 23 Mon 08-Feb-88 12:59 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph KTLLLLLLLLL (LLLLLLLLLLLLb  CoNO CHANGE!WN d10 75 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 EXPENSE REPORT2 3 4 A5 A6 Air,A7 Rent38 Dail9 MealNote that if you had a worksheet currently10 Ente11 displayed and you retrieved a new file, the12 13 new file replaces the existing file on the14 Tota15 Lessscreen.16 Bal17 Bal318 A19 A20 A21 22 23 Mon 08-Feb-88 12:59 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph KTLLL333333333)LL2am de JHPN  CNO CHANGE!+N~Question 1How To Get Help in Solution DesignerPT R U E o r F A L S E2The Help key provides you with informationon any Solution Designer command. %That's incorrect. This statement%%is true. If you need to find out% about any Solution Designer command, just press Help.$P22222+++++++++F 2am #c P Gintro>help>TF1.false&#Lintro>help>TF1.common.path2am d JHPN   NO CHANGE!+N.Question 1How To Get Help in Solution DesignerPT R U E o r F A L S E2The Help key provides you with informationon any Solution Designer command.2O (Select your answer by pressing one of the indicated selections)$P22222(@2am c P Nintro>menu2am !c N ! TRUE  FALSE G 2am dZ JHPN  ENO CHANGE!+NsQuestion 1How To Get Help in Solution DesignerPT R U E o r F A L S E2The Help key provides you with informationon any Solution Designer command. %Correct. This statement is true.%%If you need to find out about any% Solution Designer command, justpress Help.$P22222+++++++++2am g< JHPN   7NO CHANGE!+N4a1MENU WorksheetRangeCopyMoveFilePrintGraphDataAdvancedQuitCopyoneormorecells a b c d e f g h i1 2 3 4 5 6 7 There e two wa that yocan8 9  finiss from SolQuion Desinder:10 11 12 Use the it comma13 14 Press thFinishk15 16 17 18 19 20 21 22 23 Fri05-Feb-8810:05AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]+++  7NO CHANGE! N4a1MENU WorksheetRangeCopyMoveFilePrintGraphDataAdvancedQuitCopyoneormorecells a b c d e f g h i1 2 3 4 5 6 7 There two wahat yon8 9  finiss usom SolQuitn Desind.:10 11 12 e the comma13 14 ess thnishk15 16 17 18 19 20 21 22 23 Fri05-Feb-8810:05AM MacrG o  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]&%&  8 NO CHANGE! lNa1MENU WorksheetRangeCopyMoveFilePrintGraphDataAdvancedQuitCopyoneormorecells a b c d e f g h i1 2 3 4 5 6 7 ere o wat yo8 9 iniss use SolQuit cDesind.10 11 12 the omma13 14 s thshk15 16 17 18 19 20 21 22 23 Fri05-Feb-8810:05AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]&#&?  2LNO CHANGE!^Nka1MENU WorksheetRangeCopyMoveFilePrintGraphDataAdvancedQuitCopyoneormorecells a b c d e f g h i1 2 3 4 5 6 7 e wayo8 9 Leiss use tholQuit comsind.10 11 12 e ma13 14 thk15 16 17 18 19 20 21 22 23 Fri05-Feb-8810:05AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]&#&  )NO CHANGE!;]Na1MENU WorksheetRangeCopyMoveFilePrintGraphDataAdvancedQuitCopyoneormorecells a b c d e f g h i1 2 3 4 5 6 7 '8 9 Let's use the Quit command first.10 11 '12 13 14 15 16 17 18 19 20 21 22 23 Fri05-Feb-8810:05AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am cH  P Ggraphs>I.1Ggraphs>I.2/Ggraphs>Def.1DGgraphs>Def.2YGgraphs>Def.3nGgraphs>Def.4Ggraphs>Def.5Ggraphs>def.6ZCarla.fontZSD.fontGgraphs>how.1Ggraphs>how.2Ggraphs>how.3Ggraphs>how.4$ZSD.font4ZFont3.fontGGgraphs>how.5\Ggraphs>how.6qZFont3.fontZSD.fontGgraphs>how.7Ggraphs>how.8Ggraphs>how.9Ggraphs>how.10Zsd.fontZfont3.font Ggraphs>how.11"Ggraphs>how.128ZFont3.fontKZSD.font[Ggraphs>how.13qGgraphs>how.14ZSD.fontZFont3.fontGgraphs>how.15Ggraphs>how.16Ggraphs>how.17Ggraphs>how.18ZFont3.fontZSD.font%Ggraphs>how.19;Ggraphs>how.20QZSD.fontaZCarla.fonttGgraphs>qseg2 graphs>FIB12am f JHPN  3NO CHANGE!+NQa1MENU WorksheetRangeCopyMoveFilePrintGraphDataAdvancedQuitCopyoneormorecells a b c d e f g h i1 2 3 4 5 6 7 '8 9 Let's use the Quit command first. 10 11 '12 13 14 15 It's real simple:16 17 18 Just type qto Quit.19 20 21 22 23 Fri05-Feb-8810:05AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]   3 O@NO CHANGE!RNWa1MENU No Yes SaveDon't exit program; return to READY mode a b c d e f g h i1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Mon 18-Jul-88 9:25 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]?  LNO CHANGE!^Na1MENU No Yes SaveDon't exit program; return to READY mode a b c d e f g h i1 2 3 ;4 5 The q ~ To select a command, type the first letter of ~ ~~ ~ the command name. ~ ~~ ~ Dismiss this message and type q for Quit. ~ time time2am ?fH  JHPN  2NO CHANGE!+?Na1MENU No Yes SaveExit program immediately -- ANY CHANGES SINCE LAST SAVE WILL BE LOST a b c d e f g h i1 2 3 ;4 5 TheQuitcommandgivesyouthreeoptions:6 7 8 9 NomeansyoudecidednottoexitSolutionDesigner.10 11 12 YesmeansyouwanttoexitSolutionDesigner13 14 anddo notwant to save any changes.15 16 ;17 18 19 20 21 22 23 Mon 18-Jul-88 9:27 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]777752am f/ JHPN  :NO CHANGE!+Na1MENU No Yes SaveSave changes to worksheet; then exit program a b c d e f g h i1 2 3 ;4 5 TheQuitcommandgivesyouthreeoptions:6 7 8 9 NomeansyoudecidednottoexitSolutionDesigner.10 11 12 YesmeansyouwanttoexitSolutionDesigner13 14 anddo notwant to save any changes.15 16 17 SavemeansyouwanttoexitSolutionDesigner18 19 andgoaheadandsaveanychanges.20 21 ;22 23 Mon 18-Jul-88 9:27 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]777757747 &2am Bf JHPN  CNO CHANGE!+NCa1MENU No Yes SaveSave changes to worksheet; then exit program a b c d e f g h i1 2 3 4 5 6 77 8 Let's assume you just finished changing a worksheet9 10 and you now want to exit Solution Designer.11 12 713 14 &15 16 17 To save and exit, types.18 19 20 &21 22 23 Mon 18-Jul-88 9:27 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] !NO CHANGE!3N  H  -UNO CHANGE!gNFThat's all there is to it!(Press Next Page to Continue)D'''''''u 'I NO CHANGE! N3a1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1O 2 3 4 5 6 !7 8 Now let's use the Finish key. 9 10 First, locate the Finish key11 12 on your keyboard.13 14 !15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:30 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] 8NO CHANGE!BNa1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1O 2 3 4 5 6 !7 8 Now let's use the Finish key. 9 10 First, locate the Finish key11 12 on your keyboard.13 14 !15 16 #17 18 After you've done so,19 20 Press Next Page to Continue21 22 #23 Mon 08-Feb-88 12:30 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]#####s ~ You are practicing how to save your worksheet ~ ~~ ~ and exit Solution Designer. ~ ~~ ~ Dismiss this message and press s for Save. ~ time 0x0C time time2am f: JHPN  NO CHANGE!+N  @  #MNO CHANGE!_Na1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit  Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1L 2 #3 4 Notice your mode indicator.5 6 You are currently in MENU mode.7 8 #9 !10 11 You can use the Finish key 12 13 if you're in READY mode only.14 15 !16 #17 18 Therefore, press Cancel 19 20 to remove the command menu.21 22 #23 Mon 08-Feb-88 12:30 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]#########I #  O-NO CHANGE!?Na1READY a b c d e f g h i1234567891011121314151617181920212223Thu 04-Feb-88 4:26 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  #NO CHANGE!Na1READY a b c d e f g h i1234The mode indicator5 6now displays READY.789101112Go ahead and finish.13141516!1718Press theFinishkey.1920!212223Thu 04-Feb-88 4:26 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] s ; NO CHANGE! Nia1MENU No Yes SaveExit program immediately -- ANY CHANGES SINCE LAST SAVE WILL BE LOST a b c d e f g h i1 2 3 4 5 '6 7 The Quit command menu displays.8 9 Go ahead and exit Solution Designer10 11 without saving any changes.12 13 '14 15 '16 17 18 To do this, typeyfor Yes.19 20 21 '22 23 Mon 18-Jul-88 9:27 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]   NO CHANGE! N   E NO CHANGE! N8help>TF1.true%#Lintro>help>TF1.common.path2am 9e JHPN  NO CHANGE!+N'! %NO CHANGE!9NHow To Get Help in Solution Designer5To get help anytime you need more information on a command, function, orconcept, press the Help key.'To return to your worksheet from a Help!screen, press the Cancel key or theFinish key.When in Help, to display the Help Tableof Contents, press the CONTENT (F1)function key.$5!&'' 2am 2f JHPN  NO CHANGE!+2N@HowToGetHelpinSolutionDesigner5To get help anytime you need moreYouhavereachedtheinformation on a command, function, orendofthislesson.concept,presstheHelpkey.Wesuggestyouproceedtothenextlesson,To return to your worksheet from a HelpHow To Finish Fromscreen,presstheCancelkeyortheSolution Designer.Finishkey.PressNextPagetoreturntotheIntromenu.When in Help, to display the Help Tableof Contents,presstheCONTENT(F1)functionkey.5555 ! 5 &5 $555 '5 %55555 '5   55555K 2am ng JHPN  NO CHANGE!+=NSolution Designer Help Copying Cell Contentsp COMMAND PATH: /c (or Copy) DESCRIPTION: The Copy command copies the entire contents FROM a cell or group of cells TO another selected location.< 5  PROCEDURE: To copy a ceTo get help on5 1 Make sure you arother subjects in5 2 Move the cursor Solution Designer,f range of cells) you want to copy. 5 press the appropriate 3 Type: /c 5 function key.% The cursor is anied before selecting the Copy command. p 4 Select the range of cells you want to copy FROM.p If your cursor is not on the beginning of the range you want to copy, type the beginning cell address followed by a period (.), then move the cursor to indicate ending cell address in the range and press Press NEXT PAGE for more information.+ CONTENTUSEHELPCOMMAND RANGE  MOVE  FILE  CURSOR CELLREF   5 %h  uNO CHANGE!nNSolution Designer Help 2  Copying Cell Contents2 COMMAND PATH: /c (or Copy) 2 DESCRIPTION: The Copy command copies the entire contents FROM a cell or group of cells TO another selected location.< 5  PROCEDURE: To copy a ceTo get help on5 1 Make sure you arother subjects in5 2 Move the cursor Solution Designer,f range of cells) you want to copy. 5 press the appropriate 3 Type: /c 5 function key.% The cursor is anied before selecting the Copy command. p 4 Select the range of cells you want to copy FROM.p If your cursor is not on the beginning of the range you want to copy, type the beginning cell address followed by a period (.), then move the cursor to indicate ending cell address in the range and press Press NEXT PAGE for more information.+ CONTENTUSEHELPCOMMAND RANGE  MOVE  FILE  CURSOR CELLREF  p 5 5555555555%+  6 NO CHANGE! nNSolution Designer Help 2  Copying Cell Contents2 COMMAND PATH: /c (or Copy) 2 DESCRIPTION: The Copy command copies the entire contents FROM a cell or group of cells TO another selected location.< 5  PROCEDURE: To copy a ceTo get help on5 1 Make sure you arother subjects in5 2 Move the cursor Solution Designer,f range of cells) you want to copy. 5 press the appropriate 3 Type: /c 5 function key.% The cursor is anied before selecting the Copy command. p 4 Select the range of cells you want to copy FROM.p If your cursor is not on the beginning of the range you want to copy, type the beginning cell address followed by a period (.), then move the cursor to indicate ending cell address in the range and press Press NEXT PAGE for more information.+ CONTENTUSEHELPCOMMAND RANGE  MOVE  FILE  CURSOR CELLREF  p 5 5555555555%+  ONO CHANGE!nNSolution Designer Help 2  Copying Cell Contents2 COMMAND PATH: /c (K or Copy) 2 DESCRIPTION: The Copy command copies the entire contents FROM a cell or group of cells TO another selected location.< 5  PROCEDURE: To copy a ceTo get help on5 1 Make sure you arother subjects in5 2 Move the cursor Solution Designer,f range of cells) you want to copy. 5 press the appropriate 3 Type: /c 5 function key.% The cursor is anied before selecting the Copy command. p 4 Select the range of cells you want to copy FROM.p If your cursor is not on the beginning of the range you want to copy, type the beginning cell address followed by a period (.), then move the cursor to indicate ending cell address in the range and press Press NEXT PAGE for more information.+ CONTENTUSEHELPCOMMAND RANGE  MOVE  FILE  CURSOR CELLREF  p 5 5555555555%+ NO CHANGE!.MNSolution Designer Help 2  Copying Cell Contents2 COMMAND PATH: /c (or Copy) 2 DESCRIPTION: The Copy command copies the entire contents FROM a cell or group of cells TO another selected location.< 5  PROCEDURE: To copy a ceTo get help on5 1 Make sure you arother subjects in5 2 Move the cursor Solution Designer,f range of cells) you want to copy. 5 press the appropriate 3 Type: /c 5 function key.% The cursor is anied before selecting the Copy command. , * 4 Select $ But for now, just press Next Page. If your you want to copy, type th*d (.), then move the cursor to indicate ending cell address in the range and press Press NEXT PAGE for more information.+ CONTENTUSEHELPCOMMAND RANGE  MOVE  FILE  CURSOR CELLREF  p 5 5555555555,$*$*$*$c%+2am Ng JHPN  NO CHANGE!+NNSolution Designer Help 2  Copying Cell Contents2 COMMAND PATH: /c (or Copy) 2 DESCRIPTION: The Copy command copies the entire contents FROM a cell or group of cells TO another selected location.< ,  PROCEDURE: To copy cell contents:$ * 1 Make su$ This is just one of several function 2 Move thof cells) you want to copy key menus that you will see, and $  3 Type: each function key menu provides you$  The cur with information about specificre selecting the Copy co$ Solution Designer commands, 4 Select $ functions and concepts. If your you want to copy, type th*d (.), then move the cursor to indicate ending cell address in the range and press Press NEXT PAGE for more information.+ CONTENTUSEHELPCOMMAND RANGE  MOVE  FILE  CURSOR CELLREF  p , $$*L $*$*$*$*$*$*$*$*$*$*$*$*$c%+ ~ You are to display the Help Table of Contents. ~ ~~ ~ To do this, press the CONTENT function key. ~ ~~ ~ Dismiss this message and press f1. ~ F1 time 0x0C ~ You are viewing the list of various Help topics. ~ ~ There are three pages of topics. ~ ~ ~ ~ Dismiss this message and press Next Page to ~ ~ view the next page of Help topics. ~ NextPage time 0x0C ~ You are viewing the list of various Help topics. ~ ~ There are three pages of topics. ~ ~ ~ ~ Dismiss this message and press Next Page to ~ ~ view the next page of Help topics. ~ NextPage time time 8  OENO CHANGE!WNa17 ' Balance Due From EmployeeREADY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car  40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances 16 Balance Due To Employee 17 Balance Due From Employee 18 19 20 21 22 23 Tue 09-Feb-88 11:27 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  7NO CHANGE!*NIa17 ' Balance Due From EmployeeREADY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses Fantastic!15 Less Advances 16 Balance Due To Employee 17 Balance Due From Employee (Press Next Page to Continue)18 19 20 21 22 23 Tue 09-Feb-88 11:27 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T%  %% %% JHPN  0NO CHANGE!+NZQuestion 2What Is a Range?PUWhich of the following define ranges?"F1 - a1..a1F2 - g8..g4F3 - a1..b3F4 - All of the aboveF5 - None of the above#That's correct, however, all three choices are valid ranges.The appropriate answer is F4.#P///          ##L #####2am 2c N 2 F1  F2  F3  F4  F5 2am d= JHPN  NO CHANGE!+N'! &NO CHANGE!NWhat Is a Range?5A range is a rectangular block of cells.It can be a single cell or a group ofcontiguous, or adjacent cells.'Several commands, for instance, the Copy!command, require you to define a rangeon which to perform the command.5