IMD 1.18: 15/05/2012 10:16:07 solution designer tutorial sd-7 7 of 7 71-03155-07  SD-7monetcCofg;!F!ysQSD: 9|M^2am }e JHPN  ONO CHANGE!+N@a1 READY a b c d e f g h 1 XYZ Company2 Employee Listing3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Fri 04-Mar-88 11:44 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] 6NO CHANGE! }Na1 READY a b c d e f g h 1 XYZ Company2 Employee Listing3 4 SortNo EmpNo LastName FirstName Area Phone MailStop5 6 7 8 9 310 11 Adatabaseconsistsoftwosections:12 13 1)RecordHeadings14 15 316 17 18 19 20 21 22 23 Fri 04-Mar-88 11:44 AM Macro  Edit  Name Abs  Go To  Window Query Table   Calc  Graph ]K2am (g JHPN   NO CHANGE!+Na1 READY a b c d e f g h 1 XYZ Company2 Employee Listing3 4 SortNo EmpNo LastName FirstName Area Phone MailStop5 6 7 8 9 310 11 Adatabaseconsistsoftwosections:12 13 1)RecordHeadings,and14 15 2)RecordInformation16 17 318 19 20 21 22 23 Fri 04-Mar-88 11:44 AM Macro  Ed it  Name Abs  Go To  Window Query Table  Calc  Graph ] ONO CHANGE!?Na1 READY a b c d e f g h 1 XYZ Company2 Employee Listing3 4 SortNo EmpNo LastName FirstName Area Phone MailStop5 514 Smith Michelle408 4341234 156 230 Dold Cathy 215 3785500 PA7 164 Smith Ron 404 2632125 GA8 748 Bennett Charles 214 7552288 TX9 310 11 Adatabaseconsistsoftwosections:12 13 1)RecordHeadings,and14 15 2)RecordInformation16  17 318 19 20 21 22 23 Fri 04-Mar-88 11:44 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]-  :NO CHANGE!L(Na1 READY a b c d e f g h 1 XYZ Company2 Employee Listing3 4 SortNo EmpNo LastName FirstName Area Phone MailStop5 514 Smith Michelle408 4341234 156 230 Dold Cathy 215 3785500 PA7 164 Smith Ron 404 2632125 GA8 748 Bennett Charles 214 7552288 TX9 310 11 Adatabaseconsistsoftwosections:12 13 1)RecordHeadings,and14 15 2)RecordInformation16 17 318 529 Davenport Alex 312 7931851 IL19 342 Young Russ 408 4341234 1520 231 O'Connor Kacie 714 27890 CA21 475 Monaghan Ed 513 3664667 OH22 648 Crosby Sue214 7552288 TX23 624 Clark Tom201 3520990 NJFri 04-Mar-88 11:44 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]'2am go JHPN  ONO CHANGE!+N`a1 READY a b c d e f g h 1 XYZ Company2 Employee Listing3 4 SortNo EmpNo LastName FirstName Area Phone MailStop5 514 Smith Michelle408 4341234 156 230 Dold Cathy 215 3785500 PA7 164 Smith Ron 404 2632125 GA8 748 Bennett Charles 214 7552288 TX9 265 Johnson Clarence313 5610300 MI10 438 Green Larry 714 27890 CA11 826 Gurewitz Carla 808 4341234 HI12 194 Rhodes John 919 9512366 NC13 871 Speck Joe 513 3664667 OH14 814 Johnson Corinne 201 3520990 NJ15 161 White Steve 714 27890 CA16 581 Carter Joe 313 5610300 MI17 434 Davis Arnold 305 3932848 FL18 529 Davenport Alex 312 7931851 IL19 342 Young Russ 408 4341234 1520 231 O'Connor Kacie 714 27890 CA21 475 Monaghan Ed 513 3664667 OH22 648 Crosby Sue214 755228 8 TX23 624 Clark Tom201 3520990 NJFri 04-Mar-88 11:44 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]! .NO CHANGE!@Na1 READY a b c d e f g h 1 XYZ Company2 Employee Listing3 4 SortNo EmpNo LastName FirstName Area Phone MailStop5 514 Smith  Michelle408 4341234 156 230 Dold Cathy 215 3785500 PA7 0125 GA8 288 TX9 There's nothing special that you have to do 300 MI10 0 CA11 to enter the headings or record information.234 HI12 366 NC13 Enter labels and values in the same way that667 OH14 990 NJ15 you did with your expense report.0 CA16 300 MI17 0848 FL18 529 Davenport Alex 312 7931851 IL19 342 Young Russ 408 4341234 1520 231 O'Connor Kacie 714 27890 CA21 475 Monaghan Ed 513 3664667 OH22 648 Crosby Sue214 7552288 TX23 624 Clark Tom201 3520990 NJFri 04-Mar-88 11:44 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]&2am `g JHPN  #NO CHANGE!+`Na1 READY a b c d e f g h 1 XYZ Company2 Employee Listing3 4 SortNo EmpNo LastName FirstName Area Phone MailStop5 514 Smith Michelle408 4341234 156 230 Dold Cathy 215 3785500 PA7 1*25 GA8 788 TX9 2It is a good idea, though, to increase00 MI10 400 CA11 8the width of columns if necessary,34 HI12 166 NC13 8such as the last name and first name67 OH14 890 NJ15 1columns. By doing this, you can00 CA16 500 MI17 4display longer names and make the48 FL18 551 IL19 3database more readable.34 1520 200 CA21 4*67 OH22 648 Crosby Sue214 7552288 TX23 624 Clark Tom201 3520990 NJFri 04-Mar-88 11:44 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am g$  JHPN  ;NO CHANGE!+Na1 READY a b c d e f g h 1 XYZ Company2 Employee Listing3 4 SortNo EmpNo LastName FirstName Area Phone MailStop5 514 Smith Michelle408 4341234 156 230 Dold Cathy 215 3785500 PA7 '2632125 GA8 7552288 TX9 Another good idea is to number5610300 MI10 27890 CA11 your records in the order they4341234 HI12 9512366 NC13 were entered. The SortNo column3664667 OH14 3520990 NJ15 has been included for this purpose.27890 CA16 5610300 MI17 '3932848 FL18 529 Davenport Alex 312 7931851 IL19 342 Young Russ 408 4341234 1520 231 O'Connor Kacie 714 27890 CA21 475 Monaghan Ed 513 3664667 OH22 648 Crosby Sue214 7552288 TX23 624 Clark Tom201 3520990 NJFri 04-Mar-88 11:44 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am g JHPN  'NO CHANGE!+Nth8 800 POINTEnter Bin range: h5..h8 O 9 b c  d h i j k 1 XYZ Company 1$ 2 E 2$ 3 3 Freq. Distrib. 4 EmpNo Then, define the bin4 (Bin range) 5 514 S 200 6 342 Yrange.6 400 7 438 G7 600 8 231 O8 800 9 161 White Steve 9$ 10 434 Davis Arnold 10# 11 164 Smith Ron 11# 12 826 Gurewitz Carla 12# 13 529 Davenport Alex 13# 14 316 Gee Ann 14# 15 581 Carter Joe 15# 16 265 Johnson Clarence 16# 17 194 Rhodes John 17# 18 412 West Jayne 18# 19 624 Clark Tom 19# 20 814 Johnson Corinne 20# 21 475 Monaghan Ed 21# 22 871 Speck Joe 22# 23 230 Dold Cathy 23# Sun 06-Mar-88 7:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T    2am g4  JHPN  NO CHANGE!+Nh5 200 READY b c d h i j k 1 XYZ Company 1$ 2 Employee Listing 2$ 3* 3 Freq. Distrib. 4 EmpNo LastName FirstName 4 (Bin range) 5 514 Smith Michelle 5 200 3 6 342 Young Russ 6 400 5 7 438 Green Larry 7 600 7 8 231 O'Connor Kacie 8 800 3 9 161 White Steve 9 3 10 434 Davis Arnold 10  11 164 Sm+  12 826 Gu  13 529 DaAfter pressing Return, the frequency  14 316 Ge 15 581 Cadistributions are calculated. The 16 265 Jo 17 194 Rhlast number refers to all employees 18 412 We 19 624 Clwith employee numbers greater than 800. 20 814 Jo 21 475 Mo+ 22 871 Speck Joe 22# 23 230 Dold Cathy 23# Sun 06-Mar-88 7:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T +++++++++2am g  JHPN   NO CHANGE!+Nvh8 800 POINTEnter Bin range: h5..h8 O 9 b c  d h i j k 1 XYZ Company 1$ 2 E $ 3  Freq. Distrib. 4 EmpNo Then, a prompt displays (Bin range) 5 514 S 200 6 342 Yto define the bin range. 400 7 438 G 600 8 231 O 800 9 161 White Steve 9$ 10 434 Davis Arnold 10# 11 164 Smith Ron 11# 12 826 Gurewitz Carla 12# 13 529 Davenport Alex 13# 14 316 Gee Ann 14# 15 581 Carter Joe 15# 16 265 Johnson Clarence 16# 17 194 Rhodes John 17# 18 412 West Jayne 18# 19 624 Clark Tom 19# 20 814 Johnson Corinne 20# 21 475 Monaghan Ed 21# 22 871 Speck Joe 22# 23 230 Dold Cathy 23# Sun 06-Mar-88 7:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T    2am g  JHPN  9NO CHANGE!+Nh5 200 READY b c d h i j k 1 XYZ Company 1$ 2 Employee Listing 2$ 3* 3 Freq. Distrib. 4 EmpNo LastName FirstName 4 (Bin range) 5 514 Smith Michelle 5 200 3 6 342 Young Russ 6 400 5 7 438 Green Larry 7 600 7 8 231 O'Connor Kacie 8 800 3 9 161 White Steve 9 3 10 434 Davis Arnold 10  11 164 Sm+  12 826 Gu  13 529 DaAfter pressing Return, the frequency  14 316 Ge 15 581 Cadistributions are calculated. The 16 265 Jo 17 194 Rhlast number refers to all employees 18 412 We 19 624 Clwith employee numbers greater than 800. 20 814 Jo 21 475 Mo+ 22 871 Speck Joe 22# 23 230 Dold Cathy 23# Sun 06-Mar-88 7:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T +++++++++ZCarla.font Gadvanc>g>qseg1# advanc>g>FIB3 JHPN   NO CHANGE!+NIntroduction to DatabasesP_That's incorrect.To remove all database records that match the criteria,use the Data/Query/Delete command.hPp2am #e JHPN  NO CHANGE!+#NjIntroductiontoMacros5Amacrocanbeusedonlywiththeworksheetforwhichitiscreated.Youhavereachedtheendofthislesson.Wesuggestyouproceedtothenextlesson,Other Advanced SolutionDesigner Commands.PressNextPagetoreturntotheAdvancmenu. 5555555555555555555555555555 2am e JHPN   NO CHANGE!+NNOtherAdvancedSolutionDesignerCommandsP Acme Widget Company BudgetSalesResearchManufacturingTotal Budget SalesResearchManufacturingDivisionDivision DivisionBudget$450Budget$800Budget$10P NO CHANGE!NMOtherAdvancedSolutionDesignerCommandsP AcmeWidgetCompanyBudgetSalesResearchManufacturingTotal Budget SalesResearchManufacturingDivision$450Division DivisionBudget$450Budget$800Budget$10Pq ~NO CHANGE!NWOtherAdvancedSolutionDesignerCommandsP AcmeWidgetCompanyBudgetSales$450ResearchManufacturingTotal Budget$450 SalesResearchManufacturingDivisionDivision DivisionBudget$450Budget$800Budget$10P1  > NO CHANGE!P NQOtherAdvancedSolutionDesignerCommandsP AcmeWidgetCompanyBudgetSales$450ResearchManufacturingTotal Budget$450  SalesResearchManufacturingDivisionDivision DivisionBudget$450Budget$800Budget$10P  NO CHANGE! NSOtherAdvancedSolutionDesignerCommandsP AcmeWidgetCompanyBudgetSales$450ResearchManufacturingTotal Budget$450  SalesResearchManufacturingDivisionDivision Division$800Budget$450Budget$800Budget$10P (NO CHANGE!NXOtherAdvancedSolutionDesignerCommandsP  AcmeWidgetCompanyBudgetSales$450Research $800 ManufacturingTotal Budget$450  SalesResearchManufacturingDivisionDivision DivisionBudget$450Budget$800Budget$10P` mNO CHANGE!NXOtherAdvancedSolutionDesignerCommandsP AcmeWidgetCompanyBudgetSales$450Research$800ManufacturingTotal Budget$1250  SalesResearchManufacturingDivisionDivision DivisionBudget$450Budget$800Budget$10P!  .NO CHANGE!@NLOtherAdvancedSolutionDesignerCommandsP AcmeWidgetCompanyBudgetSales$450Research$800ManufacturingTotal Budget$1250  SalesResearchManufacturingDivisionDivision DivisionBudget$450Budget$800Budget$10P NO CHANGE!NOOtherAdvancedSolutionDesignerCommandsP AcmeWidgetCompanyBudgetSales$450Research$800ManufacturingTotal Budget$1250  SalesResearchManufacturingDivisionDivision Division$10Budget$450Budget$800Budget$10P  *NO CHANGE!NTOtherAdvancedSolutionDesignerCommandsP AcmeWidgetCompanyBudgetSales$450Research$800Manufacturing$10 Total Budget$1250  SalesResearchManufacturingDivisionDivision DivisionBudget$450Budget$800Budget$10PC PNO CHANGE!bkN)OtherAdvancedSolutionDesignerCommandsP AcmeWidgetCompanyBudgetSales$450Research$800Manufacturing$10Total Budget$2250 % SalesResearchManufacturingDivisionDivision DivisionBudget$450Budget$800Budget$10P 2am Mf JHPN  NO CHANGE!+MNOtherAdvancedSolutionDesignerCommandsPDEPENDENT WORKSHEET AcmeWidgetCompanyBudgetThe company worksheet isSales$450dependent on the divisionResearch$800Manufacturing$10worksheets for information.Total Budget$2250  SalesResearchManufacturingDivisionDivision DivisionBudget$450Budget$800Budget$10P 2am f JHPN  NO CHANGE!+NOtherAdvancedSolutionDesignerCommandsPDEPENDENT WORKSHEET AcmeWidgetCompanyBudgetThe division worksheetsSales$450support the dependentResearch$800Manufacturing$10worksheet by supplyingTotal Budget$2250 it with information. SUPPORTING WORKSHEETS SalesResearchManufacturingDivisionDivision DivisionBudget$450Budget$800Budget$10P 2am ~d JHPN   ONO CHANGE!+N  @ 'MNO CHANGE!_~NOtherAdvancedSolutionDesignerCommandsPAdvanced/Move%The Advanced/Move command movesmultiple rows and columns at a time.dYounowhaveachoiceoftwotypesofMovecommands:MoveAdvanced/MoveP $$$d   2am e^ JHPN  &NO CHANGE!+N6h10 POINTEnter range to move FROM: f6..f10 Enter range to move TO: h6..h10d a b c d e f g h i1O 2O 3O 4 * 5 * 6  10 7  20 8  30 9  40 10  50 11 * 12 * 13 8 14 8 15 When using the Move command, you define the range to 16 8 17 move FROM and a range of the same size to move TO. 18 8 19 8 20N 21N 22N 23N Thu 03-Mar-88 12:53 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T     2am e> JHPN  NO CHANGE!+N/a14POINTEnter range of rows to move FROM: a9..a10 Move TO : a14 a b c d e f g h i123456789 JanFebMarAprMayJunJulAug10 SepOctNovDec11121341415 When using the Advanced/Move command, you define16 17 the range of rows (or columns) to move FROM, and18 19 the row (or column) to move TO.20 21 422 23 Thu 03-Mar-88 12:56 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am d9 JHPN  3NO CHANGE!+NAOtherAdvancedSolutionDesignerCommandsPAdvanced/WidthlThe Advanced/Width command sets the column widthfor multiple columns or rows.Younowhaveachoiceofthreecolumn widthcommands:Worksheet/Global/Column-WidthWorksheet/Column-WidthAdvanced/WidthP000   2am e JHPN  0NO CHANGE!+Na1 READY a b c . sp sq sr1 2 3 4 5 6 7 58 9 The Worksheet/Global/Column-Width command10 11 sets the column width for the entire spreadsheet.12 13 514 15 16 .818781888189819081918192Wed 02-Mar-88 11:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph )%,c2am e' JHPN  NO CHANGE!+Na1READY a b c d e f g h 1 2 3 4 5 6 7 +8 9 TheWorksheet/Column-Widthcommandsets10 11 thecolumn-widthforasinglecolumn.12 13 +14 15 16 17 18 19 20 21 22 23 Wed 02-Mar-88 11:31 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 h1 2 3 4 5 6 The Advanced/Column-Width7 8 command sets the column9 10  width for multiple11 12 columns.13 14 15 16 17 18 19 20 21 22 23 Wed 02-Mar-88 11:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph _ ''''''''''''''''''''''''2am d! JHPN  )NO CHANGE!+Ng- Question 1 -Introduction to DatabasesPF I L L I N T H E B L A N KNNNN;  To remove all database records that match the  criteria, use theData/Query/ ~~ command.  ; NNNNN(Type your answer and press GO when ready)Pf 3J*2am d JHPN  ONO CHANGE!+Ne- Question 1 -Introduction to DatabasesPFILLINTHEBLANKNNNN 8 To ~ ~ a database means to find records in the database that match one or more criteria. 8 NNNNN(Type your answer and press GO when ready)P2 1L* JHPN  ANO CHANGE!+pNHIntroduction to DatabasesP4Recordheadings,alsocalledfields, play animportantrolewhenyouwant to use,orquery,thedatabase.However, we'll talk about that later.First let's talk about how to create a database.4>P^+2am h JHPN  %NO CHANGE!+NOa1 MENU Fill Table Sort Query Distribution Matrix Regression Parse Fil a range with values:  a b c d e f g h 1  XYZ Company- 2 Employee Listing* 3O 4 SortNo EmpNo LastName FirstName Area Phone MailStop 5 514 Smith Michelle 408 4341234 15 6 230 Dold Cathy 215 3785500 PA 7 164%32125 GA 8 74852288 TX 9 265To number your records, you would10300 MI 10 43889 0 CA 11 826usethe Data/Fill command.41234 HI 12 19412366 NC 13 871%64667 OH 14 814 Johnson Corinne 201 3520990 NJ 15 161 White Steve 714 27890 CA 16 581 Carter Joe 313 5610300 MI 17 434 Davis Arnold 305 3932848 FL 18 529 Davenport Alex 312 7931851 IL 19 342 Young Russ 408 4341234 15 20 231 O'Connor Kacie 714 27890 CA 21 475 Monaghan Ed 513 3664667 OH 22 648 Crosby Sue 214 7552288 TX 23 624 Clark Tom 201 3520990 NJ Fri 04-Mar-88 2:32 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph O %%%%%2am gr JHPN  NO CHANGE!+N a25 POINTEnter Fill range: a5..a25 O 3 a b c  d e f g h 3" , 4 SortNo EmpNo LastName  FirstName Area Phone MailStop 5 514 Smith Michelle 408 4341234 15 6 230 Dold Cathy 215 3785500 PA 7 2125 GA 8 2288 TX 9 The first thing to do is define the0300 MI 10 90 CA 11 range where numbers are to be entered.1234 HI 12 2366 NC 13 The range defined here is in column a,4667 OH 14 0990 NJ 15 under the field, SortNo, and includes90 CA 16 0300 MI 17 all records.2848 FL 18 1851 IL 19 *1234 15 20 231 O'Connor Kacie 714 27890 CA 21 475 Monaghan Ed 513 3664667 OH 22 648 Crosby Sue 214 7552288 TX 23 624 Clark Tom 201 3520990 NJ 24 316 Gee Ann 312 7931851 IL 25 412 West Jayne 919 9512366 NC Fri 04-Mar-88 2:39 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T    * * * * * * * * * * *  #     2am _h JHPN  NO CHANGE!+_Na1 .EDIT Start:1  After defining the fill range, specify the a  g h 1 number to start with, or the start value. 2  3 . 4 SortNo EmpNo LastName FirstName Area Phone MailStop 5 514 Smith Michelle 408 4341234 15 6 230 Dold Cathy 215 3785500 PA 7 164 Smith Ron 404 2632125 GA 8 748 Bennett Charles 214 7552288 TX 9 265 Johnson Clarence 313 5 610300 MI 10 438 Green Larry 714 27890 CA 11 826 Gurewitz Carla 808 4341234 HI 12 194 Rhodes John 919 9512366 NC 13 871 Speck Joe 513 3664667 OH 14 814 Johnson Corinne 201 3520990 NJ 15 161 White Steve  714 27890 CA 16 581 Carter Joe 313 5610300 MI 17 434 Davis Arnold 305 3932848 FL 18 529 Davenport Alex 312 7931851 IL 19 342 Young Russ 408 4341234 15 20 231 O'Connor Kacie 714 27890 CA 21 475 Monaghan Ed 513 3664667 OH 22 648 Crosby Sue 214 7552288 TX 23 624 Clark Tom 201 3520990 NJ Fri 04-Mar-88 2:37 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ....%2am Rh JHPN  NO CHANGE!+RNa1 !EDIT Step:1 ' Next, specify the number a e f g h 1 increment, or the step value. 2  3 ! 4 SortNo EmpNo LastName FirstName Area Phone MailStop 5 514 Smith Michelle 408 4341234 15 6 230 Dold Cathy 215 3785500 PA 7 164 Smith Ron 404 2632125 GA 8 748 Bennett Charles 214 7552288 TX 9 265 Johnson Clarence 313 5610300 MI 10 438 Green Larry 714 27890 CA 11 826 Gurewitz Carla 808 4341234 HI 12 194 Rhodes John 919 9512366 NC 13 871 Speck Joe 513 3664667 OH 14 814 Johnson Corinne 201 3520990 NJ 15 161 White Steve 714 27890 CA 16 581 Carter Joe 313 5610300 MI 17 434 Davis Arnold 305 3932848 FL 18 529 Davenport Alex 312 7931851 IL 19 342 Young Russ 408 4341234 15 20 231 O'Connor Kacie 714 27890 CA 21 475 Monaghan Ed 513 3664667 OH 22 648 Crosby Sue 214 7552288 TX 23 624 Clark Tom 201 3520990 NJ Fri 04-Mar-88 2:37 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph !!!)!2am Ph JHPN  NO CHANGE!+PNa1 &EDIT Stop:21 ( Finally, specify the last possible a b f g h 1 number, or the stop value. 2  3 & 4 SortNo EmpNo LastName FirstName Area Phone MailStop 5 514 Smith Michelle 408 4341234 15 6 230 Dold Cathy 215 3785500 PA 7 164 Smith Ron 404 2632125 GA 8 748 Bennett Charles 214 7552288 TX 9 265 Johnson Clarence 313 5610300 MI 10  438 Green Larry 714 27890 CA 11 826 Gurewitz Carla 808 4341234 HI 12 194 Rhodes John 919 9512366 NC 13 871 Speck Joe 513 3664667 OH 14 814 Johnson Corinne 201 3520990 NJ 15 161 White Steve 714 27890 CA 16 581 Carter Joe 313 5610300 MI 17 434 Davis Arnold 305 3932848 FL 18 529 Davenport Alex 312 7931851 IL 19 342 Young Russ 408 4341234 15 20 231 O'Connor Kacie 714 27890 CA 21 475 Monaghan Ed 513 3664667 OH 22 648 Crosby Sue 214 7552288 TX 23 624 Clark Tom 201 3520990 NJ Fri 04-Mar-88 2:37 PM: 9Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph &&&" &2am $h JHPN  NO CHANGE!+$Nva5 READY a b c d e f g h 3O 4 SortNo EmpNo LastName FirstName Area Phone MailStop 5 1 514 Smith Michelle 408 4341234 15 6 2 230 Dold Cathy 215 3785500 PA 7 3 164 Smith Ron 404 2632125 GA 8 4 748 Bennett Charles 214 7552288 TX 9 5 (610300 MI 10 6 7890 CA 11 7 AfterpressingReturn,Data/Fill341234 HI 12 8 512366 NC 13 9 entersnumbersinthedefinedrange.664667 OH 14 10 520990 NJ 15 11 (7890 CA 16 12 581 Carter Joe 313 5610300 MI 17 13 434 Davis Arnold 305 3932848 FL 18 14 529 Davenport Alex 312 7931851 IL 19 15 342 Young Russ 408 4341234 15 20 16 231 O'Connor Kacie 714 27890 CA 21 17 475 Monaghan Ed 513 3664667 OH 22 18 648 Crosby Sue 214 7552288 TX 23 19 624 Clark Tom 201 3520990 NJ 24 20 316 Gee Ann 312 7931851 IL 25 21 412 West Jayne 919 9512366 NC Fri 04-Mar-88 2:39 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am g7 JHPN  NO CHANGE!+Na1 READY a b c d e f g h 1 XYZ Company- 2 Employee Listing* 3O 4 SortNo EmpNo LastName FirstName Area Phone MailStop 5 1 514 Smith Michelle 408 4341234 15 6 2 1 7 3 8 4 These numbers identify the original order of 9 5 10 6 information in a database. Once you sort the 11 7 12 8 database, you can return the information to   13 9 14 10 its original order at any time by sorting the 15 11 16 12 database by these numbers. 17 13 18 14 1 19 15 342 Young Russ 408 4341234 15 20 16 231 O'Connor Kacie 714 27890 CA 21 17 475 Monaghan Ed 513 3664667 OH 22 18 648 Crosby Sue 214 7552288 TX 23 19 624 Clark Tom 201 3520990 NJ Fri 04-Mar-88 2:39 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am d JHPN  NO CHANGE!+NW- Question -Introduction to DatabasesPFILLINTHEBLANKNNNN 3 The Data/Query/Find command changes the mode indicator from MENU to ~~ mode. 3 NNNNN(Type your answer and press GO when ready)Pb /N*2am c JHPN   ONO CHANGE!+;N#Introduction to DatabasesPpPpf  :sNO CHANGE!NIntroduction to DatabasesPbVery good!The Data/Query/Find command changes themode indicator from MENU to FIND mode.fPl2am "c P Gadvanc>d>FIB7.a000$"Ladvanc>d>FIB7.common.path 2am c- JHPN   :NO CHANGE!+NIntroduction to DatabasesP[Sorry, that's not right.The Data/Query/Find command changes themode indicator from MENU to FIND mode.fPl2am "c P Gadvanc>d>FIB7.a999$"Ladvanc>d>FIB7.common.path2amch!pPFIND2am c P Gadvanc>d>o.1ZCarla.font1Zsd.fontAGadvanc>d>o.2VGadvanc>d>o.3kGadvanc>d>o.4Gadvanc>d>o.5Gadvanc>d>o.6Gadvanc>d>o.7Gadvanc>d>o.8Gadvanc>d>o.9Gadvanc>d>o.10ZSD.fontZCarla.font"Gadvanc>d>qseg19advanc>d>TF9 2am cC JHPN   /NO CHANGE!+NIntroduction to "What If?" Analysis and Goal SeekingPThat's not right.When using the Advanced/Goal-Seeking command,the target cell contains the goal.4P2am cB JHPN   NO CHANGE!+NIntroduction to "What If?" Analysis and Goal SeekingPThat's correct!When using the Advanced/Goal-Seeking command,the target cell contains your goal.4P2am d2 JHPN  ONO CHANGE!+Nx- Question 1 -Introduction to "What If?" Analysis and Goal SeekingPFILLINTHEBLANKNNNN 9 When using the Advanced/Goal-Seeking command, the target cell contains your ~~ . 9 NNNNN(Type your answer and press GO when ready)4Pe2K*2am e JHPN   ONO CHANGE!+N)Question Introduction to DatabasesP: Course Description Instructor Days Cost Location:TS200Sys AdminGreene5$10DallasMTS300ProgrammingGreene5$10DallasFM300Hdw MaintShaffer10$20SanJoseUCX110UNIX BasicsWest3$500AtlantaC:LHTLook at the database shown above.OIHow many records are there?IPCLF1 - 4F3 - 24EEF2 - 6F4   - None of the above(Select your answer by pressing one of the indicated selections)P+++++ %%%@2am cf JHPN   $NO CHANGE!+NIntroduction to "What If?" Analysis and Goal SeekingPThat's correct!When using the Advanced/Goal-Seeking command,the target cell contains your target,or more specifically, your goal.)4PB*2am f JHPN  NO CHANGE!+ NYIntroduction to DatabasesP: Course Description Instructor Days Cost Location:TS200Sys AdminGreene5$10DallasTS300ProgrammingGreene5$10DallasFM300Hdw MaintShaffer10$20SanJoseCX110UNIX BasicsWest3$500Atlanta:Look at the database shown above.How many records are there?F1 - 4F3 - 24F2 - 6F4 - None of the above Correct! There are 4records in the database.P<<<7777<+++++ 2am !c P Gadvanc>d>mc1.correct&!Ladvanc>d>mc1.common.path  2am !c P Gadvanc>d>mc1.incorrect(!Ladvanc>d>mc1.common.path2am !c P Gadvanc>d>mc1.incorrect(!Ladvanc>d>mc1.common.path2am !c P Gadvanc>d>mc1.incorrect(!Ladvanc>d>mc1.common.path2am ?f JHPN  <NO CHANGE!+?NIntroduction to DatabasesP: Course Description Instructor Days Cost Location:TS200Sys AdminGreene5$10DallasTS300ProgrammingGreene5$10DallasFM300Hdw MaintShaffer10$20SanJoseCX110UNIX BasicsWest3$500Atlanta:Look at the database shown above.How many records are there?F1 - 4F3 - 24  F2 - 6F4 - None of the above0That's incorrect. The correct answer is F1. There are 4 records in the database.0P<<<7777<+++++000002am +c N + F1  F2  F3  F4 2am dE JHPN   ONO CHANGE!+NVQuestion Introduction to DatabasesP@MTo enter a list of sequential numbersUinto your worksheet, useCLHTOF1 - the Data/Sort commandIIF2 - the Data/Fill commandPCF3 - the Data/Distribution commandLEF4 - None of the aboveE(Select your answer by pressing one of the indicated selections)P/////@2am c[ JHPN  "NO CHANGE!+NIntroduction to "What If?" Analysis and Goal SeekingPCorrect.When using the Advanced/Goal-Seeking command,the target cell is the cell that containsyour target, or goal..4P282am ee   JHPN  NNO CHANGE!+eNIntroduction to DatabasesPUTo enter a list of sequential numbersinto your worksheet, useFF1 - the Data/Sort commandThat's correct.F2 - the Data/Fill commandThe Data/FillF3 - the Data/Distribution commandcommand is usedF4 - None of the aboveto enter a listof sequential numbers into yourworksheet.P/////2am !c P Gadvanc>d>MC3.incorrect(!Ladvanc>d>MC3.common.path2am !c P Gadvanc>d>MC3.correct&!Ladvanc>d>MC3.common.path2am !c P Gadvanc>d>MC3.incorrect(!Ladvanc>d>MC3.common.path  2am !c P Gadvanc>d>MC3.incorrect(!Ladvanc>d>MC3.common.path2am 8e JHPN  3NO CHANGE!+8NIntroduction to DatabasesPUTo enter a list of sequential numbersinto your worksheet, usesF1 - the Data/Sort commandF2 - the Data/Fill commandF3 - the Data/Distribution commandF4 - None of the above1That's incorrect. The correct answer is F2.The Data/Fill command is used to enter a list of sequential numbers into your worksheet.1P/////11111112am +c N + F1  F2  F3  F4 2am e   JHPN   ONO CHANGE!+NKQuestion Introduction to DatabasesP: Course Description Instructor Days Cost Location:TS200Sys AdminGreene5$10DallasMTS300ProgrammingGreene5$10DallasFM300Hdw MaintShaffer10$20SanJoseUCX110UNIX BasicsWest3$500AtlantaC:LHTThis database has been sorted.OIWhat field was used as the primary sort key?IPCLF1 - CourseF3 - LocationEEF2 - InstructorF4 - None of the above(Select your answer by pressing one of the indicated selections)P666 6 ---@2am c P Nadvanc>menu2am ^f JHPN   NO CHANGE!+^NIntroduction to DatabasesP: Course Description Instructor Days Cost Location:TS200Sys AdminGreene5$10DallasTS300ProgrammingGreene5$10DallasFM300Hdw MaintShaffer10$20SanJoseCX110UNIX BasicsWest3$500Atlanta:This database has been sorted.What field was used as the primary sort key?F1 - CourseF3 - LocationF2 - InstructorF4 - None of the above>Excellent! The field, Instructor, was used as the primary sort key. Also note that records were sorted in ascending order.CP<      <666 6 $ CCCCC2am !c   P Gadvanc>d>MC4.incorrect(!Ladvanc>d>MC4.common.path2am !c P Gadvanc>d>MC4.correct&!Ladvanc>d>MC4.common.path2am !c P Gadvanc>d>MC4.incorrect(!Ladvanc>d>MC4.common.path2am !c P Gadvanc>d>MC4.incorrect(!Ladvanc>d>MC4.common.path2am Qf   JHPN  NO CHANGE!+QNIntroduction to DatabasesP: Course Description Instructor Days Cost Location:TS200Sys AdminGreene5$10DallasTS300ProgrammingGreene5$10DallasFM300Hdw MaintShaffer10$20SanJoseCX110UNIX BasicsWest3$500Atlanta:This database has been sorted.What field was used as the primary sort key?F1 - CourseF3 - LocationF2 - InstructorF4 - None of the aboveCNice try, however, that's incorrect. F2 is the correct answer.All records are sorted by the primary sort key, Instructor.CP<      <666 6 $ CCCCC2am +c N + F1  F2  F3  F4 2am d JHPN   NO CHANGE!+N  @ /MNO CHANGE!_NLIntroduction to DatabasesPM3You can create a separate listing of allmatching records using the Data/Query commands,Output, Extract, and Unique.You can also delete all matching recordsusing the Data/Query/Delete commands.3P @2am Ah JHPN  NO CHANGE!+ANa4 ^SortNo MENU Input Criterion Output Find Extract Unique Delete Reset Quit Delete all records that match criteria1 a b c d e f g h 4 SortNo EmpNo LastName FirstName Area Phone MailStop 5 15 342 Young Russ 408 4341234 15 6 6 438 Green Larry 714 27890 CA 7 16 231 O'Connor Kacie 714 27890 CA 8 11 161 White Steve 714 27890 CA 9 13 434 Davis # 10 7   826 Gurewitz  11 14 529 Davenport And all the Smiths are removed. 12 20 316 Gee  13 12 581 Carter The Delete command is helpful 14 5 265 Johnson  15 8 194 Rhodes for cleaning out your database. 16 21 412 West  17 19 624 Clark # 18 10 814 Johnson Corinne 201 3520990 NJ 19 17 475 Monaghan Ed 513 3664667 OH 20 9 871 Speck Joe 513 3664667 OH 21 2 230 Dold Cathy 215 3785500 PA 22 4 748 Bennett Charles 214 7552288 TX 23 18 648 Crosby Sue 214 7552288 TX 24N 25N 26N Sun 06-Mar-88 5:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am Ah JHPN  NO CHANGE!+ANa4 ^SortNo MENU Input Criterion Output Find Extract Unique Delete Reset Quit Delete all records that match criteria1 a b c d e f g h 4 SortNo EmpNo LastName FirstName Area Phone MailStop 5 15 342 Young Russ 408 4341234 15 6 6 438 Green Larry 714 27890 CA 7 16 231 O'Connor Kacie 714 27890 CA 8 11 161 White Steve 714 27890 CA 9 13 434 Davis # 10 7 826 Gurewitz  11 14 529 Davenport And all the Smiths are removed. 12 20 316 Gee  13 12 581 Carter The Delete command is helpful 14 5 265 Johnson  15 8 194 Rhodes for cleaning out your database. 16 21 412 West  17 19 624 Clark # 18 10 814 Johnson Corinne 201 3520990 NJ 19 17 475 Monaghan Ed 513 3664667 OH 20 9 871 Speck Joe 513 3664667 OH 21 2 230 Dold Cathy 215 3785500 PA 22 4 748 Bennett Charles 214 7552288 TX 23 18 648 Crosby Sue 214 7552288 TX 24N 25N 26N Sun 06-Mar-88 5:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am Dh   JHPN   NO CHANGE!+DNwa1 MENU Input Criterion Output Find Extract Unique Delete Reset Quit Enter the output rang to which matching records are to be copied a b  c d e f g h 1 XYZ Company- 2 Employee Listing* 3O 4 SortNo 2ailStop 5 1 5 6 15 To create a listing of all matching records,5 7 6 A 8 16 you must first define the area where allA 9 11 A 10 13 matching records are to be copied. To do this,L 11 3 A 12 7 you would select the Output command.L 13 14 I 14 202L15 12581CarterJoe3135610300MI16 5 265 Johnson Clarence 313 5610300 MI 17 8 194 Rhodes John 919 9512366 NC 18 21 412 West Jayne 919 9512366 NC 19 19 624 Clark Tom 201 3520990 NJ 20 10 814 Johnson Corinne 201 3520990 NJ 21 17 475 Monaghan Ed 513 3664667 OH 22 9 871 Speck Joe 513 3664667 OH 23 2 230 Dold Cathy 215 3785500 PA Sun 06-Mar-88 4:47 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph *G,+...+2am h JHPN  ?NO CHANGE!+NGg33 ^MailStop POINTEnter Output range: a33..g33 O % a b c d  e f g h 11 3 164 Smith Ron  404 2632125 GA 12 7 826 Gurewi 13 14 529 Davenp 14 20 316 Gee The first row of the output range must 15 12 581 Carter 16 5 265 Johnsocontain the headings exactly as they 17 8 194 Rhodes 18 21 412 West appear in the input range. Subsequent 19 19 624 Clark  20 10 814 Johnsorows should be blank, otherwise existing 21 17 475 Monagh 22 9 871 Speck information might be overwritten. 23 2 230 Dold  24 4 748 Bennet 25 18 648 Crosby Sue  214 7552288 TX 26 3 164 Smith Ron  404 2632125 GA 27/  28/  29/  30 SortNo EmpNo LastName FirstName Area Phone MailStop 31 Smith  32/  33 SortNo EmpNo LastName FirstName Area Phone MailStop Sun 06-Mar-88 5:04 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T, ,,,,,,,,,K2am Sh  JHPN  ?NO CHANGE!+SNa1 MENU Input Criterion Output Find Extract Unique Delete Reset Quit Copy any records that match criteri to Output range# a b c  d e f g h 1 XYZ Company, 2 Employee Listing* 3O 4 SortNo EmpNo LastName FirstName Area Phone MailStop 5 1 - 15 6 15 15 7 6  The Extract command then copies all CA 8 16 CA 9 11 matching records to the output range. CA 10 13 FL 11 3 - GA 12 7 826 Gurewitz Carla 808 4521879 HI 13 14 529 Davenport Alex 312 7931851 IL 14 20 316 Gee Ann 312 7931851 IL 15 12 581 Carter Joe 313 5610300 MI 16 5 265 Johnson Clarence 313 5610300 MI 17 8 194 Rhodes John 919 9512366 NC 18 21 412 West Jayne 919 9512366 NC 19 19 624 Clark Tom 201 3520990 NJ 20 10 814 Johnson Corinne 201 3520990 NJ 21 17 475 Monaghan Ed 513 3664667 OH 22 9 871 Speck Joe 513 3664667 OH 23 2 230 Dold Cathy 215 3785500 PA Sun 06-Mar-88 5:04 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ##9)))2am g* JHPN  3NO CHANGE!+Na33 ^SortNo READY a b c d e f g h 17 8 194 Rhodes John 919 9512366 NC 18 21 412 West Jayne 919 9512366 NC 19 19 624 Clark Tom 201 3520990 NJ 20 10 814 Johnson Corinne 201 3520990 NJ 21 17 . OH 22 9 OH 23 2 Three records have been extracted from the PA 24 4 TX 25 18 database and copied to the output range. TX 26 3 GA 27 Notice duplicate records have been found 28  29  for Smith, employee number 164. 30 SortNo Em MaiStop 31  . 32 8 33 SortNo EmpNo LastName FirstName Area Phone MailStop 34 1 514 Smith Michelle 408 4341234 15 35 3 164 Smith Ron 404 2632125 GA 36 3 164 Smith Ron 404 2632125 GA 37N 38N 39N Sun 06-Mar-88 5:05 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T......... 9992am /g  JHPN   NO CHANGE!+/Nna34 MENU Input Criterion Output Find Extract Unique Delete Reset Quit Copy any records that match criteria, eliminting duplicates a b c d e f g h 17 8 194 Rhodes John  919 9512366 NC 18 21 412 West Jayne 919 9512366 NC 19 19 . NJ 20 10 NJ 21 17 The Unique command works like the Extract OH 22 9 OH 23 2 command, except it does not copy duplicate PA 24 4 TX 25 18  records to the output range. TX 26 3 GA 27 . 28  29  30 SortNo EmpNo LastName FirstName Area Phone MailStop 31 Smith5 32N 33 SortNo EmpNo LastName FirstName Area Phone MailStop 34N 35N 36N 37N 38N 39N Sun 06-Mar-88 5:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ,,'***** 2am h JHPN  CNO CHANGE!+Nqa34 1 MENU Input Criterion Output Find Extract Unique Delete Reset Quit Copy any records that match criteria, eliminating duplicates a b c d e f g h 17 8 194 Rhodes John 919 9512366 NC 18 21 412 West Jayne 919 9512366 NC 19 19 624 Clark Tom 201 3520990 NJ 20 10 814 Johnson Corinne 201 3520990 NJ 21 17 475 Monaghan Ed 513 3664667 OH 22 9 871 Speck Joe 513 3664667 OH 23 2 230 Dold Cathy 215 3785500 PA 24 4 748 Bennett Charles 214 7552288 TX 25 18 648 Crosby Sue 214 7552288 TX 26 3 164 Smith Ron 404 2632125 GA 27N 28N 29N 30 SortNo EmpNo LastName FirstName Area Phone MailStop 31 Smith5 32N 33 SortNo EmpNo LastName FirstName Area Phone MailStop 34 1 514 Smith Michelle 408 4341234 15 35 3 164 Smith Ron 404 2632125 GA 36  2  37  38 This time, the record is now copied only once. 39   Sun 06-Mar-882 Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 92222am h  JHPN  ONO CHANGE!+N  @ ,MNO CHANGE!_Na4 ^SortNo MENU Input Criterion Output Find Extract Unique Delete Reset Quit Delete all records that match criteria " a b c d e f g h 4 SortNo EmpNo LastName FirstName rea Phone MailStop 5 1 514 Smith Michelle 408 4341234 15 6 15 342 Young Russ 408 4341234 15 7 6 438 Green Larry 714 27890 CA 8 16 231 O'Connor Kaci2am hb JHPN   GNO CHANGE!+N+a4 ^SortNo 'ENU Cancel Delete  Delete records that match criteria After selecting the Delete command, a b c h 4 SortNo EmpNo LastName you can cancel this command if you 5 1 514 Smith   6 15 342 Young decide not to delete any records. 7 6 438 Green  8 16 231 O'Connor ' 9 11 161 White  Steve 714 27890 CA 10 13 434 Davis  Arnold 305 3932848 FL 11 3 164 Smith  12 7 826 Gurewitz 13 14 529 Davenport In this example, the Delete 14 20 316 Gee 15 12 581 Carter command will remove from the 16 5 265 Johnson 17 8 194 Rhodes database all employees with 18 21 412 West 19 19 624 Clark the last name, Smith. 20 10 814 Johnson 21 17 475 Monaghan 22 9 871 Speck  Joe 513 3664667 OH 23 2 230 Dold  Cathy 215 3785500 PA 24 4 748 Bennett  Charles 214 7552288 TX 25 18 648 Crosby  Sue 214 7552288 TX 26 3 164 Smith  Ron 404 2632125 GA Sun 06-Mar-88 5:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ''#'''''2am id JHPN   NO CHANGE!+N  @  MNO CHANGE!_iNQIntroduction to DatabasesPN1Now let's talk about querying a database.Toqueryadatabasemeanstosearchforarelatedgroupofinformation.Forexample,youcanqueryadatabaseforallemployeeswhoselastnameisSmith.1?Pp2am g:  JHPN   NO CHANGE!+N"g31 POINTEnter Criterion range: a30..g31 a b c d e f g h 9 11 161 White Steve 714 27890 CA 10 13 434 Davis Arnold 305 3932848 FL 11 3 164 Smith Ron 404 2632125 GA 12 7 826 Gurewitz Carla 808 4341234 HI 13 14 529 Davenport Alex 312 7931851 IL 14 20 316 Gee Ann 312 7931851 IL 15 12 581 Carter Joe 313 5610300 MI 16 5 265 Johnson Clarence 313 5610300 MI 17 8 194 Rhodes John 919 9512366 NC 18 -19 9512366 NC 19 01 3520990 NJ 20 You can change the criterion at any time.01 3520990 NJ 21 13 3664667 OH 22 In this example, find all employees with13 3664667 OH 23 15 3785500 PA 24 the last name, Smith.14 7552288 TX 25 14 7552288 TX 26  27 2 28 2 29 2 30 SortNo EmpNo LastName FirstName Area Phone MailStop 31 Smith5 Fri 04-Mar-88 2:52 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T * *2am gT JHPN   ONO CHANGE!+N;a11 3 FIND a b c d e f g h 5 1 514 Smith Michelle 408 4341234 15 6 15 342 Young Russ 408 4341234 15 7 6 438 Green Larry 714 27890 CA 8 16 231 O'Connor Kacie 714 27890 CA 9 11 161 White Steve 714 27890 CA 10 13 434 Davis Arnold 305 3932848 FL 11 3 164 Smith Ron 404 2632125 GA 12 7 826 Gurewitz Carla 808 4341234 HI 13 14 529 Davenport Alex 312 7931851 IL 14 20 +31851 IL 15 12 10300 MI 16 5 Each matching record is highlighted,10300 MI 17 8 12366 NC 18 21 and a beep sounds when the Find command12366 NC 19 19 20990 NJ 20 10 cannot find anymore matching records.20990 NJ 21 17 64667 OH 22 9 +64667 OH 23 2 230 Dold Cathy 215 3785500 PA 24 4 748 Bennett Charles 214 7552288 TX 25 18 648 Crosby Sue 214 7552288 TX 26N 27N Fri 04-Mar-88 2:53 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  5 NO CHANGE!NEa11 3 FIND a b c d e f g h 5 1 514 Smith Michelle 408 4341234 15 6 15 342 Young Russ 408 4341234 15 7 6 438 Green Larry 714 27890 CA 8 16 231 O'Connor Kacie 714 27890 CA 9 11 161 White Steve 714 27890 CA 10 13 434 Davis Arnold 305 3932848 FL 11 3 164 Smith Ron 404 2632125 GA 12 7 826 Gurewitz Carla 808 4341234 HI 13 14 529 Davenport Alex 312 7931851 IL 14 20 +31851 IL 15 12 10300 MI 16 5 Each matching record is highlighted,10300 MI 17 8 12366 NC 18 21 and a beep sounds when the Find command12366 NC 19 19 20990 NJ 20 10 cann ot find anymore matching records.20990 NJ 21 17 64667 OH 22 9 To finish viewing records that have64667 OH 23 2 85500 PA 24 4 been found, you would press Cancel.52288 TX 25 18 52288 TX 26 + 27N Fri 04-Mar-88 2:53 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph TK2am gg JHPN   !NO CHANGE!+NSa30 ^SortNo MENU Input Criterion Output Find Extract Unique Delete Reset Quit Find records that match criteria7 a b c d e f g h 8 16 231 O'Connor Kacie 714 27890 CA 9 11 161 White Steve 714 27890 CA 10 13 434 Davis Arnold 305 3932848 FL 11 3 164 Smith Ron 404 2632125 GA 12 7 04 HI 13 14 1 IL 14 20 The Data command menu is then redisplayed,1 IL 15 12 0 MI 16 5 and the mode indicator returns to MENU mode.0 MI 17 8 6 NC 18 21 06 NC 19 19 624 Clark Tom 201 3520990 NJ 20 10 814 Johnson Corinne 201 3520990 NJ 21 17 475 Monaghan Ed 513 3664667 OH 22 9 871 Speck Joe 513 3664667 OH 23 2 230 Dold Cathy 215 3785500 PA 24 4 748 Bennett Charles 214 7552288 TX 25 18 648 Crosby Sue 214 7552288 TX 26N 27N 28N 29N 30 SortNo EmpNo LastName FirstName Area Phone MailStop Fri 04-Mar-88 2:53 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am Od JHPN  'NO CHANGE!+ON/Introduction to DatabasesP0The search is based on one or more criteria.A criterion is a piece of information thatyou are searching for. In the example above, the criterionis the last name, Smith.0@P2am lh  JHPN  %NO CHANGE!+lNpa1 MENU Fill Table Sort Query Distribution Matrix Regression Parse Query a database A a b  c d e f g h 1 XYZ Company- 2 Employee Listing* 3O 4 SortNo EmpNo LastName FirstName Area Phone MailStop 5 1 514 Smith Michelle 408 4341234 15 6 15 3&341234 15 7 6 47890 CA 8 16 2To query a database, you would use7890 CA 9 11 17890 CA 10 13 4the Data/Query command.932848 FL 11 3 1632125 GA 12 7 8341234 HI 13 14 5Let's query your database for all931851 IL 14 20 3931851 IL 15 12 5employees whose MailStop is CA.610300 MI 16 5 2610300 MI 17 8 1&512366 NC 18 21 412 West Jayne 919 9512366 NC 19 19 624 Clark Tom 201 3520990 NJ 20 10 814 Johnson Corinne 201 3520990 NJ 21 17 475 Monaghan Ed 513 3664667 OH 22 9 871 Speck Joe 513 3664667 OH 23 2 230 Dold Cathy 215 3785500 PA Fri 04-Mar-88 2:46 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph G&&&&&&#&"&2am h_ JHPN   !NO CHANGE!+Ng25 'TX POINTEnter Input range: a4..g25 O 5 a b c d e f g h 4 SortNo EmpNo LastName FirstName Area Phone MailStop 5 1 514 Smith  Michelle 408 4341234 15 6 15 342 Young  Russ 408 4341234 15 7 6 14 27890 CA 8 16 14 27890 CA 9 11 The first thing to do is define14 27890 CA 10 13 05 3932848 FL 11 3 an input range, which is the04 2632125 GA 12 7 08 4341234 HI 13 14 range to query. Usually it's12 7931851 IL 14 20 12 7931851 IL 15 12 the entire database. Note that13 5610300 MI 16 5 13 5610300 MI 17 8 record headings are included as19 9512366 NC 18 21 19 9512366 NC 19 19 part of the input range.01 3520990 NJ 20 10 01 3520990 NJ 21 17 13 3664667 OH 22 9 #13 3664667 OH 23 2 230 Dold Cathy  215 3785500 PA 24 4 748 Bennett Charles 214 7552288 TX 25 18 648 Crosby Sue 214 7552288 TX 26N Fri 04-Mar-88 2:47 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph KK#############KK 2am h JHPN  BNO CHANGE!+Ng31 'CA (INTEnter Criterion range: a30..g31 # Next, define the criterion range, a b c 12 7 826 Gurewitz which contains the criteria 13 14 529 Davenport 14 20 316 Gee used to match records in the query.15 12 581 Carter 16 5 265 Johnson The range is located in an unused17 8 194 Rhodes 18 21 412 West portion of the worksheet. Here,19 19 624 Clark 20 10 814 Johnson the criterion is MailStop. You want21 17 475 Monaghan  22 9 871 Speck to find all records whose MailStop  23 2 230 Dold  24 4748Bennettis CA. 25 18648 Crosby 26 ! 27   28   29/  30 SortNo EmpNo LastName FirstName Area Phone MailStop 31@ CA 32N 33N 34N Fri 04-Mar-88 2:51 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph (#(((((((((((((((B B 2am "g JHPN  .NO CHANGE!+"NWa30 ^SortNo MENU Input Criterion Output Find Extract Unique Delete Reset Quit Find records that match critria7 a b  d e f g h 12 7 826 Gurewiz Carla 808 4341234 HI 13 14 529 Davenport Alex 312 7931851 IL 14 20 316 Gee Ann 312 7931851 IL 15 12 2 MI 16 5 MI 17 8 After the criterion is established, search NC 18 21 NC 19 19  for all records that match the criterion. NJ 20 10 NJ 21 17 To do this, you would select OH 22 9 OH 23 2 the Find command. PA 24 4 TX 25 18 2 TX 26N 27N 28N 29N 30 SortNo EmpNo LastName FirstName Area Phone  MailStop 31@ CA 32N 33N 34N Fri 04-Mar-88 2:51 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 7....  2am gW JHPN   HNO CHANGE!+N#a7 6 FINDN O a b c d e f g h 7 6 438 Green Larry 714 27890 CA 8 16 231 O'Connor Kacie  714 27890 CA 9 11 161 White Steve  714 27890 CA 10 13 434 Davis Arnold  305 3932848 FL 11 3 164 Smit 12 7 826 Gure 13 14 529 DaveThe Find command searches for a record and 14 20 316 Gee  15 12 581 Carthighlights it. Notice that the mode  16 5 265 John 17 8 194 Rhodindicator changed from MENU to FIND mode. 18 21 412 West 19 19 624 Clar. 20 10 814 Johnson Corinne 201 3520990 NJ 21 17 475 Monaghan Ed 513 3664667 OH 22 9 871 Speck Joe 513 3664667 OH 23 2 230 Dold Cathy 215 3785500 PA 24 4 748 Bennett Charles 214 7552288 TX 25 18 648 Crosby Sue 214 7552288 TX 26N 27N 28N 29N Fri 04-Mar-88 2:51 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph .......2am gL JHPN  NO CHANGE!+Na8 16 FIND a b c d e f g h 7 6 438 Green Larry 714 27890 CA 8 16 231 O'Connor Kacie 714 27890 CA 9 11 161 White  Steve  714 27890 CA 10 13 434 Davis  Arnold  305 3932848 FL 11 3 164 Smith  Ron  404 2632125 GA 12 7 826  41234 HI 13 14 52931851 IL 14 20 316To search for the next record in31851 IL 15 12 58110300 MI 16 5 265the database that matches the 10300 MI 17 8 19412366 NC 18 21 412criterion, you would press the12366 NC 19 19 62420990 NJ 20 10 814Down Arrow key. To highlight20990 NJ 21 17 47564667 OH 22 9 871the previously-selected record,64667 OH 23 2 23085500 PA 24 4 748you would press the Up Arrow key.52288 TX 25 18 64852288 TX 26 % 27  28  29N Fri 04-Mar-88 2:52 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph TK 2am g JHPN  NO CHANGE!+Na9 11 FIND a b c d e f g h 7 6 438 Green Larry 714 27890 CA 8 16 231 O'Connor Kacie 714 27890 CA 9 11 161 White Steve 714 27890 CA 10 13 434 Davis Arnold 305 3932848 FL 11 3 164 Smith Ron 404 2632125 GA 12 7 826 $41234 HI 13 14 529 31851 IL 14 20 316 After the last record is found,31851 IL 15 12 581 10300 MI 16 5 265 the Find command will beep if10300 MI 17 8 194 12366 NC 18 21 412 you try to find anymore records.12366 NC 19 19 624 20990 NJ 20 10 814 $20990 NJ 21 17 475 Monaghan Ed 513 3664667 OH 22 9 871 Speck Joe 513 3664667 OH 23 2 230 Dold Cathy 215 3785500 PA 24 4 748 Bennett Charles 214 7552288 TX 25 18 648 Crosby Sue 214 7552288 TX 26N 27N 28N 29N Fri 04-Mar-88 2:52 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph TK2am 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 cA JHPN  'NO CHANGE!+NFL E T ' S T E S TY O U R K N O W L E D G EB Y A N S W E R I N GA F E W Q U E S T I O N S!F  2am 7e JHPN  ONO CHANGE!+N'! 7NO CHANGE!7NIntroduction to Databases5A database is a collection of relatedinformation.A database consists of records. 'The information in each record is organized!under one or more record headings.To create a database, simply enter records and record headings into the worksheet asyou would enter functions, formulas, labels and values.52am ,e JHPN  ONO CHANGE!+,NIntroduction to Databases5To enter a sequential list of numbersinto your worksheet, use the Data/Fillcommand.'To sort a database by a certain recordheading, or field, use the Data/Sort !command.To query a database for records that match certain criteria, use the Data/Query commands, Input, Criterion, and Find.5%&*K2am we JHPN  NO CHANGE!+wN+Introduction to Databases5To copy records that match the criteriato a different part of your worksheet,use the Data/Query commands, Output,Extract, and Unique.'To remove records from the database that!match the criteria, use the Data/Query/Delete command.To calculate the frequency distributionusing informa tion in your database records, use the Data/Distribution command.5'%('"2am nf JHPN  NO CHANGE!+nNIntroductiontoDatabases5To copy records that match the criteriato a different part of your worksheet,YouhavereachedtheusetheData/Querycommands,Output,endofthislesson.Extract,andUnique.Wesuggestyouproceedtothenextlesson,To remove records from the database thatIntroduction to "What If?"match the criteria,usetheAnalysis and Goal Seeking.Data/Query/Deletecommand.PressNextPagetoreturnto the Advanc menu.To calculate the frequency distributionusing information in your databaserecords,usetheData/Distributioncommand.  55 '5 %5555555 (5 55555 '5 " 5 $5552am (d JHPN  5NO CHANGE!+(NIntroduction to DatabasesP8Once you've created a database, you can sort recordsbased on any of the record headings.For example, you can sort the employeelist by employee number.8P2am Hh JHPN  %NO CHANGE!+HNa1 MENU Fill Table Sort Query Distribution Matrix Regression Parse Sort a databaseG a b c d e f g h 1  XYZ Company- 2 Employee Listing* 3O 4 SortNo EmpNo LastName FirstName Area Phone MailStop 5 1 514 Smith Michelle 408 4341234 15 6 2 (85500 PA 7 3 32125 GA 8 4 To sort a database, you would select52288 TX 9 5 10300 MI 10 6 the Data/Sort Comma nd.890 CA 11 7 41234 HI 12 8 (12366 NC 13 9 871 Speck Joe 513 3664667 OH 14 10 814 Johnson Corinne 201 3520990 NJ 15 11 161 White Steve 714 27890 CA 16 12 581 Carter Joe 313 5610300 MI 17 13 434 Davis Arnold 305 3932848 FL 18 14 529 Davenport Alex 312 7931851 IL 19 15 342 Young Russ 408 4341234 15 20 16 231 O'Connor Kacie 714 27890 CA 21 17 475 Monaghan Ed 513 3664667 OH 22 18 648 Crosby Sue 214 7552288 TX 23 19 624 Clark Tom 201 3520990 NJ Fri 04-Mar-88 2:40 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph M$2am h@ JHPN  CNO CHANGE!+Ng25 'NC 2Enter Data range: a5..g25  The first thing to do is define the data range a b 3 to sort, usually the entire database.4 SortNo EmpNo Las5 1 514 Smith 06 2 230 Dold Cathy 215 3785500 PA 7 3 164 Smith Ron 404 2632125 GA 8 4 748 Bennett Charles 214 7552288 TX 9 5 265 Johnson Clarence 313 5610300 MI 10 6 438 Green Larry 714 27890 CA 11 7 826 Gurewitz Carla 808 4341234 HI 12 8 194 Rhodes John 919 9512366 NC 13 9 871 Speck Joe 513 3664667 OH  14 10 814 Johnson Corinne 201 3520990 NJ 15 11 161 White Steve 714 27890 CA 16 12 581 Carter Joe 313 5610300 MI 17 13 434 Davis Arnold 305 3932848 FL 18 14 529 Davenport Alex 312 7931851 IL 19 15 342 Young Russ 408 4341234 15 20 16 231 O'Connor Kacie 714 27890 CA 21 17 475 Monaghan Ed 513 3664667 OH 22 18 648 Crosby Sue 214 7552288 TX 23 19 624 Clark Tom 201 3520990 NJ 24 20 316 Gee Ann 312 7931851 IL 25 21 412 West Jayne 919 9512366 NC Fri 04-Mar-88 2:40 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 2&222KKKKKKKKKKKKKKKKKKKK2am Kh JHPN  ?NO CHANGE!+KNa1 EDIT Enter Primary sort key address: b4 Enter Sort Order (A or D): A1   a b c d e f  g h 1 XYZ Compay  2 Employee Liting  3 4 SortNo EmpNo LastNameFirstNameAreaPhonMailStop 5 1 514 Smith Michelle40843412415 6 2 230 Dold Cathy215378550PA 7 3 164 Smith Ron404263215GA 8 4 748 Bennett Charles214755228TX  9 5 265 Johnson Clarence313561030MI 10 6 438 Green  Larry 714 278900 CA 11   808 434124 HI 12  919 951236 NC 13 Then, define the field on which to 513 366467 OH 14  201  352090 NJ 15 base the sort. For example, to sort  16  17 by employee number, set the primary And sort in ascending 18  19 sort key to the field, EmpNo. order. 20   21 (  22 18 648 Crosby Sue 214 7552288 TX 23 19 624 Clark Tom 201 3520990 NJ Fri 04-Mar-88 2:41 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am -h JHPN  8NO CHANGE!+-Nta1 MENU Data-Range Primary-Key Secondary-Key Reset Go Quit Sort database, and return to READY mode & a b c d  e f g h 1 XYZ Company  2 Employee Listing* 3O 4 SortNo EmpNo LastName FirstName Area Phone MailStop 5 11 514 White Steve 714 27890 CA 6 3 /GA 7 8 NC 8 2  To perform the sort, you wouldPA 9 16 CA 10 5 select the Go command.MI 11 20 IL 12 15 /15 13 21 871 West Jayne 919 9512366 NC 14 13 814 Davis Arnold 305 3932848 FL 15 6 161 Green Larry 714 27890 CA 16 17 581 Monaghan Ed 513 3664667 OH 17 1 434 Smith Michelle 408 4341234 15 18 14 529 Davenport Alex 312 7931851 IL 19 12 342 Carter Joe 313 5610300 MI 20 19 231 Clark Tom 201 3520990 NJ 21 18 475 Crosby Sue 214 7552288 TX 22 4 648 Bennett Charles 214  7552288 TX 23 10 624 Johnson Corinne 201 3520990 NJ Fri 04-Mar-88 2:44 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 0,,$2am Ui JHPN  :NO CHANGE!+UNYa1 READY a b c d e f g h 1 XYZ Company- 2 Employee Listing* 3O 4 SortNo EmpNo LastName FirstName Area Phone MailStop 5 11 161 White Steve 714 27890 CA 6 3 164 Smith Ron 404 2632125 GA 7 8 194 Rhod#66 NC 8 2 230 Dold00 PA 9 16 231 O'CoAfter pressing Go, the database00 CA 10 5 265 00 MI 11 20 316 Gee is sorted by employee number.51 IL  12 15 342 Youn34 15 13 21 412 West#66 NC 14 13 434 Davis Arnold 305 3932848 FL 15 6 438 Green Larry 714 27890 CA 16 17 475 Monaghan Ed 513 3664667 OH 17 1 514 Smith Michelle 408 4341234 15  18 14 529 Davenport Alex 312 7931851 IL 19 12 581 Carter Joe 313 5610300 MI 20 19 624 Clark Tom 201 3520990 NJ 21 18 648 Crosby Sue 214 7552288 TX 22 4 748 Bennett Charles 214 7552288 TX 23 10 814 Johnson Corinne 201 3520990 NJ Fri 04-Mar-88 2:42 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]:::#####" " " " " " " " " " 2am gW JHPN  3NO CHANGE!+N7a1 MENU Data-Range Primary-Key Secondary-Key Reset Go Quit Enter secondary sort key column7 a b c d e f g h 1 XYZ Comany- 2 Employee Listing* 3 3 4 SortNo  MailStop 5 1Let's look at another example. Let's say your 15 6 15 15 7 6records are sorted by MailStop. Since more CA 8 16 CA 9 11than one employee may have the same MailStop, CA 10 13 FL 11 3you might want to further define the sort order GA 12 7 HI 13 14by specifying a secondary sort key, such as IL 14 20 IL 15 12LastName. This key is used when two or more MI 16 5 MI 17 8records have the same primary sort key. NC 18 21 NC 19 193 NJ 20 10 814 Johnson Corinne 201 3520990 NJ 21 17 475 Monaghan Ed 513 3664667 OH 22 9 871 Speck Joe 513 3664667 OH 23 2 230 Dold Cathy 215 3785500 PA Fri 04-Mar-88 2:45 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  =2am h1  JHPN   0NO CHANGE!+)Na1 READY a b c d e f g h 1 XYZ Company- 2 Employee Listing* 3O 4 SortNo EmpNo LastName FirstName Area Phone MailStop 5 1 514 Smith Michelle 408 4341234 15 6 15 342 Young Russ 408 4341234 15 7 6 438 Green Larry 714 27890 CA 8 16 231 O'Connor Kacie 714 27890 CA 9 11 161 White Steve 714 27890 CA 10 13 434 Davis Arnold 305 3932848 FL 11 3 164 Smith Ron 404 2632125 GA 12 7 826 Gurewitz Carla 808 4341234 HI 13 14 529 Davenport Alex 312 7931851 IL 14 20 316 Gee Ann 312 7931851 IL 15 12 581 Carter Joe 313 5610300 MI 16 5 265 Johnson Clarence 313 5610300 MI 17 8 194 Rhodes John 919 9512366 NC 18 21 412 West Jayne 919 9512366 NC 19 19 624 Clark Tom 201 3520990 NJ 20 10 814 Johnson Corinne 201 3520990 NJ 21 17 475 Monaghan Ed 513 3664667 OH 22 9 871 Speck Joe 513 3664667 OH 23 2 230 Dold Cathy 215 3785500 PA Fri 04-Mar-88 2:45 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]T  aNO CHANGE!sN>a1 READY a b c d e f g h 1 XYZ Company- 2 Employee Listing* 3O 4 SortNo EmpNo LastName FirstName Area Phone MailStop 5 1 514 Smith Michelle 408 4341234 15 6 15 342 Young Russ 408 4341234 15 7 6 -890 CA 8 16 890 CA 9 11 Records have been sorted by MailStop. CA 10 13 32848 FL 11 3 -32125 GA 12 7 826 Gurewitz Carla 808 4341234 HI 13 14 529 Davenport Alex 312 7931851 IL 14 20 316 Gee Ann 312 7931851 IL 15 12 581 Carter Joe 313 5610300 MI 16 5 265 Johnson Clarence 313 5610300 MI 17 8 194 Rhodes John 919 9512366 NC 18 21 412 West Jayne 919 9512366 NC 19 19 624 Clark Tom 201 3520990 NJ 20 10 814 Johnson Corinne 201 3520990 NJ 21 17 475 Monaghan Ed 513 3664667 OH 22 9 871 Speck Joe 513 3664667 OH 23 2 230 Dold Cathy 215 3785500 PA Fri 04-Mar-88 2:45 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]444444---7777777777772am hH JHPN   /NO CHANGE!+N{a1 .READY But, records with the same MailStop have a  g h 1 been further sorted by the secondary sort 2  3 key, LastName. For example, the two 4 SortNo E MailStop 5 1 employees with the MailStop, IL, have been4 15 6 15  7 6 further sorted by last name.0 C 8 16 0 C 9 11 &0 C 10 13 434 Dais Arnold 305 3932848  F 11 3 164 Sm th Ron 404 2632125 G 12 @13  14 529 Davenport Alex 312 7931851 IL  14  20 316 Gee Ann 312 7931851 IL  15  12 581 Carter Joe 313 5610300 MI  16  5 265 Johnson Clarence 313 5610300 MI  17 @18 21 412 West Jayne 919 9512366 NC 19 19 624 Clark Tom 201 3520990 NJ 20 10 814 Johnson Corinne 201 3520990 NJ 21 17 475 Monaghan Ed 513 3664667 OH 22 9 871 Speck Joe 513 3664667 OH 23 2 230 Dold Cathy 215 3785500 PA Fri 04-Mar-88 2:45 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ..... .  .  . . .  * *    ::::::2am d9 JHPN   NO CHANGE!+NXQuestion Introduction to DatabasesPT R U E o r F A L S E0The Data/Query/Extract command copiesall matching records, except duplicaterecords, to the specified output range.0 (Select your answer by pressing one of the indicated selections)P?000+000'@2am c P Gadvanc>d>d.1Gadvanc>d>d.23ZCarla.fontFZSD.fontVGadvanc>d>d.3kGadvanc>d>d.4Gadvanc>d>d.5Gadvanc>d>d.6Gadvanc>d>d.7ZSD.fontZCarla.fontGadvanc>d>rev.1Gadvanc>d>rev.2Gadvanc>d>rev.3'Gadvanc>d>rev.4>Nadvanc>menu2am !c P Gadvanc>d>TF9.true#!Ladvanc>d>TF9.common.path 2am !c P Gadvanc>d>TF9.false$!Ladvanc>d>TF9.common.path2am Xe JHPN  CNO CHANGE!+XNIntroduction to DatabasesPT R U E o r F A L S E0The Data/Query/Extract command copiesall matching records, excluding duplicaterecords, to the specified output range. #Correct. This statement is false.##It is the Data/Query/Unique command that copies all matching records, except duplicate records, to the specified output range. P?0000000--- ------2am !c N ! TRUE  FALSE 2am ^e  JHPN  ANO CHANGE!+^NIntroduction to DatabasesPT R U E o r F A L S E0The Data/Query/Extract command copies all matching records, except duplicaterecords, to the specified output range. "That's incorrect. This statement is""false. It is the Data/Query/Unique command that copies all matching records, except duplicate records, to the specified output range.P?0000000...".....$.2am dB JHPN  NO CHANGE!+N- Question -Introduction to "What If?" Analysis and Goal SeekingPFILLINTHEBLANKNNNN>When using the Advanced/Goal-Seeking command, thetarget cell is the cell that contains your ~ ~ .>NNNNN(Type your answer and press GO when ready)4Pg 4I*2am cW JHPN  *NO CHANGE!+NIntroduction to "What If?" Analysis and Goal SeekingPThat's correct!When using the Advanced/Goal-Seeking command,the target cell is the cell that containsyour goal.44P752am "c P Gadvanc>g>FIB3.a000$"Ladvanc>g>FIB3.common.path 2am c\ JHPN  *NO CHANGE!+NIntroduction to "What If?" Analysis and Goal SeekingPThat's incorrect.When using the Advanced/Goal-Seeking command,the target cell is the cell that contains your goal.44P752am "c P Gadvanc>g>FIB3.a999$"Ladvanc>g>FIB3.common.path2amch!pPgoal(aPtarget2am c P advanc>g>MC4 2am <d JHPN  BNO CHANGE!+<N$Introduction to "What If?" Analysis and Goal SeekingP4In "What If?" analysis, you changed one or morevariables to see how this affected other numbersin the worksheet --to see "what" would happen "if ." .4}4Pp2am gy JHPN   ?NO CHANGE!+N b5 (C2) [W10] 10 READY a b c d e f g h 1 !2 3 # Shares 450 To do this, the goal-seeking 4 Purchase price $7.75 5 Current price $10.00 command must vary the current6 Market value $4,500.00 7 price, located in cell c5,8 Dollar Gain $1,012.50 9 called the variable cell.10 11 !12 13 14 15 The value in the variable cell is 16 17 adjusted until it reaches the goal18 19 in cell b8, called the target cell.20 21 '22 23 Tue 08-Mar-88 7:20 PM Macro  Edit   Name Abs  Go To  Window Query Table  Calc  Graph T!!! !!!!  !''''' '2am uf JHPN  NO CHANGE!+uNb5(C2)[W10]10MENU Record-MacroLinkGoal-SeekingMoveAutomaticDefaultWidthAdjustavariablecelltohangeavalueinatargetcell a b  c d e f g h 1 2 3 # Shares 4504 Purchase price $7.755 Current price $10.006 Market value $4,500.007 8 Dollar Gain $1,012.509 10 11 -12 13 To perform goal seeking, you would14 15 select the  Advanced/Goal-Seeking command.16 17 -18 19 20 21 22 23 Tue 08-Mar-88 7:20 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  9 &))2am f) JHPN  NO CHANGE!+Nb8 (C2) [W10] +b6-(b3*b4) POINTEnter Variable Cell: b5 Enter Target Cell: b8 )  ! a  b c d e f g h 1 2 3 # Shares  450 4 Purchase price $7.75 5 Current price  $10.00 6 Market value $4,500.00 7 8 Dollar Gain $1,012.50 9 10 11 12  13 14 First, you would defineThen, you would define15 16 the variable cell. the target cell.17 18 19 20 21 22 23 Tue 08-Mar-88 7:30 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am df JHPN  NO CHANGE!+dNb5 (C2) [W10] 10 EDIT Enter goal: 50 $O " a b c d e  f g h 1 2 3 # Shares 450 4 Purchase price $7.75 5 Current price $10.00 Finally, you would enter6 Market value $4,500.00 7 your goal, 50.8 Dollar Gain $1,012.50 9 10 11 12 13 )14 15 After defining your goal and pressing16 17 Return, goal seeking is performed.18 19 )20 21 22 23 Tue 08-Mar-88 7:31 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T )))))2am e]  JHPN   NO CHANGE!+(Nb5 (C2) [W10] 11.00 READY a b c d e f g h 1O 2O 3 # Shares 4504 4 Purchase price $7.754 5 Current price $11.004 6 Market value $4,950.004 7O 8 Dollar Gain $1,462.504 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Tue 08-Mar-88 7:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T S  +`NO CHANGE!rNIb5 (C2) [W10] 18.86 1 READY a b c d e f g h 1 2 3 # Shares 450 4 Purchase price $7.75 The current price per share5 Current price $18.86 6 Market value $8,487.50 must be $18.86 in order for7 8 Dollar Gain $5,0.00 you to reach your goal of9 10 $5,0.11 12 13 14 15 16 17 18 19 20 21 22 23 Tue 08-Mar-88 7:31 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am Od JHPN   NO CHANGE!+ON/Introduction to "What If?" Analysis and Goal SeekingP8Goal seeking is the opposite of "What If?" analysis.In goal seeking, you know the result you wantand you must determine what valuewill help you reach that result.8|4P= '2am Ne JHPN  *NO CHANGE!+NNIntroductionto"WhatIf?"AnalysisandGoalSeekingP5For example, you just bought 450 shares of stockat $7.75 per share. The current price is $10.00per share, giving you a dollar gain of $1,012.50.However, your goal is to gain $5,0.You can use goal seeking to determine what thecurrent price should be in order to reach yourgoal of $5,0.Let's take a closer look at this example.5 Pp 2am e JHPN  ENO CHANGE!+Nb3 [W10] 450 READY a b c d e f g h 1 2 3 # Shares 450 4 Purchase price $7.75 5 Current price $10.00 6 Market value $4,500.00 7 This worksheet contains8 Dollar Gain $1,012.50 9 your stock information.10 11 12 13 14 15 16 17 18 19 20 21 22 23 Tue 08-Mar-88 7:19 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am e, JHPN  NO CHANGE!+Nb3 [W10] 450 READY a b c ! h 1 2 Cell b3 contains the number3 # Shares 450 4 Purchase price $7.75 of shares that you purchased.5 Current price $10.00 6 Market value $4,500.00 !7 8 Dollar Gain $1,012.50 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Tue 08-Mar-88 7:19 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph $ !! !!!2am e; JHPN  NO CHANGE!+Nb4 (C2) [W10] 7.75 READY a b c d e f g h 1$ $ 2$ $  3 # Shares 450 Cell b4 contains the price at4 Purchase price $7.75 5 Current price $10.00which you purchased your shares. 6 Market value $4,500.007 $8 Dollar Gain $1,012.509 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Tue 08-Mar-88 7:19 PM Macro  Ed it  Name Abs  Go To  Window Query Table  Calc  Graph T$$ $$$2am e# JHPN   $NO CHANGE!+Nb5 (C2) [W10] 10 READY a b c d e f g h 1 2 3 # Shares 450 4 Purchase price $7.75 Cell b5 contains5 Current price $10.00 6 Market value $4,500.00 the current price.7 8 Dollar Gain $1,012.50 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Tue 08-Mar-88 7:20 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am Ef JHPN   CNO CHANGE!+EN}b6 (C2) [W10] +b5*b3 READY7 O " a b c d e  f g h 1 2 3 # Shares 450 Cell b6 contains a formula that4 Purchase price $7.75 5 Current price $10.00 uses the values in cells b3 and6 Market value $4,500.00 7 b5, to calculate the market8 Dollar Gain $1,012.50 9 value of your purchased shares.10 11 $12 13 14 15 16 17 18 19 20 21 22 23 Tue 08-Mar-88 7:20 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$$$$ $$$$$2am fs  JHPN  'NO CHANGE!+N(b8 (C2) [W10] +b6-(b3*b4) READY7 O " a b c d e  f g h 1 2 3 # Shares 450 4 Purchase price $7.75 And finally, cell b8 contains5 Current price $10.00 6 Market value $4,500.00 a formula that uses the values7 8 Dollar Gain $1,012.50 in cells, b3, b4 and b6, to 9 10 calculate the dollar gain if11 12 you sell your shares.13 14 "15 16 /17 18 You want to find out what the current price19 20 should be in order for you to gain $5,0.21 22 /23 Tue 08-Mar-88 7:20 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T""""" """"""2am d] JHPN   NO CHANGE!+N  @ CMNO CHANGE!_N|Introduction to DatabasesP8A database is any collection of related information.8LPp NO CHANGE!NIntroduction to DatabasesP8Adatabaseisanycollectionofrelatedinformation.8 A database can be an index card file .YWUTSmith, M.Emp# 514Phone: 408 434 1234MailStop: 15 Division:SalesP-- " JHPN  ANO CHANGE!+XNIntroductionto"WhatIf?"AnalysisandGoalSeekingPIn this lesson, you will learnHow to perform "What If?" analysisusing the Data/Table commandHow to perform goal seeking analysisusing the Advanced/Goal-Seeking command P     2am Ed  JHPN   NO CHANGE!+N  @  !MNO CHANGE!_EN%Introduction to "What If?" Analysis and Goal SeekingP4"What If?" analysis involves changing one or twovariables, viewing the results, changing one or two variables again, viewing the results again,and so on.4~4P?2am fU JHPN   NO CHANGE!+Nd8 @PMT(b1,c2/12,b3) POINTEnter Table range: c2..d8K F a  b c d e f g 1 Loan amount $11,0 Interest Payment 2 Annual interest  12% @PMT(b1,c2/1 3 Months to repay  48 8%& 4  9%& 5 Monthly payment $289.67 10%& 6  11%& 7  12%& 8  13%& 9 10 11 12 13 14 First, you must define the table range. In general, the 15 16 table range must include the formula, the variables, and17 18 and empty cells to display the results.19 20 <21 22 23 Mon 07-Mar-88 2:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T<<<<<<2am zf JHPN  ;NO CHANGE!+zNc2 POINTEnter Input cell 1: c2..c2L E a b c d e f g 1 Loan amount $11,0 Interest Payment 2 Annual interest  12% @PMT(b1,c2/1 3 Months to repay  48 8%& 4  9%& 5 Monthly payment $289.67 10%& 6  11%& 7  12%& 8  13%& 9 10 11 Then, you must define the input cell.12 13 )14 15 .16 17 After entering the input cell and pressing18 19 Return, "What If?" analysis is performed.20 21 .22 23 Mon 07-Mar-88 2:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T )))..... 2am f5 JHPN   ONO CHANGE!+Nc2 READY a b c d e f g 1 Loan amount $11,0 Interest Payment 2 Annual interest 12% @PMT(b1,c2/1 3 Months to repay 48 8% $268.54 4' 9% $273.74 5 Monthly payment $289.67 10% $278.99 6& 11% $284.30 7& 12% $289.67 8& 13% $295.10 9 10 11 12 13 14 15 16 17 18 19N 20N 21N 22N 23N Mon 07-Mar-88 2:39 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  4NO CHANGE!N!c2 READY a b c d e f g 1 Loan amount $11,0 Interest Payment 2 Annual interest 12% @PMT(b1,c2/1 3 Months to repay 48 8% $268.54 4' 9% $273.74 5 Monthly payment $289.67 10% $278.99 6& 11% $284.30 7& 12% $289.67 8& 13% $295.10 9  10  11 12  13 , 14 And monthly payments for the different 15 , 16 interest rates have been calculated. 17 , 18 If you wish, you can put in new interest 19 , 20 rates and perform "What If?" analysis 21 , 22 using the new variables. 23 , Mon 07-Mar-88 2:39 PM , Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T 2am Ke JHPN  &NO CHANGE!+KN+Introduction to "What If?" Analysis and Goal SeekingP;Now let's look at another example.Let's say you want to vary the months to repayas well as the interest rate. In other words,what would your monthly payment be if ..the interest rate is 8% and you repay in 24 months?.the interest rate is 9% and you repay in 36 months?For this example, you must create aa two-input-cell data table.;4P[ 2am g% JHPN   NO CHANGE!+Nh9 POINTDefine first input cell.Define second input cell.  b c d  f  g h i 1 Interest Pay ent   2 $11,0( 3 12% @PMT(b2,e2/1 24 36 48   4 48 8%   5 9%   6 $289.67  10%   7  11%   8  12%   9  13%   10 11 12 Define tableList first setList second set13 14 range.of variables.of variables.15 16 17 218 19 Like the one-input-cell data table, create the20 21 data table, only this time, use two variables.22 23 2TUP -115-Jan-00 -7:-35 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph %.  00000002am f/ JHPN   ONO CHANGE!+Nd3 (T) [W12] @PMT(b2,e2/12,f2) READY a b c d e f g 1' Interest Payment 2 Loan amount $11,02 3 Annual interest 12% @PMT(b2,e2/1 24 36 48 4 Months to repay  48 8% 50 9% 6 Monthly payment $289.67 10% 7/ 11% 8/ 12% 9/ 13% 10 11 12 13 14 15 16 17 18 19 20 21 22 23  -115-Jan-00 -7:-35 AM8 Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!Nd3 (T) [W12] @PMT(b2,e2/12,f2) READY a b c d e f g 1' Interest Payment 2 Loan amount $11,02 3 Annual interest 12% @PMT(b2,e2/1 24 36 48 4 Months to repay 48 8% $497.50 $344.70 $268.54 50 9% $502.53 $349.80 $273.74 6 Monthly payment $289.67 10% $507.59 $354.94 $278.99 7/ 11% $512.69 $360.13 $284.30 8/ 12% $517.81 $365.36 $289.67 9/ 13% $522.96 $370.63 $295.10 10 11 12 *13 14 And monthly payments are calculated15 16 for the different interest rates under17 18 different monthly terms.19 20 *21 22 23  -115-Jan-00 -7:-35 AM8 Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  2am e JHPN  NO CHANGE!+NIntroductionto"WhatIf?"AnalysisandGoalSeekingP2For example, you need an $11,0 loan.What would your monthly payment be if .. the interest rate is 8%?. the interest rate is 9%?. the interest rate is 10%?. and so on.The Data/Table command helps you findanswers to these "What If?" questions.2 PC ]2am f JHPN  JNO CHANGE!+Nb5 (C2) @PMT(b1,b2/12,b3) READYu ' a b c' 1 Loan amount $11,0  Let's take a look at this example. 2 Annual interest 12% ' 3 Months to repay 48  You have a loan for $11,0 and you 4$ ' 5 Monthly payment $289.67  have 48 months to repay it. At the 6$ ' 7$ current interest rate of 12%, your 8$ ' 9 monthly payment is $289.67. 10 ' 11 ' 12  13  14  15  16  17  18  19  20  21  22N 23N Mon 07-Mar-88 2:34 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph %''''' ''''''2am hd  JHPN  &NO CHANGE!+hNHIntroduction to "What If?" Analysis and Goal SeekingP'You can perform "What If?" analysisto see how different interest rateswill affect your monthly payments.To perform "What If?" analysis,you need to create a data table.'4P, :2am f JHPN  6NO CHANGE!+Nb5 (C2) @PMT(b1,c2/12,b3) READY a b c d e f g 1 Loan amount $11,0InterestPayment 2 Annual interest 12% @PMT(b1,c2/1  3 Months to repay 48  8%  4  9%  5 Monthly payment $289.67  10%  6  11%  7  12%  8  13%  9  10  11 12 13  14 This is a data table. It15 16 consists of a set of17 18 variables and a formula.19 20 21 22 23 Mon 07-Mar-88 2:34 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T2am h JHPN  NO CHANGE!+Nb5 (C2) @PMT(b1,c2/12,b3)%READY a b c d e f g 1 Loan amount $11,0 Interest Payment  2 Annual interest 12% @PMT(b1,c2/1  3 Months to repay 48 8%   4' 9%   5 Monthly payment $289.67 10%   6 11% 7 12% 8 13% 9  10   11  12 The first column contains The second column contains 13  14 the set of variables that the formula that calculates 15 16 are used in the formula.different results using 17 18 Here, the variables areeach of the variables.19 20 the interest rates.Let's take a closer look at21 22 this formula.23 Mon 07-Mar-88 2:34 PM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  2am e  JHPN  NO CHANGE!+NIntroduction to "What If?" Analysis and Goal SeekingPThis formula calculates the monthly payment. @PMT(b1,c2/12,b3)4P,(( 9NO CHANGE!NIntroduction to "What If?" Analysis and Goal SeekingPThisformulacalculatesthemonthlypayment. @PMT(b1,c2/12,b3)Cell b1 containsCell b3 contains the  the loan amount.months to repay. Cell c2 is called the input cell.The input cell contains the variable,which is the interest rate. Eachinterest rate is substituted intocell c2 and the monthly payment iscalculated for each interest rate.4P ((  %%%%%%%%%%2am Tf JHPN  =NO CHANGE!+TNd2@PMT(b1,c2/12,b3)MENU FillTableSortQueryDistributionMatrixRegressionParseCreateatable  a b c d e f g 1 Loanamount $11,0 Interest Payment 2 Annual interest 12% @PMT(b1,c2/1 3 Months to repay 48 8%& 4' 9%& 5 Monthly payment $289.67 10%& 6& 11%& 7& 12%& 8& 13%& 9O 10N 11 12 ,13 14 To create a data table, you would select15 16 the Data/Table command.17 18 ,19 20 21 22 23 Mon 07-Mar-88 2:34 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph K (2am f JHPN  -NO CHANGE!+Nd2 @PMT(b1,c2/12,b3) MENU 1 2 ResetE ne input cell, one or more dependent formulas" a b c d e f g  Loan amount $11,0 Interest Payment 2 Annual interest 12% @PMT(b1,c2/1 3 Months to repay 48 8%& 4' 9%& 5 Monthly payment $289.67 10%& 6& 11%& 7& 12%& 8& 13%& 9 10 11 :12 13 A data table can have one variable (one input cell),14 15 or two var iables (two input cells). For this example, 16 17 you will create a one-input-cell data table.18 19 :20 21 22 23 Mon 07-Mar-88 2:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table   Calc  Graph -O 2am de JHPN  NO CHANGE!+N`Question Introductionto"WhatIf?"AnalysisandGoalSeekingP MThe Data/Table command is used toUCLHTF1 - perform goal seekingOIF2 - perform "What If?" analysisIPF3 - calculate frequency distributionsCLF4 - None of the aboveEE(Select your answer by pressing one of the indicated selections) P)$$g&&&&&&& 2am c P Gadvanc>g>Rev.1 Gadvanc>g>Rev.27Gadvanc>g>Rev.3NNadvanc>menu2am e JHPN  ONO CHANGE!+NxIntroductionto"WhatIf?"AnalysisandGoalSeekingP The Data/Table command is used toF1 - perform goal seeking F2 - perform "What If?" analysisF3 - calculate frequency distributionsF4 - None of the above"Correct. The Data/Table command isused to perform "What If?" analysis. ( P)$$g &&&&&&  ((((( 2am !c P Gadvanc>g>MC4.incorrect(!Ladvanc>g>MC4.common.path2am !c P Gadvanc>g>MC4.correct&!Ladvanc>g>MC4.common.path2am !c P Gadvanc>g>MC4.incorrect(!Ladvanc>g>MC4.common.path2am !c P Gadvanc>g>MC4.incorrect(!Ladvanc>g>MC4.common.path 2am Oe JHPN  NO CHANGE!+ONIntroductionto"WhatIf?"AnalysisandGoalSeekingP The Data/Table command is used toF1 - perform goal seeking"F2 - perform "What If?" analysis"F3 - calculate frequency distributionsF4 - None of the above0That's incorrect. The correct answer is F2.The Data/Table command is used to perform"What If?" analysis.0 P)$$g !!!&&&00000002am +c N + F1  F2  F3  F4 2am c9 JHPN  NO CHANGE!+N9;I T ' S T I M E T O S E EW H A T Y O U H A V E L E A R N E D . . .;.33332am e  JHPN  ONO CHANGE!+N'! ONO CHANGE!NHIntroduction to "What If?" Analysis and Goal Seeking5"What If?" analysis involves changingone or two variables, seeing how itaffects the results, changing thevariables, seeing how it affects theޫ'results again, and so on.!To perform "What If?" analysis, use theData/Table command.The data table contains one or twosets of variables and a formula thatuses the variables to calculatedifferent end results.45X M2am {e JHPN  ONO CHANGE!+{N>Introduction to "What If?" Analysis and Goal Seeking5Goal seeking analysis is a way ofdetermining what you need to do in orderto reach a specific goal.'To perform goal seeking analysis, usethe Advanced/Goal-Seeking command.!Goal seeking uses a variable cell and atarget cell. The variable cell containsthe value that gets adjusted until thegoal is reached. The target cell containsthe goal.45V   2am lf JHPN  NO CHANGE!+lNIntroductionto"WhatIf?"AnalysisandGoalSeeking5Goal seeking analysisisawayofdeterminingwhatyouneedtodoinordertoreachaspecificgoal.Youhavereachedtheendofthislesson.To perform goal seeking analysis,useWesuggestyouproceedtheAdvanced/Goal-Seekingcommand.tothenextlesson,Introduction to Macros.Goalseekingusesavariable cellandaPressNextPagetoreturntarget cell.ThevariablecellcontainstotheAdvancmenu.thevaluethatgetsadjusteduntilthegoalisreached.Thetargetcellcontainsthegoal. 55 5555555   55555  5   555555555 2am d JHPN  <NO CHANGE!+NIntroductiontoMacrosPR)Note that for demonstration purposes,the macro was played back at aslower-than-normal speed. Macros areplayed back at a much faster speed.) Pp2am mg JHPN  ONO CHANGE!+N  @ MNO CHANGE!_MNa18D RCD READY a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $609.00 $234.00 $159.00 $1,002.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee( $198.00 15 16 317 3 18 {GOTO}d5~  Play back the macro named "e".19 587{DOWN}    20 36/{BS}~/  To start the playback, firstpressF1 .21 c~{RIGHT}    22 .{RIGHT}~ 323 {DOWN}75~ Tue01-Mar-884:49PM, Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T FNO CHANGE!ZNa18D RCD READY a b c d e f  g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $609.00 $234.00 $159.00 $1,002.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee( $198.00 15 *16 17 Then, typee, and watch your18 {GOTO}d5~ 19 587{DOWN} worksheet as it gets automatically20 36/{BS}~/ 21 c~{RIGHT} updated.22 .{RIGHT}~ 23  {DOWN}75~ *Tue01-Mar-884:49PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T "#% 2 NO CHANGE!D Na18D RCD EDIT Enter address to go to: d5 a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air  , rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $609.00 $234.00 $159.00 $1,002.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee( $198.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T NO CHANGE!Nd5 (C2) [W12] 4505 RCD VALUE587 a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $609.00 $234.00 $159.00 $1,002.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee( $198.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!Nd6 (C2) [W12] 456 RCD VALUE36 a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $746.00 $234.00 $159.00 $1,139.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee) $61.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!N d6 (C2) [W12] 366 RCD READY a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $45.00 $45.00 $126.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $737.00 $234.00 $159.00 $1,130.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee) $70.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T M ZNO CHANGE!l1Nd6 (C2) [W12] 366 RCD 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 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $45.00 $45.00 $126.00 7 D  aily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $737.00 $234.00 $159.00 $1,130.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee) $70.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!NGd6 (C2) [W12] 366 RCD POINTEnter range to copy FROM: d6..d6 Enter range to copy TO: d6j a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $45.00 $45.00 $126.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $737.00 $234.00 $159.00 $1,130.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee) $70.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T " "NO CHANGE!"NGe6 (C2) [W12] 456 RCD POINTEnter range to copy FROM: d6..d6 Enter range to copy TO: e6j a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $45.00 $45.00 $126.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $737.00 $234.00 $159.00 $1,130.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee) $70.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T & &NO CHANGE!&NKf6 (C2) [W12] 456 RCD POINTEnter range to copy FROM: d6..d6 Enter range to copy TO: e6..f6f a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $45.00 $45.00 $126.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $737.00 $234.00 $159.00 $1,130.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee) $70.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T* *NO CHANGE!*Nd7 (C2) [W12] 896 RCD VALUE75 a b c d  e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $36.00 $36.00 $108.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00!  8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $737.00 $225.00 $150.00 $1,112.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee) $88.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T l. y.NO CHANGE!.2Nd7 (C2) [W12] 756 RCD 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 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $36.00 $36.00 $108.00 7 Daily lodging $75.00 $89.00 $89.00 $253.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $723.00 $225.00 $150.00 $1,098.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee( $102.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2 2NO CHANGE!2NHd7 (C2) [W12] 756 RCD POINTEnter range to copy FROM: d7..d7 Enter range to copy TO: d7j a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $36.00 $36.00 $108.00 7 Daily lodging $75.00 $89.00 $89.00 $253.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $723.00 $225.00 $150.00 $1,098.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee( $102.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 6 6NO CHANGE!6NHe7 (C2) [W12] 896 RCD POINTEnter range to copy FROM: d7..d7 Enter range to copy TO: e7j a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $36.00 $36.00 $108.00 7 Daily lodging $75.00 $89.00 $89.00 $253.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $723.00 $225.00 $150.00 $1,098.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee( $102.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T : :NO CHANGE!:NLf7 (C2) [W12] 896 RCD POINTEnter range to copy FROM: d7..d7 Enter range to copy TO: e7..f7f a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car ! $36.00 $36.00 $36.00 $108.00 7 Daily lodging $75.00 $89.00 $89.00 $253.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $723.00 $225.00 $150.00 $1,098.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee( $102.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T> >NO CHANGE!>Nd8 (C2) [W12] 256 RCD VALUE35 a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $36.00 $36.00 $108.00 7 Daily lodging $75.00 $75.00 $75.00 $225.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $723.00 $211.00 $136.00 $1,070.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee( $130.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T B BNO CHANGE!B2Nd8 (C2) [W12] 356 RCD 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 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $36.00 $36.00 $108.00 7 Daily lodging $75.00 $75.00 $75.00 $225.00 8 Meals $35.00 $25.00 $25.00 $85.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $733.00 $211.00 $136.00 $1,080.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee( $120.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T F FNO CHANGE!GN e8 (C2) [W12] 256 RCD READY a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $36.00 $36.00 $108.00 7 Daily lodging $75.00 $75.00 $75.00 $225.00 8 Meals $35.00 $25.00 $25.00 $85.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $733.00 $211.00 $136.00 $1,080.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee( $120.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T J JNO CHANGE!JNe8 (C2) [W12] 256 RCD VALUE20 a b c  d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $36.00 $36.00 $108.00 7 Daily lodging $75.00 $75.00 $75.00 $22" 5.00 8 Meals $35.00 $25.00 $25.00 $85.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $733.00 $211.00 $136.00 $1,080.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee( $120.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T qN ~NNO CHANGE!NN f8 (C2) [W12] 256 RCD READY a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $36.00 $36.00 $108.00 7 Daily lodging $75.00 $75.00 $75.00 $225.00 8 Meals $35.00 $20.00 $25.00 $80.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $733.00 $206.00 $136.00 $1,075.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee( $125.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 8R ERNO CHANGE!WRNf8 (C2) [W12] 256 RCD VALUE40 a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $36.00 $36.00 $108.00 7 Daily lodging $75.00 $75.00 $75.00 $225.00 8 Meals $35.00 $20.00 $25.00 $80.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $733.00 $206.00 $136.00 $1,075.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee( $125.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T V VNO CHANGE! VNd9E RCD VALUE50 a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $36.00 $36.00 $108.00 7 Daily lodging $75.00 $75.00 $75.00 $225.00 8 Meals $35.00 $20.00 $40.00 $95.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $733.00 $206.00 $151.00 $1,090.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee( $110.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T Y  KYNO CHANGE!YNd9(C2) [W12] 50RCD VALUE a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $36.00 $36.00 $108.00 7 Daily lodging $75.00 $75.00 $75.00 $225.00 8 Meals $35.00 $20.00 $40.00 $95.00 9 Entertainment $50.00 $75.00 $125.00 10 K- 11 Total Expenses $783.00 $206.00 $151.00 $1,140.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14"  Balance Due From Employee) $60.00 15N 16N 17N 18 {GOTO}d5~C 19 587{DOWN}C 20 36/{BS}~/C 21 c~{RIGHT}C 22 .{RIGHT}~C 23 {DOWN}75~C Tue01-Mar-884:49PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ]  ]NO CHANGE!]mNd9(C2) [W12] 50RCD VALUE a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $36.00 $36.00 $108.00 7 Daily lodging $75.00 $75.00 $75.00 $225.00 8 Meals $35.00 $20.00 $40.00 $95.00 9 Entertainment $50.00 $75.00 $125.00 10 K- 11 Total Expenses $783.00 $206.00 $151.00 $1,140.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee) $60.00 15 16 17 And the expense values in your worksheet18 {GOTO}d5~ 19 587{DOWN} have been automatically updated.20 36/{BS}~/ 21 c~{RIGHT} (Press Next Page to continue)22 .{RIGHT}~ 23 {DOWN}75~ Tue01-Mar-884:49PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2(((222time  F1 e e time time time time time time time time time time time time time time time time time time time time time time2am e JHPN   8NO CHANGE!+N`Introduction to DatabasesP8Adatabaseisanycollectionofrelatedinformation.8! C & M Sporting Goods InventoryList. or a listingof some sort.Prod# Description CostQty 10Volleyball$36201001Basketball$25351002Soccerball$401220Tennis Rqt$79202001Squash Rqt$35142002RqtBall Rqt$392640Kayak$25054001Surfboard$400810Aerobic Shoes $4560101Ski boots$16040 .!P:::::YB# 2am dX JHPN  NO CHANGE!+NIntroduction to DatabasesP=A database worksheet-is extremely useful for organizing large quantitiesof information- eliminates the task of manually looking up information- makes it easy for you to find information that matchescertain criteria-provides convenient ways to add and remove information=I2am d JHPN  FNO CHANGE!+NIntroduction to DatabasesP>Creating a database worksheet is no different fromcreating any other worksheet, such as your expense report.Labels and values are entered in the same way.>Pp2am zd JHPN   NO CHANGE!+zNRIntroduction to DatabasesPA What distinguishes a database from other worksheets, however, is its unique organization.A database is a collection of records.Each record contains information organizedunder specific headings.A'PR02am h JHPN  INO CHANGE!+N~a1 #Y* * For example, this is a database a b c 1 XYZ Company that consists of employee 2 Employee Listing 3) records for the XYZ Company.4 SortNo EmpNo LastName Fi5 514 Smith Miche#6 230 Dold Cathy 215 3785500 PA 7 164 Smith Ron 404 2632125 GA 8 748 Bennett Charles 214 7552288 TX 9 265 Johnson Clarence 313 5610300 MI 10 438 Green Larr# y 714 27890 CA 11 826 Gurewitz Carla 808 4341234 HI 12 194 Rhodes John 919 9512366 NC 13 871 Speck Joe 513 3664667 OH 14 814 Johnson Corinne 201 3520990 NJ 15 161 White Steve 714 27890 CA 16 581 Carter Joe 313 5610300 MI 17 434 Davis Arnold 305 3932848 FL 18 529 Davenport Alex 312 7931851 IL 19 342 Young Russ 408 4341234 15 20 231 O'Connor Kacie 714 27890 CA 21 475 Monaghan Ed 513 3664667 OH 22 648 Crosby Sue 214 7552288 TX 23 624 Clark Tom 201 3520990 NJ Fri 04-Mar-88 11:44 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph (2am h JHPN  -NO CHANGE!+ N\a1 READY a b c d e f g h 1 XYZ Company- 2 Employee Listing* 3O 4 SortNo EmpNo LastName FirstName Area Phone MailStop 5 514 Smith Michelle 408 4341234 15  6 230 Dold Cathy 215 3785500 PA 7  164 Smith Ron 404 2632125 GA 8  748 Bennett Charles 214 7552288 TX 9  265 Johnson Clarence 313 5610300 MI 10  438 Green Larry 714 27890 CA 11  826 Gurewitz Carla 808 4341234 HI 12 " 919 9512366 NC 13  513 3664667 OH 14 Each row contains an employee record. 201 3520990 NJ 15  714 27890 CA 16 ) 313 5610300 MI 17 434 Davis Arnold 305 3932848 FL 18 529 Davenport Alex 312 7931851 IL 19 342 Young Russ 408 4341234 15 20 231 O'Connor Kacie 714 27890 CA 21 475 Monaghan Ed 513 3664667 OH 22 648 Crosby Sue 214 7552288 TX  23 624 Clark Tom 201 3520990 NJ Fri 04-Mar-88 11:44 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]))) 2am h JHPN   ENO CHANGE!+ Na1 READY a b c d e f g h 1 XYZ Company- 2 Employee Listing* 3O 4 SortNo EmpNo LastName FirstName Area Phone MailStop 5  514 Smith  Michell 48 434234 15  6 230 Dold  Cathy  25 378500 PA  7     8  9 Record information is organized under several headings. 10 11 ; 12 194 Rhodes John 919 9512366 $ NC 13 871 Speck Joe 513 3664667 OH 14 814 Johnson Corinne 201 3520990 NJ 15 161 White Steve 714 27890 CA 16 581 Carter Joe 313 5610300 MI 17 434 Davis Arnold 305 3932848 FL 18 529 Davenport Alex 312 7931851 IL 19 342 Young Russ 408 4341234 15 20 231 O'Connor Kacie 714 27890 CA 21 475 Monaghan Ed 513 3664667 OH 22 648 Crosby Sue 214 7552288 TX 23 624 Clark Tom 201 3520990 NJ Fri 04-Mar-88 11:44 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]E    ;;;2222222222222am pd JHPN  ANO CHANGE!+pNHIntroduction to DatabasesP4Recordheadings,alsocalledfields, play animportantrolewhenyouwant to use,orquery,thedatabase.However, we'll talk about that later.First let's talk about how to create a database.4>P^+2am dn JHPN   ONO CHANGE!+NQuestion Introduction to MacrosP How do you play back a macro?M UCLF1 - Type in the one-letter character name,Hthen press Go.TOF2 - Press the Macro key (F1), then type Ithe one-character macro name.IPF3 - Select the Advanced/Macro command.CLF4 - None of the aboveEE(Select your answer by pressing one of the indicated selections)P'&&+++++++2am c P Gadvanc>m>Rev.1 Gadvanc>m>Rev.27Gadvanc>m>Rev.3NGadvanc>m>Rev.4eNadvanc>menu$ 2am oe JHPN  HNO CHANGE!+oNIntroduction to MacrosP How do you play back a macro? *F1 - Type in the one-letter character name,then press Go.F2 - Press the Macro key (F1), then type the one-character macro name.F3 - Select the Advanced/Macro command.F4 - None of the above <Very good. The correct answer is F2. To play back a macro, pressthe Macro (F1) function key, then type the one-character macro name.HP'&&++++++'&& HHHHH2am !c P Gadvanc>m>mc3.incorrect(!Ladvanc>m>mc3.common.path2am !c P Gadvanc>m>mc3.correct&!Ladvanc>m>mc3.common.path2am !c%  P Gadvanc>m>mc3.f3inc$!Ladvanc>m>mc3.common.path2am !c P Gadvanc>m>mc3.incorrect(!Ladvanc>m>mc3.common.path2am eW JHPN   NO CHANGE!+NPIntroduction to MacrosP How do you play back a macro? *F1 - Type in the one-letter character name,then press Go.*F2 - Press the Macro key (F1), then type the one-character macro name.*F3 - Select the Advanced/Macro commandF4 - None of the aboveActually, F3 is a trick answer. There is no suchSorry, that's not right. command named Advanced/Macro.The correct answer is F2.However, there is a commandnamedAdvanced/Record-Macro.P'&&++))))&2am je JHPN  NO CHANGE!+jNIntroduction to MacrosP How do you play back a macro? *F1 - Type in the one-letter character name,then press Go.*F2 - Press the Macro key (F1), then type the one-character macro name.*F3 - Select the Advanced/Macro commandF4 - None of the aboveNSorry, that's not right. The correct answer is F2. To play back a macro, press the Macro (F1) function key, then type the one-character macro na% me.NP'&&++))))&&&NNNNN2am +c N + F1  F2  F3  F4 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 fileHeaders.sysmfd.syslog.sys sysImage.sys badBlk.sys crashDump.sysOCID>?@@ & SD-7monetcCofg;!F!ysQSD: 9|M^SysSD: 9{EfileHeaders.sys Sys3^of^of^ofvvmfd.sys Sys3`of`of<fɨlog.sysSysbofbofbofa sysImage.sysSyseofeofeofф badBlk.sysSysgofgofgof& f crashDump.sysSysiofiofiofd advanc>d>cr.1 sd3>8wffXf4 advanc>d>cr.2 sd3@@wffXft  H advanc>d>cr.3 sd 3BIwffXf   advanc>d>cr.4 sd 3DQwffXf&I advanc>d>cr.5 sd 3FYwf fYf. advanc>D>d.9 sd 3JPfTfsfN(/ advanc>D>d.8 sd 3HHfMfsfF' E advanc>d>d.7 sd3F$f'f'f> ] advanc>d>d.6 sd3D$f$f$f6 advanc>d>d.5 sd3B$f"f"fH  advanc>d>d.4 sd3@$fffV~  advanc>d>d.3 sd3>$fffdv  advanc>d>d.2 sd3<$fffxp  B advanc>d>d.1 sd3:$fffl Eadvanc>o>link.6 sd3FfŜfPf' advanc>o>move.3 sd3BҜffPfadvanc>o>move.2 sd3@̜ffPfadvanc>o>move.1 sd3>ƜffPfadvanc>g>fib1.a000sdFfffHadvanc>g>fib3.a002 etsd3BUgUgg JUadvanc>d>fib6sdNfff]advanc>d>fib10sd#Bfff Radvanc>o>wid.4 sd3Nf f f( advanc>o>wid.3 sd3Lf fnQfƮadvanc>o>wid.2 sd3JfflQfA advanc>o>wid.1 sd 3HݜffhQfȱ! advanc>d>f.1 sd!3PwffYfG" advanc>d>f.2 sd"3RwffYf$~# advanc>d>f.3 sd#3:wff.Yf`$ advanc>d>f.4 sd$3<wff7Yf}G% advanc>d>f.5 sd%3>wffd>f.6 sd&3@wffCYfO3' advanc>d>f.7 sd'3Bxf܅fKYf( advanc>d>FIB7 sd(3Pxfff_)advanc>d>FIB7.a000 sd)3N xffy[f+}*advanc>d>FIB7.A000.Path sd*3<xff~[fF!3+advanc>d>FIB7.a999 sd+3<xff[fh,advanc>d>FIB7.A999.Path sd,3Fxff[fF-advanc>d>FIB7.answers sd-3H%xf)xf[f() 5.advanc>d>FIB7.common.path sd.3D*xff\fN o/advanc>o>link.5 sd/3DffPfxF 0advanc>o>link.4 sd03BffPf`Vj 1advanc>o>link.3 sd13@ffPfl2 advanc>d>mc1 sd23@Axff|Yf\3advanc>d>mc3.common.path sd33<fɛfOZf8\ "  4advanc>d>mc1.correct sd43HLxffoYf6&:5advanc>d>mc1.F001.Path sd53@SxffsYfG,) Us6advanc>d>mc1.F002.Path sd63RXxfofYfI0f^7advanc>d>mc1.F003.Path sd73P^xff1tfI4(e8advanc>d>mc1.F004.Path sd83HdxffVsfI8h9advanc>d>mc1.incorrect sd93DjxffYfj<^+:advanc>d>mc1.legend sd:3JpxftxfzYf4Bɻ; advanc>d>mc3 sd;3Dxxf fYfF<advanc>d>mc4.common.path sd<3J#fϛf[f{d =advanc>d>mc3.correct sd=3:xf fYfN* >advanc>d>MC3.F001.Path sd>3RxfxfntfIT}?advanc>d>mc3.f002.path sd?3JxfxfYfGX8@advanc>d>MC3.F003.Path sd@3HxfxfYfI\&Aadvanc>d>MC3.F004.Path sdA3@xfxfArfI`^nBadvanc>d>mc3.incorrect sdB3<xffYfcdKCadvanc>d>MC3.legend sdC3@xfxfYf4jD advanc>d>mc4 sdD3FxffLZfnTXEadvanc>initial.path sdE3<fEqfqft* ϝFadvanc>d>mc4.correct sdF3PxffSZfxOGadvanc>d>MC4.F001.Path sdG3NxffCZfI~Hadvanc>d>MC4.F002.Path sdH3FxffYZfGy|Iadvanc>d>MC4.F003.Path sdI3>xf'fqfI|Jadvanc>d>MC4.F004.Path sdJ3<xffqfI=5Kadvanc>d>mc4.incorrect sdK3Rxf#f=Zf|6Ladvanc>d>MC4.legend sdL3RxffJZf4M advanc>d>o.1 sdM3RxfHfHf+ N advanc>d>o.10 sdN3Jxf`f`fl!O advanc>d>o.11 sdO3Lxfxfsfl0P advanc>d>o.2 sdP3:xfJfJfoVQ advanc>d>o.3 sdQ3<xfMfMfFR advanc>d>o.4 sdR3>yfPfPf~S advanc>d>o.5 sdS3@yfSfSf9T advanc>d>o.6 sdT3ByfUfUfZjKU advanc>d>o.7 sdU3DyfXfXfE+ V advanc>d>o.8 sdV3Fyf[f[f` dpW advanc>d>o.9 sdW3Hyf^f^f8X advanc>d>q.1 sdX3N%yfcfcfiY advanc>d>q.10 sdY3J,yf{f{foRZ advanc>d>q.11 sdZ3L3yf~f~f d 4[ advanc>d>q.12 sd[3N:yfff\ advanc>d>q.2 sd\3PAyfefefz ] advanc>d>q.3 sd]3RFyfhfhf, ^ advanc>d>q.4 sd^3:Kyfjfjf \_ advanc>d>q.5 sd_3<Pyfmfmf1 =` advanc>d>q.6 sd`3>WyfpfpfM(~a advanc>d>q.7 sda3@\yfsfsf 0qb advanc>d>q.8 sdb3Bbyfufuf8\c advanc>d>q.9 sdc3Dgyfxfxf@-dadvanc>d>qseg1 sdd3Fnyfryf\fH$eadvanc>d>qseg2 sde3Htyfvyf`[fL, fadvanc>d>rev.1 sdf3Fxyfff=Pgadvanc>d>rev.2 sdg3H~yfffWVnhadvanc>d>rev.3 sdh3Jyfff\xtiadvanc>d>rev.4 sdi3Lyfffb j advanc>d>s.1 sdj3JyfffShk advanc>d>s.2 sdk3Lyfffsl{l advanc>d>s.3 sdl3Nyffftm advanc>d>s.4 sdm3Pyfffv|- n advanc>d>s.5 sdn3RyfffXwo advanc>d>s.6 sdo3:yfff drp advanc>d>s.7 sdp3<yfff BMq advanc>d>s.8 sdq3>yfff+ 3{r advanc>d>s.9 sdr3@yfffs advanc>d>TF9 sds3Ryf(f\fvtadvanc>d>TF9.common.path sdt3Jyfԛf^fR~uadvanc>d>TF9.F001.Path sdu3Ryfyf\fD- \vadvanc>d>TF9.F002.Path sdv3Jyfyf\fE,wadvanc>d>TF9.false sdw3Jyf-f\fsxadvanc>d>TF9.legend sdx3<yfyf\f*pyadvanc>d>TF9.true sdy3Jyf3f\fxz advanc>G>FIB3 sdz3Pyf Ugg2{advanc>G>FIB3.a000 sd{3<yfUgg |advanc>G>FIB3.A000.Path sd|3@yfTggF}advanc>G>FIB3.a999 sd}3DyfUg g. ~advanc>G>FIB3.A999.Path sd~3Jzf Ug gFadvanc>G>FIB3.answers sd3DzfUg gDmadvanc>G>FIB3.common.path sd3@ zfUg gW advanc>G>g.1 sd3:zfDggg7w advanc>G>g.10 sd3RzfGgg+$ advanc>G>g.11 sd3:zfLggل advanc>G>g.12 sd3<$zfQgg advanc>G>g.13 sd3>)zfVgg. U advanc>G>g.14 sd3@.zf\ggVi advanc>G>g.2 sd3<5zfJggzf advanc>G>g.3 sd3>;zfOggy advanc>G>g.4 sd3@?zfSgg  advanc>G>g.5 sd3BFzfYgg& advanc>G>g.6 sd3DLzf^gg, advanc>G>g.7 sd3FRzfagg2` advanc>G>g.8 sd3HWzfcggp8/ w advanc>G>g.9 sd3J]zffgg%>Padvanc>o>link.2 sd3>ffPf81advanc>o>link.1 sd3<ffPfY advanc>G>if.1 sd3PnzfogxgNMEadvanc>G>if.10 sd3<szfggR<advanc>G>if.11 sd3>yzfggZ%advanc>G>if.12 sd3@~zfgg` ͕advanc>G>if.13 sd3Bzfggvj/ hadvanc>G>if.14 sd3Dzfggp廗advanc>G>if.15 sd3Fzfggx ; advanc>G>if.2 sd3Rzfqgyg@){ advanc>G>if.3 sd3:zfsg{g advanc>G>if.4 sd3<zfvg|g z advanc>G>if.5 sd3>zfyg}g advanc>G>if.6 sd3@zf{g~gJ禝 advanc>G>if.7 sd3Bzf~gg0 ױ advanc>G>if.8 sd3Dzfgg advanc>G>if.9 sd3Fzfgg advanc>G>MC4 sd3Lzff gdjadvanc>G>MC4.common.path sd3Dzf f fbvadvanc>G>MC4.correct sd3@zfffCadvanc>G>MC4.F001.Path sd3:zfffIadvanc>G>MC4.F002.Path sd3Lzf!f!fGadvanc>G>MC4.F003.Path sd3JzfffI0 advanc>G>MC4.F004.Path sd3BzfffIͧadvanc>G>MC4.incorrect sd3>zfffz{advanc>G>MC4.legend sd3Hzff g4&advanc>G>qseg1 sd3@{f{fgadvanc>G>rev.1 sd3@{f?fN`fadvanc>G>rev.2 sd3B {fDfc`fadvanc>G>rev.3 sd3D{fIfr`f䟭 advanc>M>E sd3D{f{fNgD1 Ϯ advanc>M>eg sd3J{fUfMgbd?Aadvanc>M>EG.pedal sd3R"{fMfMg}Xްadvanc>o>dflt.16 sd3PffaQfladvanc>o>dflt.15 sd3Nff_Qff\q advanc>o>i.2 sd3Ff`g`gol advanc>o>i.1 sd3Df]g]g8.advanc>o>dflt.18 sd3:ffeQfzâadvanc>o>dflt.17 sd3RffdQf3r1 advanc>o>dflt.14 sd3Lzff^QfD^ advanc>o>dflt.13 sd3Juff[QfX¸advanc>o>dflt.12 sd3HnffXQfRd advanc>M>MC3 sd3<V{fUf^g h ̺advanc>M>mc3.common.path sd3D\{f{f2bfy20advanc>M>MC3.correct sd3Ja{f[fafƼadvanc>M>mc3.F001.Path sd3Pg{fj{fbgI/advanc>M>mc3.F002.Path sd3Hl{fo{fafG2  advanc>M>mc3.F003.Path sd3Fp{ft{fafEǀadvanc>M>mc3.F004.Path sd3>u{fx{frfID7advanc>M>mc3.f3inc sd3Rz{f`faf advanc>M>mc3.incorrect sd3:{fefagxadvanc>M>mc3.legend sd3<{f{f]g4Tadvanc>M>qseg2 sd3P{f{fPgvadvanc>M>rev.1 sd3H{ffegTfPadvanc>M>rev.2 sd3J{fffgIZ2 YDadvanc>M>rev.3 sd3L{ffhgR` advanc>M>Seg sd3>{f{fHgfO advanc>M>tf2 sd3<{fUgRgn~fadvanc>M>TF2.common.path sd3J{ff_grKUadvanc>M>TF2.F001.Path sd3>{ffZgDvPadvanc>M>TF2.F002.Path sd3P{fffEzadvanc>M>tf2.false sd3H{fff)~hWadvanc>M>TF2.legend sd3J{ffQg*3 advanc>M>tf2.true sd3H{ffXgadvanc>o>dflt.11 sd3FiffTQf-JSadvanc>o>dflt.10 sd3Dcff)Qf<Badvanc>o>dflt.9 sd3B]ff(Qf:Xadvanc>o>dflt.8 sd3@Xff%Qflbadvanc>o>auto.1 sd3>ffPfaDadvanc>o>dflt.1 sd3L/ffQfladvanc>o>auto.4 sd3D*ffPf3 yadvanc>o>auto.3 sd3B&ffPfadvanc>o>auto.2 sd3@ ffPf advanc>m>i.3 sd3Fff@g advanc>m>i.2 sd3D ff?gGadvanc>m>how.6 sd3@ffGg^advanc>m>how.4 sd3<fzfEgYadvanc>o>dflt.7 sd3>Qff"Qfd> advanc>m>i.1 sd3Bff>g4 advanc>m>how.5 sd3>f|fFgwadvanc>m>how.3 sd3:fwfDgadvanc>o>dflt.6 sd3<Kff Qfjadvanc>o>dflt.5 sd3:EffQfTadvanc>o>dflt.4 sd3R?ffQfadvanc>o>dflt.3 sd3P9ffQf#1advanc>o>dflt.2 sd3N4ffQfz6 advanc>O>FIB1 sd3>A|f'fPf4 =advanc>O>fib1.a000 sd3:E|f{f cf":advanc>O>FIB1.A000.Path sd3@K|fN|f cfF&:advanc>O>fib1.a999 sd3BP|ffPf*x=advanc>O>FIB1.A999.Path sd3DV|fY|fPfF.Oadvanc>O>FIB1.answers sd3F[|f_|fPf(2Uadvanc>O>FIB1.common.path sd3F`|fd|fQf6advanc>m>how.2 sd3RftfCg1advanc>m>how.1 sd3PfrfAg)5 \ advanc>g>I.2 sd3Rۛfgwgj advanc>g>I.1 sd3P֛fgugS advanc>d>I.3 sd3NfEfnCfn advanc>d>I.2 sd3LfCfoCf  advanc>d>I.1 sd3JfAfrCfoWadvanc>d>def.9 sd3Hf?f?fcadvanc>d>def.8 sd3Ff<f<fK| advanc>O>MC4 sd3@|ffWef5 advanc>O>MC4.common.path sd3P|f|fefadvanc>O>MC4.correct sd3B|ff^ef~^advanc>O>MC4.F001.Path sd3P|f|fOefIfadvanc>O>MC4.F002.Path sd3H|f|faefGVadvanc>O>MC4.F003.Path sd3F|f|fAsfI]advanc>O>MC4.F004.Path sd3>|f|f rfIMmadvanc>O>MC4.incorrect sd3:|ff6efcadvanc>O>MC4.legend sd3R|f|fUef46 l'advanc>d>def.7 sd3Df:f:f5tadvanc>d>def.6 sd3Bf7f7fDladvanc>d>def.5 sd3@f4f4fhadvanc>O>qseg1 sd3J|f|fPfkadvanc>O>qseg2 sd3L|f|fef37advanc>O>Rev.1 sd3D|fbgbg!advanc>O>Rev.2 sd3F|fegegAadvanc>O>Rev.3 sd3H|fgggge6 advanc>O>Rev.4 sd3J|fjgjgdadvanc>O>Rev.5 sd3L|flglg^ advanc>O>tf2 sd3>|ffQf advanc>O>tf2.common.path sd 3B}fۜfoQfbp advanc>O>TF2.F001.Path sd 3B}f }f QfD Z advanc>O>TF2.F002.Path sd 3B}f}fScfE 1 advanc>O>tf2.false sd 3B}ffIcf x advanc>O>TF2.legend sd 3H}f!}fQf* 7 advanc>O>tf2.true sd3<"}ff Qf  advanc>O>tf3 sd3B*}fff  &advanc>O>TF3.common.path sd3P0}fff advanc>O>TF3.F001.Path sd3>6}fffD$ advanc>O>TF3.F002.Path sd3P;}fffE( advanc>O>tf3.false sd3>@}fff,  advanc>O>TF3.legend sd3FE}fff*2 advanc>O>tf3.true sd3NJ}fff6 7  advanc>d>def.4 sd3>f1f1fAd8advanc>d>def.3 sd3<f/f/f `{advanc>d>def.2 sd3:f,f,fZ advanc>d>def.1 sd3Ryf*flCfFoOCIDsys}f}f{QfR Yadvanc>g>initial.path sd3PfUg g9 Vuadvanc>d>initial.path sd3<fśfsCf advanc>o>initial.path sd3DffPf$ 8 ^advanc>m>initial.path sd3LffWgT advanc>d>mc1.common.path sd3:ffYfX e advanc>m>rev.4 sd 3NffigNZK!advanc>g>fib1sdLfff"advanc>g>FIB3.A002.Path etsd"3PUgUggFLW#$V$%U%&8 T&'S'(R()Q)*P*+ O+, N,- M-.9  L./ K/0J01I12H23G34F45E569 D67C78B89@9:z: advanc>d>f.3#advanc>d>mc3.correct= advanc>d>o.2P advanc>d>q.4^ advanc>d>s.6o advanc>G>g.1 advanc>G>g.11 advanc>G>if.3advanc>G>MC4.F001.Pathadvanc>M>mc3.incorrectadvanc>O>fib1.a000advanc>O>MC4.incorrectadvanc>d>mc1.common.path advanc>d>d.1advanc>d>def.2advanc>m>how.3advanc>o>dflt.5advanc>o>dflt.18 advanc>d>f.4$advanc>d>FIB7.A000.Path*advanc>d>FIB7.a999+advanc>d>mc3.incorrectBadvanc>d>MC4.F004.PathJ advanc>d>o.3Q advanc>d>q.5_ advanc>d>s.7padvanc>d>TF9.legendxadvanc>G>FIB3.a000{ advanc>G>g.12 advanc>G>g.2advanc>G>if.10 advanc>G>if.4 advanc>M>MC3advanc>M>mc3.legend advanc>M>tf2advanc>O>tf2.trueadvanc>d>initial.pathadvanc>d>mc3.common.path3 advanc>d>d.2advanc>initial.pathEadvanc>d>def.3advanc>m>how.4advanc>o>dflt.6advanc>o>link.1 advanc>d>cr.1 advanc>d>f.5%advanc>d>MC4.F003.PathI advanc>d>o.4R advanc>d>q.6` advanc>d>s.8q advanc>G>g.13 advanc>G>g.3advanc>G>if.11 advanc>G>if.5advanc>G>MC4.incorrectadvanc>M>mc3.F004.Path advanc>M>Segadvanc>M>TF2.F001.Path advanc>O>FIB1advanc>O>MC4.F004.Path advanc>O>tf2advanc>O>TF3.F001.Pathadvanc>O>tf3.false advanc>d>d.3advanc>d>def.4advanc>m>how.5advanc>o>auto.1advanc>o>dflt.7advanc>o>link.2advanc>o>move.1:  advanc>d>cr.2 advanc>d>f.6& advanc>d>mc12advanc>d>mc1.F001.Path5advanc>d>MC3.F004.PathAadvanc>d>MC3.legendC advanc>d>o.5S advanc>d>q.7a advanc>d>s.9radvanc>G>FIB3.A000.Path|advanc>G>FIB3.common.path advanc>G>g.14 advanc>G>g.4advanc>G>if.12 advanc>G>if.6advanc>G>MC4.correctadvanc>G>qseg1advanc>G>rev.1advanc>O>FIB1.A000.Path advanc>O>MC4 advanc>d>d.4advanc>d>def.5advanc>m>how.6advanc>o>auto.2advanc>o>dflt.8advanc>o>link.31advanc>o>move.2 advanc>d>cr.3 advanc>d>f.7' advanc>d>o.6T advanc>d>q.8b advanc>G>g.5advanc>G>if.13 advanc>G>if.7advanc>G>MC4.F004.Pathadvanc>G>rev.2advanc>O>fib1.a999advanc>O>MC4.correctadvanc>O>tf2.common.path advanc>O>TF2.F001.Path advanc>O>TF2.F002.Path advanc>O>tf2.false  advanc>O>tf3 advanc>d>d.5advanc>d>def.6 advanc>m>i.1advanc>o>auto.3advanc>o>dflt.9advanc>o>link.40advanc>o>move.3advanc>g>fib3.a002 advanc>d>cr.4 advanc>d>FIB7.common.path.advanc>d>mc1.incorrect9 advanc>d>mc3; advanc>d>o.7U advanc>d>q.9cadvanc>G>FIB3.a999}advanc>G>FIB3.answers advanc>G>g.6advanc>G>if.14 advanc>G>if.8advanc>G>MC4.common.pathadvanc>G>rev.3 advanc>M>Eadvanc>M>mc3.common.pathadvanc>O>FIB1.A999.Pathadvanc>O>Rev.1advanc>o>initial.path advanc>d>d.6advanc>d>def.7 advanc>m>i.2advanc>o>auto.4advanc>o>dflt.10 advanc>o>i.1advanc>o>link.5/ advanc>d>cr.5 advanc>d>FIB7.A999.Path, advanc>d>mc4Dadvanc>d>MC4.F002.PathH advanc>d>o.8Vadvanc>d>qseg1dadvanc>d>rev.1f advanc>G>g.7advanc>G>if.15 advanc>G>if.9advanc>M>mc3.F003.Pathadvanc>O>FIB1.answersadvanc>O>FIB1.common.pathadvanc>O>MC4.F003.Pathadvanc>O>Rev.2advanc>O>TF3.legend advanc>d>d.7advanc>d>def.8 advanc>m>i.3advanc>o>dflt.11 advanc>o>i.2advanc>o>link.6advanc>d>FIB7.answers-advanc>d>mc1.correct4advanc>d>mc1.F004.Path8advanc>d>MC3.F003.Path@ advanc>d>o.9Wadvanc>d>qseg2eadvanc>d>rev.2g advanc>G>g.8advanc>G>MC4.legendadvanc>M>mc3.F002.Pathadvanc>M>rev.1advanc>M>tf2.falseadvanc>M>tf2.trueadvanc>O>MC4.F002.Pathadvanc>O>Rev.3advanc>O>TF2.legend  advanc>D>d.8 advanc>d>def.9advanc>o>dflt.12advanc>o>wid.1 advanc>d>mc1.legend:advanc>d>mc3.f002.path? advanc>d>o.10N advanc>d>q.10Yadvanc>d>rev.3h advanc>d>s.1jadvanc>d>TF9.common.pathtadvanc>d>TF9.F002.Pathvadvanc>d>TF9.falsewadvanc>d>TF9.trueyadvanc>G>FIB3.A999.Path~ advanc>G>g.9advanc>G>MC4.F003.Path advanc>M>egadvanc>M>MC3.correctadvanc>M>rev.2advanc>M>TF2.common.pathadvanc>M>TF2.legendadvanc>O>qseg1advanc>O>Rev.4advanc>d>mc4.common.path< advanc>D>d.9 advanc>d>I.1advanc>o>dflt.13advanc>o>wid.2 advanc>d>o.11O advanc>d>q.11Zadvanc>d>rev.4i advanc>d>s.2k advanc>G>MC4advanc>G>MC4.F002.Pathadvanc>M>rev.3advanc>O>qseg2advanc>O>Rev.5advanc>m>initial.path advanc>d>I.2advanc>o>dflt.1advanc>o>dflt.14advanc>o>wid.3advanc>d>FIB7.a000)advanc>d>MC4.F001.PathG advanc>d>q.1X advanc>d>q.12[ advanc>d>s.3ladvanc>O>tf3.trueadvanc>m>rev.4  advanc>d>I.3advanc>o>dflt.2advanc>o>dflt.15advanc>o>wid.4:  advanc>d>f.1! advanc>d>FIB7(advanc>d>mc1.F003.Path7advanc>d>mc4.correctF advanc>d>q.2\ advanc>d>s.4m advanc>G>FIB3z advanc>G>if.1advanc>M>mc3.F001.Pathadvanc>M>qseg2advanc>M>TF2.F002.Pathadvanc>O>MC4.common.pathadvanc>O>MC4.F001.Pathadvanc>O>TF3.common.pathadvanc>O>TF3.F002.Pathadvanc>g>initial.path advanc>g>I.1advanc>m>how.1advanc>o>dflt.3advanc>o>dflt.16advanc>g>FIB3.A002.Path" advanc>d>f.2"advanc>d>mc1.F002.Path6advanc>d>MC3.F001.Path>advanc>d>mc4.incorrectKadvanc>d>MC4.legendL advanc>d>o.1M advanc>d>q.3] advanc>d>s.5n advanc>d>TF9sadvanc>d>TF9.F001.Pathu advanc>G>g.10 advanc>G>if.2advanc>M>EG.pedaladvanc>M>mc3.f3incadvanc>O>MC4.legendadvanc>d>def.1 advanc>g>I.2advanc>m>how.2advanc>o>dflt.4advanc>o>dflt.172am dx JHPN  NO CHANGE!+N'! NO CHANGE!NIntroduction to Macros5A macro is a sequence of keystrokes storedin a worksheet that can be "played back"at any time.'To create a macro, select the1) select the Advanced/Record-Macro!command,2)enter a one-character macro name,3)define the range where the keystrokeswill be stored.5d2am e JHPN  NO CHANGE!+NIntroduction to Macros5The mode indicator changes to RCD READYwhen your keystrokes are being recordedto a macro.'To stop recording to a macro,1) press the Macro function key (F1), then!2)press Finish.To play back a macro, 1)press the Macro function key (F1), then2)type the one-character macro name.5'D; 2am 'd JHPN  NO CHANGE!+'NIntroduction to Macros5A macro can be used only with theworksheet for which it is created.'!5 @2am gX JHPN  NO CHANGE!+_NG$Let's take a look at an example.$$7 CNO CHANGE!N-a18 $ RCD READYLet's take a look at an example. a b f g 1 EXPENSE REPORT $ 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 "- - -- 11 Total Expenses $60.00 $23.00 $15.00 $1,002.00 12 Less Advances  $1,200.00 13 Balance Due To Employee   14 Balance Due From Employee  $198.00 15   16  17 This is your expense report. A macro 18 {GOTO}d5~  19 587{DOWN}  has been created for this worksheet. 20 36/{BS}~/  21 c~{RIGHT} This macro is going to automatically 22 .{RIGHT}~  23 {DOWN}75~ insert new expense values for you. Tue 01-Mar-88 4:49 PM  Macro  Edit  Name Abs *raph  2am d;  JHPN   NO CHANGE!+N@- Question -Introduction to MacrosPT R U E o r F A L S E0When the mode indicator says RCD READY,any keystrokes that you type arerecorded into a macro.0 (Select your answer by pressing one of the indicated selections)P(($('@2am c P advanc>m>mc32am !c P Gadvanc>M>TF2.true#!Ladvanc>M>TF2.common.path2am !c P Gadvanc>M>TF2.false$!Ladvanc>M>TF2.common.path2am dw<  JHPN   /NO CHANGE!+NIntroduction to MacrosPT R U E o r F A L S E0When the mode indicator says RCD READY,any keystrokes that you type are beingrecorded into a macro. $That's incorrect. This statement$$is true. RCD READY indicates that keystrokes you type are beingrecorded into a macro.P(('(,,,,,,,,,L2am !c N ! TRUE  FALSE 2am dl JHPN  &NO CHANGE!+NzIntroduction to MacrosPT R U E o r F A L S E0When the mode indicator says RCD READY,any keystrokes that you type are beingrecorded into a macro. #Correct. This statement is true.##RCD READY indicates that keystrokes you type are being recorded intoa macro.P(('(---------K2am d<  JHPN   ONO CHANGE!+N  @ MNO CHANGE!_NIntroduction to DatabasesP9So far, you created a worksheet that organizes labelsand values into the form of an expense report.Generating reports is a common use of worksheets.9Pp2am cX JHPN  NO CHANGE!+NIntroduction to DatabasesP;However, another common use of the worksheet is tostore and manage information in the form of a database.;jPZ2am Cd JHPN  NO CHANGE!+CN!Introduction to DatabasesPIn this lesson, you will learnwhat a database isthe benefits of a databasehow to create a databasehow to sort a databasehow to query a databasehow to use a database to produce frequency distributionsP2am cm JHPN   ONO CHANGE!+N  @ MNO CHANGE!_NIntroduction to "What If?" Analysis and Goal SeekingPQ+Solution Designer provides you withthe capability to analyze the datain your worksheet.+o 4Pp2am Xd=  JHPN  NO CHANGE!+XNIntroductionto"WhatIf?"AnalysisandGoalSeekingPIn this lesson, you will learnhow to perform "What If?" analysisusing the Data/Table commandhow to perform goal seeking analysisusing the Advanced/Goal-Seeking command P     2am cC JHPN   ONO CHANGE!+N  @ AMNO CHANGE!_NIntroduction to MacrosP4A macro is a sequence of keystrokes stored in aworksheet that can be "played back" at any time.4Pp2am e JHPN  FNO CHANGE!+NIntroduction to MacrosP9There are some major benefits to using macros --Macros save you the time it takes to enter afrequently-used series of keystrokes and commands.Macros perform commands faster than you could.Macros are extremely easy to use. All it takesis just two keystrokes to start a macro.Macros are not hard to create.9Pp2am e; JHPN   NO CHANGE!+Na1 MENU Record-Macro Link Goal-Seeking Move Automatic Default Width Definea macro with keystroke recorder0 a b c d e f g 1  2 3 4 5 6 7 '8 9 To create a macro, you would select10 11 the Advanced/Record-Macro command.12 13 '14 15 16 17 18 19 20 21 22 23 Tue 01-Mar-88 5:47 PM; Macro  Edit  Name A= bs  Go To  Window Query Table  Calc  Graph O''''''2am eV JHPN  8NO CHANGE!+NGa1 POINTEnter macro name: e  Enter macro range: a18..a100* $  a b c d e f g 1 2 3 4 5 6 7 $8 9 You would then enter a one-character macro10 11 name and the range in your worksheet where12 13 the recorded keystrokes will be stored.14 15 216 17 18  19N 20N 21N 22N 23N Tue 01-Mar-88 5:48 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am zf JHPN  NO CHANGE!+zNa1RCD READY& a b cg 1 After you press Return, the mode2 3 indicator says RCD READY. This4 5 means that any keystroke entered6 7 will now be recorded in the macro.8 9 &10 11 12 *13 14 To finish, or stop recording, a macro,15 16 you would 1) press the Macro (F1)17 18 function key, then 2) press the Finish19 20 key.21 22 *23 Tue 01-Mar-88 5:48 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph & &&&&&&&&2am f>  JHPN  ,NO CHANGE!+Na1 READYM O a b c d e f g 1 '2 3 After finishing the macro, the mode4 5 indicator returns to READY mode and6 7 the macro keystrokes appear in your 8 9 worksheet.10 11 '12 13 14 )15 16 Note that a macro can be used only17 18 {GOTO}d5~ with the worksheet it is created for. 19 587{DOWN} 20 36/{BS}~/ ) 21 c~{RIGHT}  22 .{RIGHT}~C 23 {DOWN}75~C Tue 01-Mar-88 5:48 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]'''''''''2am 0d JHPN   NO CHANGE!+N  @ MNO CHANGE!_0NIntroduction to MacrosP1If you use Solution Designer often enough,you may find yourself entering certainkeystrokes and commands over and over again.This takes time and can also be very tedious.1Pp2am d JHPN  NO CHANGE!+NIntroduction to MacrosPR)Solution Designer provides a shortcutfor multiple keystrokes and commandsthat you may frequently use.This shortcut is known as a macro.)PB)2am cP JHPN   NO CHANGE!+NIntroduction to MacrosPIn this lesson, you will learnwhat a macro isthe benefits of macroshow to record a macrohow to play back a macroP p> 2am e{ JHPN   ONO CHANGE!+N  @ 'MNO CHANGE!_NfOtherAdvancedSolutionDesignerCommandsPAdvanced/AutomaticlThe Advanced/Automatic command automaticallymoves the cell pointer to the next cell whenyou press Return to enter cell information.Thiscommandisusefulwhenyouaretypinglongcolumnsorrowsofcellinformationintoanewworksheet.^P,,,,,  ^2am eD JHPN  :NO CHANGE!+Na1 MENU Record-Macro Link Goal-Seeking Move Automatic Default Width Define a macro with keystroke recorder * a b c d e f g h i1 2 3 4 5 6 27 8 To set up automatic cursor movement, you would9 10 set the Advanced/Automatic command to Yes.11 12 213 14 15 16 17 18 19 20 21 22 23 Wed 02-Mar-88 11:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ,0.*&2am e JHPN   $NO CHANGE!+Na1 READY a b c d e f g h i1O 2 3 4 05 6 Automatic cursor movement is set up7 8 after the command is performed.9 10 The direction the cell pointer moves11 12 depends on the most recently used arrow key.13 14 015 16 17 18 19 20 21 22 23 Wed 02-Mar-88 11:31 PM; Macro  Edit  Name Ab? s  Go To  Window Query Table  Calc  Graph ]2am e9 JHPN  NO CHANGE!+N*a2 READY a b c d e f g h i1 10D 2 3 4 5 26 7 For example, if you pressed the Down Arrow key8 9 to enter the number 10 into cell a1, then from10 11 here on, when entering data with the Return12 13 key, the cell pointer will move down one cell.14 15 216 17 18 19 20 21 22 23 Wed 02-Mar-88 11:32 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am [d JHPN   ONO CHANGE!+N  @ 'MNO CHANGE!_[NOtherAdvancedSolutionDesignerCommandsPAdvanced/DefaultThere are three Advanced/Default commands used toestablish certain default worksheet settings:Copy-ValuesAlign-ColumnsBlank-FormatP111     2am e JHPN   ONO CHANGE!+N  @ MNO CHANGE!_NkOtherAdvancedSolutionDesignerCommandsP$Advanced/Default/Copy-Values$iThe Advanced/Default/Copy-Values commandsets a default for the Copy command. Thiscommandgivesyouthechoiceofcopyingeitherformulasandvalues,orvaluesonly.Bydefault,theCopycommandcopiesbothformulasandvalues.P ((? (2am fI JHPN  7NO CHANGE!+Ng14 (C2) [W12] +g12-g11 READY, O * a b c d  e f g 1 EXPENSE REPORT # 2+  Total 3 Date 08/88 Expenses 4 -- 5 Air, rail, bus For example, cell g14 $587.00 6 Rental car $36.00 $108.00 7 Daily lodging contains the formula, $75.00 $225.00 8 Meals $40.00 $95.00 9 Entertainment +g12-g11. $75.00 10 -- 11 Total Expenses $151.00 $1,090.00 12 Less Advances $1,200.00 13 Balance Due To Employee 14 Balance Due From Employee $110.00 15 16 17 18 19 20 21 22 23 Tue 01-Mar-88 11:06 PM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am f# JHPN  NO CHANGE!+Ng14(C2)[W12]+g12-g11MENU Copy-ValuesAlign-ColumnsBlank-FormatCopyaluesonly a b c d e f g 1 EPENSEREPORT2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Re336.00 $108.00 7 Da75.00 $225.00 8 MeIf you set the40.00 $95.00 9 En $75.00 10 -Advanced/Default/Copy-Values command to Yes .- 11 To51.00 $1,090.00 12 Le3 $1,200.00 13 Balance Due To Employee 14 Balance Due From Employee $110.00 15N 16N 17N 18N 19N 20N 21N 22N 23N Tue 01-Mar-88 11:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  N//( 2am )g@  JHPN   NO CHANGE!+)NYg14 (C2) [W12] +g12-g11 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delee, Column-Width, Erase, Titles, Window, Status a b  c d e f g 1 EXPENSE REPORT ; 2 1 Total 3 Date01/06/8801/07/8801/08/88Expenses4 K-5 Air,0$587.006 Renta36.00$108.007 Daily . then the Copy command copies only the75.00$225.008 Meals40.00$95.009 Enter value, rather thanboth formula and value.$75.0010 --11 Total051.00$1,090.0012 LessAdvances$1,200.0013 BalanceDueToEmployee14 BalanceDueFromEmployee $110.00 15 16 17 18 19 20 21 22 23 Tue01-Mar-8811:06PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ?**  2am g JHPN  BNO CHANGE!+Ng14 (C2) [W12] +g12-g11 READY O B a b  c d e f g 1 EXPENSE REPORT ; 2 Total 3 Date 01/06/8801/07/8801/08/88 Expenses 4 -:- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00$36.00$36.00 $108.00 7 Daily lodging $75.00$75.00$75.00 $225.00 8 Meals $35.00$20.00$40.00 $95.00 9 Entertainment  $75.00 $75.00 10 -:- 11 Total Expenses $733.00 $206.00 $151.00 $1,090.00 12 Less Advances 0 $1,200.00 13 Balance Due ToEmployee3 14 Balance Due Frm Employee  $110.00 15 $110.00 16 -17 18 For example, the formula in cell g14 has 19 20 been copied to cell g15. As you can see,21 22 cell g14 contains a formula.23 Tue 01-Mar-88 11:11 PM - Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ? -------2am 9g@  JHPN  KNO CHANGE!+9Ng15 (C2) [W12] 110 READY O E a b c d e f g 1 EXPENSE REPOR> 2 4 Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 -=- 5 Air, rail, us $587.00 $587.00 6 Rental car  $36.00 $36.00 $36.00 $108.00 7 Daily lodgig $75.00 $75.00 $75.00 $225.00 8 Meals  $35.00 $20.00 $40.00 $95.00 9 Entertainmet $75.00 $75.00 10 -=- 11 Total Expenes $733.00 $206.00 $151.00 $1,090.00 12 Less Advancs2 $1,200.00 13 Balance DueTo Employee3 14 Balance DueFrom Employee( $110.00 15 5 $110.00 16 $17 18 Cell g15, however, contains19  20 just the value, not the formula.21 22 $23 Tue 01-Mar-88 11:11 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph B $$$$$2am Ad JHPN   #NO CHANGE!+ANOtherAdvancedSolutionDesignerCommandsP&Advanced/Default/Align-Columns&hThe Advance/Default/Align-Columns command sets or removes theone-space gutterto the right of each worksheet column. P )&&&&Pp2am d3A  JHPN  ONO CHANGE!+Ny- Question -Other Advanced Solution Designer CommandsPFILLINTHEBLANKNNNN<  Use the Advanced/ ~ ~ command if you want  to share your worksheet data with another worksheet.  < NNNNN(Type your answer and press GO when ready))P@ 3J*2am cD JHPN   'NO CHANGE!+NOther Advanced Solution Designer CommandsPThat's correct.Use the Advanced/Link command if you wantto share your worksheet data with another worksheet.)Px2am "c P Gadvanc>o>FIB1.a000$"Ladvanc>o>FIB1.common.path2am cF JHPN   'NO CHANGE!+NOther Advanced Solution Designer CommandsPThat's incorrect.Use the Advanced/Link command if you wantto share your worksheet data with another worksheet.)Px2am "cA  P Gadvanc>o>FIB1.a999$"Ladvanc>o>FIB1.common.path2amch!pLink2am c P advanc>o>TF22am fV JHPN  ONO CHANGE!+N4g14 (C2) [W12] +g12-g11 READY a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $36.00 $36.00 $108.00 7 Daily lodging $75.00 $75.00 $75.00 $225.00 8 Meals $35.00 $20.00 $40.00 $95.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $733.00 $206.00 $151.00 $1,090.00 12 Less Advances $1,200.00 13 Balance Due To Employee 14 Balance Due From Employee $110.00 15 16 17 18 !19 20 This is the one-space gutter.21 22 !23 Tue 01-Mar-88 11:16 PM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T !!!B 2am g JHPN  NO CHANGE!+N.g14(C2)[W12]+g12-g11MENU Copy-ValuesAlign-ColumnsBlank-FormatCopyvaluesonly a b  c d e f g 1 EXPENSEREPORT2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 -+- 5 Air, rail, $587.00 6 Rental car Toremovethegutter,you would set6.00 $108.00 7 Daily lodgi5.00 $225.00 8 Meals the Advanced/Default/Align-Columns0.00 $95.00 9 Entertainme  $75.00 10 -command to No.- 11 Total Expen1.00 $1,090.00 12 Less Advanc+ $1,200.00 13 Balance Due To Employee 14 Balance Due From Employee $110.00 15 16 17 18 19 20 21 22 23 Tue 01-Mar-88 11:16 PM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph @+'+"  2am g{ JHPN  NO CHANGE!+NOg14 (C2) [W12] +g12-g11 READY a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $587.00 $587.00 6 Rental car $36.00 $36.00 $36.00 $108.00 7 Daily lodging $75.00 $75.00 $75.00 $225.00 8 Meals $35.00 $20.00 $40.00 $95.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $733.00 $206.00 $151.00 $1,090.00 12 Less Advances  $1,200.00 13 Balance Due To Employee 14 Balance Due From Employee $110.00 15 !16 17 After performing the command,18 19 the gutter is removed.20 21 !22 23 Tue 01-Mar-88 11:13 PM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T !!!B !!2am di JHPN   NO CHANGE!+NeOtherAdvancedSolutionDesignerCommandsP%Advanced/Default/Blank-Format%hThe Advanced/Default/Blank-Format command sets the Range/Erasecommand to erase all settings, including formatting information.Bydefault,theRange/Erasecommanderasesonlythevalue,nottheformattinginformation.YP  /////   Y2am fJ JHPN  NO CHANGE!+Nd3 (D4) [W12] @DATE(88,1,6) READY O O a b c d e f g 1 EXENSE REPORT> 2 ? Total 3 ate  01/06/88 01/07/88 01/08/88 Expenses 4 ---6- 5 ir, rail, bus $587.00 $587.00 6 e $36.00 $36.00 $108.00 7 a $75.00 $75.00 $225.00 8 For example, look at the format $20.00 $40.00 $95.00 9 En $75.00 $75.00 10 -information for cell d3."- 11 To $206.00 $151.00 $1,090.00 12 Le#$1,200.00 13 Balance Due To Employee 14 Balance Due From Employee $110.00 15 16 17 18 19 20 21 22 23 Tue 01-Mar-88 11:18 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T #####2am gC  JHPN  NO CHANGE!+NJd3 (D4) [W12] @DATE(88,1,6) MENU Format Label Erase Name Justify Protect Unprotect Input Value TransposeFormat one or mor cells? a b c d e f g 1 EXPENSE REPOR> 2 4 Total 3 Date01/06/88 01/07/8801/08/88Expenses4 K-5 Air,rail,bus'$587.006 Rentalcar36.00$108.007 DailylodgingBy default, the Range/Erase command75.00$225.008 Meals40.00$95.009 Entertainmenterases everything in the cell.$75.0010 --11 TotalExpenses'51.00$1,090.0012 LessAdvances$1,200.0013 BalanceDueToEmployee14 BalanceDueFromEmployee$110.0015 16 17 18 19 20 21 22 23 Tue01-Mar-8811:18PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph B '''''2am f1 JHPN   #NO CHANGE!+Nd3  READY O @ a b c d e f g 1 EXPENSE REPORT 9 2 / Total 3 Date  01/07/88 01/08/88 Expenses 4 --6- 5 Air,rai$587.006 Rentalc$36.00$36.00$108.007 DailyloBoth formatting information$75.00$75.00$225.008 Meals$20.00$40.00$95.009 Entertaiand value would be erased.$75.00$75.0010 - -11 TotalEx$206.00$151.00$1,090.0012 LessAdvances$1,200.0013 BalanceDueToEmployee14 BalanceDueFromEmployee$110.0015 16 17 18 19 20 21 22 23 Tue01-Mar-8811:18PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am fL JHPN   NO CHANGE!+Nd3(D4)[W12]@DATE(88,1,6)MENU Copy-ValuesAlign-ColumnsBlank-FormatCopyvaluesonly a b c d e f g 1 EXPENSEREPORT2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail,3 $587.00 6 Rental car $108.00 7 Daily lodgHowever, if you first set the $225.00 8 Meals  $95.00 9 EntertainmAdvanced/Default/Blank-Format command to No . $75.00 10 C  - - 11 Total Expe3$1,090.00 12 Less Advances$1,200.00 13 Balance Due To Employee 14 Balance Due From Employee $110.00 15 16 17 18 19 20 21 22 23 Tue 01-Mar-88 11:18 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph !2 //)2am g JHPN  NO CHANGE!+N>d3 (D4) [W12] @DATE(88,1,6) MENU Format Label Erase Name Justify Protect Unprotect Input Value TransposeFormat one or mor cells? a b c d e f g 1 EXPENSE REPOR> 2 4 Total 3 Date01/06/88 01/07/8801/08/88Expenses4 K-5 Air,rail,0$587.006 Rentalcar$108.007 Dailylodgi. then the Range/Erase command erases only$225.008 Meals$95.009 Entertainmethe value, not the formatting information.$75.0010 - -11 TotalExpen0$1,090.0012 LessAdvances$1,200.0013 BalanceDueToEmployee14 BalanceDueFromEmployee$110.0015 16 17 18 19 20 21 22 23 Tue01-Mar-8811:18PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph B ,,,2am f JHPN  NO CHANGE!+Nd3 (D4) [W12]READY a b c Value is erased, format is not. g 1 EXPENSE REPORT # 2E Total 3 Date! 01/07/88 01/08/88 Expenses 4 K-5 Air,rail,bus$587.00$587.006 Rentalcar$36.00$36.00$36.00$108.007 Dailylodging$75.00$75.00$75.00$225.008 Meals$35.00$20.00$40.00$95.009 Entertainment$75.00$75.0010 K-11 TotalExpenses$733.00$206.00$151.00$1,090.0012 LessAdvances$1,200.0013 BalanceDueToEmployee14 BalanceDueFromEmployee$110.0015 16 17 18 19 20 21 22 23 Tue01-Mar-8811:18PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph # D 2am cR JHPN   ONO CHANGE!+N  @  MNO CHANGE!_NOther Advanced Solution Designer CommandsP8This lesson introduces several advancedSolution Designer commands that you may find useful.8l)Pp2am Dd JHPN  -NO CHANGE!+DNOtherAdvancedSolutionDesignerCommandsPVThis lesson provides a description of each of the following Advanced commands:LinkMoveAutomaticDefault/Copy-ValuesDefault/Align-ColumnsDefault/Blank-FormatWidthP@2am ds JHPN   ONO CHANGE!+N  @ $MNO CHANGE!_NVOtherAdvancedSolutionDesignerCommandsPAdvanced/LinksThe Advanced/Link command lets youshare data between worksheets.Sharingdatabetweenworksheetseliminatestheneedtoduplicatevaluesorcalculationsthatarecommonamongtwoormoreworksheets.Let's look at an example. P """""      2am fD  JHPN  NO CHANGE!+ NOtherAdvancedSolutionDesignerCommandsP This worksheet calculates the budgetAcmeWidgetCompanyBudget for the Acme Widget Company, which Sales has three divisions:ResearchManufacturing SalesTotalBudget Research Manufacturing SalesResearchManufacturingDivisionDivision DivisionBudget$450Budget$800Budget$10P$$$$$$$$$$$ P2am de JHPN   ONO CHANGE!+NnQuestion Other Advanced Solution Designer CommandsPThe Advanced/Blank-Format command isM used to set a default forUCLHTF1 - the Worksheet/Delete commandOIF2 - the Range/Erase commandIPF3 - the Range/Format commandCLF4 - None of the aboveEE(Select your answer by pressing one of the indicated selections))P.).).!!!!!!!  @2am c P ZSD.fontZCarla.font,Gadvanc>o>Rev.1CGadvanc>o>rev.2ZGadvanc>o>rev.3qGadvanc>o>rev.4Gadvanc>o>rev.5NAdvanc>menuE 2am Se JHPN  8NO CHANGE!+SNOther Advanced Solution Designer CommandsPThe Advanced/Blank-Format command is used to set a default forsF1 - the Worksheet/Delete commandF2 - the Range/Erase command F3 - the Range/Format commandF4 - None of the above" That's right. The correct answer is F2.The Advanced/Blank-Format command is used toset a default for the Range/Erase command.0)P.).).!!!00000002am !c P Gadvanc>o>MC4.incorrect(!Ladvanc>o>MC4.common.path2am !c P Gadvanc>o>MC4.correct&!Ladvanc>o>MC4.common.path2am !cE  P Gadvanc>o>MC4.incorrect(!Ladvanc>o>MC4.common.path2am !c P Gadvanc>o>MC4.incorrect(!Ladvanc>o>MC4.common.path2am e JHPN  NO CHANGE!+NOther Advanced Solution Designer CommandsPThe Advanced/Blank-Format command is used to set a default forsF1 - the Worksheet/Delete commandF2 - the Range/Erase commandF3 - the Range/Format commandF4 - None of the above1That's incorrect. F2 is the correct answer.The Advanced/Blank-Format command can set theRange/Erase command to erase just the cellcontents, and leave format information alone.1)P.).).!11111112am +c N + F1  F2  F3  F4 F 2am f) JHPN  NO CHANGE!+NOtherAdvancedSolutionDesignerCommandsP Acme Widget Company BudgetThe company worksheet usesSalesthe budgets from the threeResearchManufacturingdivision worksheets toTotal Budgetcalculate the total budget.  SalesResearchManufacturingDivisionDivision DivisionBudget$450Budget$800Budget$10PHHHHHHHHH     H2am "c P Gadvanc>g>fib3.a002$"Ladvanc>g>FIB3.Common.Path2am e: JHPN  KNO CHANGE!+N+a14POINTEnter range of rows to move FROM: a9..a10 Move TO : a14 a b c d e f g h i123456789 JanFebMarAprMayJunJulAug10 SepOctNovDec11121341415 When using the Advanced/Move command, you define16 17 the range of rows (or columns) to move FROM, and18 19 row (or column) to move TO.20 21 422 23 Thu 03-Mar-88 12:56 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T F 2am c9 JHPN  NO CHANGE!+N9;I T ' S T I M E T O S E EW H A T Y O U H A V E L E A R N E D . . .;.33332am cA JHPN  'NO CHANGE!+NFL E T ' S T E S TY O U R K N O W L E D G EB Y A N S W E R I N GA F E W Q U E S T I O N S!F 2am e JHPN  NO CHANGE!+N'! NO CHANGE!NOther Advanced Solution Designer Commands5To share data between worksheets, usethe Advanced/Link command.There are two different commands to move'cells in a worksheet:!1) Move - moves one cell or range ofcellsat a time2) Advanced/Move - moves multiple rowsor columns at a time)5. (< ;2am eG  JHPN   NO CHANGE!+NOther Advanced Solution Designer Commands5To automatically move the cell pointer tothe next cell after pressing Return, usethe Advanced/Automatic command.'To set the default for the Copy !command to copy values only, or both formulas and values, use the Advanced/Default/Copy-Values command.)5.)#Y2am :e JHPN   MNO CHANGE!+:NOther Advanced Solution Designer Commands5To remove or reset the one-space gutter tothe right of each worksheet column, use theAdvanced/Default/Align-Columns command.'To set the default for the Range/Eraseڱ!command to erase format information only,or both value and format information, use the Advanced/Default/Blank-Format command.)5.*"Z&)$2am 9e JHPN  MNO CHANGE!+9NOther Advanced Solution Designer Commands5There are three different commands used toset column width:1) Worksheet/Global/Column-Width -changes column width of the entire 'worksheet!2)Worksheet/Column-Width - changescolumn width one column at a time3)Advanced/Width - changes column widthof multiple columns at a time.)5.**:G 2am 3f JHPN  MNO CHANGE!+3NYOtherAdvancedSolutionDesignerCommands5There are three different commands used to Congratulations!set column width: You have reached the end1)Worksheet/Global/Column-Width- of this tutorial.changescolumnwidthoftheentire worksheetKeep in mind that you can 2)Worksheet/Column-Width-changesretake any of the lessons columnwidthonecolumnatatime if you feel you need to.3)Advanced/Width-changescolumnwidthPressNextPagetoreturnofmultiplecolumnsatatime.totheAdvanc menu. 555 *5 5  55535 555 55555555552am dT JHPN   NO CHANGE!+NfQuestion Other Advanced Solution Designer CommandsPT R U E o r F A L S E0The Advanced/Automatic command is usefulwhen you are typing long columns or rowsof numbers into a new worksheet.0 (Select your answer by pressing one of the indicated selections))P?0,0,0 0'@2am c P Gadvanc>o>Dflt.1!Gadvanc>o>Dflt.29ZCarla.fontLZSD.font\Gadvanc>o>Dflt.3tGadvanc>o>Dflt.4Gadvanc>o>Dflt.5Gadvanc>o>Dflt.6Gadvanc>o>Dflt.7Zsd.fontZCarla.fontGadvanc>o>Dflt.8ZCarla.font"Zsd.font2Gadvanc>o>Dflt.9JGadvanc>o>Dflt.10cGadvanc>o>Dflt.11|Zsd.fontZCarla.fontGadvanc>o>Dflt.12ZCarla.fontZSd.fontGadvanc>o>Dflt.13GadvaH nc>o>Dflt.14 Gadvanc>o>Dflt.15&Gadvanc>o>Dflt.16?Gadvanc>o>Dflt.17XGadvanc>o>Dflt.18qZsd.fontZCarla.fontGadvanc>o>Wid.1ZCarla.fontZsd.fontGadvanc>o>Wid.2Gadvanc>o>Wid.3Gadvanc>o>Wid.4ZSD.font#ZCarla.font6Gadvanc>o>qseg2Madvanc>o>TF32am !c P Gadvanc>o>TF2.true#!Ladvanc>o>TF2.common.path2am !c P Gadvanc>o>TF2.false$!Ladvanc>o>TF2.common.path2am eK JHPN  ONO CHANGE!+N4Other Advanced Solution Designer CommandsPT R U E o r F A L S E0The Advanced/Automatic command is usefulwhen you are typing long columns or rowsof numbers into a new worksheet. That's incorrect. This statement is true.The Advanced/Automatic command is useful fortyping long columns or rows of numbers into anew worksheet because it automatically advancesthe cell pointer to the next cell in thedirection of the Arrow key that was last used.)P?0,0,0 09999999999999H 2am !c N ! TRUE  FALSE 2am eO JHPN  NO CHANGE!+N,Other Advanced Solution Designer CommandsPT R U E o r F A L S E0The Advanced/Automatic command is usefulwhen you are typing long columns or rowsof numbers into a new worksheet. Correct. This statement is true. TheAdvanced/Automatic command is useful for typinglong columns or rows of numbers into a newworksheet because it automatically advances thecell pointer to the next cell in the directionof the Arrow key that was last used.)P?0,0,0 044449999999992am dY JHPN   ANO CHANGE!+N|Question Other Advanced Solution Designer CommandsPT R U E o r F A L S E8When the Advanced/Default/Copy-Values commandis set to Yes, the Copy command copies the valueonly, rather than both formula and value.8 (Select your answer by pressing one of the indicated selections))P;8888888+@I 2am c P advanc>o>MC42am !c P Gadvanc>o>TF3.true#!Ladvanc>o>TF3.common.path2am !c P Gadvanc>o>TF3.false$!Ladvanc>o>TF3.common.path2am e JHPN  JNO CHANGE!+NOther Advanced Solution Designer CommandsPT R U E o r F A L S E8When the Advanced/Default/Copy-Values commandis set to Yes, the Copy command copies the value only, rather than both formula and value. That's incorrect. This statement is true. If the Advanced/Default/Copy-Values commandis set to Yes, then the Copy command copiesthe value onI ly, rather than both formula and value.)P;8888888555555555552am !c N ! TRUE  FALSE 2am ~e JHPN  ENO CHANGE!+~NOther Advanced Solution Designer CommandsPT R U E o r F A L S E8When the Advanced/Default/Copy-Values commandis set to Yes, the Copy command copies the value only, rather than both formula and value. That's correct. This statement is true.If the Advanced/Default/Copy-Values commandis set to Yes, then the Copy command copiesthe value only, rather than both formula and value.)P;8888888555555555552am d9 JHPN   NO CHANGE!+NAOtherAdvancedSolutionDesignerCommandsPAdvanced/WidthlThe Advanced/Width command sets the column widthfor multiple columns or rows.Younowhaveachoiceofthreecolumn-widthcommands:Worksheet/Global/Column-WidthWorksheet/Column-WidthAdvanced/WidthP000  J 2am e JHPN  0NO CHANGE!+Na1 READY a b c . sp sq sr1 2 3 4 5 6 7 58 9 The Worksheet/Global/Column-Width command10 11 sets the column width for the entire spreadsheet.12 13 514 15 16 .818781888189819081918192Wed 02-Mar-88 11:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph )%,c2am e' JHPN  NO CHANGE!+Na1READY a b c d e f g h 1 2 3 4 5 6 7 +8 9 TheWorksheet/Column-Widthcommandsets10 11 thecolumn-widthforasinglecolumn.12 13 +14 15 16 17 18 19 20 21 22 23 Wed 02-Mar-88 11:31 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 h1 2 3 4 5 6 The Advanced/Column-Width7 8 command sets the column9 10  width for multiple11 12 columns.13 14 15 16 17 18 19 20 21 22 23 Wed 02-Mar-88 11:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph _J ''''''''''''''''''''''''SD2am c P Gadvanc>m>i.1Gadvanc>m>i.23Gadvanc>m>i.3HGadvanc>M>how.1_Gadvanc>M>how.2vZCarla.fontZSD.fontGadvanc>M>how.3Gadvanc>M>how.4Gadvanc>M>how.5Gadvanc>M>how.6Gadvanc>M>seg Xadvanc>M>EgZSD.font.ZCarla.fontAGadvanc>M>eTGadvanc>m>qseg2kadvanc>M>TF22amcm P advanc>d>MC32am c P Gadvanc>d>s.1ZCarla.font1ZSD.fontAGadvanc>d>s.2VGadvanc>d>s.3kGadvanc>d>s.4Gadvanc>d>s.5Gadvanc>d>s.6Gadvanc>d>s.7Gadvanc>d>s.8Gadvanc>d>s.9ZSD.fontZCarla.font Gadvanc>d>qseg1#advanc>d>MC4K e 714 27890 CA 9 111 CA 10 13 FL 11 3 To delete all database records that match GA 12 7 HI 13 14 the criterion, you would IL 14 20 IL 15 12 use the Delete command. MI 16 5 MI 17 81 NC 18 21 412 West Jayne 919 9512366 NC 19 19 624 Clark Tom 201 3520990 NJ 20 10 814 Johnson Corinne 201 3520990 NJ 21 17 475 Monaghan Ed 513 3664667 OH 22 9 871 Speck Joe 513 3664667 OH 23 2 230 Dold Cathy 215 3785500 PA 24 4 748 Bennett Charles 214 7552288 TX 25 18 648 Crosby Sue 214 7552288 TX 26 3 164 Smith Ron 404 2632125 GA Sun 06-Mar-88 5:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 4()+2am c P Gadvanc>d>q.1Gadvanc>d>q.23ZCarla.fontFZsd.fontVGadvanc>d>q.3kGadvanc>d>q.4Gadvanc>d>q.5Gadvanc>d>q.6Gadvanc>d>q.7Gadvanc>d>q.8Gadvanc>d>q.9Gadvanc>d>q.10Gadvanc>d>q.11Gadvanc>d>q.12+ZSD.font;ZCarla.fontNGadvanc>d>qseg2e advanc>d>Fib7++ @ P Gadvanc>d>MC4.incorrect(!Ladvanc>d>MC4.common.path2am d JHPN   NO CHANGE!+N  @ BMNO CHANGE!_NdIntroduction to DatabasesPL5 Querying for records is just one of the tasksthat you can perform with a database.Another task is to use values within the databaseto produce statistical information.One such example is frequency distribution.5=Pu  K 2am Me JHPN  'NO CHANGE!+MN)Introduction to DatabasesP8Afrequencydistributionevaluatesasetofnumbersandcountswherethenumbersfallwithinaspecifiedrange,calledthebinrange.For example, you can find out how many employeesfall into four different bin ranges:Employee numbers lower than or equal to 200Employee numbers from 201 to 400Employee numbers from 401 to 600Employee numbers from 601 to 8008P2am 9g JHPN  !NO CHANGE!+9NCh5 READY b c d h i j k 1 XYZ Company 1$ 2 Employee Listing 2$ 3* 3 Freq. Distrib. 4 EmpNo LastName FirstName 4 (Bin range) 5 514 Smith Michelle 5$ 6 342 Young Russ 6$ 7 438 Green Larry 7$ 8 231 O'Connor Kacie 8$ 9 161 4 10 434 11 164 This is your database. 12 826 13 529 (This worksheet has been split into two windows 14 316 15 581 for the convenience of showing this example.) 16 265 17 194 4 18 412 West Jayne 18# 19 624 Clark Tom 19# 20 814 Johnson Corinne 20# 21 475 Monaghan Ed 21# 22 871 Speck Joe 22# 23 230 Dold Cathy 23# Sun 06-Mar-88 7:01 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am +hL  JHPN   NO CHANGE!++Nh9MENU FillTableSortQueryDistributionMatrixRegressionParseCalculateafrequencydistributin b c d h i j k 1 XYZCompany1 2 Employee Listing 2$ 3* 3 Freq. Distrib. 4 EmpNo LastName FirstName 4 (Bin range) 5 514 Smith Michelle 5 200 6 342 Young Russ 6 400  7 438 Green Larry 7 600  8 231 O'Connor Kacie 8 800  9 161 White Steve 9  10 434 Davis Arnold 10 11 164 612 826  13 529 The first thing to do is to enter bin ranges.14 316 15 581 Then, calculate the frequency distribution.16 265 17 194 To perform the calculation, you would18 412 19 624 select the Data/Distribution command.20 814 21 475 622 871 Speck Joe 22 23 230 Dold Cathy 23 Sun 06-Mar-88 7:04 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph      3 666666666 2am h JHPN   6NO CHANGE!+Nb25 648 (OINTEnter Value range: b5..b25 $ First, define the value range, which b c k 3! is the range to evaluate. In this 4 EmpNo LastName Fir 5 514 Smith Michelexample, it is the employee numbers. 6 342 Young Russ 7 438 Green Larry # 8 231 O'Connor Kacie  8 800 9 161 White Steve  9$ 10 434 Davis Arnold  10# 11 164 Smith Ron  11# 12 826  12# 13 529 Davenport Alex 13# 14 316 Gee Ann 14# 15 581 Carter Joe 15# 16 265 Johnson Clarence 16# 17 194 Rhodes John 17# 18 412 West Jayne 18# 19 624 Clark Tom 19# 20 814 Johnson Corinne 20# 21 475 Monaghan Ed 21# 22 871 Speck Joe 22# 23 230 Dold Cathy 23# 24 748 Bennett Charles 24# 25 648 Crosby Sue 25# Sun 06-Mar-88 7:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph (  ((( ( (                   2am cL  P Gadvanc>g>I.1Gadvanc>g>I.23Gadvanc>g>If.1IGadvanc>g>If.2_ZCarla.fontrZsd.fontGadvanc>g>If.3Zsd.fontZcarla.fontGadvanc>g>if.4Zcarla.fontZsd.fontGadvanc>g>if.5 Gadvanc>g>if.6 Zsd.font0Zcarla.fontCGadvanc>g>if.7YZcarla.fontlZsd.font|Gadvanc>g>if.8Gadvanc>g>if.9Gadvanc>g>if.10Gadvanc>g>if.11Gadvanc>g>if.12Zsd.fontZcarla.fontGadvanc>g>if.13'Zcarla.font:Zsd.fontJGadvanc>g>if.14aGadvanc>g>if.15xZSD.fontZCarla.fontGadvanc>g>g.1Gadvanc>g>g.2Gadvanc>g>g.3ZCarla.fontZSD.fontGadvanc>g>g.4Gadvanc>g>g.5'Gadvanc>g>g.6<Gadvanc>g>g.7QGadvanc>g>g.8fGadvanc>g>g.9{Gadvanc>g>g.10Gadvanc>g>g.11Gadvanc>g>g.12Gadvanc>g>g.13Gadvanc>g>g.14ZSD.font2am c P Gadvanc>d>I.1Gadvanc>d>I.23Gadvanc>d>I.3HGadvanc>D>Def.1_Gadvanc>D>Def.2vGadvanc>D>Def.3Gadvanc>D>Def.4Gadvanc>D>Def.5ZCarla.fontZSD.fontGadvanc>D>Def.6Gadvanc>D>Def.7 Gadvanc>D>Def.8#Zsd.font3ZCarla.fontFGadvanc>D>Def.9]ZCarla.fontpZSD.fontGadvanc>d>cr.1Gadvanc>d>cr.2Gadvanc>d>cr.3Gadvanc>d>cr.4Gadvanc>d>cr.5Gadvanc>d>f.1Gadvanc>d>f.2Gadvanc>d>f.3-Gadvanc>d>f.4BGadvanc>d>f.5WGadvanc>d>f.6lGadvanc>d>f.7ZSD.fontZCarla.fontGadvanc>d>qseg2advanc>d>mc12am c P Gadvanc>O>I.1Gadvanc>o>i.23Gadvanc>o>link.1KGadvanc>o>link.2cGadvanc>o>link.3{Gadvanc>o>link.4Gadvanc>o>link.5Gadvanc>o>link.6Gadvanc>o>move.1ZCarla.fontZSD.fontGadvanc>o>move.2Gadvanc>o>move.3.ZSD.font>ZCarla.fontQGadvanc>o>auto.1iZCarla.font|ZSD.fontGadvanc>o>auto.2Gadvanc>o>auto.3Gadvanc>o>auto.4ZSD.fontZCarla.fontGadvanc>o>qseg1 advanc>o>FIB1