IMD 1.18: 15/05/2012 9:55:17 solution designer tutorial sd-2 2 of 7 71-03155-07  xSD-2monetc-fg>$:ys`SD SysF9|M^2am >f JHPN   NO CHANGE!+>Nja1 MENU Retrieve Save Combine Xtract Erase List Import Directory Read in a spreadsheet file  a b c d e f h i1 2 3 4 5 @6 @7 68 9 If you decide that you do not want to continue10 11 with a command, you can cancel the command12 13 at any time.14 15 616 @17 @18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]6666666+2am e JHPN   ENO CHANGE!+ N- Question -The Solution Designer Command MenuPFILLINTHEBLANKNa1MENU WorksheetRangeCopyMoveFilePrintGraphDataAdvancedQuitRetrieve, Save, Combine, Xtract, Import a b c d e f g h iThis is the command panel. The bottom linedisplaysa list of commands. These commands belong tothe~~ commands menu.N(Type your answer and press GO when ready)"PN e* 2am c7 JHPN  .NO CHANGE!+DN,The Solution Designer Command MenuPp"Ppo  '|NO CHANGE!NThe Solution Designer Command MenuPVery good.The commands,Retrieve, Save, Combine, Xtract, and Import,all belong to the Filecommand menu."PG%2am $c P GIntro>Cmds>FIB1.a000&$LIntro>Cmds>FIB1.common.path2am :d JHPN   ,NO CHANGE!+:NThe Solution Designer Command MenuPThat's incorrect. The commands,Retrieve, Save, Combine, Xtract, and Import,all belong to the Filecommand menu.The bottom line of the command paneldisplays additional commands or a descriptionof the highlighted command."PG%2am $c P GIntro>Cmds>FIB1.a999&$LIntro>Cmds>FIB1.common.path 2amch!p<File2am c P  Intro>Cmds>FIB22am qd JHPN  ONO CHANGE!+qN8- Question -The Solution Designer Command MenuPFILLINTHEBLANKNNNNNCTo select commands, a worksheet must be in ~~ mode.CNNNNNN(Type your answer and press GO when ready)"P 7*2am c  JHPN  ONO CHANGE!+DN,The Solution Designer Command MenuPp"Ppo .|NO CHANGE!NsThe Solution Designer Command MenuPSCorrect!To select commands, a worksheet must be in MENU mode.^"Pd 2am $c P GIntro>Cmds>FIB2.a000&$LIntro>Cmds>FIB2.common.path2am ci JHPN   ONO CHANGE!+NThe Solution Designer Command MenuPThat's incorrect.To use commands, a worksheet must be in MENU mode.Whenever the mode indicator says MENU, it means that a command menu is displayed.$"P2am $c P GIntro>Cmds>FIB2.a999&$LIntro>Cmds>FIB2.common.path2amch!p<MENU 2am c P ZCarla.fontZSD.font,GIntro>Cmds>Inv.1EGIntro>Cmds>Inv.2^GIntro>Cmds>Inv.3wXIntro>Cmds>TWInv1GIntro>Cmds>CanclXIntro>Cmds>TWCanclGIntro>Cmds>Inv2XIntro>Cmds>TWInv2GIntro>Cmds>Sel.1GIntro>Cmds>Sel.2)GIntro>Cmds>Sel.3BGIntro>Cmds>Sel.4[GIntro>Cmds>Sel.5tGIntro>Cmds>Sel.6GIntro>Cmds>Sel.7GIntro>Cmds>Sel.8GIntro>Cmds>Sel.9Gintro>cmds>goZSD.fontZCarla.fontGintro>cmds>qseg1* intro>cmds>Fib32am dx JHPN  NO CHANGE!+N- Question -The Solution Designer Command MenuPFILLINTHEBLANKNN 7 You are currently in READY mode. The keystroke combination to type if you want to use the Worksheet/Global/Default commands is ~~ . 7 NNN(Type your answer and press GO when ready)"Pd 1*2am cc JHPN  +NO CHANGE!+NThe Solution Designer Command MenuPExcellent! If you are currently in READY mode,the keystroke combination to use theWorksheet/Global/Defaultcommandsis/wgd."P57 2am $c P GIntro>Cmds>FIB3.a000&$LIntro>Cmds>FIB3.common.path2am dS JHPN   $NO CHANGE!+NThe Solution Designer Command MenuPThat's incorrect. If you are currently in READY mode,The keystroke combination you type to use the Worksheet/Global/Default commands is/wgd./displays the command menu,wdisplays the Worksheet commands,gdisplays the Global commands, andddisplays the Default commands."P2am $c P GIntro>Cmds>FIB3.a999&$LIntro>Cmds>FIB3.common.path2amc h!p</wgd(awgd2am c P GIntro>Cmds>Rev.1"GIntro>Cmds>Rev.2;Gintro>cmds>rev.3TNIntro>Menu2am c P ZCarla.fontZSD.font,GIntro>Cmds>SegCGIntro>Cmds>Menu.1]GIntro>Cmds>Menu.2wGIntro>Cmds>Menu.3GIntro>Cmds>Menu.4GIntro>Cmds>Menu.5GIntro>Cmds>Menu.6Gintro>cmds>menu.7Gintro>cmds>menu.8XIntro>Cmds>TWMenu-ZSD.font=ZCarla.fontPGintro>cmds>Qseg1i Intro>Cmds>FIB12am eT JHPN  ONO CHANGE!+N'a1 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 75 76 -7 8 There are two ways to select a command:9 10 -11 712 713 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ], 2am f JHPN   NO CHANGE!+N?a1 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 75 76 -7 8 There are two ways to select a command:9 10 11 12 -13 714 715 16 17 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ],&  3NO CHANGE!ENWa1 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 75 76 -7 8 There are two ways to select a command:9 10 11 12 13 14 -15 716 717 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ],`  mNO CHANGE!;Noa1 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 75 76 -7 8 There are two ways to select a command:9 10 11 12 13 14 15 16 -17 718 719 20 21 22 23 Thu04-Feb-884:28PM 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 Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 2 3 4 75 76 -7 8 There are two ways to select a command:9 10 11 12 13 14 15 16 17 18 -19 720 721 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ],4 ;ANO CHANGE!SNa1 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 75 76 -7 8 There are two ways to select a command:9 10 11 Type the first letter of a command12 13 14 15 16 17 18 -19 720 721 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ])))),2am f] JHPN  4NO 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 i1 2 3 4 75 76 -7 8 There are two ways to select a command:9 10 11 Type the first letter of a command12 13 14 Use Arrow keys to move highlight15 to command, then press Return16 17 18 -19 720 721 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ])))))),2am e JHPN  9NO CHANGE!+cNa1 MENU 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 This is the File command submenu.8 9 %10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] %%%  BNO CHANGE!fNa1 MENU 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 This is the File command submenu.8 9 %10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]%%% B NO CHANGE!2pNa1 MENU 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 This is the File command submenu.8 9 %10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]%%% B NO CHANGE! Na1 MENU 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 This is the File command submenu.8 9 %10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]%%%B O NO CHANGE!a Na1 MENU Retrieve Save Combine Xtract Erase List Import DirectoryRead in a spreadsheet file(  a b c d e f g  h i1 2 3 4 5 %6 7 This is the File command submenu.8 9 %10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]%%%2am e JHPN  @NO CHANGE!+Na1 MENU Retrieve Save Combine Xtract Erase List Import DirectoryRead in a spreadsheet file&  a b c d e f g  h i1 2 3 4 5 %6 7 This is the File command submenu.8 9 %10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table   Calc  Graph ]%%% 7NO CHANGE!Na1 MENU Retrieve Save Combine Xtract Erase List Import DirectoryRead in a spreadsheet file  a b c d e f g  h i1 2 3 4 5 %6 7 This is the File command submenu.8 9 %10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]%%%S .`NO CHANGE!rNa1 MENU Retrieve Save Combine Xtract Erase List Import DirectoryRead in a spreadsheet file  a b c d e f g  h i1 2 3 4 5 %6 7 This is the File command submenu.8 9 %10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]%%% " NO CHANGE! Na1 MENU Retrieve Save Combine Xtract Erase List Import DirectoryRead in a spreadsheet file  a b c d e f g  h i1 2 3 4 5 %6 7 This is the File command submenu.8 9 %10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  ]%%%   NO CHANGE! Na1 MENU Retrieve Save Combine Xtract Erase List Import DirectoryRead in a spreadsheet file & a b c d e f g  h i1 2 3 4 5 #6 7 This describes the highlighted 8 9 command.10 11 #12 13 14 15 16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]#####2am f JHPN  NO CHANGE!+NTa1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Retrieve, Save, Combine, Xtract, Import0 a b c d e f g h i1 2 3 4 5 A6 A7 38 9 The second way to select a command is to10 11 move the highlight to the desired command name.12 13 314 A15 A16 17 18  19 20 21 22 23 Fri 05-Feb-88 10:02 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]///-2am ew 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 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]   NO CHANGE! JNa1 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 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]W  dNO CHANGE!vN:a1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Inert, Delete, Column-Width, Erase, Titles, Window, Statu a  b c d e f g  h i1 2 3 4 5 This is Solution Designer's6 7 main commands menu.8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph K  7 72am f JHPN  NO CHANGE!+NCa1 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 6 The commands menu is displayed7 8 in the command panel.9 10 "11 12 13 14 15 16 17 18 19 20 21  22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  6"""  "P2am f JHPN  NO CHANGE!+NPa1 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 6 The command panel consists of the 7 8 top three lines of the screen.9 10 %11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  6%%%%% 2am g~ JHPN   4NO CHANGE!+Na1 MENU WorksheetRange Copy Move File Print Graph Data Advanced Quit  Global, Inert, Delete, Column-Width, Erase, Titles, Window, Status  a  b c d e f g  h i1 2 3 4 05 6 You're already familiar with the top line:7 8 It currently contains the cell pointer9 10 location and the mode indicator. 11 12 Later on, you'll see that it also displays13 14 the contents and format of the current cell.15 16 17 018 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  ; 8 O000000000000P 2am xf JHPN   NO CHANGE!+xNa1 MENU WorksheetRange Copy Move File Print Graph Data Advanced Quit  Global,Insert, Delete, Column-Width, Erase, Titles, Window, Status   b c d e f g h i1 2 3 4 15 6 The middle line displays the commands menu.7 8 The commands menu displayed will be either 9 10 the main commands menu (currently shown).11 12 113 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph K < <1111111P2am f JHPN   NO CHANGE!+Nqa1 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Specify glbal worksheet parameters  a  b c d e f g  h i1 7 2 3 4 /5 6 . or the commands menu of one of the main7 8 commands. For instance, this is the 9 10 Worksheet commands menu.11 12 /13  14 15 16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:28 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph K 7  75///////P2am 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 e{ JHPN  ONO CHANGE!+N'! 5NO CHANGE!NThe Solution Designer Command Menu5To display the command menu, type slash (/).To select a command,'1)Type the first letter of a!command, OR2)Use the Arrow keys to movehighlighted to command, thenpress the Return key.To cancel a command,press the Cancel key or Code-Cancel."5.X2am Dd JHPN  ONO CHANGE!+DNThe Solution Designer Command Menu5To perform a command or function,press either the Return key or theGo key.'!"5 To cancel a command,presstheCancelkeyorCode-Cancel.555 55555 5555555555555 55552am eh JHPN   ONO CHANGE!+N  @ OMNO CHANGE!_NPa1 D DD a D1 D2 D3 D4 D5 D6 D7 D8 D9 D10 D11 D12 D13 D14  D15 D16 D17 D18 D19 D20 D21 D22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph   H OUNO CHANGE!g'Na1 8 88 a b 81 82 83 84 D5 D6 D7 88 89 810 811 812 813 814 815 816 @17 @18 @19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 2am Xe JHPN  NO CHANGE!+XNa1 READY a b c d e f g h i1 2 3 4 5 6 '7 8 In the upcoming lessons, you will9 10 have the opportunity to use several11 12 Solution Designer commands.13 14 '15 16 17 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am We JHPN  ONO CHANGE!+WNa1 READY a b c d e f g h i1 2 3 4 5 '6 7 Sometimes it is necessary to select8 9 more than one command to get to10 11 the command you want to use.12 13 '14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am he  JHPN  ONO CHANGE!+hNa1 READY a b c d e f g h i1 2 3 4 45 6 For example, to display numbers7 8 as monetary values, you must use9 10 the Worksheet/Global/Format/Currency command .11 12 413 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am xe JHPN   NO CHANGE!+NWa1 READY a b c d e f g h i1 2 3 4 5 6 7 8 9 First, type / to display the main commands menu,10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  (NO CHANGE!:xNa1 MENU WorksheetRangeCopyMoveFilePrintGraphDataAdvancedQuitGlobal,Insert,Delete,Column-Width,Erase,Titles,Window,Status a b c d e f g h i1 2 3 4 5 6 7 8 9 First, type / to display the main commands menu,10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Wind2am e JHPN  NO CHANGE!+Na1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Globl, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 2 3 then, select Worksheet to select the Worksheet commands,4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph >]    2am e\ JHPN  NO CHANGE!+Na1 $READY    a b c d . so sp sq sr1 2 3 4 5 6 7 Each cell is identified by a cell address,8 9 or cell reference. It consists of the 10 11 column letter followed by the row number,12 13 for example, a1.14..818781888189819081918192Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph '-......... " ]ow Query Table  Calc  Graph ]se, Titles, Window, Status a b c d e f g h i1 2 3 Select Worksheet to select the Worksheet commands,a1 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Speify global worksheet parameters0  a b c d e f g h i1 L 2 3 then select Global to select the Global commands,11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph >]   " ]2am ff   JHPN   NO CHANGE!+`Na1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Globl, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 2 3 then,selectWorksheettoselecttheWorksheetcommands,4 5 6 7 8 9 10 11 12 13 14 15 16 a1 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Speify global worksheet parameters0  a b c d e f g h i1 L 2 3 then select Global to select the Global commands,Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph >]    ] ONO CHANGE!cNa1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Globl, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 2 3 then,selectWorksheettoselecttheWorksheetcommands,4 5 6 7 8 9 10 11 a1 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Speify global worksheet parameters0  a b c d e f g h i1 L 2 3 then select Global to select the Global commands,19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph >]    ] D NO CHANGE!, fNa1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Globl, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 2 3 then,selectWorksheettoselecttheWorksheetcommands,a1 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Speify global worksheet parameters0  a b c d e f g h i1 L 2 3 then select Global to select the Global commands,11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph >]    " ]2am Le JHPN  8NO CHANGE!+LNa1READY a b c d e f g h i1234567)89As you can see, the entire worksheet1011cannot be displayed at any one time.1213The worksheet is displayed one window1415at a time.1617)181920212223 Thu 04-Feb-88 4:26 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  2am 3g JHPN   NO CHANGE!+%NWa1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Globl, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 2 3 then,selectWorksheettoselecttheWorksheetcommands,a1 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Speify global worksheet parameters0  a b c d e f g h i1 L 2 3 then select Global to select the Global commands,11 12 13 14 15 16 17 a1 MENU Format Label-Prefix Column-Width Recalculation Protection Default Zero Speify global format>  a b c d e f g h i1 L 2 3 then select Format to display the Format commands, Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph >]      ] ]P O]NO CHANGE!o3Nia1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Globl, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 2 3 then,selectWorksheettoselecttheWorksheetcommands,a1 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Speify global worksheet paramet2am g JHPN   NO CHANGE!+Na1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Globl, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 2 3 then,selectWorksheettoselecttheWorksheetcommands,a1 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Speify global worksheet parameters0  a b c d e f g h i1 L 2 3 then select Global to select the Global commands,a1 MENU Format Label-Prefix Column-Width Recalculation Protection Default Zero Speify global format>  a b c d e f g h i1 L 2 3 then select Format to select the Format commands,a1 MENU Fixed Scientific Currency , General +/- Percent Date Text Hidden VisibStandard format (x.xx r x.xxExx), a b c d e f g h i1  2 3 and finally, select the Currency comma  2am ep JHPN  'NO CHANGE!+Naa1 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 16 7 Therefore, to select 8 9 the Worksheet/Global/Format/Currency command,10 11 12 You wouldtype/wgfc.13 14 15 116 17 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am eA JHPN  NO CHANGE!+Na1 MENU RetrieveSaveCombineXtractEraseListImportDirectoryReadinaspreadsheetfile a b c d e f g h i1 2 3 4 5 6 (7 8 9 To cancel the File command,10 11 12 simply press Cancel.13 14 15 (16 17 18 19 20 21 22 23 Thu 04-Feb-88 14:29 PM 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 Retrieve, Save, Combine, Xtract, Import 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 Fri 05-Feb-88 10:02 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]; HNO CHANGE!ZNa1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Retrieve,Save,Combine,Xtract,Import a b c d e f g h i1 2 3 4 5 6 7 The main commands menu reappears and8 9 the File command is highlighted.10 11 (12 13 14 15 16 17 18 19 20 21 22 23 Fri 05-Feb-88 10:02 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ](((((   ~To remove a command menu from the command panel, ~ ~~ ~ press Cancel. ~ ~~ ~Dismiss this message and press Cancel. ~ Cancel time time2am fO JHPN  ONO 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 i1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]m zNO 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 i1 2 3 4 15 6 Let's try it.7 8 Select the File command using the first way:9 10 Type in the first letter of the File command.11 12 113 14 15 #16 17 18 To do this, typef.19 20 21 #22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]      b  9oNO CHANGE!aNa1 MENU 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 This is the File commands menu.8 9 #10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]###  8 NO CHANGE! dNa1 MENU 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 This is the File commands menu.8   9 #10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]###e r NO CHANGE! zNa1 MENU 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 This is the File commands menu. 8 9 #10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]###  8 NO CHANGE!Na1 MENU 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 This is the File commands menu. 8 9 #10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]### 9NO CHANGE!N a1 MENU 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 This is the File commands menu. 8 9 There are eight File commands.10 11 #12 13 14 15 16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]#####x 9NO CHANGE!NPa1 MENU 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 This is the File commands menu.8 9 There are eight File commands.10 11 Notice that the highlighted12 13 command is described.14 15 #16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]######### 9NO CHANGE!1Nla1 MENU Retrieve Save Combine Xtract Erase List Import Directory Read in a spreadsheet file   a b c d e f  h i1 2 3 4 5 #6 7 This is the File commands menu.8 9 There are eight File commands.10 11 Notice that the highlighted12 13 command is described.14 15 #16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]#########    1 NO CHANGE!/Nla1 MENU Retrieve Save Combine Xtract Erase List Import Directory Read in a spreadsheet file    a b c d e f  h i1 2 3 4 5 #6 7 This is the File commands menu.8 9 There are eight File commands.10 11 Notice that the highlighted12 13 command is described.14 15 #16 17 18 19 20 21 22 23 Thu 04-Feb-88 4:29 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]#########time f ~In all our lessons, unless otherwise specified, ~ ~ you will select a command by typing the first ~ ~ letter of a command. ~ ~~ ~Dismiss this message and type 'f' for File. ~ time time time time time time time time2am lf JHPN  ONO CHANGE!+'Na1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Retrieve, Save, Combine, Xtract, Import0 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 Fri 05-Feb-88 10:02 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]R _NO CHANGE!qlNa1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Retrieve, Save, Combine, Xtract, Import0 a b  c d e f g h i1 2 3 4 5 Select the Copy command.6 7 8 9 %10 11 There are two steps involved:12 13 14 First, use the Left Arrow15 16 17 key to move the highlight to18 19 the Copy command.20 21 %22 23 Fri 05-Feb-88 10:02 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 Move one or more cellsA 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 Fri 05-Feb-88 10:04 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  + >8 NO CHANGE!J NLa1 MENU Worksheet Range Copy t Graph Data Advanced Quit Copy one or more cells  / a b c  d  e f g h i1 2 3 4 5 The Copy command is6 7 highlighted and described.8 9 10 11 12 13 14 .15 16 Then, pressReturnto select Copy.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  ] [ 3h NO CHANGE!z 0Na1 POINTEnter range to copy FROM: a1..a1 a b c d e f g h i1 2 '3 4 The Copy command prompt displays.5 6 '7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Fri 05-Feb-88 10:08 AM Macro  Edit  Name Abs  Go To  Window Query Table   Calc  Graph ]''' 3NO CHANGE!BNa1 POINTEnter range to copy FROM: a1..a1 a b c d  e f g h i1 2 3 4 The Copy command prompt displays.5 6 '7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22  23 Fri 05-Feb-88 10:08 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]'''  3NO CHANGE!*Na1 POINTEnter range to copy FROM: a1..a1 a b c d  e f g h i1 2 3 4 The Copy command prompt displays.5 6 (You'll learn how to use Copy7 8 later on.)9 10 '11 12 13 14 15 16 17 18 19 20 21 22 23 Fri 05-Feb-88 10:08 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]''''''' NO CHANGE!7NWa1 POINTEnter range to copy FROM: a1..a1 a b c d e f g h i1 2 '3 4 The Copy command prompt displays.5 6 (You'll learn how to use Copy7 8 later on.)9 10 '11 12 713 14 For now, I want you to cancel this Copy command.15 16 If you forgot how to do this, press Help.17 18 719 20 21 22 23 Fri 05-Feb-88 10:08 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ])''''''')000 4&NO CHANGE!81N5a1 POINTEnter range to copy FROM: a1 a b c d e f g h i1 2 3 4 /5 6 Notice that the Copy prompt did not go away7 8 entirely. For some commands, such as Copy,9 10 you need to press Cancel more than once.11 12 /13 14 15 16 Press Cancel once more.17 18 19 20 21   22 23 Fri 05-Feb-88 10:09 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]5    i +vNO CHANGE!N]a1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Copy one or more cells 0 a b c d  e f g h i1 2 3 4 5 6 The main menu is redisplayed.7 8 !9 10 11 12 113 14 Now let's go back to the Copy command prompt. 15 16 117 18 19 20 Typec.21 22 23 Fri 05-Feb-88 10:05 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]!!!  NO CHANGE!NRa1 POINTEnter range to copy FROM: a1..a1 a b c d e f g h i1 2 3 4 5 86 7 To cancel this command, you had to press Cancel8 9 twice. Well, there's another way to cancel a10 11 command: Use Code Cancel.12 13 814 15 (16 17 18 Try it. PressCode Cancel.19 20 21 (22 23 Fri 05-Feb-88 10:08 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  Very good!7 8 Note that Code Cancel returns you to READY 9 10 mode rather than the main commands menu.11 12 .13 14 15 Press Next Page16 17 to Continue18 19 20 21 22 23 Fri05-Feb-8810:08 Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ].......time  ~You are learning another way to select a command, ~ ~ which is to move the highlight to the desired ~ ~ command using either the Right or Left Arrow. ~ ~~ ~Dismiss this message and press the Left Arrow. ~ LeftArrow  ~ You're almost there. ~ ~ The command you want is Copy. ~ ~~ ~Dismiss this message and press the Left Arrow ~ ~once more. ~ LeftArrow 0x0A ~ To select a command, you must press Return. ~ ~ Get to know this key. ~ ~ You will be using it frequently. ~ ~~ ~ Dismiss this message and press Return. ~ Return time time time  ~ To cancel any command, ~ ~  ~ ~ simply press the Cancel key. ~ ~~ ~ Dismiss this message and press Cancel. ~  Cancel c ~ Remember, to select a command, type the first ~ ~~ ~ letter of the command n  ame. ~ ~~ ~ Dismiss this message and press 'c'. ~ ~Code Cancel returns you to the main command menu. ~ ~~ ~ ~ ~ Dismiss this message, then ~ ~ hold the Code key down while pressing Cancel. ~ CodeLeft Cancel time2am Gf JHPN   ONO CHANGE!+Na1 READYO  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 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  :NO CHANGE!GN\a1 READYO  a b c d e f g h i1 2 .3 4 All Solution Designer commands are5 6 available from the main commands menu.7 8 .9 %10 11 To display the commands menu,12 13 14 type/,15 16 17 the slash key.18 19 20 Type this key right now.21 22 %23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] !        ! - O:NO CHANGE!LGNa1 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 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-88 4:28 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] M NO CHANGE! ANoa1 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 Good. Notice that your worksheet4 5 is now in MENU mode instead of6 7 Ready mode.8 9 %10 11 12 13 14 15 16 17 18 Press Next Page to Continue19 20 21 22 23 Thu04-Feb-88 4:28 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]%%%%%%%!!!!!  time / ~The slash key is used to display the command menu.~ ~The command menu must be displayed first before ~ ~ you can use any of the available commands. ~ ~~ ~ Dismiss this message and press '/'. ~ Slash time time2am Cf JHPN  %NO CHANGE!+N N)StatusContextsyoucanreturntoApplicationsyoucanstart)Art DesignerDocument DesignerExecutiveMailSolution Designer)PressGOtoreturntothiscontext.Exec   A D  S D   D D  Mail N 2  ANO CHANGE!CN utive1(OSClstrLfMp. Ueary:SMryonb2  mStusConextycnrrpicaioyoucsrtAr eirDocumensigerxtiveS li n D ignressGOrturthiscntex.xe A DS  D D i  4V #cNO CHANGE!u Nc xecutive11.(OSt1ClstrLfMp-.8) Uerame:aryt:[Sys]Mon Feb 15, 1988:2M mdtusConyciaioysrAr Dcmsietve SgrsGthscntex S Di 4 # NO CHANGE! |N$Executive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPat:[Sys]Mon Feb 15, 19882:22PM!  mndymtveSsx S!    @  * NO CHANGE!< NtExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]Mon Feb 15, 19882:22PMP CommandPG   NO CHANGE! ,NExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]Mon Feb 15, 19882:22PMP CommandB?To see if you have the Context Manager installed,you press ACTION-GO. The ACTION key is held downwhile th e GO key is pressed.For this exercise, DO NOT PRESS ACTION-GO. Press the HELP key instead.?PGJ????????//%%7 %NO CHANGE!7N  L YNO CHANGE!kNbExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]Mon Feb 15, 19882:22PMPN)StatusContextsyoucanreturntoApplicationsyoucanstart)ArtDesignerDocumentDesignerExecutiveMailSolution DesignerGood. Notice that one of the "Applications you can start" is the Solution Designer.  D D  Mail #Using the DOWN ARROW key, move the selection to "Solution Designer".Pp,,,,,,,,,,,,,,C %PNO CHANGE!bMNExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]Mon Feb 15, 19882:22PMPN)StatusContextsyoucanreturntoApplicationsyoucanstart)ArtDesignerDocumentDesignerExecutiveMailSolution Designer)Selectapplication,optionallychoosefunctionkey,thenpressGO.Exec   A D  S D   D D  Mail NP2  0NO CHANGE!MNExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]Mon Feb 15, 19882:22PMPN)StatusContextsyoucanreturntoApplicationsyoucanstart)ArtDesignerDocumentDesignerExecutiveMailSolution Designer)Selectapplication,optionallychoosefunctionkey,thenpressGO.Exec   A D  S D   D D  Mail NPu2  0(NO CHANGE!:MNExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]Mon Feb 15, 19882:22PMPN)StatusContextsyoucanreturntoApplicationsyoucanstart)ArtDesignerDocumentDesignerExecutiveMailSolution Designer)Selectapplication,optionallychoosefunctionkey,thenpressGO.Exec   A D  S D   D D  Mail NP`%2  NO CHANGE!N\Executive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]Mon Feb 15, 19882:22PMPN)StatusContextsyoucanreturntoApplicationsyoucanstart)ArtDesignerDocumentDesignerExecutiveMailNow press GO to startSolution Designerthe Solution Designer.)Selectapplication,optionallychoosefunctionkey,thenpressGO.Exec   A D  S D   D D  Mail NP<2l  yNO CHANGE!NExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]Mon Feb 15, 19882:22PMPN)StatusContextsyoucanreturntoApplicationsyoucanstart)ArtDesignerDocumentDesignerExecutiveMailSolution Designer )Loading .Exec   A D  S D   D D  Mail NP2 ONO CHANGE!N    NO CHANGE!mN]Solution Designer Version 1.0 Copyright (C) 1987 Convergent, Inc. g tNO CHANGE!NHa1 READYO  a b c d e f g h i1O 2O 3O 4O 5O 6O 7O 8O 9 You're getting the hang of it! 10N 11 Press NEXT PAGE to continue 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Thu04-Feb-88 4:26 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]&&&&time time time time time Action  time DownArrow DownArrow  ~To start up Solution Designer from the Context ~ ~~ ~Manager, you must press Go. ~ ~~ ~Dismiss this message and press Go ... ~ Go time time time time2am *e JHPN   0NO CHANGE!+NN)StatusContextsyoucanreturntoApplicationsyoucanstart)Art DesignerDocument DesignerExecutiveMailSolution Designer)PressGOtoreturntothiscontext.Exec   A D  S D   D D  Mail N 2 ANO CHANGE!*NThis is the Context Manager screen. You may or may notSthave the Context Manager installed on your system.artDocument DesignerExecutiveMailSolution Designer)PressGOtoreturntothiscontext.Exec   A D  S D   D D  Mail N AAAAAAA22am f  JHPN   CNO CHANGE!+NThis is the Context Manager screen. You may or may notSthave the Context Manager installed on your system.artihn goohDocucent tesigierExe utiv hsy M il Solution Designer )PressGOtoreturntothiscontext.Exec   A D  S D   D D  Mail N AAAAAAA 72B HONO CHANGE!aNThis is the Context Manager screen. You may or may notSthave the Context Manager installed on your system.artinghe nte Magero iokehe t lutign Dign ishe st y. M Soioeser )PressGOtoreturntothiscontext.Exec   A D  S D   D D  Mail N AAAAAAA2  , NO CHANGE!$ ZNThis is the Context Manager screen. You may or may notSthave the Context Manager installed on your system.artUsing the Context Manager to invoke the Solution Designeris the best way. )PressGOtoreturntothiscontext.Exec   A D  S D   D D  Mail N AAAAAAAAAAAA#22am te JHPN   NO CHANGE!+NtExecutive11.2 (OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP CommandPG  NO CHANGE!NNExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP Command i s t E e t T i k h l t n D s r f h E e t e t p t e o m n   S l i D s g r   Y t i ! y e t o m d a w PG00 @j  wNO CHANGE!N@Executive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP Command his is the E ecutive To i vok th Soluti n Desig er fr the Exec tive type the omm nd: Soluti n Designer You try it! Ty e the co mand as sh w .PG00  @   NO CHANGE!)qN0Executive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP CommandThis is the Executive.To invoke the Solution Designer fromthe Executive, type the command:Solution DesignerYou try it! Type the command as shown.PG00 @  NO CHANGE!NExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP CommandS 6 PGU  bNO CHANGE!tNExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP CommandSo 6 PG   NO CHANGE!0 NExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP CommandSol 6 PG   NO CHANGE! NExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP CommandSolu 6 PG  NO CHANGE! NExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP CommandSolut 6 PGK X NO CHANGE!j NExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP CommandSoluti 6 PG  NO CHANGE!* NExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP CommandSolutio 6 PG  NO CHANGE! NExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP CommandSolution 6 PG  NO CHANGE! NO CHANGE!  NO CHANGE! NExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP CommandSolution D6 PG} NO CHANGE!NExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP CommandSolution De6 PG? LNO CHANGE!^NExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP CommandSolution Des6 PG NO CHANGE!!NExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP CommandSolution Desi6 PG NO CHANGE!NExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP CommandSolution Desig6 PG NO CHANGE!NExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP CommandSolution Design6 PGQ ^NO CHANGE!pNExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]MonFeb15,19882:22PMP CommandSolution Designe6 PG $NO CHANGE!6NExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]Mon Feb 15, 19882:22PMP CommandSolution Designer5 Now press the GO key .}PG*  ONO CHANGE!,NExecutive11.2(OSt1ClstrLfsMp-9.8)Username:MaryPath:[Sys]Mon Feb 15, 19882:22PMP CommandSolution Designer5 P   ONO CHANGE!N    NO CHANGE!"mN]Solution Designer Version 1.0 Copyright (C) 1987 Convergent, Inc.  NO CHANGE!Na1 READYO  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 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]J WNO CHANGE!itNa1 READYO  a b c d e f g h i1O 2 3 4 5 This is the6 7 Solution Designer screen.8 9 (We'll discuss the screen later.)10 11 12 13 For now, press Next Page to continue.14 15 16 17 18 19 20 21 22 23 Thu04-Feb-88 4:26 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]/      ///////time time time s ~This is a Training Wheels exercise. You should ~ ~type the command as instructed. ~ ~We are practicing invoking the Solution Designer ~ ~from the Executive. ~ ~Dismiss this message and type 'S' ... ~ s o ~ Please type the entire command ~ ~~ ~ Solution Designer ~ ~~ ~ Dismiss this message and type 'o' ... ~ o l ~ Please type the entire command ~ ~~ ~ Solution Designer ~ ~~ ~ Dismiss this message and type 'l' ... ~ l u ~ Please type the entire command ~ ~~ ~ Solution Designer ~ ~~ ~ Dismiss this message and type 'u' ... ~ u t ~ Please type the entire command ~ ~~ ~ Solution Designer ~ ~~ ~ Dismiss this message and type 't' ... ~ t i i o o n n 0x20 ~The command is "Solution Designer", with a SPACE ~ ~between the words. For this exercise, we must ~ ~type the entire command name. ~ ~ ~ ~Dismiss this message and press the SPACE BAR ... ~ Space d d e e s i g n e r  ~Now that the command name has been typed, you must~ ~press the GO key to invoke the Solution Designer. ~ ~~ ~~ ~Dismiss thie message and press GO ... ~ Go time time time time time2am d JHPN  4NO CHANGE!+N\- Question -How To Start Up Solution DesignerPF I L L I N T H E B L A N KNNNN 9 There are three ways to invoke Solution Designer.  Name one of them: ~~ 9 NNNNN(Type your answer and press GO when ready)!Pe2K*2am cc  JHPN  NO CHANGE!+CN+How To Start Up Solution DesignerPp!Ppn .{NO CHANGE!NHow To Start Up Solution DesignerPThat's right!The Context Manager is one of the three waysto invoke Solution Designer.'The other two ways areThe ExecutiveSignOn!P2am &c P GIntro>Invoke>FIB1.a000(&LIntro>Invoke>FIB1.common.path2am cc JHPN   NO CHANGE!+NHow To Start Up Solution DesignerPThat's right!The Executiveis one of the three waysto invoke Solution Designer.'The other two ways areThe Context ManagerSignOn !P 2am &c P GIntro>Invoke>FIB1.a002(&LIntro>Invoke>FIB1.common.path2am dy  JHPN   NO CHANGE!+NHowToStartUp Solution DesignerPThat's right!The SignOn Screen is one of the three waysto invoke Solution Designer.'The other two ways areThe Context ManagerThe ExecutiveP 2am &c P GIntro>Invoke>FIB1.a003(&LIntro>Invoke>FIB1.common.pathers0  a b c d e f g h i1 L 2 3 then select Global to select the Global commands,a1 MENU Format Label-Prefix Column-Width Recalculation Protection Default Zero Speify global format>  a b c d e f g h i1 L 2 3 then select Format to display the Format commands,18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph >]      ] " ]2am dz JHPN  'NO CHANGE!+NHowToStartUpSolutionDesignerP Sorry, that's not right. Any of the following are correct:$The Context ManagerThe ExecutiveThe SignOn ScreenP 2am &c  P GIntro>Invoke>FIB1.a999(&LIntro>Invoke>FIB1.common.path2am"ch!"p<ContextManager3a< ExecutiveRa<Signonna<SignOn2am c P GIntro>Invoke>Rev.1$GIntro>Invoke>Rev.2?NIntro>Menu2am !c P ZCarla.fontGIntro>Invoke>Segue.19GIntro>Invoke>Segue.2VGIntro>Invoke>Segue.3sGIntro>Invoke>Segue.4GIntro>Invoke>Segue.5ZCarla.fontZSD.fontXIntro>Invoke>ExecGIntro>Invoke>CMSegue.1 GIntro>Invoke>CMSegue.2(XIntro>Invoke>CM@!GIntro>Invoke>SignonSegueaXIntro>Invoke>Signon}ZSD.fontZCarla.fontGintro>invoke>QSeg1 Intro>Invoke>FIB12am 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 d: JHPN  ONO CHANGE!+N'!  5NO CHANGE!NHow To Start Up Solution Designer5To invoke Solution Designer meansto start it up and begin using it.Therearethreewaystoinvoke'SolutionDesigner:!-FromtheExecutive-FromtheContextManager-FromtheSignOnScreen!52am e) JHPN  NO CHANGE!+NHowToStartUpSolutionDesigner5ToinvokeSolutionDesignermeanstostartitupandbeginusingit.You have reached the end of this lesson.TherearethreewaystoinvokeWe suggest you proceedSolutionDesigner: to the next lesson,-FromtheExecutiveThe Solution Designer-FromtheContextManager Screen.-FromtheSignOnScreen Press Next Page to return to the Intro menu.555 "55555  5 555555 555555552am Od  JHPN   NO CHANGE!+N  @ OMNO CHANGE!_NKignerKKKKKKKKKKKKKKKKKKKKKKKKKKp ONO CHANGE!&NCtionDesignerC CCCCCCCCCCCCCCCCCCCCC p ONO CHANGE!N7tartUpSoluti2am fh JHPN  ONO CHANGE!+fNHowToStartUpSolutionDesignerPINVOKING THE SOLUTION DESIGNERNow let's learn how to invoke the Solution Designer.(If that sounds too technical, I'll translate. Toinvoke the Solution Designer simply means to startit up and begin using it.)/herartreys tv eSo t Desgner: PbF8 NO CHANGE!mNHowToStartUpSolutionDesignerPINVOKING THE SOLUTION DESIGNERNow let's learn how to invoke the Solution Designer.(If that sounds too technical, I'll translate. Toinvoke the Solution Designer simply means to startit up and begin using it.)  There arethree ways to nvoke he Solution Desgner: ,P" 0      1       ?F     F  8  O* NO CHANGE!< NHowToStartUpSolutionDesignerPINVOKING THE SOLUTION DESIGNERNow let's learn how to invoke the Solution Designer.(If that sounds too technical, I'll translate. Toinvoke the Solution Designer simply means to startit up and begin using it.)FThere are three ways to invoke the Solution Designer:FP-FFFF F F F nd.>]      ] " ]   ]2am -e JHPN  NO CHANGE!+-NHowToStartUpSolutionDesignerPINVOKING THE SOLUTION DESIGNERNow let's learn how to invoke the Solution Designer.(If that sounds too technical, I'll translate. Toinvoke the Solution Designer simply means to startit up and begin using it.)FThere are three ways to invoke the Solution Designer:From the ExecutiveFP-FFFFFF F F2am Qe JHPN  ONO CHANGE!+QNHowToStartUpSolutionDesignerPINVOKING THE SOLUTION DESIGNERNow let's learn how to invoke the Solution Designer.(If that sounds too technical, I'll translate. Toinvoke the Solution Designer simply means to startit up and begin using it.)FThere are three ways to invoke the Solution Designer:From the ExecutiveFrom the Context ManagerFP-FFFFFF F F2am me  JHPN  NO CHANGE!+mNHowToStartUpSolutionDesignerPINVOKING THE SOLUTION DESIGNERNow let's learn how to invoke the Solution Designer.(If that sounds too technical, I'll translate. Toinvoke the Solution Designer simply means to startit up and begin using it.)FThere are three ways to invoke the Solution Designer:From the ExecutiveFrom the Context ManagerFrom the SignOn ScreenFP-FFFFFF F F2am f JHPN  )NO CHANGE!+N/SignOn 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) !9The last way to invoke the Solution Designeris from Signon. Normally, when you sign onto the NGEN, your system administrator configures your system so that you will invokeeither the Context Manager or the Executive.You may also be configured to invoke theSolution Designer upon signing on.9P(H/////////////R )NO CHANGE!N#SignOn 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) !9Thlaytvkeei seri fo Signon. Normlly, eyou inonFr thsxrcise, peten tht yutGysysm mtigOn nam is Marcfueu yt aouwlnEnter the name n the "Usr name"eblaik oamoveaasd br so fO.diSoluiDgergg9P(H(')''')'(S )NO 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) !9nny, y nFor this exercise, pretend that your SignOn name is Mar.Enter the name on the "User name" blank above and press GO.9P(''''''''' ) NO 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) !9For this exercise, pretend that your SignOn name is Mary.Enter the name on the "User name" blank above and press GO.9P(;'''''''''   * NO CHANGE! NSignOn 11.2 (OS t1ClstrLfsMp-9.8)Mon Feb 15, 19888:03AMPUser name(e.g. Allen) MPasswordDate/Time (e.g. Fri Sep 9 1983 8:00 am) P( + NO CHANGE! NSignOn 11.2 (OS t1ClstrLfsMp-9.8)Mon Feb 15, 19888:03AMPUser name(e.g. Allen) MaPasswordDate/Time (e.g. Fri Sep 9 1983 8:00 am) P( , NO CHANGE! NSignOn 11.2 (OS t1ClstrLfsMp-9.8)Mon Feb 15, 19888:03AMPUser name(e.g. Allen) MarPasswordDate/Time (e.g. Fri Sep 9 1983 8:00 am) P( -NO CHANGE!NSignOn 11.2 (OS t1ClstrLfsMp-9.8)Mon Feb 15, 19888:03AMPUser name(e.g. Allen) MaryPasswordDate/Time (e.g. Fri Sep 9 1983 8:00 am) Now Press GO .P(  NO CHANGE!NSignOn 11.2 (OS t1ClstrLfsMp-9.8)Mon Feb 15, 19888:03AMPUser name(e.g. Allen) MaryPasswordDate/Time (e.g. Fri Sep 9 1983 8:00 am) P   ONO CHANGE!N    NO CHANGE!mN]Solution Designer Version 1.0 Copyright (C) 1987 Convergent, Inc. N  [NO CHANGE!mFNva1 READYO  a b c d e f g h i1O 2 3 4 5 6 7 8 Great! Now you're ready9 10 to use Solution Designer.11 12 13 Press Next Page to Continue14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]%%%%%time time time M ~In this exercise, we are going to observe ~ ~signing on as a method for invoking the ~ ~Solution Designer. Our user name is "Mary". ~ ~~ ~Dismiss this message and type an 'M' ... ~ ShiftRight m a ~Please type the complete name, "Mary". ~ ~~ ~~ ~~ ~Dismiss this message and type an 'a' ... ~ r ~Please type the complete name, "Mary". ~ ~~ ~~ ~~ ~Dismiss this message and type an 'r' ... ~ y ~Please type the complete name, "Mary". ~ ~~ ~~ ~~ ~Dismiss this message and type a 'y' ... ~  Go time time time time2am ,g JHPN  ONO CHANGE!+N  @ )MNO CHANGE!_N_Sign2 (OstrL.8)Feb888User(e.gn)PassDate(e.gSep 8:0(ast inve So Desom S No, wh sige NGur sadmitor gure sys thawiller thext r orxecuay a cond toe thion er ugnin MRZ )gNO CHANGE!y,NNSignOn 12 (OS t1strLfsMp.8)MoFeb15,888:03User nam(e.g. Aln) PasswordDate/Tim(e.g. FrSep 9 19 8:00 am$Theast way invoke e Soluti Designeis om SignO Normal, when y sign onto e NGEN, ur systeadministtor congures yo system that yowill inveeitr the Coext Manar or thexecutiveYouay also configud to inve theSolion Desier upon gning onHR ) NO CHANGE! N/SignOn 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) !9The last way to invoke the Solution Designeris from SignOn. Normally, when you sign onto the NGEN, your system administrator configures your system so that you will invokeeither the Context Manager or the Executive.You may also be configured to invoke theSolution Designer upon signing on.9P(H/////////////R2am oe JHPN  NO CHANGE!+oNa1 READYN  a b c d e f g h i1 2 3 4 5 06 07 "8 9 Let's take a closer look10 11 at it.12 13 "14 015 016 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]! NO CHANGE!eNa1 READYN  a b c d e f g h i1 2 3 4 5 6 ,7 "8 9 Let's take a closer look10 11 at it.12 13 "14 ,15 16 17 18 19 20 21 22 23   Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]! +NO CHANGE!=Nta1 READYN  a b c d e f g h i1 2 3 4 5 6 7 "8 9 Let's take a closer look10 11 at it.12 13 "14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]Q ^ NO CHANGE!p N_a1 READYN  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 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]""""  NO CHANGE! Nha1 READYO  a b c d e f g h i1 2 3 4 5 6 7 $8 9 T e e a e t e w rk he t ol m s 10 11 $12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]$   NO CHANGE! Nha1 READYO  a b c d e f g h i1 2 3 4 5 6 7 $8 9 These are the worksheet columns.10 11 $12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]$  NO CHANGE!"Nna1 READYO  a b c d e f g h i1 2 3 4 5 6 7 $8 9 These are the worksheet columns.10 11 $12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]$ A NNO CHANGE!`+Nwa1 READYO  a b c d e f g h i1 2 3 4 5 6 7 $8 9 These are the worksheet columns.10 11 $12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P $  2am %f JHPN  NO CHANGE!+gNa1 READYO  a b c d e f g h i1 2 3 4 5 6 7 $8 9 These are the worksheet columns.10 11 12 They are designated by the 13 $14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]$   NO CHANGE!Na1 READYO  a b c d e f g h i1 2 3 4 5 6 7 $8 9 These are the worksheet columns.10 11 12 They are designated by the 13 14 letters a through i. 15 $16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]$  Y fNO CHANGE!xNa1 READYO  a b c d e f g h i1 2 3 4 5 6 7 $8 9 These are the worksheet columns.10 11 12 They are designated by the 13 14 letters a through i. 15 16 $17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]$  3 @ NO CHANGE!R Na1 READYO  a b c d e f g h i1 2 3 4 5 '6 7 $8 9 These are the worksheet columns.10 11 12 They are designated by the 13 14 letters a through i. 15 16 $17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name  Abs  Go To  Window Query Table  Calc  Graph I $   ) NO CHANGE!; Na1 READYO  a b c d e f g h i1 2 3 4 5 '6 7 $8 9 These are the worksheet columns.10 11 12 They are designated by the 13 14 letters a through i. 15 16 $17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph I $    NO CHANGE!1Na1 READYO  a b c d e f g h i1 2 3 4 5  '6 7 $8 9 These are the worksheet columns.10 11 12 They are designated by the 13 14 letters a through i. 15 16 $17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs   Go To  Window Query Table  Calc  Graph I $   "NO CHANGE!4Na1 READYO  a b c d e f g h i1 2 3 4 5 '6 7 $8 9 These are the worksheet columns.10 11 12 They are designated by the 13 14 letters a through i. 15 16 $17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph I $  % 2NO CHANGE!DNa1 READYO  a b c d e f g h i1 2 3 4 5 #6 7 $8 9 These are the worksheet columns.10 11 12 They are designated by the 13 14 letters a through i. 15 16 $17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph I $  B ONO CHANGE!a Na1 READYO  a b c d e f g h i1 2 3 4 5 6 7 $8 9 These are the worksheet columns.10 11 12 They are designated by the 13 14 letters a through i. 15 16 $17 18  19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph I $  l yNO CHANGE!N+a1 READYO  a b c d e f g h i1 2 3 4 5 6 7 $8 9 These are the worksheet columns.10 11 12 They are designated by the 13 14 letters a through i. 15 16 $17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph I $   NO CHANGE!%N8a1 READYO  a b c d e f g h i 1 2 3 4 5 6 7 $8 9 These are the worksheet columns.10 11 12 They are designated by the 13 14 letters a through i. 15 16 $17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph I $  2am e JHPN  )NO CHANGE!+Naa1 READYO  a b c d e f g h i1 2 3 4 This is the cell pointer.5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] = OJNO CHANGE!\Nda1 READYO  a b c d e f g h i1 2 3 4 This is the cell pointer.5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] q O~NO CHANGE!Nka1 READYO  a b c d e f g h i1 2 3 4 This is the cell pointer.5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] 2am e  JHPN   ,NO CHANGE!+TNa1 READYO  a b c d e f g h i1 2 3 4 This is the cell pointer. 5 6 7 It indicates thecurrent8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit Name Abs  Go To  Window Query Table  Calc  Graph ]   NO CHANGE!Na1 READYO  a b c d e f g h i1 2 3 4 This is the cell pointer. 5 6 7 It indicates thecurrent8 9 or active cell.10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  2am e$ JHPN  *NO CHANGE!+Na1 READYO  a b c d e f g h i1 2 3 4 5 6 7 8 9 10 This indicates the 11 12 location of the cell13 14 pointer, known as the15 16 cell reference.17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]   NO CHANGE!Na1 READYO  a b c d e f g h i1 2 3 4 5 6 7 8 9 10 This indicates the 11 12 location of the cell13 14 pointer, known as the15 16 cell reference.17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] ] OjNO CHANGE!|Na1 READYO  a b c d  e f g h i1 2 3 4 5 6 7 8 9 10 This indicates the 11 12 location of the cell13 14 pointer, known as the15 16 cell reference.17 18 19 20 21 22 23 Thu04-Feb-884:26PM 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 9 10 This indicates the 11 12 location of the cell13 14 pointer, known as the15 16 cell reference.17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  O NO CHANGE! Na1 READY& (  a b c d  e f g h i1 2 3 4 5 6 7 8 9 10 This indicates the 11 12 location of the cell13 14 pointer, known as the15 16 cell reference.17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  ONO CHANGE!Na1 #READY& (  a b c d  e f g h i1 2 3 4 5 6 7 8 9 10 This indicates the 11 12 location of the cell13 14 pointer, known as the15 16 cell reference.17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am f JHPN  >NO CHANGE!+Na1 #READY& (  a b c d  e f g h i1 2 3 4 5 6 7 8 9 10 This indicates the 11 12 location of the cell13 14 pointer, known as the15 16 cell reference.17 18 19 20 21 "22 23 It changes as the cell pointerThu04-Feb-884:26PM Macro  Edit  Name Amoves around the worksheet. Calc  Graph ] """" (NO CHANGE!:N@a1 #READY& (  a b c d  e f g h i1 2 3 4 5 6 7 8 9 10 This indicates the 11 12 location of the cell13 14 pointer, known as the15 16 cell reference.17 "18 19 It changes as the cell pointer20 21 moves around the worksheet.22 23 "Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  """""X eNO CHANGE!wNa1 #READY& (  a b c d  e f g h i1 2 3 4 5 6 7 8 9 10 This indicates the 11 12 location of the cell13 "14 15 It changes as the cell pointer16 17 moves around the worksheet.18 19 "20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]"""""F  4S NO CHANGE!e Na1 #READY& (  a b c d  e f g h i1 2 3 4 5 6 7 8 9 "10 11 It changes as the cell pointer12 13 moves around the worksheet.14 15 "16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name  Abs  Go To  Window Query Table  Calc  Graph ]"""""2am e JHPN  ;NO CHANGE!+PNa1 #READY& (  a b c d  e f g h i1 2 3 4 5 6 7 8 9 "10 11 12 Watch .13 14 15 "16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]"""""{  NO CHANGE!YNb1 #READY& (  a b c d  e f g h i1 2 3 4 5 6 7 8 9 "10 11 12 Watch .13 14 15 "16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name  Abs  Go To  Window Query Table  Calc  Graph T """""  :NO CHANGE!YNb2 #READY& (  a b c d  e f g h i1 2 3 4 5 6 7 8 9 "10 11 12 Watch .13 14  15 "16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T """""k  x NO CHANGE! YNc2 #READY& (  a b c d  e f g h i1 2 3 4  5 6 7 8 9 "10 11 12 Watch .13 14 15 "16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T """""  : NO CHANGE! YNc3 #READY& (  a b c d  e f g h i1 2 3 4 5 6 7 8 9 "10 11 12 Watch .13 14 15 "16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T """""[ 4hNO CHANGE!zNc4 #READY& (  a b c d  e f g h i1 2 3 4 5 6 7 8 9 "10 11 12 Press Next Page13 to Continue14 15 16 "17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T "      ""2am Ze JHPN  NO CHANGE!+DNa1 READY    a b c d e f g h i1 2 3 4 5 6 7 8 9 10 11 12 13 14  This displays the15 16 current date and time.17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]o -|NO CHANGE!MNa1 READY    a b c d e f g h i1 2 3 4 5 6 7 8 9 10 11 12 13 14  This displays the15 16 current date and time.17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] -NO CHANGE!WNa1 READY    a b c d e f g h i1 2 3 4 5 6 7 8 9 10 11 12 13 14  This displays the15 16 current date and time.17 18  19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]Q -^ NO CHANGE!p YNa1 READY    a b c d e f g h i1 2 3 4 5 6 7 8 9 10 11 12 13 14  This displays the15 16 current date and time.17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query  Table  Calc  Graph ] - NO CHANGE! ZNa1 READY    a b c d e f g h i1 2 3 4 5 6 7 8 9 10 11 12 13 14  This displays the15 16 current date and time.17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] - ONO CHANGE!Na1 ( (( a b c d (1 (2 (3 (4 D5 D6 D7 (8 (9 Solution (10 (11 complete(12 13 with easy, one-letteruse of commands.14 15 .16 @17 @18 @19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ! &&-J OW NO CHANGE!i Na1    a b c d e f 1 2 3 4 D5 D6 D7 .8 9 Solution Designer provides10 11 completeon-screen menus12 13 with easy, one-letteruse of commands.14 15 .16 @17 @18 @19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 3 &&&&&-S ` NO CHANGE!r Na1 READY    a b c d e f g h i1 2 3 4 @5 @6 @7 .8 9 Solution Designer provides10 11 completeon-screen menus12 13 with easy, one-letteruse of commands.14 15 .16 @17  @18 @19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph I &&&&&- 2am d JHPN  NO CHANGE!+NN- Question -The Solution Designer ScreenPFILLINTHEBLANKNNNN 2  The cell pointer location indicates  the locationof the ~~ cell.  2NNNNN(Type your answer and press GO when ready)Pa.O*2am c# JHPN   !NO CHANGE!+NThe Solution Designer ScreenPCorrect!The cell pointer location indicates thelocation of the current, or active, cell.PC&2am &c P GIntro>Screen>FIB1.a000(&LIntro>Screen>FIB1.common.path 2am d JHPN   !NO CHANGE!+NThe Solution Designer ScreenPThat's not correct.The cell pointer location indicates thelocation of the current, or active, cell.The current cell is the cell that isready to accept informationor commands from you.PC&2am &c P GIntro>Screen>FIB1.a999(&LIntro>Screen>FIB1.common.path2amch!pPcurrent+aPactive2am c P  Intro>Screen>FIB2 2am d JHPN  ONO CHANGE!+NZ- Question -The Solution Designer ScreenPFILLINTHEBLANKNNNN 4 If the cell pointer is in row 155, column f, then the cell reference is~~ . 4 NNNNN(Type your answer and press GO when ready)Pb /N*2am c. JHPN   (NO CHANGE!+NThe Solution Designer ScreenPVery good.If the cell pointer is in row 155, column f,the cell reference, or cell address, is f155.PY2am &c P GIntro>Screen>FIB2.a000(&LIntro>Screen>FIB2.common.path2am cu JHPN  2NO CHANGE!+NThe Solution Designer ScreenPThat's not right.If the cell pointer is in row 155, column f,the cell reference is f155.The cell reference consists of the column letterfollowed by the row number.;PP 2am &c P GIntro>Screen>FIB2.a999(&LIntro>Screen>FIB2.common.path2amch!p<f1552am c P Gintro>screen>rev.1$Gintro>screen>rev.2?Gintro>screen>rev.3ZGintro>screen>rev.4uNIntro>menu2am f JHPN   NO CHANGE!+<Na1 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 These are the worksheet17 18 function keys.19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  g ?tNO CHANGE!BNa1 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 These are the worksheet17 18 function keys.19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  KNO CHANGE!RNa1 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 These are the worksheet17 18 function keys.19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] 9 F NO CHANGE!X jNa1 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 These are the worksheet17 18 function keys.19 20 21 22 23 Thu0 -Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]   NO 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 These are the worksheet17 18 function keys.19 20 21 22 23 Thu0 -Feb-8 4:26 M Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  $NO CHANGE! NFa1 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 These are the worksheet17 18 function keys.19 20 21 22 23 Thu0 -Feb-8 4:26 M Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] 2am f  JHPN  NO CHANGE!+=Nha1 READY Solution Designer functions.  a b c g h i1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 These are the worksheet17 18 function keys.19 20 21 22 23  Thu0 -Feb-8 4:26 M Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph   ! h uNO CHANGE!Na1 READY    a b c g h i1 2 Function keys are used3 4 to perform certain5 6 Solution Designer functions.7 8 9 10 11 12 13 14 15 16 These are the worksheet17 18 function keys.19 20 21 22 23 Thu0 -Feb-8 4:26 M Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph !        + 8 NO CHANGE!J Na1 READY    a b c d e f g h i1 2 3 4 5 6 7 8 9 10 Function keys are used11 12 to perform certain13 14 Solution Designer functions.15 16 17 18 function keys.19 20 21 22 23 Thu0 -Feb-8 4:26 M Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]         5 NO CHANGE! MNva1 READY    a b c d e f g h i1 2 3 4 5 6 7 8 9 10 11 12 13 Function keys are used14 15 to perform certain16 17 Solution Designer functions.18 19 20 21 22 23 Thu0 -Feb-8 4:26 M Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]        2am f JHPN   NO CHANGE!+<Na1 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 These are the worksheet17 18 function keys.19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] g ?tNO CHANGE!BNa1 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 These are the worksheet17 18 function keys.19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  NO CHANGE!ANa1 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 These are the worksheet17 18 function keys.19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] ( K5 NO CHANGE!G RNa1 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 These are the worksheet17 18 function keys.19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]   NO CHANGE! jNa1 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 These are the worksheet17 18 function keys.19 20 21 22 23 Thu0 -Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] " D/NO CHANGE!ANa1 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 These are the worksheet17  18 function keys.19 20 21 22 23 Thu0 -Feb-8 4:26PM Macro  Edit  Name Abs  Go To  W indow Query Table  Calc  Graph ]   NO 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 These are the worksheet17 18 function keys.19 20 21 22 23 Thu0 -Feb-8 4:26 M Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  .NO 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 These are the worksheet17 18 function keys.19 20 21 22 23 Thu0 -Feb-8 4:26 M Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  $NO CHANGE! NFa1 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 These are the worksheet17 18 function keys.19 20 21 22 23 Thu0 -Feb-8 4:26 M Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] 2am f( JHPN  NO CHANGE!+=Nha1 READY Solution Designer functions.  a b c g h i1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 These are the worksheet17 18 function keys.19 20 21 22 23  Thu0 -Feb-8 4:26 M Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph   ! h uNO CHANGE!Na1 READY Function keys are used  a b cto perform certain g h i1  2 Solution Designer functions.3 4 5 6 7 8 9 10 11 12 13 14 15 16 These are the worksheet17 18 function keys.19 20 21 22 23 Thu0 -Feb-8 4:26 M Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph    !     ' NO CHANGE!9 Na1 READY    a b c g h i1 2 Function keys are used3 4 to perform certain5 6 Solution Designer functions.7 8 9 10 11 12 13 14 15 16 These are the worksheet17 18 function keys.19 20 21 22 23 Thu0 -Feb-8 4:26 M 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 Function keys are used7 8 to perform certain9 10 Solution Designer functions.11 12 13 14 15 16 These are the worksheet17 18 function keys.19 20 21 22 23 Thu0 -Feb-8 4:26 M 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 9 10 Function keys are used11 12 to perform certain13 14 Solution Designer functions.15 16 17 18 function keys.19 20 21 22 23 Thu0 -Feb-8 4:26 M Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]        M 5ZNO CHANGE!lMNva1 READY    a b c d e f g h i1 2 3 4 5 6 7 8 9 10 11 12 13 Function keys are used14 15 to perform certain16 17 Solution Designer functions.18 19 20  21 22 23 Thu0 -Feb-8 4:26 M Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]       2am e JHPN   NO CHANGE!+N  @ MNO CHANGE!_Na1 READYO  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 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  'NO CHANGE!N-a1 READYN  a b c d e f g h i1 2 3 4 5 6 7 8 9 10 11 i12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]   ,NO CHANGE!N8a1 READYN  a b c d e f g h i1 2 3 4 5 6 7 8 9 s is 10 11 esign12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]    NO CHANGE!.NDa1 READYN  a b c d e f g h i1 2 3 4 5 6 7 8 9 This is the10 11 n Designer 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  /( NO CHANGE!: NHa1 READYN  a b c d e f g h i1 2 3 4 5 6 7 8 9 This is the10 11 ion Designer sc12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]+ 8 NO CHANGE!J NLa1 READYN  a b c d e f g h i1 2 3 4 5 6 7 8 9 This is the10 11 ution Designer scre12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] ? LNO CHANGE!^NPa1 READYN  a b c d e f g h i1 2 3 4 5 6 7 8 9 This is the10 11 Solution Designer screen.12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]S `NO CHANGE!rNna1 READYN  a b c d e f g h i1 2 3 4 5 6 7 8 9 This is the10 11 Solution Designer screen.12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] 4NO CHANGE!UNa1 READYN  a b c d e f g h i1 2 3 4 5 6 7 "8 9 This is the10 11 Solution Designer screen.12 13 "14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] NO CHANGE!rNa1 READYN  a b c d e f g h i1 2 3 4 5 6 ,7 "8 9 This is the10 11  Solution Designer screen.12 13 "14 ,15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]! 4NO CHANGE!|Na1 READYN  a b c d e f g h i1 2 3 4 5 06 07 "8 9 This is the10 11  Solution Designer screen.12 13 "14 015 016 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]!% 2NO CHANGE!DNa1 READYN  a b c d e f g h i1 2 3 4 45 46 47 "8 9 This is the10 11  Solution Designer screen.12 13 "14 415 416 417 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]! 2am e JHPN   3NO CHANGE!+Na1 READYN  a b c d e f g h i1 2 3 4 45 46 47 "8 This is the9 10 Solution Designer screen.11  12 13 "14 415 416 417 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]! NO CHANGE!Na1 READYN  a b c d e f g h i1 2 3 4 45 46 47 "8 9 Solution Designer screen.10 11  12 It displays just a small13 "14 415 416 417 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]!u  NO CHANGE!Na1 READYN  a b c d e f g h i1 2 3 4 45 46 47 "8 Solution Designer screen.9 10 11  It displays just a small12 13 "14 415 416 417 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]!0 = NO CHANGE!O Na1 READYN  a b c d e f g h i1 2 3 4 45 46 47 "8 9 10 It displays just a small11  12 portion of the worksheet.13 "14 415 416 417 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go onDesigner777777 Designer.77ate. To77to start777777779 ONO CHANGE!N'HowToStartUpSolutionDesigner')''LUTION DESIGNER'''oke the Solution Designer.''cal, I'll translate. To''er simply means to start'''') ONO CHANGE!ENHowToStartUpSolutionDesigner4KING THE SOLUTION DESIGNER how to invoke the Solution Designer. too technical, I'll translate. Toinvoke the Solution Designer simply means to startit up and begin using it.))4.  ;NO CHANGE!MONHowToStartUpSolutionDesignerPINVOKING THE SOLUTION DESIGNERNow let's learn how to invoke the Solution Designer.(If that sounds too technical, I 'll translate. Toinvoke the Solution Designer simply means to startit up and begin using it.))P2am e  JHPN  %NO CHANGE!+Na1 READY    a b c d e f g h i1 2 3 4 5 6 7 8 9 10 11 12 13 If you are running CT-Mail,14 15 then you may occasionally16 17 get a message like this.18 19 20 21 22 23 Thu04-Feb-884:26PMYou have mail Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] 3NO CHANGE!Na1 READY    a b c d e f g h i1 2 3 4 5 6 7 8 9 10 11 12 13 If you are running CT-Mail,14 15 then you may occasionally16 17 get a message like this.18  19 20 21 22 23 Thu04-Feb-884:26PMYou have mail Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am em JHPN  NO CHANGE!+Na1 READY    a b c d e f g h i1 2 3 4 5 6 7 8 9 10 11 12 CT-Mail a13 If you are running CT-Mail,14 you whene15 then you may occasionally16 you in yo17 get a message like this.18 19 20 21 22 23 Thu04-Feb-884:26PMYou have mail Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]         *NO CHANGE!+N a1 READY    a b c d e f g h i1 2 3 4 5 6 7 8 9 10 "11 12 CT-Mail automatically notifies13 If you ar  e runnin14 you whenever there is mail for15 then you may occa16 you in your In Tray.17 get a message lik18 "19 20 21 22 23 Thu04-Feb-884:26PMYou have mail Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]""""""" 8,NO CHANGE!>Na1 READY    a b c d e f g h i1 2 3 4 5 6 7 8 9 10 "11 12 CT-Mail automatically notifies13 14 you whenever there is mail for15 16 you in your In Tray.17 18 "19 20 21 22 23 Thu04-Feb-884:26PMYou have mail Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]"""""""!2am dK JHPN  NO CHANGE!+N`Question The Solution Designer ScreenP@MThe size of a Solution Designer Worksheet is UCL HTF1 - 7 columns, 23 rowsOIF2 - 512 columns, 8192 rowsIPF3 - 63 columns, 255 rowsCLF4 - 256 columns, 8192 rowsEEF5 - None of the above(Select your answer by pressing one of the indicated selections)P64446@2am c P  Intro>Screen>FIB12am We   JHPN  LNO CHANGE!+WNThe Solution Designer ScreenPQThe size of a Solution Designer Worksheet is F1 - 7 columns, 23 rowsVery good. TheF2 - 512 columns, 8192 rowscorrect answerF3 - 63 columns, 255 rowsis F2. A F4 - 256 columns, 8192 rowsworksheet hasF5 - None of the above512 columns and 8192 rows.BP644462am %c P #GIntro>Screen>MC1.incorrect,%LIntro>Screen>MC1.common.path2am %c P !GIntro>Screen>MC1.correct*%LIntro>Screen>MC1.common.path2am %c P #GIntro>Screen>MC1.incorrect,%LIntro>Screen>MC1.common.path! 2am %c P #GIntro>Screen>MC1.incorrect,%LIntro>Screen>MC1.common.path2am %c P #GIntro>Screen>MC1.incorrect,%LIntro>Screen>MC1.common.path2am ie JHPN  :NO CHANGE!+iNThe Solution Designer ScreenPQThe size of a Solution Designer Worksheet is F1 - 7 columns, 23 rowsThat's incorrect.F2 - 512 columns, 8192 rowsThe correctF3 - 63 columns, 255 rowsanswer is F2. A F4 - 256 columns, 8192 rowsworksheet hasF5 - None of the above512 columns and 8192 rows.@P644462am 2c!  N 2 F1  F2  F3  F4  F5 2am Ne JHPN  =NO CHANGE!+3Nwa1 READY (  a b c d e f g h i1 2 3 4 5 This is the6 7 mode indicator.8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] ^ 8kNO CHANGE!}@Na1 READY (  a b c d e f  g h i1 2 3 4 5 This is the6 7 mode indicator.8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  :NO CHANGE!MNa1 READY    a b c d e f  g h i1 2 3 4 5 This is the6 7 mode indicator.8 9 10 11 12 13 14 15 16 17 18 19 20 21  22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] ) I6 NO CHANGE!H NNa1 READY    a b c d e f  g h i1 2 3 4 5 This is the6 7 mode indicator.8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] 2am f{"  JHPN   0NO CHANGE!+mNa1 READY    a b c d e f  g h i1 2 3 4 5 This is the6 7 mode indicator.8 9 It shows what10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM 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 This is the6 7 mode indicator.8 9 It shows what10 11 you are doing 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] T 7aNO CHANGE!sNa1 READY    a b c d e f  g h i1 2 3 4 5 This is the6 7 mode indicator.8 9 It shows what10 11 you are doing 12 13 in your14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] 9 0F NO CHANGE!X Na1 READY    a b c d e f  g h i1 2 3 4 5 This is the6 7 mode indicator.8 9 It shows what10 11 you are doing 12 13 in your14 15 worksheet.16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] 2am :f JHPN  NO CHANGE!+:Na1 READY    a b c d e f  g h i1 2 3 4 5 This is the6 7 mode indicator.8 9 It shows what10 11 you are doing RE12 13 in youris14 15 worksheet.in16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM M" acro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] e ?rNO CHANGE!:Na1 READY    a b c d e f  g h i1 2 3 4 5 This is the6 7 mode indicator.8 9 It shows what10 11 you are doing READY means 12 13 in youris ready to 14 15 worksheet.information 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  3NO CHANGE!!Na1 READY    a b c d e f  g h i1 2 3 4 5 This is the6 7 mode indicator.8 9 It sh10 11 you aREADY means the workshee12 13 in yois ready to accept14 15 worksinformation from you.16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM 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 This is the6 7 mode indicator.8 9 10 11 READY means the worksheet12 13 is ready to accept14 15 information from you.16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] 2am f JHPN  )NO CHANGE!+4N.a1 READY    a b c d e f  g h i1 2 3 4 5 This is the6 7 mode indicator.8 9 10 11 READY means the worksheet12 13 is ready to accept14 15 information from you.16 17 18 19 20 21 22 23 Thu04-Feb-# 884:26PMOther mode indicators Macro  Edit  Name Abs  Go To  Window ph ] _ )lNO CHANGE!~Nqa1 READY    a b c d e f  g h i1 2 3 4 5 This is the6 7 mode indicator.8 9 10 11 READY means the worksheet12 13 is ready to accept14 15 information from you.16 17 18 19 20 Other mode indicators21 22 that you will see are23 Thu04-Feb-884:26PMMENU, POINT, EDIT, Macro  Edit  Name Abs  Go To  Window ph ]  I NO CHANGE!( Nfa1 READY    a b c d e f  g h i1 2 3 4 5 This is the6 7 mode indicator.8 9 10 11 12 13 Other mode indicators14 15 that you will see are16 17 MENU, POINT, EDIT,18 19 VALUE, LABEL & ERROR.20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] 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 en>E.2ZSD.fontZCarla.font*Gintro>screen>Qseg2EIntro>Screen>MC1# 2am c P ZCarla.fontZSD.font,GIntro>Screen>I.1EGIntro>Screen>I.2^GIntro>Screen>SegwGIntro>Screen>Col.1GIntro>Screen>Col.2GIntro>Screen>Row.1Gintro>screen>Row.2GIntro>Screen>Cur.1GIntro>Screen>Cur.2GIntro>Screen>Cur.34GIntro>Screen>Cur.4OGIntro>Screen>Cur.5jGIntro>Screen>Mod.1GIntro>Screen>Mod.2GIntro>Screen>Mod.3GIntro>Screen>Mod.4GIntro>Screen>DTGIntro>Screen>FN.1GIntro>Screen>FN.2"GIntro>Screen>Mail.1>GIntro>Screen>Mail.2ZGintro>screen>wdw.1uGintro>screen>wdw.2Gintro>screen>wdw.3Gintro>screen>wdw.4Gintro>screen>wdw.5Gintro>screen>wdw.6Gintro>screen>wdw.7Gintro>screen>wdw.82Gintro>screen>wdw.9MGintro>screen>wdw.10iGintro>screen>ref.1Gintro>screen>ref.2Gintro>screen>ref.3Gintro>screen>ref.4GIntro>Screen>EZSD.fontZCarla.fontGintro>screen>Qseg2*Intro>Screen>MC1To  Window Query Table  Calc  Graph ]!   NO CHANGE! Na1 READYN  a b c d e f g h i1 2 3 4 45 46 47 "8 9 It displays just a small10 11  portion of the worksheet.12 13 "14 415 416 417 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]!2am _e JHPN   ANO CHANGE!+_Na1READY a b c d e f g h i1234567*89Initially, the window displays columns1011a to i and rows 1 to 23.121314To view cells outside the window, move1516the cell pointer to the desired cell.1718*1920212223 Thu 04-Feb-88 4:26 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph $ ]2am eP JHPN   'NO CHANGE!+N$:ys`SD SysF9|M^SysSD 9{vfileHeaders.sys Sys3-f-f-f mfd.sys Sys3-f-f}gmlog.sysSys-f-f-f8 sysImage.sysSys-f-f-fI badBlk.sysSys-f-f-f& a+ crashDump.sysSys-f-f-fintro>cmds>cancl sd3-f-fgi̼intro>cmds>fib1 sd3-fggK  intro>cmds>fib1.a000 sd 3.fggLb? Intro>Cmds>FIB1.A000.Path sd 3.fggJ intro>cmds>fib1.a999 sd 3.fggen Intro>Cmds>FIB1.A999.Path sd 3 .fggJI Intro>Cmds>FIB1.answers sd 3.fgg( ' intro>cmds>fib1.common.path sd3.fgg!$^intro>cmds>fib2 sd3.ffg( intro>cmds>fib2.a000 sd3.ffg!,rIntro>Cmds>FIB2.A000.Path sd3.f.fgJ0>intro>cmds>fib2.a999 sd3.ffg4}Intro>Cmds>FIB2.A999.Path sd3#.f&.fgJ8TIntro>Cmds>FIB2.answers sd3'.f+.fg(<intro>cmds>fib2.common.path sd3,.fggB@' intro>cmds>fib3 sd35.fEfg*Fintro>cmds>fib3.a000 sd38.fPfPfLvIntro>Cmds>FIB3.A000.Path sd3;.fNfNfJPNKintro>cmds>fib3.a999 sd3?.fHfgTȃIntro>Cmds>FIB3.A999.Path sd3B.f>fgJZTIntro>Cmds>FIB3.answers sd3E.fWfgA^cHintro>cmds>fib3.common.path sd3H.fJfggbintro>cmds>initial.path sd3L.ffgf( Ointro>cmds>Inv.1 sd3O.fR.fgjaintro>cmds>Inv.2 sd3T.f[.fgp@ intro>cmds>Inv.3 sd 3\.f`.fgG$!intro>cmds>Inv1.1 sd!3a.fd.fcmds>Inv1.2 sd"3e.fh.f=fY#intro>cmds>Inv2 sd#3i.fk.fg?R$intro>cmds>Menu.1 sd$3l.f Pggt  ؑ%intro>cmds>Menu.2 sd%3o.fPgg1( |&intro>cmds>Menu.3 sd&3s.fPggB'intro>cmds>Menu.4 sd'3v.fPgg0(intro>cmds>Menu.5 sd(3y.fPgg)intro>cmds>Menu.6 sd)3|.fPgg)*intro>cmds>qseg1 sd*3.f.fg+intro>cmds>rev.1 sd+3.f fgd,intro>cmds>rev.2 sd,3.ffgo-intro>cmds>seg sd-3.ffga( ) .intro>cmds>sel.1 sd.3.fPgg/intro>cmds>sel.2 sd/3.fPgg0intro>cmds>sel.3 sd03.fPgg1intro>cmds>sel.4 sd13.f!Pggl2intro>cmds>sel.5 sd23.f#Pgg 3intro>cmds>sel.6 sd33.f,Pgg M4intro>cmds>sel.7 sd43.f/Pgg 2& ^5intro>cmds>sel.8 sd53.f2Pgg:`) T6intro>cmds>sel.9 sd63.f5Pgg"@e7intro>cmds>twcancl sd73.f>Pgg F m8intro>cmds>twcancl.pedal sd83.f@PggR\9intro>cmds>Twinv1 sd93.fDPggJT g:intro>cmds>Twinv1.pedal sd:3.fFPggt;intro>cmds>TWInv2 sd;3.fJPgg$v&A<intro>cmds>TWInv2.pedal sd<3.fLPgg:r=intro>cmds>twmenu sd=3.fOPgg * >Intro>Cmds>TWMenu.pedal sd>3.fRPgg^?intro>invoke>cm sd?3.f.fg!"T@Intro>Invoke>CM.pedal sd@3.f.fgAIntro>Invoke>CMSegue.1 sdA3.f.fg>аBIntro>Invoke>CMSegue.2 sdB3.f.fg~  CIntro>Invoke>Exec sdC3.f.fgDIntro>Invoke>Exec.pedal sdD3.f.fgEintro>invoke>FIB1 sdE3.fyPgg * YFintro>invoke>fib1.a000 sdF3.fPgPgw:GIntro>Invoke>FIB1.A000.Path sdG3.fwPgwPgNHintro>invoke>fib1.a002 sdH3.fPgPgAIIntro>Invoke>FIB1.A002.Path sdI3.fjPgjPgNJintro>invoke>fib1.a003 sdJ3.fPgPg+KIntro>Invoke>FIB1.A003.Path sdK3 /f|Pg|PgN"`Lintro>cmds>menu.7 sdL3fPggQ Mintro>invoke>fib1.a999 sdM3/ftPgg,*+ I,NIntro>Invoke>FIB1.A999.Path sdN3/f~PggN.OIntro>Invoke>FIB1.answers sdO3/fPgg2 Pintro>invoke>fib1.common.path sdP3/fhPggR6Qintro>invoke>initial.path sdQ3/fKfg:vRintro>invoke>qseg1 sdR3/f /fg>pSintro>invoke>rev.1 sdS3!/ffgBYTintro>invoke>rev.2 sdT3$/ff gHWUIntro>Invoke>Segue.1 sdU3'/fNfgN+ ҞVIntro>Invoke>Segue.2 sdV3*/fPfgW RɚWIntro>Invoke>Segue.3 sdW3./fSfgXbsXIntro>Invoke>Segue.4 sdX30/fUfg|hTYIntro>Invoke>Segue.5 sdY34/fXfgn`ZIntro>invoke>signon sdZ36/f9/fgtڄ[Intro>Invoke>Signon.pedal sd[3:/fInvoke>SignonSegue sd\3=/fN8fgY ]intro>screen>col.1 sd]3@/fB/fg, a^intro>screen>col.2 sd^3C/fF/f!g"$_intro>screen>cur.1 sd_3G/fPg'g 3`intro>screen>cur.2 sd`3J/fPg(g7aintro>screen>cur.3 sda3M/fPg+gz2lbintro>screen>cur.4 sdb3Q/fPg0g ]cintro>screen>cur.5 sdc3T/fPg5g-\dintro>screen>DT sdd3W/fof?gBeintro>cmds>sel.10 etsde38Pg;Pg;PgEz , |fintro>invoke>fib1-oldmonetsdmPgqPgqPg gintro>screen>FIB1 sdg3`/f[fkg4hintro>screen>FIB1.a000 sdh3c/fofÌf8ԁiIntro>Screen>FIB1.A000.Path sdi3f/fofČfN<jintro>screen>FIB1.a999 sdj3i/fofogC@kIntro>Screen>FIB1.A999.Path sdk3l/fofogNDҸlIntro>Screen>FIB1.answers sdl3n/fofmgGHmintro>screen>fib1.common.path sdm3q/foftg#L- knintro>screen>FIB2 sdn3t/f]fqgPgointro>screen>FIB2.a000 sdo3w/fFf fTpIntro>Screen>FIB2.A000.Path sdp3z/f|/ffNXqintro>screen>FIB2.a999 sdq3}/fJfug'\rIntro>Screen>FIB2.A999.Path sdr3/f/fvgN` sIntro>Screen>FIB2.answers sds3/f/fsg(dtintro>screen>fib2.common.path sdt3/f/fghuintro>screen>FN.1 sdu3/f/fIgl- tfvintro>screen>FN.2 sdv3/f/fKg9~=wIntro>Screen>FnKeys.1 sdw3/f/f=fxIntro>Screen>FnKeys.2 sdx3/f/f=f+GyIntro>Screen>I.1 sdy3/fPgggzIntro>Screen>I.2 sdz3/fPggx -{intro>cmds>fib3.a002 sd{3RfUfUfOv|Intro>Screen>Mail.1 sd|3/f/fLgb^R}Intro>Screen>Mail.2 sd}3/f/fNg  . _~intro>screen>mc1 sd~3/fkfdg9+intro>screen>mc1.common.path sd3/f/fmg# Ԁintro>screen>MC1.correct sd3/fcfcfaIntro>Screen>MC1.F001.Path sd3/f/fhgQNIntro>Screen>MC1.F002.Path sd3/f/ffO#Intro>Screen>MC1.F003.Path sd3/f/f8fQIntro>Screen>MC1.F004.Path sd3/f/ffQ Intro>Screen>MC1.F005.Path sd3/f/fHfQ$. Tintro>screen>mc1.incorrect sd3/fefhg(jIntro>Screen>MC1.legend sd3/f/fcg;.Έintro>screen>mod.1 sd3/f/f7g 2 intro>screen>mod.2 sd3/f/f9gZ >+intro>screen>mod.3 sd3/f/f<g3Lintro>screen>mod.4 sd3/f/f>g \d:intro>screen>qseg2 sd3/f/fagjbintro>screen>wdw.3 sd3"fvfQg/ intro>screen>wdw.2 sd3ftfQgwȏintro>screen>wdw.1 sd3fqfOgSintro>screen>ref.3 sd3 fRg]g\ intro>screen>ref.2 sd3fRg\gintro>screen>ref.1 sd3fRgZgintro>screen>wdw.6 sd35f~fUg"uintro>screen>wdw.5 sd3/f{fTgɷintro>screen>wdw.4 sd3(fyfSgU/ kintro>screen>rev.1 sd3/fPgyg'hintro>screen>rev.2 sd3/fPg{gintro>screen>rev.3 sd3/fPggTintro>screen>rev.4 sd3/fPggB5intro>screen>row.1 sd3/ff"gintro>screen>row.2 sd3/ff$g8intro>screen>seg sd3/f/fgM8ԑintro>screen>tf1 sd3/f]f=fH0 f intro>screen>tf1.common.path sd3/f0f!>fLDIntro>Screen>TF1.F001.Path sd30f0f#>fLPIntro>Screen>TF1.F002.Path sd30f0fk=fMT$intro>screen>tf1.false sd30fbf >fXA;Intro>Screen>TF1.legend sd3 0f 0f5=f*\Cintro>screen>tf1.true sd3 0fff=f`intro>cmds>Fib3.A002.Path sd3@fCfCfJ |intro>whatis>i.1 sd30ffgh0 (intro>whatis>i.10 sd30ffg|hintro>whatis>i.11 sd30ffgintro>whatis>i.12 sd30ffgѪintro>whatis>i.13 sd30ffgj8intro>whatis>i.14 sd3"0ffg'GHintro>whatis>i.2 sd3&0ffg.intro>whatis>i.3 sd3(0ffgq-intro>whatis>i.4 sd3+0ffg1 =Įintro>whatis>i.5 sd3.0ffg|$Яintro>whatis>i.6 sd310ffgm <intro>whatis>i.7 sd340ffg[intro>whatis>i.8 sd370ffg0Eٲintro>whatis>i.9 sd3;0ffgOJjOOCIDsys04f44fgfxintro>screen>wdw.7 sd3:ffVgVf׵intro>screen>wdw.8 sd3@ffWg#1 Uiintro>screen>wdw.9 sd3EffXgMmintro>screen>wdw.10 sd3KffYgMintro>screen>ref.4 sd3"fSg^g|intro>cmds>menu.8 sd3f Pgg# O intro>cmds>go sd3Ȋfʊfg qintro>cmds>rev.3 sd3Պffgl Intro>WhatIs>Initial.path sd3VAfVfg Dintro>whatis>rev.1 sd3lVfoVfg\ 2 -intro>whatis>rev.2 sd3sVfyVfgb intro>whatis>rev.3 sd3}VfVfgf SIntro>Screen>Initial.path SD3Zf`ffgCp$ ll  &,F64KIntro>Screen>FIB1.A002.Path etSD3^fofӌfN& ll x &,F$ 42Ointro>screen>e sd3ofof_grm(Intro>Screen>FIB1.a002 sd3ofofьfx-Intro>Invoke>FIB1.A004.Path etsd3RPgTPgTPg  intro>screen>rc.1monetsdPgPgPgS 2 vRintro>screen>rc.2monetsdPgPgPg R7intro>screen>rc.3monetsdfPgPgPg\  +intro>screen>rc.4monetsdPgPgPgintro>screen>rc.5monetsdPgPgPgw,;intro>screen>rc.6monetsdPgPgPg|,.intro>screen>rc.7monetsdPgPgPgml3 kjihgfed3 cba`_^]\4 [ZYXWVUT4 SRQPONML5 KJIHGFED5 CBA@?>=~<}6 ;|9{8z8{intro>cmds>fib1.a000 intro>cmds>fib2intro>cmds>Inv1.1!intro>cmds>Menu.6)intro>cmds>sel.1.intro>cmds>Twinv1.pedal:intro>invoke>rev.1SIntro>Invoke>Signon.pedal[intro>screen>DTdintro>screen>FIB1gintro>screen>FN.2vIntro>Screen>I.1yIntro>Screen>MC1.F002.Pathintro>screen>qseg2intro>whatis>i.12intro>whatis>i.3intro>screen>wdw.6Intro>Screen>FIB1.A002.Pathintro>cmds>fib2.a000intro>cmds>fib3Intro>Cmds>FIB3.A000.Pathintro>cmds>Inv1.2"intro>cmds>sel.2/Intro>Invoke>Exec.pedalDintro>invoke>fib1.a000Fintro>invoke>rev.2TIntro>Screen>FIB1.answerslintro>screen>FIB2nintro>screen>fib2.common.pathtIntro>Screen>I.2zintro>screen>MC1.correctIntro>Screen>MC1.F003.Pathintro>whatis>i.13intro>whatis>i.4intro>screen>wdw.7intro>cmds>menu.7LIntro>WhatIs>Initial.pathintro>cmds>fib2.a999intro>cmds>Inv2#intro>cmds>qseg1*intro>cmds>sel.30Intro>Invoke>FIB1.A000.PathGintro>invoke>fib1.a999MIntro>invoke>signonZIntro>Screen>FIB2.answerssIntro>Screen>TF1.legendintro>whatis>i.14intro>whatis>i.5intro>screen>wdw.8intro>cmds>menu.8intro>cmds>fib1.common.pathintro>cmds>fib3.a999intro>cmds>fib3.common.pathintro>cmds>sel.41intro>cmds>twcancl7Intro>Cmds>TWMenu.pedal>Intro>Invoke>ExecCintro>invoke>fib1.a002HIntro>Invoke>FIB1.A003.PathKIntro>Invoke>FIB1.A999.PathNintro>invoke>initial.pathQintro>screen>mc1~intro>screen>mc1.common.pathintro>screen>row.1intro>whatis>i.6intro>screen>wdw.9 intro>cmds>gointro>screen>e6 intro>cmds>sel.52intro>cmds>Twinv19intro>invoke>fib1.a003JIntro>Invoke>Segue.1UIntro>Screen>FIB1.A000.Pathiintro>screen>mc1.incorrectIntro>Screen>MC1.legendintro>screen>rev.1intro>screen>row.2Intro>Screen>TF1.F002.Pathintro>whatis>i.7intro>whatis>rev.1Intro>Invoke>FIB1.A004.PathIntro>Cmds>FIB1.A000.Path Intro>Cmds>FIB2.answersintro>cmds>Menu.1$intro>cmds>sel.63intro>cmds>TWInv2;intro>cmds>twmenu=intro>invoke>qseg1RIntro>Invoke>Segue.2Vintro>screen>col.1]intro>screen>cur.1_Intro>Screen>FIB1.A999.PathkIntro>Screen>FIB2.A000.PathpIntro>Screen>FnKeys.1wIntro>Screen>MC1.F001.Pathintro>screen>mod.1intro>screen>rev.2intro>screen>segintro>screen>tf1intro>screen>tf1.trueintro>screen>wdw.1Intro>Screen>Initial.path>screen>rc.2intro>cmds>canclIntro>Cmds>FIB1.A999.Path Intro>Cmds>FIB2.A000.Pathintro>cmds>fib3.a000Intro>Cmds>FIB3.answersintro>cmds>Menu.2%intro>cmds>seg-intro>cmds>sel.74intro>invoke>cm?Intro>Invoke>CM.pedal@Intro>Invoke>Segue.3Wintro>screen>col.2^intro>screen>cur.2`intro>screen>fib1.common.pathmIntro>Screen>FIB2.A999.PathrIntro>Screen>FnKeys.2xIntro>Screen>Mail.1|Intro>Screen>MC1.F004.Pathintro>screen>mod.2intro>screen>rev.3intro>whatis>i.8intro>screen>ref.1intro>cmds>fib1.a999 Intro>Cmds>FIB2.A999.Pathintro>cmds>Inv.1intro>cmds>Menu.3&intro>cmds>rev.1+intro>cmds>sel.85intro>cmds>twcancl.pedal8intro>cmds>TWInv2.pedal<Intro>Invoke>Segue.4XIntro>Invoke>SignonSegue\intro>screen>cur.3aintro>screen>FIB1.a000hIntro>Screen>Mail.2}Intro>Screen>MC1.F005.Pathintro>screen>mod.3intro>screen>rev.4intro>whatis>i.9intro>screen>ref.2intro>screen>wdw.2intro>screen>wdw.3intro>whatis>rev.2intro>whatis>rev.3Intro>Cmds>FIB1.answers intro>cmds>fib2.common.pathIntro>Cmds>FIB3.A999.Pathintro>cmds>initial.pathintro>cmds>Inv.2intro>cmds>Menu.4'intro>cmds>rev.2,intro>cmds>sel.96Intro>Invoke>CMSegue.1Aintro>invoke>FIB1EIntro>Invoke>FIB1.A002.PathIintro>invoke>fib1.common.pathPIntro>Invoke>Segue.5Yintro>screen>cur.4bintro>screen>FIB1.a999jintro>screen>FIB2.a000ointro>screen>mod.4intro>screen>tf1.falseintro>whatis>i.1intro>whatis>i.10intro>screen>ref.3intro>cmds>fib1intro>cmds>Inv.3 intro>cmds>Menu.5(Intro>Invoke>CMSegue.2BIntro>Invoke>FIB1.answersOintro>screen>cur.5cintro>screen>FIB2.a999qintro>screen>FN.1uintro>screen>tf1.common.pathIntro>Screen>TF1.F001.Pathintro>whatis>i.11intro>whatis>i.2intro>screen>wdw.4intro>screen>wdw.5intro>screen>wdw.10intro>cmds>rev.3Intro>Screen>FIB1.a002intro>screen>ref.4intro>cmds>Fib3.A002.Pathintro>cmds>fib3.a002{intro>cmds>sel.10ee>fib1-oldf2am f JHPN  NO CHANGE!+NITheSolutionDesignerScreen5TheSolutionDesignerscreendisplaysawindowoftheworksheetatatime.Youhavereachedtheendofthislesson.Theworksheetconsistsof512columnsWesuggestyouproceedand8192rows.tothenextlesson,The Solution DesignerColumnshaveletternames,androws Command Menu.havenumbernames.PressNextPagetoreturntotheIntromenu.Cellsareaddre7 ssedbycellreferences,whichconsistofthecolumnletterandrownumber,forexample,a1.5555 #55555555555 5555! 55555552am ze JHPN   NO CHANGE!+zNa1 READYO  a b c d e f g h i1  2 3 4 5 6 7 !8 9 These are the worksheet rows.10 11 !12 13 14 15 16 17 18 19 20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P !18 19 20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P !y NO CHANGE!Na1 READYO  a b c d e f g h i1  2 3 4 5 6 7 !8 9 These are the worksheet rows.10 11 12 They are designated by the13 14 numbers 1 through 23.15 16 !17 18 19 20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P !  NO CHANGE! Na1 READYO  a b c d e f g h i1  2 3  4 5 6 7 !8 9 These are the worksheet rows.10 11 12 They are designated by the13 14 numbers 1 through 23.15 16 !17 18 19 20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P !   NO CHANGE! Na1 READYO  a b c d e f g h i17   2 3  4 5  6 7  !8 9 These are the worksheet rows.10 11 12 They are designated by the13 14 numbers 1 through 23.15 16 !17 18 19 20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P ! NO CHANGE!Na1 READYO  a b c d e f g h i1  2 3  4 5  6 7  !8 9  These are the worksheet rows.10 11  12 They are designated by the13 14 numbers 1 through 23.15 16 !17 18 19 20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P ! NO CHANGE!Na1 READYO  a b c d e f g h i1  2 3  4 5  6 7  !8 9  These are the worksheet rows.10 11  12 They are designated by the13  14 numbers 1 through 23.15  16 !17 18 19 20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P !  NO CHANGE!2N&a1 READYO  a b c d e f g h i1  2 3  4 5  6 7  !8 9  These are the worksheet rows.10 11  12 They are designated by the13  14 numbers 1 through 23.15  16 !17  18 19  20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P !I VNO CHANGE!hN*a1 READYO  a b c d e f g h i1  2 3  4 5  6 7  !8 9  These are the worksheet rows.10 11  12 They are designated by the13  14 numbers 1 through 23.15  16 !17  18 19  20 21  22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P !8 2am f JHPN  NO CHANGE!+Na1 READYO  a b c d e f g h i1  2 3 4 5 6 7 !8 9 These are the worksheet rows.10 11 12 They are designated by the13 !14 15 16 17 18 19 20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P ! NO CHANGE!Na1 READYO  a b c d e f g h i1  2 3 4 5 6 7 !8 9 These are the worksheet rows.10 11 12 They are designated by the13 14 numbers 1 through 23.15 16 !17 18 19 20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P ! NO CHANGE!Na1 READYO  a b c d e f g h i1  2 3  4 5 6 7 !8 9 These are the worksheet rows.10 11 12 They are designated by the13 14 numbers 1 through 23.15 16 !17 18 19 20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P !   NO CHANGE!' Na1 READYO  a b c d e f g h i1  2 3  4 5  6 7  !8 9 These are the worksheet rows.10 11 12 They are designated by the13 14 numbers 1 through 23.15 16 !17 18 19 20 21 22 23  Thu04-Feb-884:26PM Macro  Edit   Name Abs  Go To  Window Query Table  Calc  Graph P !& 3NO CHANGE!ENa1 READYO  a b c d e f g h i1  2 3  4 5  6 7  !8 9  These are the worksheet rows.10 11  12 They are designated by the13 14 numbers 1 through 23.15 16 !17 18 19 20 21 22 23  Thu8 04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P !L YNO CHANGE!kNa1 READYO  a b c d e f g h i1  2 3  4 5  6 7  !8 9  These are the worksheet rows.10 11  12 They are designated by the13  14 numbers 1 through 23.15  16 !17 18 19 20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P !z NO CHANGE!N&a1 READYO  a b c d e f g h i1  2 3  4 5  6 7  !8 9  These are the worksheet rows.10 11  12 They are designated by the13  14 numbers 1 through 23.15  16 !17  18 19  20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P ! NO CHANGE!N*a1 READYO  a b c d e f g h i1  2 3  4 5  6 7  !8 9  These are the worksheet rows.10 11  12 They are designated by the13  14 numbers 1 through 23.15  16 !17  18 19  20 21  22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P ! NO CHANGE!Na1 READYO  a b c d e f g h i1  2 3  4 5  6 7  !8 9  These are the worksheet rows.10 11 12 They are designated by the13 14 numbers 1 through 23.15 16 !17 18 19 20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P ! NO CHANGE!Na1 READYO 9  a b c d e f g h i1  2 3  4 5  6 7  !8 9  These are the worksheet rows.10 11  12 They are designated by the13 14 numbers 1 through 23.15 16 !17 18 19 20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P !" "NO CHANGE! # Na1 READYO  a b c d e f g h i1  2 3  4 5  6 7  !8 9  These are the worksheet rows.10 11  12 They are designated by the13  14 numbers 1 through 23.15 16 !17 18 19 20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P !& $&NO CHANGE!6&Na1 READYO  a b c d e f g h i1  2 3  4 5  6 7  !8 9  These are the worksheet rows.10 11  12 They are designated by the13  14 numbers 1 through 23.15  16 !17 18 19 20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P !E) R)NO CHANGE!d)N"a1 READYO  a b c d e f g h i1  2 3  4 5  6 7  !8 9  These are the worksheet rows.10 11  12 They are designated by the13  14 numbers 1 through 23.15  16 !17  18 19 20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P !w, ,NO CHANGE!,N&a1 READYO  a b c d e f g h i1  2 3  4 5  6 7  !8 9  These are the worksheet rows.10 11  12 They are designated by the13  14 numbers 1 through 23.15  16 !17  18 19  20 21 22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P !/ /NO CHANGE!/N*a1 READYO  a b c d e f9  g h i1  2 3  4 5  6 7  !8 9  These are the worksheet rows.10 11  12 They are designated by the13  14 numbers 1 through 23.15  16 !17  18 19  20 21  22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P !2 2NO CHANGE!3N*a1 READYO  a b c d e f g h i1  2 3  4 5  6 7  !8 9  These are the worksheet rows.10 11  12 They are designated by the13  14 numbers 1 through 23.15  16 !17  18 19  20 21  22 23  Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P !2am e  JHPN  NO CHANGE!+Na1 READYN  a b c d e f g h i1 2 3 4 45 46 47 "8 It displays just a small9 10  portion of the worksheet.11 12 13 "14 415 416 417 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]! NO CHANGE!Na1 READYN  a b c d e f g h i1 2 3 4 45 46 47 "8 9  portion of the worksheet.10 11 12 Let's take a closer look13 "14 415 416 417 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]!p  }NO CHANGE!Na1 READYN  a b c d e f g h i1 2 3 4 45 46 4: 7 "8  portion of the worksheet.9 10 11 Let's take a closer look12 13 "14 415 416 417 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]! * NO CHANGE!< yNa1 READYN  a b c d e f g h i1 2 3 4 45 46 47 "8 9 10 Let's take a closer look11 12 at it.13 "14 415 416 417 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]!  NO CHANGE! yNa1 READYN  a b c d e f g h i1 2 3 4 45 46 47 "8 9 Let's take a closer look10 11 at it.12 13 "14 415 416  417 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]!2am Td JHPN   NO CHANGE!+TNQuestion The Solution Designer ScreenPT R U E o r F A L S E#++The worksheet can be viewed++a window at a time.++#V (Select your answer by pressing one of the indicated selections)P! @2am c P GIntro>Screen>Rev.1$GIntro>Screen>Rev.2?GIntro>Screen>Rev.3ZGIntro>Screen>Rev.4uGIntro>Screen>Rev.5GIntro>Screen>Rev.6GIntro>Screen>Rev.7NIntro>Menu: 2am %c P GIntro>Screen>TF1.true'%LIntro>Screen>TF1.common.path2am %c P GIntro>Screen>TF1.false(%LIntro>Screen>TF1.common.path2am d, JHPN  NO CHANGE!+NAThe Solution Designer ScreenPT R U E o r F A L S E#++The worksheet can be viewed++a window at a time.++!That's incorrect. This statement is!!true. Since the worksheet is so!large, it can be viewed only a windowat a time.P/////// /2am !c N ! TRUE  FALSE ; 2am d JHPN  7NO CHANGE!+N6The Solution Designer ScreenPT R U E o r F A L S E#++The worksheet can be viewed++a window at a time.++ Correct. This statement is true. Since the worksheet is so large, it can be viewed only a windowat a time.P000000042am c P Gintro>whatis>i.1"Gintro>whatis>i.2;Gintro>whatis>i.3TGintro>whatis>i.4mGintro>whatis>i.5Gintro>whatis>i.6Gintro>whatis>i.7Gintro>whatis>i.8Gintro>whatis>i.9Gintro>whatis>i.10Gintro>whatis>i.11Gintro>whatis>i.128Gintro>whatis>i.13RGintro>whatis>i.14lNIntro>Menu2am fz JHPN   NO CHANGE!+N  @  MNO CHANGE!_N What n Designer        p/  <NO CHANGE!NN\ What n Designer SOLU NER is an worksheet `        NO CHANGE!|NA What n Designer SOLU NER is an worksheet id of cell contain , numbers, as. t lution Des orm the ca for you.          NO CHANGE!N What n Designer ;  SOLU NER is an worksheet id of cell contain , numbers, as.  You set Solution Designer up wi d numbers, t lution Des orm the ca for you.           NO CHANGE! N What n Designer  SOLU NER is an worksheet a large grid of cellsthat can containwords, numbers, or formulas.You set Solution Designer upwith text and numbers,then let Solution Designer perform the calculations for you.          NO CHANGE! \N& What n Designer  ?SOLUTION DESIGNER is an electronic worksheet --a large grid of cellsthat can containwords, numbers, or formulas.You set Solution Designer upwith text and numbers,then let Solution Designer perform the calculations for you.?         NO CHANGE!(N What n Designer ?SOLUTION DESIGNER is an electronic worksheet --a large grid of cellsthat can containwords, numbers, or formulas.You set Solution Designer upwith text and numbers,then let Solution Designer perform the calculations for you.?       7NO CHANGE!0NrWhat Is Solution DesignerP?SOLUTION DESIGNER is an electronic worksheet --a large grid of cellsthat can containwords, numbers, or formulas.You set Solution Designer upwith text and numbers,then let Solution Designer perform the calculations for you.?P2am g JHPN   NO CHANGE!+NR0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIO2BalanceBUDGET SHEET9INCOME PROJECTION0.00ADATABASEEMPLOYEE RECORDSEmpNo LastName FirtName AreaPhone MailStop9< 194RhodesJohn9199512366NC164SmithRon4042632125GA748BennettCharles2147552288TXO871SpeckJoe5133664667OH316GeeAnn3127931851IL?EXPENSE REPORT9/89/99/107Air, rail, bus450.002 L=4  ;              ONO CHANGE!NU0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIO2BalanceBUDGET SHEET9INCOME PROJECTION0.00ADATABASEEMPLOYEE RECORDSEmpNo LastName FirtName AreaPhone MailStop9?EXPENSE REPORT9/89/99/10O7Air, rail, bus450.00Rental car40.0040.00 40.00Daily lodging68.0068.00 68.00Meals25.0025.00 25.00Entertainment75.007Total Expenses583.00208.00 133.002 L=4  ;             M  Z NO CHANGE!l xNM0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIO2BalanceBUDGET SHEET9INCOME PROJECTION0.00ADATABASE?EXPENSE REPORT9/89/99/107Air, rail, bus450.00Rental car40.0040.00 40.00Daily lodging68.0068.00 68.00Meals25.0025.00 25.00Entertainment75.00O7Total Expenses583.00208.00 133.00Less AdvancesBal due to employeeBal due from employee?92 L=4  ;L  (                ;2am ud JHPN  ONO CHANGE!+uNJWhatIsSolutionDesignerP (  ; (NO CHANGE!2(N-jSo, put away your pen, paper,calculator,andfile folders . 6*  ;C*NO CHANGE!U*NSo, put away your pen, paper,calculator,andfile folders . F,  *S,NO CHANGE!e,NSo, put away your pen, paper,calculator,andfile folders . -.  4:.NO CHANGE!L.NSo, put away your pen, paper, calculator,and file folders .  0  :!0NO CHANGE!30NSo, put away your pen, paper,calculator,andfile folders . 1  <2NO CHANGE!2NSo, put away your pen, paper,calculator,andfile folders . 3  63NO CHANGE!3N0And replace it with oneversatile aid:5  <5NO CHANGE!5sN0And replace it with oneversatile aid: 7 >-7NO CHANGE!?7dN0And replace it with oneversatile aid:> 8 L8NO CHANGE!8<N0And replace it with oneversatile aid:          9 K :NO CHANGE!:Nw0And replace it with oneversatile aid:      ;; BH;NO CHANGE!Z;Nh0And replace it with oneversatile aid:5Z< Dg<NO CHANGE!y<Nb0And replace it with oneversatile aid:o6n=  D{=NO CHANGE!=NK0And replace it with oneversatile aid:Kf> Ls>NO CHANGE!>NX0And replace it with oneversatile aid:k? Lx?NO CHANGE!?N^0And replace it with oneversatile aid:v@ L@NO CHANGE!@Nb0And replace it with oneversatile aid:A LANO CHANGE!ANe0And replace it with oneversatile aid:B LBNO CHANGE!BNl0And replace it with oneversatile aid:#C LCNO CHANGE!CNs0And replace it with oneversatile aid:*D LDNO CHANGE!DNz0And replace it with oneversatile aid:޲1E LFNO CHANGE!FN0And replace it with oneversatile aid:ز!5? 2am d| JHPN  ONO CHANGE!+NWhatIsSolutionDesignerP4SOLUTION DESIGNERcombines the features of two popular Spreadsheets:Lotus 1-2-3andMultiplan4~P2am xd JHPN  ONO CHANGE!+xNMWhatIsSolutionDesignerPSOLUTION DESIGNERfeatures:On-screen command menus60 built-in functionsOnline HelpGraphing capabilityDatabase capabilityMacro capabilityPP2am ea JHPN  ;NO CHANGE!+NV SOLUTION DESIGNER can be used to create a . ;NO CHANGE!.NE0BALANCE SHEET(amount in thousands)1987Assets:Cash$87Accounts Receivable75Inventories45Property/Equipment31SOLUTIONDESIGNERTotal Assets:$238(canbeusedLiabilities:tocreatea.Long-term debt$22Accounts payable40Deferred income taxes73Total Liabilities:$135(Owner's Equity:Capital$103Total liabilities andowner's equity$2380 ? 2am _f JHPN  NO CHANGE!+uNX0BALANCE SHEET(amount in thousands) 1987CHECKAssets:Cash$87DateAccounts Receivable75Inventories45Property/Equipment312/52/5Total Assets:$2382/8(2/9Liabilities: Long-term debt$22Accounts payable40Deferred income taxes73Total Liabilities:$135(Owner's Equity:Capital$103Total liabilities andowner's equity$2380  NO CHANGE!N0BALANCE SHEET(amount in thousands)1987CHECKING ACCOUNT Assets:Cash$87DateNo.DesAccounts Receivable75Inventories45Property/Equipment312/5Pay2/5700RenTotal Assets:$2382/8701Pho(2/9702HaiLiabilities:Long-term debt$22Accounts payable40Deferred income taxes73Total Liabilities:$135(Owner's Equity:Capital$103Total liabilities andowner's equity$2380  ,NO CHANGE!N0BALANCE SHEET(amount in thousands)!1987CHECKING ACCOUNT LEDGERAssets:Cash$87DateNo.DescriptionAccounts Receivable75Inventories45Property/Equipment312/5Pay day2/5700RentTotal Assets:$2382/8701Phone bill(2/9702HaircutLiabilities:!Long-term debt$22Accounts payable40Deferred income taxes73Total Liabilities:$135(Owner's Equity:Capital$103Total liabilities andowner's equity$2380 .   NO CHANGE! N0BALANCE SHEET(amount in thousands)-CHECKING ACCOUNT LEDGERAssets:CashDateNo.DescriptionDepositAccounts Receivable InventoriesProperty/Equipment2/5Pay day$10.002/5700RentTotal Assets:2/8701Phone bill2/9702HaircutLiabilities:-Long-term debt$22Accounts payable40Deferred income taxes73Total Liabilities:$135(Owner's Equity:Capital$103Total liabilities andowner's equity$2380  - 8 NO CHANGE! N0BALANCE SHEET(amount in thousa9CHECKING ACCOUNT LEDGERAssets:CashDateNo.DescriptionDepositWithdrawaAccounts Receiv InventoriesProperty/Equipm2/5Pay day$10.002/5700Rent$5.00Total Assets:2/8701Phone bill$32.002/9702Haircut$25.00Liabilities:9Long-term debt$22Accounts payable40Deferred income taxes73Total Liabilities:$135@ (Owner's Equity:Capital$103Total liabilities andowner's equity$2380 "'  NO CHANGE!N0BALANCE SHEET(amounDCHECKING ACCOUNT LEDGERAssetsCashDateNo.DescriptionDepositWithdrawalsBalanAcco InveProp2/5Pay day$10.00$10.2/5700Rent$5.00$445.To2/8701Phone bill$32.00$413.2/9702Haircut$25.00$388.LiabilDLong-term debt$22Accounts payable40Deferred income taxes73Total Liabilities:$135(Owner's Equity:Capital$103Total liabilities andowner's equity$2380 ).  NO CHANGE!_N0BALANCE SHEETJCHECKING ACCOUNT LEDGERDateNo.DescriptionDepositWithdrawalsBalance 2/5Pay day$10.00$10.002/5700Rent$5.00$445.002/8701Phone bill$32.00$413.002/9702Haircut$25.00$388.00JLong-term debt$22Accounts payable40Deferred income taxes73Total Liabilities:$135(Owner's Equity:Capital$103Total liabilities andowner's equity$23802  222222222222222am ff JHPN  NO CHANGE!+N0BALANCE SHEETJCHECKING ACCOUNT LEDGERDateNo.DescriptionDepositWithdrawalsBalance 2/5Pay day$10.00$10.002/5700Rent$5.00$445.002/8701Phone bill$32.00$413.002/9702Haircut$25.00$388.00JLong-term debt$22Accounts payable40Deferred income taxes73Total Liabilities:$135(;STOCK PORTFOLIOPurchaseCurrentMarketDollarSymbolShares Price PriceValue Gain32  222222 NO CHANGE!NU0BALANCE SHEETJCHECKING ACCOUNT LEDGERDateNo.DescriptionDepositWithdrawalsBalance 2/5Pay day$10.00$10.002/5700Rent$5.00$445.002/8701Phone bill$32.00$413.002/9702Haircut$25.00$388.00;STOCK PORTFOLIO PurchaseCurrentM@ arketDollarSymbolShares Price PriceValue Gain3W 50 5.00 7.50 375.00125.00X2036.4038.00 760.0032.00Y3004.508.502550.001200.00Z1512.0011.00165.00-15.00;02  22   NO CHANGE! N0BALANCE SHEETJCHECKING ACCOUNT LEDGERDateNo.DescriptionDepositWithdrawalsBalance ;$10.00STOCK PORTFOLIO$445.00$413.00$388.00PurchaseCurrentMarketDollarSymbolShares Price PriceValue Gain 3W 50 5.00 7.50 375.00125.00X2036.4038.00 760.0032.00Y3004.508.502550.001200.00Z1512.0011.00165.00-15.00;Capital$103Total liabilities andowner's equity$23802  222222 @ NO CHANGE! N0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIOBalancePurchaseCurrentMarketDollarSymbolShares Price PriceValue Gain$10.003$445.00$413.00W 50 5.00 7.50 375.00125.00$388.00X2036.4038.00 760.0032.00Y3004.508.502550.001200.00 Z1512.0011.00165.00-15.00;Total Liabilities:$135(Owner's Equity:Capital$103Total liabilities andowner's equity$23802  L0           222222222222am g JHPN  NO CHANGE!+N0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIOBalancePurchaseCurrentMarketDollarSymbolShares Price PriceValue Gain$10.003$445.00$413.00W 50 5.00 7.50 375.00125.00$388.00X2036.4038.00 760.0032.00Y3004.508.502550.001200.00 Z1512.0011.00165.00-15.00;Total Liabilities:$135(Owner's Equity:2BUDGET SHEETJanuaryTAKE HOME1300EXPENSES2  L0           2222  A  NO CHANGE!'N0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIOBalancePurchaseCurrentMarketDollarSymbolShares Price PriceValue Gain$10.003$445.00$413.00W 50 5.00 7.50 375.00125.00$388.00X2036.4038.00 760.0032.00Y3004.508.502550.001200.00 Z1512.0011.00165.00-15.002BUDGET SHEETJanuaryOTAKE HOME1300EXPENSESRent300Food160Car Loan175Car Ins40Gas & Elec60Telephone202  L0             = J NO CHANGE!\ N0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIOBalancePurchaseCurrentMarketDollarSymbolShares Price PriceValue Gain$10.003$445.002$413.00BUDGET SHEET00$388.000000 January00TAKE HOME1300EXPENSESRent300Food160Car Loan175OCar Ins40Gas & Elec60Telephone20VISA250Chocolate25Other50TOTAL EXP10802  L0             + :8NO CHANGE!JN0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIO2BalanceBUDGET SHEETr$10.00January$445.00TAKE HOME1300EXPENSES$413.0000$388.00Rent30000Food16000 Car Loan17500Car Ins40Gas & Elec60Telephone20VISA250Chocolate25OOther50TOTAL EXP1080BALANCE22022  L0L.  :NO CHANGE!N0BALANCE SHEETJCHECKING ACCOUNT LEDGERBSTOCK PORTFOLIO2eBUDGET SHEETPercent Gain0January 0TAKE HOME1300EXPENSES0030.00%0Rent300010.86%Food160050.00%Car Loan1750-50.00%Car Ins40Gas & Elec60 Telephone20VISA250Chocolate25OOther50TOTAL EXP1080BALANCE22022  O3L.  A 2am fa JHPN  -NO CHANGE!+N0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIO2BalanceBUDGET SHEETr$10.00January$445.00TAKE HOME1300EXPENSES$413.0000$388.00Rent30000Food16000 Car Loan17500Car Ins40Gas & Elec60Telephone20VISA250Chocolate25OOther50TOTAL EXP INCOME PROJECTIONBALANCE(Jan-MarApr-Ju2  L0L.   NO CHANGE!!N0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIO2BalanceBUDGET SHEETr$10.00January$445.00TAKE HOME1300EXPENSES$413.0000$388.00Rent30000Food16000 Car Loan17500Car Ins40Gas & Elec60T/VINCOME PROJECTIONCOOJan-MarApr-JunJul-SepO+Sales:140150160+Costs:2  L0L.    NO CHANGE!( N0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIO2BalanceBUDGET SHEETr$10.00January$445.00TAKE HOME1300EXPENSES$413.0000$388.00Rent300009INCOME PROJECTIONJan-MarApr-JunJul-SepOct-Dec1OSales:1401501602401Costs:Salaries2020Interest12001400Rent6006002  L0L.     NO CHANGE! N0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIO2BalanceBUDGET SHEETr$10.00January$445.00TAK9INCOME PROJECTIONJan-MarApr-JunJul-SepOct-Dec1Sales:140150160240B 1OCosts:Salaries2020Interest12001400Rent600600Adver.90020Purchases40420012  L0L.   9NO CHANGE!N0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIO2BalanceBUDGET SHEET9INCOME PROJECTION0.00445.00413.00388.00Jan-MarApr-JunJul-SepOct-Dec1 Sales:1401501602401Costs:Salaries2020OInterest12001400Rent600600Adver.90020Purchases4042001Total:8700102000092  L0L.L   ,       CHECKING ACCOUNT LEDGERBSTOCK PORTFOLIO2eBUDGET SHEET9INCOME PROJECTION0000Jan-MarApr-JunJul-SepOct-Dec1Sales:1401501602401Costs:Salaries2020OInterest12001400Rent600600Adver.90020Purchases4042001Total:8700102000092  O3L.L   ,       2am Ng JHPN  BNO CHANGE!+)N 0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIO2BalanceBUDGET SHEET9INCOME PROJECTION0.00DATABASEJan-MarApr-JunJul-SepOct-Dec1EMPLOYEE RECSales:140150160240EmpNo LastN1 Costs:194Rhode164SmithSalaries2020748BenneOInterest12001400871SpeckRent600600316GeeAdver.90020Purchases4042001Total:8700102000092  L0L.L   ,  B T BaNO CHANGE!sDN$0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIO2BalanceBUDGET SHEET9INCOME PROJECTION0.00DATABASEJan-MarApr-JunJul-Se&EMPLOYEE RECORDSSales:1401501600EmpNo LastName Firt&Costs:194RhodesJohn164SmithRonSalaries2020748BennettCharOInterest12001400871SpeckJoeRent600600316GeeAnnAdver.90020Purchases4042001Total:8700102000092  L0L.L   ,   ) NO CHANGE! >N0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIO2BalanceBUDGET SHEET9INCOME PROJECTION0.00%DATABASEJan-MarApr-JunEMPLOYEE RECORDSSales:140150EmpNo LastName FirtName !Costs:194RhodesJohn164SmithRonSalaries2020748BennettCharlesOInterest12001400871SpeckJoeRent600600316GeeAnnAdver.90020Purchases404200%1Total:8700102000092  L0L.L   ,   B!NO CHANGE!3FN%0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIO2BalanceBUDGET SHEET9INCOME PROJECTION0.001DATABASEJan-MEMPLOYEE RECORDSSales:140EmpNo LastName FirtName AreaPhone-Costs:194RhodesJohn919951236164SmithRon404263212Salaries20748BennettCharles214755228OInterest12871SpeckJoe513366466Rent6316GeeAnn312793185Adver.9Purchases4011Total:8700102000092  L0L.L   ,  'y NO CHANGE!JN)0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIO2BalanceBUDGET SHEET9INCOME PROJECTION0.00=DATABASEEMPLOYEE RECORDSSalesEmpNo LastName FirtName AreaPhone MailStop9Costs194RhodesJohn9199512366NC164SmithRon4042632125GASalar748BennettCharles2147552288TXOC Inter871SpeckJoe5133664667OHRent316GeeAnn3127931851ILAdverPurch=1Total:8700102000092  L0L.L   ,  .  BNO CHANGE!NN'0BALANCE SHEETJCHECKING ACCOUNT LEDGER;STOCK PORTFOLIO2BalanceBUDGET SHEET9INCOME PROJECTION0.00ADATABASEEMPLOYEE RECORDSEmpNo LastName FirtName AreaPhone MailStop9194RhodesJohn9199512366NC164SmithRon4042632125GA748BennettCharles2147552288TXO871SpeckJoe5133664667OH316GeeAnn3127931851ILA1Total:8700102000092 L=4  ;+SD5j          CCC;2am e C  JHPN  NO CHANGE!+Na1 READYN  a b c d e f g h i1 2 3 4 45 46 47 "8 It displays just a small9 10  portion of the worksheet.11 12 13 "14 415 416 417 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  G2am fF JHPN  BNO CHANGE!+Na1READY a b c d e f g h i12;3;4-56Throughout this tutorial, you will be78performing most of the exercises in910the portion of the worksheet1112thatyou see right here.131415However, just keep in mind that1617there is much more worksheet1819than meets the eye!2021-22;23 ;Thu 04-Feb-88 4:26 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]----------------*2am c# JHPN   5NO CHANGE!+NThe Solution Designer ScreenPCorrect!The cell pointer location indicates thelocation of the active, or current, cell.PC'2am eh JHPN   'NO CHANGE!+Na1 $READY    a b c d . so sp sq sr1 2 3 4 5 6 7 The cell reference, or cell address,8 9 identifies a specific cell. It10 11 consists of the column letter followed12 13 by the row number, for example, a1.14*.818781888189819081918192Thu04-Feb-884:26D PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph '-********2am $c P Gintro>cmds>fib3.a002&$Lintro>cmds>Fib3.common.path2am $d JHPN  NO CHANGE!+$NThe Solution Designer Command MenuP[That's correct, however, since you are in READY mode,you need to first display the command menu.The keystroke combination to use theWorksheet/Global/Defaultcommandsis/wgd.E"P2am eA JHPN  NO CHANGE!+Na1 MENU RetrieveSaveCombineXtractEraseListImportDirectoryReadinaspreadsheetfile a b c d e f g h i1 2 3 4 5 6 (7 8 9 To cancel the File command,10 11 12 simply press Cancel.13 14 15 (16 17 18 19 20 21 22 23 Thu 04-Feb-88 14:29 PM 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 Retrieve, Save, Combine, Xtract, Import0 a b c d e f g h i1 2 3 4 5 6 7 8 9 10 11 12 D 13 14 15 16 17 18 19 20 21 22 23 Fri 05-Feb-88 10:02 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]9  FNO CHANGE!XNa1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Retrieve, Save, Combine, Xtract, Import0 a b c d e f g h i1 2 3 4 5 6 7 The main command menu reappears and8 9 the File command is highlighted.10 11 '12 13 14 15 16 17 18 19 20 21 22 23 Fri 05-Feb-88 10:02 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]'''''2am d JHPN  MNO CHANGE!+NDQuestion 1The Solution Designer ScreenPT R U E o r F A L S E#++The worksheet can be viewed++a window at a time.++ Correct. This statement is true. Since the worksheet is so large, it can be viewed only a windowat a time.P000000042am c P Gintro>whatis>i.1"Gintro>whatis>i.2;Gintro>whatis>i.3TGintro>whatis>i.4mGintro>whatis>i.5Gintro>whatis>i.6Gintro>whatis>i.7Gintro>whatis>i.8Gintro>whatis>i.9Gintro>whatis>i.10Gintro>whatis>i.11Gintro>whatis>i.128Gintro>whatis>i.13RGintro>whatis>i.14lNIntro>Menu2am fzE  JHPN   NO CHANGE!+N  @  MNO CHANGE!_N What n Designer        p/  <NO CHANGE!NN\ What n Designer S2am _e JHPN  >NO CHANGE!+_Na1 READY    a b c d e f g h i1 2 3 4 5 (6 7 The worksheet is a grid of cells. 8 9 A cell is formed by the intersection10 11 of a column and a row.12 13 (14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] Table  Calc  Graph '-+!+  ;NO CHANGE!ONa1 READY    a b c d . so sp sq sr1 2 +3 4 Columns have letter names froma to sr.5 6 +7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph '-+!+2am Oe JHPN   ONO CHANGE!+@Na1 READY    a b c d . so sp sq sr1 2 +3 4 Columns have letter names froma to sr.5 6 +7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph '-+!+E k  ;xNO CHANGE!ONa1 READY    a b c d . so sp sq sr1 2 +3 4 Columns have letter names froma to sr.5 6 +7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph '-+!+192.8187%81888189819081918192Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph '-**2am ce JHPN  NO CHANGE!+4Na1 READY    a b c d . so sp sq sr1 2 3 4 5 6 7 8 9 10 11 12 13 14%.Rows have number names from 1 to 8192.8187%81888189819081918192Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph '-**_ lNO CHANGE!~\Na1 READY    a b c d . so sp sq sr1 2 3 4 5 6 7 8 9 10 11 12 13 14%.Rows have number names from 1 to 8192.8187%81888189819081918192Thu04-Feb-884:26PM Macro  Edit  Name A2am (e JHPN   NO CHANGE!+(Na1 READY    a b c d e f g h i1 2 3 4 5 6 7 8 9 The worksheet consists of10 11 512 columns and 8192 rows.12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]F 2am Le JHPN  8NO CHANGE!+LNa1READY a b c d e f g h i1234567)89As you can see, the entire worksheet1011cannot be displayed at any one time.1213The worksheet is displayed one window1415at a time.1617)181920212223 Thu 04-Feb-88 4:26 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am e JHPN  NO CHANGE!+Na1READY a b c d e f g h i123456*78Initially, the window displays the910columns and rows of the upper left1112corner of the worksheet.131415To view cells outside the window, move1617the cell pointer to the desired cell.1819*20212223 Thu 04-Feb-88 4:26 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am *eF  JHPN   NO CHANGE!+*Na1READY a b c d e f g h i12345/67You can move the cell pointer one cell at a89time by using one of the Arrow keys:1011Left, Right, Up, or Down.1213/14151617181920212223 Thu 04-Feb-88 4:26 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am me JHPN  NO CHANGE!+mNa1READY a b c d e f g h i1234567/89Or you can move the cell pointer one window10 11at a time. This is called scrolling.1213Scrolling is extremely useful when working1415with very large worksheets.1617/181920212223 Thu 04-Feb-88 4:26 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] 2am dp JHPN   NO CHANGE!+Naa1READY a b c d e f g h i1234567+89You can also split the worksheet window10 11into two or more windows.1213+14151617181920212223 Thu 04-Feb-88 4:26 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]G 2am +e JHPN  NO CHANGE!++Na12 READY a b c d e f g h i2 3 4 5 66 7 The worksheet window can be split horizontally .8 9 610 11 12  a b c d e f g h i12 13 14 15 16 17 18 19 20 21 22 Wed 23-Mar-88 9:38 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T]2am eq JHPN   FNO CHANGE!+Nd12 READY a b c d e f g h 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 . or10 10 11 11  vertically.12& 12 13 13 14 14 15 15 16 16 17 17 18 18 19 19 20 20 21 21 22 22 23 23 24& 24 Wed 23-Mar-88 9:39 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am cf JHPN  ONO CHANGE!+cNRd12 READY a b c d e f g h 2 2 3 3 4 4 5 5 6 6 7 7 8 8 To move the cursor from9 9 10 10 window to window, you 11 11 12& 12 would press the Window13 13 14 14 (F6) function key.15 15 16 16 17 17 18 18 19 19 20 20 21 21 22 G 22 23 23 24& 24 Wed 23-Mar-88 9:39 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  2am "e JHPN  BNO CHANGE!+"Nd12 READY a b c d e f g h i2 3 4 5 6 7 8 9 10 11 12& 13 14 15 16 17 And you can return to18 19 one window at any time.20 21 22 23 24 Wed 23-Mar-88 9:39 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T bs  Go To  Window Query Table  Calc  Graph '-** ONO CHANGE!cNa1 READY    a b c d . so sp sq sr1 2 3 4 5 6 7 8 9 10 11 12 13 14%.Rows have number names from 1 to 8192.8187%81888189819081918192Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph '-**2am e- JHPN   +NO CHANGE!+Na1 $READY    a b c d . so sp sq sr1 2 3 4 5 6 7 The cell reference, or cell address,8 9 consists of the column letter followed10 11 by the row number, for example, a1.12 13 *14.818781888189819081918192Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go ToH   Window Query Table  Calc  Graph '-*******2am &f JHPN   ,NO CHANGE!+&Nga1 MENU WorksheetRange Copy Move File Print Graph Data Advanced Quit  Global,Insert, Delete, Column-Width, Erase, Titles, Window, Status   b c d e f g   h i1 2 3 4 5 36 7 The third line displays additional menu choices8 9 of the highlighted command, .10 11 312 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph K G833333P2am eq JHPN  NO CHANGE!+N0a1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Move one or more cellsA a  b c d e f g h i1 E 2 E 3 E 4 E 5 4 6  7 . or a description of the highlighted command. 8  9 For example, this is a description of the Move 10  11 command. 12  13 4 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Thu 04-Feb-88 4:28 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph K4 OC4444444P2am f+H  JHPN   NO CHANGE!+NKK=To perform any Solution Designer command or function,press the Return key.For those of you who are experienced Multiplan or Extended Multiplan users, you know that to performa command, you would press the Go key.Well, don't worry about having to break old habits.Solution Designer lets you use either Return or Goto perform a command or function.Throughout this tutorial, however,you will be using Return rather than Go.=KK=============2=!======22am Ae JHPN  NO CHANGE!+ANyTheSolutionDesignerCommandMenu5To perform a command or function,presseithertheReturnkeyortheYouhavereachedtheGokey.endofthislesson.Wesuggestyouproceedtothenextlesson, How To Get Help in Solution Designer.PressNextPagetoreturntotheIntromenu.555   5555555555555555555555552am #f JHPN  NO CHANGE!+#NqSE S O L U T I O N D E S I G N E R M A I N M E N U F1-HowToHow to take this course F2-IntroIntroduction to Solution Designer  F3-UsingCreating and Modifying a Worksheet F4-CalcPerforming Calculations in Your Worksheet F5-FormatFormatting Your Worksheet F6 - Print Printing Your Worksheet F7-GraphsIntroduction to Graphs F8-AdvancGeneral Overview of Advanced Topics Press FINISH to Quit. E!DDI 2am c P Gintro>whatis>i.1"Gintro>whatis>i.2;Gintro>whatis>i.3TGintro>whatis>i.4mGintro>whatis>i.5Gintro>whatis>i.6Gintro>whatis>i.7Gintro>whatis>i.8Gintro>whatis>i.9Gintro>whatis>i.10Gintro>whatis>i.11Gintro>whatis>i.128Gintro>whatis>i.13RGintro>whatis>i.14lGintro>whatis>rev.1Gintro>whatis>rev.2Gintro>whatis>rev.3NIntro>Menu2am &c P GIntro>Screen>FIB1.a002(&LIntro>Screen>FIB1.common.path2am lf JHPN  ONO CHANGE!+'Na1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Retrieve, Save, Combine, Xtract, Import0 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 Fri 05-Feb-88 10:02 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]R _NO CHANGE!qlNa1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Retrieve, Save, Combine, Xtract, Import0 a b  c d e f g h i1 2 3 4 5 Select the Copy command.6 7 8 9 %10 11 There are two steps involved:12 13 14 FirsI t, use the Left Arrow15 16 17 key to move the highlight to18 19 the Copy command.20 21 %22 23 Fri 05-Feb-88 10:02 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 Move one or more cellsA 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 Fri 05-Feb-88 10:04 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]+ >8 NO CHANGE!J NLa1 MENU Worksheet Range Copy t Graph Data Advanced Quit Copy one or more cells  / a b c  d  e f g h i1 2 3 4 5 The Copy command is6 7 highlighted and described.8 9 10 11 12 13 14 .15 16 Then, pressReturnto select Copy.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  ] [ 3h NO CHANGE!z 0Na1 POINTEnter range to copy FROM: a1..a1 a b c d e f g h i1 2 '3 4 The Copy command prompt displays.5 6 '7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Fri 05-Feb-88 10:08 AM Macro  Edit  Name Abs  Go To  Window Query Table   Calc  Graph ]''' 3NO CHANGE!BNa1 POINTEnter range to copy FROM: a1..a1 a b c d  e f g h i1 2 3 4 The Copy command prompt displays.5 6 '7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22  23 Fri 05-Feb-88 10:08 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]'''  3NO CHANGE!*Na1 POINTEnter range to copy FROM: a1..a1 a b c d  e f g h i1 2 3 4 The Copy command prompt displays.5 6 (You'll learn how to use Copy7 8 later on.)9 10 '11 12 13 14 15 16 17 18 19 20 21 22 23 Fri 05-Feb-88 10:08 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]''''''' NO CHANGE!7NWa1 POINTEnter range to copy FROM: a1..a1 a b c d e f g h i1 2 '3 4 The Copy command prompt displays.5 6 (You'll learn how to use Copy7 8 later on.)9 10 J '11 12 713 14 For now, I want you to cancel this Copy command.15 16 If you forgot how to do this, press Help.17 18 719 20 21 22 23 Fri 05-Feb-88 10:08 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ])''''''')000 4&NO CHANGE!81N5a1 POINTEnter range to copy FROM: a1 a b c d e f g h i1 2 3 4 /5 6 Notice that the Copy prompt did not go away7 8 entirely. For some commands, such as Copy,9 10 you need to press Cancel more than once.11 12 /13 14 15 16 Press Cancel once more.17 18 19 20 21 22 23 Fri 05-Feb-88 10:09 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]5    i +vNO CHANGE!N]a1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Copy one or more cells 0 a b c d  e f g h i1 2 3 4 5 6 The main menu is redisplayed.7 8 !9 10 11 12 113 14 Now let's go back to the Copy command prompt. 15 16 117 18 19 20 Typec.21 22 23 Fri 05-Feb-88 10:05 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]!!!  NO CHANGE!NRa1 POINTEnter range to copy FROM: a1..a1 a b c d e f g h i1 2 3 4 5 86 7 To cancel this command, you had to press Cancel8 9 twice. Well, there's another way to cancel a10 11 command: Use Code Cancel.12 13 814 15 (16 17 18 Try it. PressCode Cancel.19 20 21 (22 23 Fri 05-Feb-88 10:08 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 cells 0 a b c d  e f g h i1 2 3 4 5 6  Very good!7 8 The main command menu is redisplayed.9 10 )11 12 13 14 Press Next Page15 16 to Continue17 18 19 20 21 22 23 Fri 05-Feb-88 10:05 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph :&6)))))J 2am fk JHPN  3NO CHANGE!+N0BALANCE SHEETJCHECKING ACCOUNT LEDGERBSTOCK PORTFOLIOePurchaseCurrentMarketDollarPercentSymbolShares Price PriceValue Gain Gain0:00W10010.0013.001300.00300.0030.00%0X4022.5525.0010.0098.0010.86%Y2005.007.501500.00500.0050.00%Z1010.005.0050.00-50.00-50.00%BTotal Liabilities:$135(Owner's Equity:Capital$1032BUDGET SHEETJanuary2  O3222222   3NO CHANGE!N0BALANCE SHEETJCHECKING ACCOUNT LEDGERBSTOCK PORTFOLIOePurchaseCurrentMarketDollarPercentSymbolShares Price PriceValue Gain Gain0:00W10010.0013.001300.00300.0030.00%0X4022.5525.0010.0098.0010.86%Y2005.007.501500.00500.0050.00%Z1010.005.0050.00-50.00-50.00%B2BUDGET SHEETOJanuaryTAKE HOME1300EXPENSESRent300Food160Car Loan1752  O32    NO CHANGE! N0BALANCE SHEETJCHECKING ACCOUNT LEDGERBSTOCK PORTFOLIOePurchaseCurrentMarketDollarPercentSymbolShares Price PriceValue Gain Gain0:00W10010.0013.001300.00300.0030.00%0X4022.5525.0010.0098.0010.86%2050.00%BUDGET SHEET0-50.02am dM JHPN  ONO CHANGE!+N'! %NO CHANGE!NWhat Is Solution Designer?5Solution Designer is an electronicworksheet -- a large grid of cellsthat can contain text, numbers, orformulas.'!K Solution Designer combines the featuresof two popular spreadsheets: Lotus 1-2-3 and Multiplan.5" r'2am d= JHPN  >NO CHANGE!+NWhat Is Solution Designer?5Solution Designer features:On-screen command menusOver 100 built-in functionsOnline Help'Graphing capability!Database capabilityMacro capability Solution Designer automatically performscalculations for you.52am e% JHPN  NO CHANGE!+NWhatIsSolutionDesigner?5Solution Designer features:On-screencommandmenusYouhavereachedtheOver100built-infunctionsendofthislesson.OnlineHelpWesuggestyouproceedGraphingcapabilitytothenextlesson,DatabasecapabilityHow To Start UpMacrocapabilitySolution Designer.PressNextPagetoreturnSolutionDesignerautomaticallyperformstotheIntromenu.calculationsforyou. 555 5555555555555555555555552am Uf JHPN   ONO CHANGE!+Na1 READYO  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 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] NO CHANGE!UNaa1 READYO K  a b c d e f g h i1 2 -3 4 All worksheet commands are available5 6 from the Solution Designer Commands Menu.7 8 -9 $10 11 To display the commands menu,12 13 14 type/,15 16 17 the slash key.18 19 20 Type this key right now.21 22 $23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]            ; OHNO CHANGE!ZGNa1 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 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-88 4:28 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] M NO CHANGE! ANoa1 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 Good. Notice that your worksheet4 5 is now in MENU mode instead of6 7 Ready mode.8 9 %10 11 12 13 14 15 16 17 18 Press Next Page to Continue19 20 21 22 23 Thu04-Feb-88 4:28 PM; Macro  Edit  Name  Abs  Go To  Window Query Table  Calc  Graph ]%%%%%%%!!!!!2am f JHPN  '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 i1 2 3 4 5 6 67 8 Here's a tip:9 10 A good way to remember commands is to11 12 remember the keystroke combination, such as /wgfc,13 14 that gets you to the desired command.15 16 617 18 19 20 21 22 23 Thu04-Feb-884:28PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]L 2am c P2am d JHPN  )NO CHANGE!+N\- Question -How to Start Up Solution DesignerPF I L L I N T H E B L A N KNNNN 9 There are three ways to invoke Solution Designer.  Name one of them: ~~ 9 NNNNN(Type your answer and press GO when ready)!Pe2K*2am (e JHPN   NO CHANGE!+(Na1 READY    a b c d e f g h i1 2 3 4 5 6 7 8 9 The worksheet consists of10 11 512 columns and 8192 rows.12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am OeL  JHPN   ONO CHANGE!+@Na1 READY    a b c d . so sp sq sr1 2 +3 4 Columns have letter names froma to sr.5 6 +7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph '-+!+k  ;xNO CHANGE!ONa1 READY    a b c d . so sp sq sr1 2 +3 4 Columns have letter names froma to sr.5 6 +7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph '-+!+2am ce JHPN  NO CHANGE!+4Na1 READY    a b c d . so sp sq sr1 2 3 4 5 6 7 8 9 10 11 12 13 14%.Rows have number names from 1 to 8192.8187%81888189819081918192Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph '-**_ lNO CHANGE!~\Na1 READY    a b c d . so sp sq sr1 2 3 4 5 6 7 8 9 10 11 12 13 14%.Rows have number names from 1 to 8192.8187%81888189819081918192Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph '-** ONO CHANGE!cNa1 READY    a b c d . so sp sq sr1 2 3 4 5 6 7 8 9 10 11 12 13 14%.Rows have number names from 1 to 8192.8187%81888189819081918192Thu04-Feb-884:26PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph '-**