IMD 1.18: 15/05/2012 10:11:20 solution designer tutorial sd-6 6 of 7 71-03155-07  ֢SD-6monetc>fjg4K@YysSDSys'9|M^2am d+ JHPN  &NO CHANGE!+Nm- Question 1 -Formatting the Entire WorksheetPF I L L - I N - T H E B L A N KNNNN<  The keystroke combination to disable protection of a  cell in your worksheetis ~~ .  < NNNNN(Type your answer and press GO when ready)P 3J*2am c9 JHPN   ONO CHANGE!+AN)Formatting the Entire WorksheetPpPpl  -yNO CHANGE!NFormatting the Entire WorksheetPThat's correct.The keystroke combination to disable protection of a cell in your worksheet is/ru.Pp2am Pd JHPN   NO CHANGE!+PN8Formatting the Entire WorksheetPThat's incorrect.The keystroke combination to disable protectionof a cell in your worksheet is /ru. wgp selects the Worksheet/Global/Protection command, lets you disable protection for the entire worksheet only.Pp 2am ed JHPN  &NO CHANGE!+eNMFormatting the Entire WorksheetPThat's incorrect.The keystroke combination to disable protectionof a cell in your worksheet is /ru./displays the command menu,rdisplays the Range commands,uselects the Unprotect command.Pp2am cd JHPN   NO CHANGE!+NFormatting the Entire WorksheetP9Let's look at some of the other Global commands,in particular, Format, Label-Prefix and Column-Width.9P  _2am d0 JHPN   3NO CHANGE!+NFormatting the Entire WorksheetPDIt was mentioned earlier that theseGlobal commands have related commands:Global commandRelated commandWorksheet/Global/FormatRange/FormatWorksheet/Global/Label-PrefixRange/LabelWorksheet/Global/Column WidthWorksheet/Column WidthDPw2am d9 JHPN  #NO CHANGE!+NFormatting the Entire WorksheetPEBBecause of their similarity to these related commands,the Global commands will look very familiar to you.Let's use some of these Global commands right now.This time, instead of working with your expense report,you are going to work with another file called JuneBudget.wkt.B7Pp 2am f9 JHPN   NO CHANGE!+ Nfa1 READY a b c d e f g h i1O 2 3 4 5 6 7 8 *9 10 Retrieve the file, JuneBudget.wkt.11 12 *13 14 15 16 17 18 19 20 21 22 23 Thu 25-Feb-88 11:56 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]***6 CNO CHANGE!U!Na1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1O 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 11:56 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]v NO CHANGE!N[a1 MENU Retrieve Save Combine Xtract Erase List Import Directory Read in a spreadsheet file= a b c d e f g h i1O 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 11:58 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] NO CHANGE!jNa1 MENU Enter filename of new spreadsheet: *.wk?( ExpenseReport.wkt JuneBudget.wkt6 a b  c d e f g h i1 9 2 9 3 9 4 1 5  1 6 Retrieve 1 7  1 8 this file. 1 9  1 10 1 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 11:58 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  NO CHANGE!. NKa1 MENU Enter filename of new spreadsheet: *.wk?( ExpenseReport.wkt JuneBudget.wkt6 a b c d e f g h i1O 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 11:58 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  & NO CHANGE!0 gNa1 READY& a b c d 1& This worksheet currently contains2& 3 1300 the numbers of a budget report.4  5 300Labels will be added later. Let's6 1607 175first display all these numbers in8 409 60monetary form, e.g., $300.00.10 2011 250&12 2513 5014  15  108016 17  22018 E19 20 To do this, first select the Worksheet/Global/Format command.21 22 E23 Thu 25-Feb-88 12:03 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph &  EAE NO CHANGE!hNa1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1O 2O 3 1300; 4O 5# 300) 6# 160) 7# 175) 8$ 40) 9$ 60) 10# 20) 11" 250) 12# 25) 13# 50) 14N 15* 1080 16N 17+ 220 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:03 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] +NO CHANGE!=KNa1 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Specify global worksheet parameters4 a b c d e f g h i1O 2O 3 1300; 4O 5# 300) 6# 160) 7# 175) 8$ 40) 9$ 60) 10# 20) 11" 250) 12# 25) 13# 50) 14N 15* 1080 16N 17+ 220 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:04 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] NO CHANGE!@Na1 MENU Format Label-Prefix Column-Width Recalculation Protection Default Zero Specify global formatB a b c d e f g h i1O 2O 3 1300; 4O 5# 300) 6# 160) 7# 175) 8$ 40) 9$ 60) 10# 20) 11" 250) 12# 25) 13# 50) 14N 15* 1080 16N 17+ 220 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:04 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  ,NO CHANGE!Na1 MENU Fixed Scientific Currency , General +/- Percent Date Text Hidden VisibStandard format (x.xx or x.xxExx)6 a b c d e f g h i1& 2& 3 1300 4& 5# 3006# 160Select Currency format.7# 1758$ 409$ 6010# 2011" 25012# 2513# 5014% 15 1080 16 $ 17 220 18 $ 19 $ 20 $ 21 $ 22 $ 23 $ Thu 25-Feb-88 12:05 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  NO CHANGE!lNa1 EDIT Enter number of decimal points: 0 a b c d e f g h i1O 2' 3 1300 4' 5# 300 6# 160 And specify two7# 175 8$ 40 decimal places.9$ 60 10# 20 11" 250 12# 25 13# 50 14N 15* 1080 16N 17+ 220 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:05 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]H  UNO CHANGE!gjNa1 EDIT Enter number of decimal points: 2 a b c d e f g h i1& 2& 3 1300 4& 5# 300Finally, press Return6# 1607# 175to format the numbers.8$ 409$ 6010# 2011" 25012# 2513# 5014% 15* 1080 16N 17+ 220 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:05 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] NO CHANGE!Na1  READY a b c d e f g h i1& 2& 3 * Very good! Notice that two4& 5 $300.00of these numbers are too6 $160.007 $175.00long to be displayed in 8 $40.009 $60.00their current cell width.10 $20.0011 $250.0012 $25.0013 $50.0014% 15  *  165 17' $220.00 18 219 Cell width needs to be increased. Use the20 21 Worksheet/Global/Column-Width command to22 23 increase all columns to a width of 12.Thu 25-Feb-88 12:05 PM 2 Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]22222# #NO CHANGE!#Na1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1O 2O 3 *: 4O 5 $300.00) 6 $160.00) 7 $175.00) 8 $40.00) 9 $60.00) 10 $20.00) 11 $250.00) 12 $25.00) 13 $50.00) 14N 15& * 16N 17' $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:05 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]O& \&NO CHANGE!n&qNa1 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Specify global worksheet parameters4 a b c d e f g h i1O 2O 3 *: 4O 5 $300.00) 6 $160.00) 7 $175.00) 8 $40.00) 9 $60.00) 10 $20.00) 11 $250.00) 12 $25.00) 13 $50.00) 14N 15& * 16N 17' $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:05 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]( (NO CHANGE!(fNa1 MENU Format Label-Prefix Column-Width Recalculation Protection Default Zero Specify global formatB a b c d e f g h i1O 2O 3 *: 4O 5 $300.00) 6 $160.00) 7 $175.00) 8 $40.00) 9 $60.00) 10 $20.00) 11 $250.00) 12 $25.00) 13 $50.00) 14N 15& * 16N 17' $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]d+ q+NO CHANGE!+~Na1 EDIT Column width: 9 a b c d e f g h i1& 2& 3 * $4& 5 $300.00Use the Right Arrow to6 $160.007 $175.00increase the cell width to 12.8 $40.009 $60.00$10 $20.0011 $250.0012 $25.0013 $50.0014% 15& * 16N 17' $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]$$$$$. .NO CHANGE! .N/a1 EDIT Column width: 10 a b c d e f g h 1* 2* 3 $1,300.00 Notice that you can now4* 5# $300.00see all values. 6# $160.007# $175.00Continue to increase the8$ $40.009$ $60.00column width to 12.10# $20.0011" $250.00 12# $25.0013# $50.0014) 15* $1,080.00  16N 17, $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88  12:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ^1 1NO CHANGE!11Na1 EDIT Column width: 11 a b c d e f g 1O 2O 3 $1,300.007 4O 5' $300.00! 6' $160.00! 7' $175.00! 8( $40.00! 9( $60.00! 10' $20.00! 11& $250.00! 12' $25.00! 13' $50.00! 14N 15/ $1,080.00 16N 171 $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph _L3 Y3NO CHANGE!k3N,a1 EDIT Column width: 12 a b c d e f 1O 2O 3 $1,300.005 4 $ 5 $300.00 6 $160.00 7 $175.00 8 $40.00 9 $60.00 10 $20.00 11 $250.00 12  $25.00 13 $50.00 14 And press Return$ 15 $1,080.00 16 to enter the new$ 17 $220.00 18 column width.$ 19 $ 20 $ 21 $ 22 $ 23 $ Thu 25-Feb-88 12:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph `P6 ]6NO CHANGE!o6Na1 READY a b c d e f 1O 2O 3 $1,300.005 4O 5 8 6  7 Excellent. Now let's add some right-aligned labels.  8  9 By default, labels are left-aligned when entered. 10  11 You want all labels to be right-aligned. 12  13 8 14N 154 $1,080.00 16N 176 $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph `8 '9NO CHANGE!91Nxa1 READY a b c d e f 1O 2O 3 $1,300.005 4O 5 8 6  7 Excellent. Now let's add some right-aligned labels.  8  9 By default, labels are left-aligned when entered. 10  11 You want all labels to be right-aligned. 12  13 8 14 %# 15 $1,080.00 16 To do this, first select the# 17 $220.00 18 Worksheet/Global/Label-Prefix# 19 # 20 command.# 21 # 22 %# 23N Thu 25-Feb-88 12:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph `%%%%%%%E< R<NO CHANGE!d<Na1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f 1O 2O 3 $1,300.005 4O 5+ $300.00 6+ $160.00 7+ $175.00 8, $40.00 9, $60.00 10+ $20.00 11* $250.00 12+ $25.00 13+ $50.00 14N 154 $1,080.00 16N 176 $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph `> ?NO CHANGE!?tNa1 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Specify global worksheet parameters6 a b c d e f 1O 2O 3 $1,300.005 4O 5+ $300.00 6+ $160.00 7+ $175.00 8, $4 0.00 9, $60.00 10+ $20.00 11* $250.00 12+ $25.00 13+ $50.00 14N 154 $1,080.00 16N 176 $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph `A ANO CHANGE!AiNa1 MENU Format Label-Prefix Column-Width Recalculation Protection Default Zero Specify global formatD a b c d e f 1O 2O 3 $1,300.005 4O 5+ $300.00 6+ $160.00 7+ $175.00 8, $40.00 9, $60.00 10+ $20.00 11* $250.00 12+ $25.00 13+ $50.00 14N 154 $1,080.00 16N 176 $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph `D  DNO CHANGE!/DN^a1 MENU Left Right Center= Right justification is the default justification) a b c d e f 1O 2O 3 $1,300.005 4 % 5 $300.00 6  $160.00 7  $175.00 8 And type r for $40.00 9  $60.00 10 right alignment. $20.00 11 $250.00 12  $25.00 13 $50.00 14 % 15 $1,080.00 16 % 17 $220.00 18 % 19 % 20 % 21 % 22 % 23 % Thu 25-Feb-88 12:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph `5G OBGNO CHANGE!TGzNa1 READY a b c d e f 12 22 3 $1,300.00 4 & 5 $300.006 Good. From hereon, any label that $160.007 $175.008 you enter will be right-aligned. $40.009 $60.0010 & $20.0011 $250.0012 ! $25.0013 $50.0014 Press Next Page and watch 15 $1,080.00 16 the labels align to the # 17 $220.00 18 right as I enter them# 19  20 into the worksheet. 21  22 ! 23  Thu 25-Feb-88 12:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph `!!!!!!!!!J  JNO CHANGE!JNxa1 LABELJanuary a b c d e f 1O 2O 3 $1,300.005 4O 5+ $300.00 6+ $160.00 7+ $175.00 8, $40.00 9, $60.00 10+ $20.00 11* $250.00 12+ $25.00 13+ $50.00 14N 154 $1,080.00 16N 176 $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:09 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph `L MNO CHANGE!MN{a2 READY a b c d e f 1 January@ 2O 3 $1,300.005 4O 5+ $300.00 6+ $160.00 7+ $175.00 8, $40.00 9, $60.00 10+ $20.00 11* $250.00 12+ $25.00 13+ $50.00 14N 154 $1,080.00 16N 176 $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:09 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T+O  8ONO CHANGE!JONa3 LABELTAKE HOME a b c d e f 1 January@ 2O 3 $1,300.005 4O 5+ $300.00 6+ $160.00 7+ $175.00 8, $40.00 9, $60.00 10+ $20.00 11 * $250.00 12+ $25.00 13+ $50.00 14N 154 $1,080.00 16N 176 $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:10 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph TdQ qQNO CHANGE!Q,Nc4 READY a b c d e f 1 January@ 2O 3 TAKE HOME $1,300.00 EXPENSES( 4O 5+ $300.00 6+ $160.00 7+ $175.00 8, $40.00 9, $60.00 10+ $20.00 11* $250.00 12+ $25.00 13+ $50.00 14N 154 $1,080.00 16N 176 $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:11 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T S SNO CHANGE!S3Nc6 READY a b c d e f  1 January@ 2O 3 TAKE HOME $1,300.00 EXPENSES( 4O 5# Rent $300.00 6+ $160.00 7+ $175.00 8, $40.00 9, $60.00 10+ $20.00 11* $250.00 12+ $25.00 13+ $50.00 14N 154 $1,080.00 16N 176 $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:11 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T V VNO CHANGE! V:Nc7 READY a b c d e f 1 January@ 2O 3 TAKE HOME $1,300.00 EXPENSES( 4O 5# Rent $300.00 6# Food $160.00 7+ $175.00 8, $40.00 9, $60.00 10+ $20.00 11* $250.00 12+ $25.00 13+ $50.00 14N 154 $1,080.00 16N 176 $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:13 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ZX gXNO CHANGE!yXENc8 READY a b c d e f 1 January@ 2O 3 TAKE HOME $1,300.00 EXPENSES( 4O 5# Rent $300.00 6# Food $160.00 7 Car loan $175.00 8, $40.00 9, $60.00 10+ $20.00 11* $250.00 12+ $25.00 13+ $50.00 14N 154 $1,080.00 16N 176 $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:13 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T Z ZNO CHANGE!ZRNc9 READY a b c d e f 1 January@ 2O 3 TAKE HOME $1,300.00 EXPENSES( 4O 5# Rent $300.00 6# Food $160.00 7 Car loan $175.00 8 Gas & Elec $40.00 9, $60.00 10+ $20.00 11* $250.00 12+ $25.00 13+ $50.00 14N 154 $1,080.00 16N 176 $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:14 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T /] <]NO CHANGE!N]_Nc10 READY a b c d e f 1 January@ 2O 3 TAKE HOME $1,300.00 EXPENSES( 4O 5# Rent $300.00 6# Food $160.00 7 Car loan $175.00 8 Gas & Elec $40.00 9 Telephone $60.00 10+ $20.00 11* $250.00 12+ $25.00 13+ $50.00 14N 154 $1,080.00 16N 176 $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:14 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T _ _NO CHANGE!_fNc11 READY a b c d e f  1 January@ 2O 3 TAKE HOME $1,300.00 EXPENSES( 4O 5# Rent $300.00 6# Food $160.00 7 Car loan $175.00 8 Gas & Elec $40.00 9 Telephone $60.00 10" VISA $20.00 11* $250.00 12+ $25.00 13+ $50.00 14N 154 $1,080.00 16N 176 $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:14 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2b ?bNO CHANGE!QbrNc12 READY a b c d e f 1 January@ 2O 3 TAKE HOME $1,300.00 EXPENSES( 4O 5# Rent $300.00 6# Food $160.00 7 Car loan $175.00 8 Gas & Elec $40.00 9 Telephone $60.00 10" VISA $20.00 11 Chocolate $250.00 12+ $25.00 13+ $50.00 14N 154 $1,080.00 16N 176 $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:15 PM; Macro  Edit  Name Abs   Go To  Window Query Table  Calc  Graph T d dNO CHANGE!dzNc13 READY a b c d e f 1 January@ 2O 3 TAKE HOME $1,300.00 EXPENSES( 4O 5# Rent $300.00 6# Food $160.00 7 Car loan $175.00 8 Gas & Elec $40.00 9 Telephone $60.00 10" VISA $20.00 11 Chocolate $250.00 12! Other $25.00 13+ $50.00 14N 154 $1,080.00 16N 176 $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:15 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T \g igNO CHANGE!{gNd17 "BALANCE READY a b c d e f 1 January@ 2O 3 TAKE HOME $1,300.00 EXPENSES( 4O 5# Rent $300.00 6# Food $160.00 7 Car loan $175.00 8 Gas & Elec $40.00 9 Telephone $60.00 10" VISA $20.00 11 Chocolate $250.00 12! Other $25.00 13+ $50.00 14N 15) TOTAL EXP $1,080.00 16N 17+ BALANCE $220.00 18N 19N 20N 21N 22N 23N Thu 25-Feb-88 12:16 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T j  B!jNO CHANGE!3jNd17 "BALANCE READY a b c d e f 1 January" 21 3 TAKE HOME $1,300.00 EXPENSES Remember that global4  5  Rent $300.0alignment must be6  Food $160.07 Car loan $175.0set up BEFORE entering8 Gas & Elec $40.09 Telephone $60.0labels into the10  VISA $20.011 Chocolate $250.0worksheet.12  Other $25.013  $50.014 15  TOTAL EXP $1,080.00 16 ( 17  BALANCE $220.00 18 ( 19 ( 20 ( 21 Press Next Page to continue22 ( 23 ( Thu 25-Feb-88 12:16 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T %%%%% / ~ To retrieve a file, select the File/Retrieve ~ ~ ~ ~ command. But first display the command menu. ~ ~~ ~ Dismiss this message and type '/' . ~ Slash f ~ The main command menu is displayed. ~ ~ ~ ~ To retrieve a file, select the File command. ~ ~~ ~ Dismiss this message and type 'f' . ~ f r ~ The File command menu is displayed. ~ ~  ~ ~ To retrieve a file, select Retrieve. ~ ~~ ~ Dismiss this message and type 'r' . ~ r  ~ There are two files displayed. ~ ~ You want to retrieve JuneBudget.wkt.  ~ ~ To do so, you must highlight the filename. ~ ~~ ~ Dismiss this message and press the Right Arrow. ~ RightArrow 0x0A ~ To retrieve the file, you must press Return. ~ ~ ~ ~  ~ ~~ ~ Dismiss this message and press Return. ~ Return / Slash w w g g f f c c 2 2 0x0A Return / Slash w w g g c c  RightArrow  RightArrow  RightArrow 0x0A Return time / Slash w w g g l l r r 0x0C time time time time time time time time time time time time time time2am e/ JHPN  NO CHANGE!+Na1 MENU Format Label-Prefix Column-Width Recalculation Protection Default Zero Speify globa format    Controls recalculation forthe entire worksheetDetermines column width for entire worksheetAligns all labels to the left, right, or center of cell Determines the way values are displayed for the entire worksheet.Format choices are the same as those in the Range/Format menu.J [2am dc JHPN  ONO CHANGE!+Na1 MENU . Recalculation Protection Default Zero  When yes is specified, zerovalues are displayed as "0"instead of a blank cellDefines printer settings to be usedwith every worksheetEnables or disables protection for the entirework 2am jd JHPN  NO CHANGE!+jN9Formatting the Entire WorksheetPIn this lesson, you will learnhow to protect your worksheethow to set up a particular format forall values in your worksheethow to change the column width of yourentire worksheethow to change label alignment for yourentire worksheetP''( 2am cA JHPN   CNO CHANGE!+NFormatting the Entire WorksheetP7Now, we'll focus on how to changethe entire worksheet rather than just a part of it.7Pp2am Nd JHPN   NO CHANGE!+NN6Formatting the Entire WorksheetP<4The Worksheet/Global commands are used to setup standards that affect the entire worksheet.Such standards include formatting, column-width,label prefixes and protection, to name a few.4Pp2am e! JHPN  LNO CHANGE!+N a1 MENU Format Label-Prefix Column-Width Recalculation Protection Default Zero Specify global format / a b c d  e f g 1 2 3 4 5 Global commands are available through6 7 the Worksheet/Global commands menu.8 9 .10 11 12 13 14 15 16 17 18 19 20 21 22 23 Wed 24-Feb-88 12:01 PM; Macro  Edit   Name Abs  Go To  Window Query Table  Calc  Graph KJ]2am ep JHPN  FNO CHANGE!+NMa1 MENU Format Label-Prefix Column-Width Recalculation Protection Default ZeroSpeify globalformat 6  a b c  d e f g 1 2 3 &4  5 Some of these commands should look familiar to you,6 7 in particular, Format, Label-Prefix,8 9 and evenColumn-Width.10 11 712 13 14 15 16 17 18 19  20 21 22 23 Wed 24-Feb-88 12:01 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph K( ]2am Uf JHPN  FNO CHANGE!+UNa1 MENU Format Label-Prefix Column-Width Recalculation Protection Default ZeroSpecify global format / a b c d e f g 1 2 3 74 5 Some of these commands should look familiar to you,6 7 in particular, Format, Label-Prefix,8 9 and evenColumn-Width.10 11 12 13 Format and Label-Prefix have related Range14 15 commands, Format and Label.16 17 718 19 20 21 22 23 Wed 24-Feb-88 12:01 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph KF]333332am fZ  JHPN  FNO CHANGE!+N a1 MENU Format Label-Prefix Column-Width Recalculation Protection Default ZeroSpecify global format / a b c d e f g 1 2 3 74 5 Some of these commands should look familiar to you,6 7 in particular, Format, Label-Prefix,8 9 and evenColumn-Width.10 11 12 13 FormatandLabel-PrefixhaverelatedRange14 15 commands,FormatandLabel.16 17 18 Column-Width is a Worksheet command19 20 that was introduced in an earlier lesson.21 22 723 Wed 24-Feb-88 12:01 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph KF]333333333332am f JHPN  #NO CHANGE!+ Noa1 MENU Format Label-Prefix Column-Width Recalculation Protection Default Zero Specify global format / a b c d e f g 1 2 3 74 5 The main difference between those commands and6 7 these global commands is that8 9 global commands affect the entire worksheet10 11 rather than just a specific cell range.12 13 714 15 16 17 18 19 20 21 22 23 Wed 24-Feb-88 12:01 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph KJ]2am f JHPN  #NO CHANGE!+Na1 MENU Format Label-Prefix Column-Width Recalculation Protection Default Zero Specify global format / a b c d e f g 1 2 3 74 5 The main difference between those commands and6 7 these global commands is that8 9 global commands affect the entire worksheet10 11 rather than just a specific cell range.12 13 714 15 16 17 18 Press Next Page for a description 19 20 of each of these global commands.21 22 23 Wed 24-Feb-88 12:01 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph KJ]+!!!+ sheetPpntXformat>all>ProtZSD.font+ZCarla.font>Gformat>all>qseg1Wformat>all>MC12am e JHPN   ONO CHANGE!+NQuestion Formatting the Entire WorksheetP@MThe main reason for protecting your worksheetUusing the Worksheet/Global/Protect command isCLHTOF1 - to ensure that cells are not accidentally modifiedIIF2 - to hide cells from viewPCF3 - to ensure that worksheet files cannot be deletedLEF4 - None of the aboveE(Select your answer by pressing one of the indicated selections)P777777777777@2am c P format>all>TF2 2am fe JHPN   NO CHANGE!+fNFormatting the Entire WorksheetPQThe main reason for protecting your worksheetusing the Worksheet/Global/Protect command isWF1 - to ensure that cells are not accidentally modifiedF2 - to hide cells from viewF3 - to ensure that worksheet files cannot be deletedF4 - None of the above2Correct! You protect your worksheet to ensurethat cells are not accidentally modified.2P777777755555222222am #c P Gformat>all>MC1.correct(#Lformat>all>MC1.common.path2am #c P !Gformat>all>MC1.incorrect*#Lformat>all>MC1.common.path2am #c  P !Gformat>all>MC1.incorrect*#Lformat>all>MC1.common.path2am #c P !Gformat>all>MC1.incorrect*#Lformat>all>MC1.common.path2am he JHPN  "NO CHANGE!+hNFormatting the Entire WorksheetPQThe main reason for protecting your worksheetusing the Worksheet/Global/Protect command is^F1 - to ensure that cells are not accidentally modifiedF2 - to hide cells from viewF3 - to ensure that worksheet files cannot be deletedF4 - None of the aboveBThat's incorrect. The correct answer is F1. You protect yourworksheet to ensure that cells are not accidentally modified.BP777777755555BBBBB2am +c N + F1  F2  F3  F4  2am md JHPN   NO CHANGE!+mNMFormatting the Entire WorksheetP$The first thing we'll discuss isprotecting your worksheet.$6One of the main reasons for protecting informationin your worksheet is to ensure that cell contentscannot be modified.6PJ 2am d JHPN  CNO CHANGE!+NFormatting the Entire WorksheetPJ8When you protect a cell, you are essentially"locking" the contents of a cell. And you cannotmodify a "locked" cell. You must "unlock" it first.8lPp2am d JHPN  NO CHANGE!+NFormatting the Entire WorksheetPQ+Protecting your cells is a good idea,however, not all cells need protection.Cells that are intended to be modifiedshould not be protected.+Pp2am gd JHPN  'NO CHANGE!+gNOFormatting the Entire WorksheetPS&For example, the expense values inyour expense report should be leftunprotected. You are more likelyto change those values rather thanthe labels, formulas and functionsin your worksheet.&Pp 2am d JHPN  NO CHANGE!+NRFormatting the Entire WorksheetPH<To enable or disable protection of the entire worksheet,use the Worksheet/Global/Protection command.To protect or unprotect cell ranges within a worksheet, use the Range/Protect or Range/Unprotect commands.<*P 2am dM JHPN  NO CHANGE!+NFormatting the Entire WorksheetP=There is no protection when you first create a worksheet. Therefore, if you want to enable protection, you mustfirst use the Worksheet/Global/Protection command.After enabling global protection, you can then usethe Range/Unprotect command to unprotect those cellsyou intend to modify.=9Pp2am g! JHPN  NO CHANGE!+Na11 ' Total Expenses 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 Advances $1,200.00 13 Balance Due To Employee 14 Balance Due From Employee $198.00 15 16 17 18 19 20 21 22  23 Mon 22-Feb-88 6:16 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  $NO CHANGE!Na11 ' Total Expenses READYExpense values a b c d e f g 1 EXPENSE REPORT 6 2 - Total 3 Date  01/06/88 01/07/88 01/08/88 Expenses 4 -6-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 Advances   $1,200.00 13 Balance Due To Employee 14 Balance Due From Employee $198.00 15 Travel Advance value16 17 018 19 Let's protect your worksheet. You are going 20 21 to protect all cells except the expense22 23 values and the travel advance value.Mon 22-Feb-88 6:16 PM  Macro  Edit  Name A0h T  2am fr JHPN   >NO CHANGE!+NOa11 ' Total Expenses 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 ).00 $267.00 8 Meals .00 $75.00 9 Entertainment Remember, this is a two-step process: $75.00 10 -- 11 Total Expenses.00 $1,002.00 12 Less Advances First, protect the entire worksheet.$1,200.00 13 Balance Due To 14 Balance Due FrThen, unprotect the expense values $198.00 15 16 and the travel advance value.17 18 )19 20 21 22  23 Mon 22-Feb-88 6:16 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am gU JHPN  ENO CHANGE!+BNa11 ' Total Expenses 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,0  02.00 12 Less Advances !$1,200.00 13 Balance Due To Employee 14 Balance Due From EmployeeProtect the entire worksheet. $198.00 15 16 !17 ,18 19 To do this, select the20 21  Worksheet/Global/Protection command.22  23 ,Mon 22-Feb-88 6:16 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ,,,,,m zNO CHANGE!NYa11 ' Total Expenses 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 $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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:01 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T {  NO CHANGE! N 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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:01 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T l yNO CHANGE!N1a11 ' Total Expenses MENU Format Label-Prefix Column-Width Recalculation Protection Default Zero Specify global formatB 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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:01 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T R _NO CHANGE!qHNa11 ' Total Expenses %MENU Enable Disable  Disable protectionProtection is currently disabled. a b c  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.0  0 $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 Advances $1,200.00 13 Balance Due To Employee 14 Balance Due From Employee $198.00 15 16 (17 18 Typeeto enable protection.19 20 (21 22 23 Wed 24-Feb-88 12:01 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph %%%  ONO CHANGE!N a11 PR ' Total Expenses READY< >  b c d e f g 1 EXPNSE REPORT 7 2 - Total 3 Date  01/06/88 01/07/88 01/08/88 Expenses 4 -6- 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 -6- 11 Total Expenses 00 $1,002.00 12    $1,200.00 13  Now, unprotect the  14 The format, PR, displays   $198.00 15 expense values found  16 for the current cell.   17 in the range, d5 to f9.  18 PR stands for protected.   19  20 In fact, every cell now  21   22 has the format, PR.  First, Go To cell d5.  23   Wed  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph L  DNO CHANGE!N"a11 PR ' Total Expenses POINTEnter address to go to: a11 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 Go to d5.17 18 19 20 21 22 23 Wed 24-Feb-88 12:02 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!Na11 PR ' Total Expenses EDIT Enter address to go to: d 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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:02 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T <# I#NO CHANGE![#Na11 PR ' Total Expenses 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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:02 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T & H&NO CHANGE!&"Nqd5 (C2) PR [W12] 450 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 '$1,002.00 12 Less Advances $1,200.00 13 Balance Due To EmployeUnprotect all expense values, which 14 Balance Due From Emplo $198.00 15 are found in the range, d5 to f9. 16 17 '18 219 20 First, select the Range/Unprotect command.21 22 223 Wed 24-Feb-88 12:03 PM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 222+ ++NO CHANGE!=+NWd5 (C2) PR [W12] 450 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 $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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:03 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T //  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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:03 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 3 ))3NO CHANGE!;3;Nd5 (C2) PR [W12] 450 POINTEnter range to unprotect: d5..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 Advances $1,200.00 13 Balance Due To Employee 14 Balance Due From EmployeeUnprotect the $198.00 15 16 range, d5 to f9.17 18  19 520 21 Use the Down Arrow to select cells, d6 to d9.22 23 5Wed 24-Feb-88 12:03 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 555v7 7NO CHANGE!7Nd6 (C2) PR [W12] 45 POINTEnter range to unprotect: d5..d6 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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:04 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  !; .;NO CHANGE!@;Nd7 (C2) PR [W12] 89 POINTEnter range to unprotect: d5..d7 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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:04 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   > >NO CHANGE!>Nd8 (C2) PR [W12] 89POINTEnter range to unprotect: d5..d8 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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:04 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T    B BNO CHANGE!B0Nhd9 POINTEnter range to unprotect: d5..d9 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 Advances $1,200.00 13 Balance Due To Employee 14 Balance Due From Employee $198.00 15 16 17 .18 19 Then, use the Right Arrow to select20 21 the expense values in columns e and f.22 23 .Wed 24-Feb-88 12:04 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T     .....F FNO CHANGE!FNe9 (C2) PR [W12] 75 POINTEnter range to unprotect: d5..e9 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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:04 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph TJ /JNO CHANGE!J NMf9 POINTEnter range to unprotect: d5..f9The range is defined.)  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 Advances $1,200.00 13 Balance Due To Employee  14 Balance Due From Employee $198.00 15 16 17 18 Unprotect it.19 20 21 22 23 Wed 24-Feb-88 12:05 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$$$$$N DNNO CHANGE!NBN}d5 (C2) U [W12] 450 READY O F  d e f g 3 The format, U, displays) Total 01/06/88 01/07/88 01/08/88 Expenses for the current cell.2-  $450.00 $450.00 U means unprotected. $45.00 $45.00 $45.00 $135.00   $89.00 $89.00 $89.00 $267.00 Note that unprotected $25.00 $25.00 $25.00 $75.00  $75.00 $75.00 cells are in bold.2-  $609.00 $234.00 $159.00 $1,002.00  $1,200.00 13 Balance Due To Employee 14 Balance Due From Employee $198.00 15 16 17 Now, unprotect the travel advance.18 19 &20 21 22 Go To cell g12.23 Wed 24-Feb-88 12:05 PM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 3 $$"$S (&SNO CHANGE!8SNd5 (C2) U [W12] 450 POINTEnter 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 A  ir, 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 18 19 Go to g12.20 21 22 23 Wed 24-Feb-88 12:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T $$$$W !WNO CHANGE!3WNd5 (C2) U [W12] 450 EDIT Enter address to go to: g 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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T $$$$Z ZNO CHANGE!ZNd5 (C2) U [W12] 450 EDIT Enter address to go to: g1 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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T $$$$^ ^NO CHANGE!^Nd5 (C2) U [W12] 450 EDIT Enter address to go to: g12 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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T $$$$=b #JbNO CHANGE!\bNg12 (C2) PR [W12] 1200 READY O F  d e f g 1 3 2 The cell is currently) Total 3 01/06/88 01/07/88 01/08/88 Expenses 4 protected.2- 5  $450.00 $450.00 6  $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 1  0 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 18 Unprotect it.19 20 21 22 23 Wed 24-Feb-88 12:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 5$$$$$ If VfNO CHANGE!hf NYg12 (C2) PR [W12] 1200 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 $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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$$$$$ tj jNO CHANGE!jN5g12 (C2) PR [W12] 1200 MENU Format Label Erase Name Justify Protect Unprotect Input Value TransposeFormat one or more cells? 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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$$$$$ {n nNO CHANGE!nNg12 (C2) PR [W12] 1200 POINTEnter range to unprotect: g12..g12 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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$$$$$ >r KrNO CHANGE!]rNg12 (C2) U [W12] 1200 READY O L a  b c d e f g 1 EXPENS REPORT> 2 ; Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 -D- 5 Air,rail, bus $450.00 $450.00 6 Rentl car $45.00 $45.00 $45.00 $135.00 7  $89.00 $89.00 $89.00 $267.00 8  $25.00 $25.00 $25.00 $75.00 9 The cell is unprotected, $75.00 $75  .00 10/- 11and its contents are in $609.00 $234.00 $159.00 $1,002.00 12  $1,200.00 13bold. 14 $198.00 15Remember that any cell not16 17 in bold is protected. YouMove the cell18 19 cannot modify its contents.pointer up once.20 21 22 23 Wed 24-Feb-88 12:07 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  I$$### v <vNO CHANGE!v5Nrg11 (C2) PR [W12] @SUM(g9..g5)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 Advances $1,200.00 13 Balance Due To Employee  14 Balance Due From Employee $198.00 15 Try to type something16 17 into this cell.18 19 20 21 22 Type the number, 1.23 Wed 24-Feb-88 12:08 PM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$$$$$  2{ @?{NO CHANGE!Q{Ng11 (C2) PR [W12] @SUM(g9..g5)ERROR 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 18N 19N 20N 21N 22N 23N Cell is lockedC Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$$$$$  ~ +~NO CHANGE!~Ng11 (C2) PR [W12] @SUM(g9..g5)ERROR a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date  01/07/88 01/08/88 Expenses 4 -&- 5 Air, rAha! It can't be done.0 $450.00 6 Rental0 $45.00 $45.00 $135.00 7 Daily 0 $89.00 $89.00 $267.00 8 !0 $25.00 $25.00 $75.00 9  $75.00 $75.00 10 --A message displays where the&- 11 0 $234.00 $159.00 $1,002.00 12 date and time is displayed,$1,200.00 13 14 and a beep sounds (although $198.00 15 16 you did not hear one). Also,17 18 note that the mode indicatorPress Cancel to return19 20 says ERROR.to READY mode.21 22  23 Cell is locked  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T!!! ! !!!!!!!!!à HЃNO CHANGE!ANPg11 (C2) PR [W12] @  SUM(g9..g5)READY a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date - Expenses 4 -- 5 Air, rail, You will get the same response if you $450.00 6 Rental car 00 $135.00 7 Daily lodgitry to modify any cell that is protected.00 $267.00 8 Meals 00 $75.00 9 Entertainme $75.00 10 -Well, your expense report is complete!- 11 Total Expen00 $1,002.00 12 Less Advanc-$1,200.00 13 Balance Due To Employee 14 Balance Due From Employee $198.00 15 16 &17 18 However, before you celebrate,19 20 save your worksheet.21 22 &23 Wed 24-Feb-88 12:09 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  &&&&&# N0NO CHANGE!BN^g9 (C2) PR [W12] @SUM(f9..d9) 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 $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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:51 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$$$$$  W  NdNO CHANGE!vN.g9 (C2) PR [W12] @SUM(f9..d9) MENU Retrieve Save Combine Xtract Erase List Import Directory Read in a spreadsheet file= 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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:51 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$$$$$  [ hNO CHANGE!zNg9 (C2) PR [W12] @SUM(f9..d9) EDIT Enter save filename: ExpenseReport 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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:51 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$$$$$   ' 4NO CHANGE!FN g9 (C2) PR [W12] @SUM(f9..d9)MENU CancelReplaceCanceloperation;don'toverwritefile 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 18N 19N 20N 21N 22N 23N Wed 24-Feb-88 12:51 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$$$$$   !NO CHANGE!&N(g9 (C2) PR [W12] @SUM(f9..d9) 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 18 Congratulations on a job well done! 19 20 21 Press Next Page to continue 22 23 Wed 24-Feb-88 12:52 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$$$$$  -#--/ Slash w w g g p p e e  F5 d d 5 5 0x0A Return / Slash r r u u DownArrow DownArrow ~ You are currently defining the range to ~ ~ unprotect, which is d5..f9. ~ ~  ~ ~ Dismiss this message and press Down Arrow ~ ~ until you reach cell d9. ~ DownArrow DownArrow  RightArrow  ~ You are currently defining the range to ~ ~ unprotect, which is d5..f9. 2am =e JHPN  ONO CHANGE!+N'! 0NO CHANGE!=NFormatting the Entire Worksheet5To prevent information in your worksheetfrom being modified, protect yourworksheet.'Protecting your worksheet is a two-stepprocess:!1)Select the Worksheet/Global/Protectioncommand to enable protection for theentire worksheet.2)Select the Range/Unprotect command tounprotect cells that you intend tomodify.5(' 2am 2e JHPN   ONO CHANGE!+2NFormatting the Entire Worksheet5To re-enable protection on a range ofcells, select the Range/Protect command.To display all values in the worksheet as'currency, select the !Worksheet/Global/Format/Currency command.To change the column width of the entireworksheet, select the Worksheet/Global/Column-Width command.5%;)N( 2am |d JHPN  NO CHANGE!+|NIFormatting the Entire Worksheet5To align labels in the entire worksheetat the left, right, or center of the cell,select the Worksheet/Global/Label-Prefix command.'!5')R ~ ~ ~ ~ Dismiss this message and press Right Arrow ~ ~ until you reach column f. ~ RightArrow 0x0A Return  F5 g g 1 1 2 2 0x0A Return / ~ To unprotect a cell or range of cells, ~ ~ select the Range/Unprotect command. ~ ~ But first display the command menu. ~ ~~ ~ Dismiss this message and type '/' . ~ Slash r ~ The main command menu is displayed. ~ ~ To unprotect cells, select Range/Unprotect. ~ ~ ~ ~~ ~ Dismiss this message and type 'r' for Range. ~ r u ~ The Range command menu is displayed. ~ ~ To unprotect cells, select Unprotect.  ~ ~ ~ ~~ ~ Dismiss this message and type 'u' for Unprotect. ~ u 0x0A ~ To unprotect the cells, you must press Return. ~ ~~ ~~ ~~ ~ Dismiss this message and press Return. ~ Return  UpArrow 1 1 time  Cancel / ~ To save your worksheet, select the ~ ~ File/Save command. ~ ~ The keystroke combination is /fs ~ ~~ ~ Dismiss this message and type '/' . ~ Slash f ~  You currently saving your file. ~ ~~ ~~ ~~ ~ Dismiss this message and type 'f' for File. ~ f s ~ You currently saving your file. ~ ~~ ~~ ~~ ~ Dismiss this message and type 's' for Save. ~ s 0x0A Return r r time -- JHPN  INO CHANGE!+N4Question 1Formatting the Entire WorksheetPT R U E o r F A L S EL4Protected cells are displayed in bold print.$Correct. This statement is false.$$Unprotected cells are displayed in$$bold print, not protected cells.P404,,, ,,,2am d+ JHPN  6NO CHANGE!+N@Question 1Formatting the Entire WorksheetPT R U E o r F A L S EL4Protected cells are displayed in bold print.%That's incorrect. This statement%%is false. Unprotected cells are%%displayed in bold print, not protected cells.OP404+++ ++++2am d> JHPN   NO CHANGE!+NaQuestion Formatting the Entire WorksheetPT R U E o r F A L S E1Your worksheet is currently unprotected. To enable protection for the entireworksheet, use the Range/Protect command.1 (Select your answer by pressing one of the indicated selections)P?1111111(@2am c P Gformat>all>gl.1!Gformat>all>gl.29Gformat>all>gl.3QZCarla.fontdZSD.fonttXformat>all>GlobZSD.fontZCarla.fontGformat>all>qseg2format>all>TF3 2am #c P Gformat>all>TF2.true%#Lformat>all>TF2.common.path2am #c P Gformat>all>TF2.false&#Lformat>all>TF2.common.path2am e JHPN  HNO CHANGE!+NFormatting the Entire WorksheetPT R U E o r F A L S E1Your worksheet is currently unprotected. To enable protection for the entireworksheet, use the Range/Protect command.  Correct. This statement is false. To enable protection for the entire worksheet, use the Worksheet/Global/Protect command. The Range/Protect command can be used toprotect cells only after global protectionis enabled.P?111111133333333324 $42am !c  N ! TRUE  FALSE 2am e7 JHPN  INO CHANGE!+NFormatting the Entire WorksheetPT R U E o r F A L S E1Your worksheet is currently unprotected. To enable protection for the entireworksheet, use the Range/Protect command.  That's incorrect. This statement is false.  To enable protection for the entire  worksheet use the Worksheet/Global/Protect  command. The Range/Protect command can be used to protect cells only after global protection is enabled.P?11111113333333332552am d JHPN   NO CHANGE!+N+Question Formatting the Entire WorksheetPT R U E o r F A L S E3The Worksheet/Global/Format commandsaffect both new values and existing values.3N (Select your answer by pressing one of the indicated selections)P33333)@2am c P format>all>TF4 2am #c P Gformat>all>TF3.true%#Lformat>all>TF3.common.path2am #c P Gformat>all>TF3.false&#Lformat>all>TF3.common.path2am d[ JHPN  NO CHANGE!+NnFormatting the Entire WorksheetPT R U E o r F A L S E3The Worksheet/Global/Format commandsaffect both new values and existing values.  "That's incorrect. This statement is""true. The Worksheet/Global/Format"commands format both new values andexisting values.P33333.......2am !c N ! TRUE  FALSE  2am dR JHPN  FNO CHANGE!+NeFormatting the Entire WorksheetPT R U E o r F A L S E3The Worksheet/Global/Format commandsaffect both new values and existing values.  "Correct. This statement is true.""The Worksheet/Global/Format commands"format both new values and existing values. P33333.......".2am wd JHPN   NO CHANGE!+wN*Question Formatting the Entire WorksheetPT R U E o r F A L S E1The Worksheet/Global/Label-Prefix commandaffects both new and existing labels.1O (Select your answer by pressing one of the indicated selections)P)(&(@2am c P Gformat>all>rev.1"Gformat>all>rev.2;Gformat>all>rev.3TGformat>all>rev.4mNformat>menu2am #c P Gformat>all>TF4.true%#Lformat>all>TF4.common.path 2am #c P Gformat>all>TF4.false&#Lformat>all>TF4.common.path2am dc JHPN  ,NO CHANGE!+N}Formatting the Entire WorksheetPT R U E o r F A L S E1The Worksheet/Global/Label-Prefix commandaffects both new and existing labels.  "Correct. This statement is false.""This command affects alignment for" new labels only. It does not affectthe alignment of existing labels.P)(&.....&...2am !c N ! TRUE  FALSE 2am e|  JHPN  9NO CHANGE!+NFormatting the Entire WorksheetPT R U E o r F A L S E1The Worksheet/Global/Label-Prefix commandaffects both new and existing labels.  That's incorrect. This statement is false. This command affects the alignment of new labels only. It doesnot affect the alignment of existinglabels.kP)(&0000000000.2am d  JHPN  NO CHANGE!+NR- Question -Printing Your WorksheetPFILLINTHEBLANKNNNN 6 Solution Designer lets you print worksheets to either a printer or a ~~ . 6 NNNNN(Type your answer and press GO when ready)Pc0M*2am c" JHPN   'NO CHANGE!+NPrinting Your WorksheetPThat's correct.Solution Designer lets you print your worksheetto either a printer or a file.*PA+ 2am c P Gprint>FIB1.a000!Lprint>FIB1.common.path2am c  JHPN  4NO CHANGE!+NPrinting Your WorksheetPThat's incorrect.Solution Designer lets you print worksheetsto either a printer or a file.*PA+2am c P Gprint>FIB1.a999!Lprint>FIB1.common.path2amch!pPfile+sPfilename 2am c P print>TF22am g  JHPN  NO CHANGE!+Na11 ' Total ExpensesMENU Range Line Page Options Clear Align Go Extended Quit Output the specified range to the printer. 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 -$- 5 Air, rail, bus  $450.00 6 Rental car Now let's print your worksheet 00 $135.00 7 Daily lodging 00 $267.00 8 Meals to a file. However, before you00 $75.00 9 Entertainment  $75.00 10 -do so, you must first returnto- 11 Total Expenses 00 $1,002.00 12 Less Advances READY mode.$1,200.00 13 Balance Due To Emplo 14 Balance Due From Emp$ $198.00 15 16 17 (18 19 To do this, typeqfor Quit.20 21 (22 23 Tue 01-Mar-88 10:52 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   JNO CHANGE!N5a11 ' Total ExpensesREADY 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 Advances $1,200.00 13 Balance Due To Employee 14 Balance Due From Employee $198.00 15 16 17 :18 19 To print to a file, select the Print/File command.20 21 :22 23 Tue 01-Mar-88 10:52 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T *6*  NO CHANGE! NVa11 ' Total ExpensesMENU 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, ra il, 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 18N 19N 20N 21N 22N 23N Tue 01-Mar-88 10:51 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!Na11 ' Total ExpensesMENU Printer FileC Print to a printerE 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 18N 19N 20N 21N 22N 23N Tue 01-Mar-88 10:51 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T O \NO CHANGE!nMNa11 ' Total ExpensesEDIT Enter print filename:  A prompt displays to enter 0   a b c the file to print to. 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 Advances $1,200.00 13 Balance Due To Employee 14 Balance Due From Employee $198.00 15 16 17 .18 19 Type in the filename, Jan.ExpRpt.20 21 .22 23 Tue 01-Mar-88 10:53 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph !   NO CHANGE!{Na11 ' Total ExpensesEDIT Enter print filename: J 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 18N 19N 20N 21N 22N 23N Tue 01-Mar-88 10:59 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T U bNO CHANGE!t|Na11 ' Total ExpensesEDIT Enter print filename: Ja 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 E ntertainment $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 18N 19N 20N 21N 22N 23N Tue 01-Mar-88 10:59 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!}Na11 ' Total ExpensesEDIT Enter print filename: Jan 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 18N 19N 20N 21N 22N 23N Tue 01-Mar-88 10:59 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ! !NO CHANGE!!~Na11 ' Total ExpensesEDIT Enter print filename: Jan. 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 18N 19N 20N 21N 22N 23N Tue 01-Mar-88 10:59 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T )% 6%NO CHANGE!H%Na11 ' Total ExpensesEDIT Enter print filename: Jan.E 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 18N 19N 20N 21N 22N 23N Tue 01-Mar-88 10:59 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ( (NO CHANGE!(Na11 ' Total ExpensesEDIT Enter print filename: Jan.Ex 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 18N 19N 20N 21N 22N 23N Tue 01-Mar-88 10:59 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  f, s,NO CHANGE!,Na11 ' Total ExpensesEDIT Enter print filename: Jan.Exp 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 18N 19N 20N 21N 22N 23N Tue 01-Mar-88 10:59 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 0 0NO CHANGE!%0Na11 ' Total ExpensesEDIT Enter print filename: Jan.ExpR 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 18N 19N 20N 21N 22N 23N Tue 01-Mar-88 10:59 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 3 3NO CHANGE!3Na11 ' Total ExpensesEDIT Enter print filename: Jan.ExpRp 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 18N 19N 20N 21N 22N 23N Tue 01-Mar-88 10:59 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T I7  V7NO CHANGE!h7NOa11 ' Total ExpensesEDIT Enter print filename: Jan.ExpRpt 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 >18 19 And press Return to print your worksheet to this file.20 21 >22 23 Tue 01-Mar-88 10:59 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T >>>\; Fi;NO CHANGE!{;Na11'TotalExpensesMENU RangeLinePageOptionsClearAlignGoExtendedQuitOutputthespecifiedrangetoth eprinter 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 Your print filename has been entered.18 19 To print your worksheet to a file,20 21 select the Go command.22 23 -Tue 01-Mar-88 10:59 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ------- @  O@NO CHANGE!*@mNa11'TotalExpensesMENU  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,002q q / ~You are going to print your worksheet to a file. ~ ~ The keystroke combination to do this is /pf ~ ~ ~ ~~ ~ Dismiss this message and type '/'. ~ Slash p ~ Select the Print command. ~ ~~ ~~ ~~ ~ Dismiss this message and type 'p'. ~ p f ~ You are to print to a file. ~ ~~ ~~ ~~ ~ Dismiss this message and type 'p'. ~ f J ShiftRight j a ~The print filename you are currently entering is ~ ~~ ~ Jan.ExpRpt ~ ~~ ~ Dismiss this message and type 'a' ... ~ a n ~The print filename you are currently entering is ~ ~~ ~ Jan.ExpRpt ~ ~~ ~ Dismiss this message and type 'n' ... ~ n . ~The print filename you are currently entering is ~ ~~ ~ Jan.ExpRpt ~ ~~ ~ Dismiss this message and type '.' ... ~ Period E ~The print filename yo2am 9h JHPN   NO CHANGE!+N  @ MNO CHANGE!_Nnt Wpertle2am c0  JHPN   NO CHANGE!+NPrinting Your WorksheetP0The Print command lets you print a worksheetto a printer or a file.0pP2am d JHPN  NO CHANGE!+NPrinting Your WorksheetPIn this lesson, you will learnhow to use the Print command toprint to a printerhow to use the Print command toprint to a fileways to format the printed copyof your worksheetEPp 2am d JHPN  =NO CHANGE!+ NPrinting Your WorksheetPQ+You just learned how to create a simpleprinted copy of your worksheet.Now take a look at what else thePrint command can do.+Pp2am eE JHPN  :NO CHANGE!+NPrintingYourWorksheetPNName: Michelle SmithEXPENSEREPORTTotal1/6/881/7/881/8/88Expenses.Air,rail,bus$450.00$450.00Rentalcar$45.00$45.00$45.00$135.00Dailylodging$89.00$89.00$89.00$267.00Meals$25.00$25.00$25.00$75.00Entertainment$75.00$75.00.TotalExpenses$609.00$234.00$159.00$1002.00LessAdvances$1200.00BalanceDueToEmployeeBalanceDueFromEmployee$198.00. and you can setpage length.XYZ Company N Ph 2am df JHPN  +NO CHANGE!+dNPrintingYourWorksheetP&EXPENSEREPORTYou can set border columns or rows.1/6/88"Air,&RentThese are columns or rows DailEXPENSEREPORTMealthat get displayed on each Ente1/7/88" page of your printout, such TotalAir,rail,busLessARentalcar$45.00as the first two columns in BalancDailylodging$89.00BalancMeals$25.00your expense report thatEntertainment$75.00"contain the labelsTotalExpenses$234.00LessAdvancesidentifying the variousBalanceDueToEmployeeBalanceDueFromEmployeeexpenses.& P#u@And finally,EXPENSEREPORTTotalyoucan1/6/88Expenses.specifyhowAir,rail,bus$450.00$450.00Rentalcar$45.00$135.00manycopiesDailylodging$89.00$267.00Meals$25.00$75.00youwantEntertainment$75.00.printed.TotalExpenses$609.00$1002.00LessAdvances$1200.00BalanceDueToEmployeeBalanceDueFromEmployee$198.00XYZ Company2Z P           Q O^NO CHANGE!p%NzPrintingYourWorksheetP22Name: Michelle SmithAndfinally,EXPENSEREPORTyoucanTotal1/6/88Expensesspecifyhow.Air,rail,bus$450.00$450.00manycopiesRentalcar$45.00$135.00Dailylodging$89.00$267.00youwantMeals$25.00$75.00Entertainment$75.00printed..TotalExpenses$609.00$1002.00LessAdvances$1200.00BalanceDueToEmployeeBalanceDueFromEmployee$198.00XYZ Company2 P4 A NO CHANGE! oNPrintingYourWorksheetP2222am of JHPN  ANO CHANGE!+NIPrintingYourWorksheetP2Name: Michelle SmithAnd finally,EXPENSEREPORTTotalyoucan1/6/88Expenses.specifyhowAir,rail,bus$450.00$450.00Rentalcar$45.00$135.00manycopiesDailylodging$89.00$267.00Meals$25.00$75.00youwantEntertainment$75.00.printed.TotalExpenses$609.00$1002.00LessAdvances$ 1200.00BalanceDueToEmployeeBalanceDueFromEmployee$198.00XYZ Company2Z P            ONO CHANGE!%NzPrintingYourWorksheetP22Name: Michelle SmithAndfinally,EXPENSEREPORTyoucanTotal1/6/88Expensesspecifyhow.Air,rail,bus$450.00$450.00manycopiesRentalcar$45.00$135.00Dailylodging$89.00$267.00youwantMeals$25.00$75.00Entertainment$75.00printed..TotalExpenses$609.00$1002.00LessAdvances$1200.00BalanceDueToEmployeeBalanceDueFromEmployee$198.00XYZ Company2 P42am 8g JHPN   -NO CHANGE!+8N~a18H MENU As-Displayed Cell-Formulas Formatted Unformatted Print range as displayed : a b c  d e f g 1 EXPENSE REPORT 3 2 ) Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 -2- 5 Air, rail, bus  $587.00 $587.00 6 Rental car % $108.00 7 Daily lodging  $225.00 8 Meals The Other commands menu provides you $95.00 9 Entertainment  $75.00 10  -with different ways of displaying the - 11 Total Expenses $1,090.00 12 Less Advances information in the printed copy of $1,200.00 13 Balance Due To Emp 14 Balance Due From Eyour worksheet. $110.00 15 16 )17 18 19 20 21 22 23 Wed 30-Mar-88 3:39 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph K D72am e JHPN  6NO CHANGE!+NtPrintingYourWorksheetPYou can get a printout of your worksheet"as displayed" on the screen .KEXPENSEREPORTTotal1/6/881/7/881/8/88ExpensesCAir,rail,bus$450.00$450.00Rentalcar$45.00$45.00$45.00$135.00Dailylodging$89.00$89.00$89.00$267.00Meals$25.00$25.00$25.00$75.00Entertainment$75.00$75.00CTotalExpenses$609.00$234.00$159.00$1002.00LessAdvances$1200.00BalanceDueToEmployeeBalanceDueFromEmployee$198.00K P(  2am e_ JHPN  NO CHANGE!+NPrintingYourWorksheetP. or with the formatting options thatyou might have previously set up.KName: Michelle SmithEXPENSEREPORTTotal1/6/881/7/881/8/88ExpensesCAir,rail,bus$450.00$450.00Rentalcar$45.00$45.00$45.00$135.00Dailylodging$89.00$89.00$89.00$267.00Meals$25.00$25.00$25.00$75.00Entertainment$75.00$75u are currently entering is ~ ~~ ~ Jan.ExpRpt ~ ~~ ~ Dismiss this message and type 'E' ... ~ ShiftLeft e x p R p t 0x0A Return g ~You just entered the name of the file to print to.~ ~ To actually print your worksheet to the file, ~ ~ you must select the Go command. ~ ~ ~ ~ Dismiss this message and type 'g'. ~ g time time time 2am fg JHPN   NO CHANGE!+N>a11 ' Total ExpensesMENU Range Line Page Options Clear Align Go Extended Quit Spcify cells to be printed7  a b c d e f g 1 EXPENSE REPORT> 2 C Total 3  Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5  Air, rail, bus # $450.00 6  Rental car $45.00 $135.00 7  Daily lodging The Range command allows you to $89.00 $267.00 8  $25.00 $75.00 9 Entertainment specify the cells to print. $75.00 10 -- 11 Total Expenses # $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 18 19 20 21 22 23 Tue 01-Mar-88 10:59 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph KT  2am fZ JHPN  ONO CHANGE!+NKc14POINTEnter Print Range: a1..c14 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 18 For example, you can print19 20 just the labels .21 22 23 Tue 01-Mar-88 10:59 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph o2am g JHPN  ONO CHANGE!+NWg14 (C2) [W12] +g12-g11POINTEnter Print Range: d5..g14 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 18 . or you can print19 20 just the values.21 22 23 Tue 01-Mar-88 10:59 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T++++++++++ 2am #g JHPN  NO CHANGE!+#Nwa11 ' Total ExpensesMENU Range Line Page Options Clear Align Go Extended Quit Specify cells to be printed< 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 $5.00 $135.00 7 Daily lodging 9.00 $267.00 8 Meals Specifying a range is optional.5.00 $75.00 9 Entertainment  $75.00 10 -If you don't define a specific - 11 Total Expenses 9.00 $1,002.00 12 Less Advances range, then the entire worksheet $1,200.00 13 Balance Due To Emp 14 Balance Due From Eis printed. $198.00 15 16 $17 18 19 20 21 22 23 Tue 01-Mar-88 10:59 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T2am fv JHPN   0NO CHANGE!+NNa11 ' Total ExpensesMENU HeaderFooterMarginsBordersSetupPage-LengthOtherCopiesQuitEnterheaderline a b c d e f g 1 EXPENSE REPORT 9 2 / Total 3 Date  01/06/88 01/07/88 01/08/88 Expenses 4 -8- 5 Air, rail, bus 0.00 6 Rental car .00 7 Daily lodging The Options commands menu provides you with.00 8 Meals .00 9 Entertainment different options to format the printed copy.00 10 -- 11 Total Expenses of your worksheet..00 12 Less Advances .00 13 Balance Due To Empl0 14 Balance Due From Employee $198.00 15 16 17 18 19 20 21 22 23 Tue 01-Mar-88 10:59 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph KJT  2am e JHPN  5NO CHANGE!+NVPrintingYourWorksheetPYou can include a header .&'Name: Michelle Smith EXPENSEREPORTTotal1/6/881/7/881/8/88ExpensesCAir,rail,bus$450.00$450.00Rentalcar$45.00$45.00$45.00$135.00Dailylodging$89.00$89.00$89.00$267.00Meals$25.00$25.00$25.00$75.00Entertainment$75.00$75.00CTotalExpenses$609.00$234.00$159.00$1002.00LessAdvances$1200.00BalanceDueToEmployeeBalanceDueFromEmployee$198.00N P v2am e JHPN  %NO CHANGE!+NTPrintingYourWorksheetPNName: Michelle SmithEXPENSEREPORTTotal1/6/881/7/881/8/88ExpensesCAir,rail,bus$450.00$450.00Rentalcar$45.00$45.00$45.00$135.00Dailylodging$89.00$89.00$89.00$267.00Meals$25.00$25.00$25.00$75.00Entertainment$75.00$75.00CTotalExpenses$609.00$234.00$159.00$1002.00LessAdvances$1200.00BalanceDueToEmployeeBalanceDueFromEmployee$198.00XYZ CompanyN.and a footer. P P2am f JHPN   NO CHANGE!+NPrintingYourWorksheetP You can set page margins(left, right, top, bottom) .H Name: Michelle SmithEXPENSEREPORTTotal1/6/881/7/881/8/88ExpensesCAir,rail,bus$450.00$450.00Rentalcar$45.00$45.00$45.00$135.00Dailylodging$89.00$89.00$89.00$267.00Meals$25.00$25.00$25.00$75.00Entertainment$75.00$75.00 CTotalExpenses$609.00$234.00$159.00$1002.00LessAdvances$1200.00BalanceDueToEmployeeBalanceDueFromEmployee$198.00XYZ CompanyN P NO CHANGE!NPrintingYourWorksheetP You can set page margins(left, right, top, bottom) .H Name: Michelle SmithEXPENSEREPORTTotal1/6/881/7/881/8/88ExpensesCAir,rail,bus$450.00$450.00Rentalcar$45.00$45.00$45.00$135.00Dailylodging$89.00$89.00$89.00$267.00Meals$25.00$25.00$25.00$75.00Entertainment$75.00$75.00CTotalExpenses$609.00$234.00$159.00$1002.00LessAdvances$1200.00BalanceDueToEmployeeBalanceDueFromEmployee$198.00XYZ CompanyN PNN2am g\ JHPN   :NO CHANGE!+N5a11 ' Total ExpensesREADY 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 6 Rental car $45.00 $135.00 7 Daily lodging Print your expense report to $89.00 $267.00 8 Meals $25.00 $75.00 9 Entertainment a printer. $75.00 10 -- 11 Total Expenses $159.00 $1,002.00 12 Less Advances $1,200.00 13 Balance Due To Employee 14 Balance Due From Employee $198.00 15 16 517 18 To do this,select the Print/Printer command.19 20 521 22 23 Tue 01-Mar-88 10:51 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T %5%  NO CHANGE!2NVa11 ' Total ExpensesMENU 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 $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 18N 19N 20N 21N 22N 23N Tue 01-Mar-88 10:51 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   + NO CHANGE!= Na11 ' Total ExpensesMENU Printer FileC Print to a printerE 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 18N 19N 20N 21N 22N 23N Tue 01-Mar-88 10:51 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE! Na11 ' Total ExpensesMENU Select printer name:< Diablo630 HPLaserJet Imagen 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 18N 19N 20N 21N 22N 23N Tue 01-Mar-88 2:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T v !NO CHANGE!WNa11 ' Total Expenses$MENU Select printer name: $  Diablo630 HPLaserJet Imagen A list of printers is displayed. a b c  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 000 7 Daily lodging 00 8 Meals The printer currently selected is Diablo630. 00 9 Entertainment 00 10 -For this exercise, use the printer named- 11 Total Expenses 00 12 Less Advances Imagen.00 13 Balance Due To Emplo 14 Balance Due From Emp000 15 16 $17 18 19 Typeito select Imagen.20 21 22 $23 Tue 01-Mar-88 2:35 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph $ $!$   NO CHANGE! N$a11 ' Total ExpensesMENU Range Line Page Options Clear Align Go Extended Quit Specify cells to be printed< 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 18N 19N 20N 21N 22N 23N Tue 01-Mar-88 10:51 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!Na11 ' Total Exp ensesMENU Range Line Page Options Clear Align Go Extended Quit Spcify cells to be printed   a b c d e f g 1 EXPENSE%  2   Total 3  Date After selecting the printer, the8 01/8/88 Expenses 4 - 5 Air, Print commands menu is displayed. $450.00 6 Renta5.00 $45.00 $135.00 7 Daily%9.00 $89.00 $267.00 8 Meals +00 $75.00 9 Entertainment $75.00 10 -The Print commands allow you to format- 11 Total Expense00 $1,002.00 12 Less Advancesyour printout. For now, just create a$1,200.00 13 Balance Due T 14 Balance Due Fsimple printed copy, no formatting. $198.00 15 16 +17 *18 19 To print, type g to select Go.20 21 *22 23 Tue01-Mar-8810:51AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T%%%%%    ONO CHANGE!eNa11 ' Total ExpensesMENU  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/ ~ You are to print your worksheet to a printer. ~ ~ The keystroke combination to do this is /pp ~ ~~ ~~ ~ Dismiss this message and type '/'. ~ Slash p ~To print your worksheet, use the Print command. ~ ~~ ~~ ~~ ~Dismiss this message and type 'p'. ~ p p ~ You are practicing printing your worksheet to ~ ~~ ~ a printer. ~ ~~ ~ Dismiss this message and type 'p'. ~ time i i time g g time time time2am c9 JHPN  NO CHANGE!+N9;I T ' S T I M E T O S E EW H A T Y O U H A V E L E A R N E D . . .;.33332am dm JHPN  NO CHANGE!+N'! "NO CHANGE!NPrinting Your Worksheet5To print your worksheet to either a printer or a file, select the Printcommand.'To print a specific range within yourworksheet, select  the Print/Range!command.If you do not define a specific rangeto print, then the entire worksheetis printed.5#% 2am Wd JHPN   NO CHANGE!+WN$Printing Your Worksheet5To format the printed copy of yourworksheet, use the Print/Options andPrint/Extended command menus.'!5" r.00CTotalExpenses$609.00$234.00$159.00$1002.00LessAdvances$1200.00BalanceDueToEmployeeBalanceDueFromEmployee$198.00XYZ CompanyK P''' ; 2am pd JHPN   NO CHANGE!+pN#Question Printing Your WorksheetPT R U E o r F A L S E2If you don't specify a range of cellsto print, the entire worksheet is printed.2O (Select your answer by pressing one of the indicated selections)P&(((@2am c P Gprint>Rev.1Gprint>Rev.21Gprint>rev.3ENInitial>mainmenu 2am c P Gprint>TF2.true Lprint>TF2.common.path2am c P Gprint>TF2.false!Lprint>TF2.common.path2am dT JHPN  NO CHANGE!+NkPrinting Your WorksheetPT R U E o r F A L S E2If you don't specify a range of cellsto print, the entire worksheet is printed. $That's incorrect. This statement $$is true. The entire worksheet is $ printed if you do not define a specific range to print.P22222,,,,,,,,,2am !c  N ! TRUE  FALSE 2am dE JHPN  NO CHANGE!+N\Printing Your WorksheetPT R U E o r F A L S E2If you don't specify a range of cellsto print, the entire worksheet is printed. $Correct. This statement is true.$$The entire worksheet is printed if $ you do not define a specific rangeto print. P22222,,,,,,,,,2am c6 JHPN  ONO CHANGE!+N  @ &MNO CHANGE!_AN1G H  &NO CHANGE!UNE   0!NO CHANGE!3iNY    (NO CHANGE!N 2am d# JHPN  NO CHANGE!+NvIntroductiontoGraphsP4When viewing a graph, however, Solution Designer relies on one of two graphics programsto display the graph on your screen.These graphics programs areArt Designer or Chart Designer.(to be referred to also as Art/Chart Designer)4 Px 3 2am cM JHPN   BNO CHANGE!+NIntroductiontoGraphsPL5Art/Chart Designer displays the graph for you andalso allows you to modify the graph's appearance.5 Pp2am d JHPN   'NO CHANGE!+NIntroductiontoGraphsPIMPORTANT NOTE4There are two requirements to create graphs:1) Your workstation must have a graphics module2) Your workstation must have Chart Designer orArt Designer installed.See your System Administrator for help on this.4 Pp2am Vd JHPN   %NO CHANGE!+VN7IntroductiontoGraphsPN0If you do not have a graphics module on yourworkstation, and Art/Chart Designer is notinstalled, don't worry about it at thepresent time. You will be able to do thislesson without them.00 Pp2am e JHPN  (NO CHANGE!+NIntroductiontoGraphsP3This lesson is an introduction to creating,modifying and displaying graphs.This lesson only describes the Graph commands.It does NOT explain how to use them.To learn how to graph your worksheet,see one of the following manuals:Getting Started With Art DesignerorGetting Started With Chart Desig 2am d JHPN  ONO CHANGE!+NT- Question -Introduction to GraphsPFILLINTHEBLANKNNNN 8 Solution Designer relies on a graphics program called ~~ to display a graph. 8 NNNNN(Type your answer and press GO when ready)Pd1L*2am c4 JHPN   NO CHANGE!+NIntroduction to GraphsPThat's correct!Solution Designer relies on eitherArt Designer or Chart Designerto display a graph.P8 2am c P Ggraphs>FIB1.a000" Lgraphs>FIB1.common.path2am c8 JHPN   NO CHANGE!+NIntroduction to GraphsPThat's not correct.Solution Designer relies on eitherArt Designer or Chart Designerto display a graph.P8  2am c P Ggraphs>FIB1.a999" Lgraphs>FIB1.common.path2am%ch!$p<ChartDesigner5s< ArtDesignerT%s<Art/ChartDesigner2am c P graphs>TF42am f JHPN  NO CHANGE!+N  @ @MNO CHANGE!_Na6 [W12] 'NorthernMENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Create, modify, view or save a graph a b c d e f g 1 2 Sales By Region3 4 5 1984 1985 1986 1987 6 Northern 252530207 Southern 273326378 Eastern 333735309 Western 2435374510 11 12 513  14 This worksheet contains a Sales By Region report.15 16 You can create a graph that shows the total sales17 18 for each sales region over a four-year period.19 20 521 22 23 Sun 06-Mar-88 8:49 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T2am f6 JHPN  NO CHANGE!+Na1MENU TypeXABCDEFResetViewSaveOptionsNameQuitViewthecurrentgraph a b c  d e f g 1  + 2 SalesByRegion3 4 5 19841985198619876 Northern 252530207 Southern273326378 Eastern333735309 Western2435374510 11 12 313 14 A graph is created once the15 16 X range and data ranges are defined.17 18 To view the graph, either select the View19 20 command, or press the Graph (F10) function key.21 22 323 Thu 03-Mar-88 7:51 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph $/3333333332am f JHPN  =NO CHANGE!+NIntroduction to GraphsPWhen you selectthe View command,Solution Designer switches to(Art/Chart Designer40to display the30 graph.20       10     The graph    |(~appears in the1984198519861987Art/Chart Designerwork area.8P 2am d&  JHPN   NO CHANGE!+NIntroduction to GraphsP,While in Art/Chart Designer, you can Modify the appearance of your graph Print your graphSave your graph Or return to Solution Designer whenyou are done working with your graph,8Pp2am <f JHPN  %NO CHANGE!+<Na1MENU TypeXABCDEFResetViewSaveOptionsNameQuitViewthecurrentgraph a b c  d e f g 1  + 2 SalesByRegion3 4 5 19841985198619876 Northern 252530207 Southern273326378 Eastern333735309 Western2435374510 11 12 )13 14 When you return to Solution Designer,15 16 the Graph command menu and your17 18 worksheet are redisplayed.19 20 )21 22 23 Thu 03-Mar-88 7:51 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T2am f JHPN  NO CHANGE!+Na1 MENU Type X A B C D E F Reset View Save Options Name Quit Legend, Format, Titles, Grid, Scale, Color, B&W, ata-Labels a b c  d  e f g 12SalesByRegion34519841985198619876 Northern252530207 Southern273326378 Eastern333735309 Western2435374510111241314Like Art/Chart Designer, Solution Designer lets1516you modify your graph's appearance. You do this1718by using the Options commands.19204212223Thu 03-Mar-88 7:52 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 1"44444442am Ce  JHPN   NO CHANGE!+CNIntroduction to GraphsPThe Options commands let you . define a legend for each data rangeNorthernSouthernEasternWestern(4030 20       10        |(~1984198519861987P  '2am Ie JHPN  NO CHANGE!+IN Introduction to GraphsPThe Options commands lets you .]NorthernSouthernEasternWestern Annual Sales (in thousands)(40Title your30 Y-Axis20       10        |(~1984198519861987P!Lc  2am De JHPN  9NO CHANGE!+DNIntroduction to GraphsPThe Options commands lets you .title your graph Sales By RegionNorthernSouthernEasternWesternAnnual Sales (in thousands)(4030 20       10        |(~1984198519861987P! 2am eG JHPN  )NO CHANGE!+N8Introduction to GraphsPYou can also display your graph in a different color,if your workstation has a color monitor.&SalesByRegionNorthernSouthernEasternWesternAnnualSales(inthousands)(4030 20       10        |(~1984198519861987P:?(.................2am `f JHPN  NO CHANGE!+`Na1 MENU Type X A B C D E F Reset View Save Options Name Quit Cancel graph settings ; a b  c  d  e f g 1 2 2 Sales By Region% 3L 4L 5 1984 1985 1986 1987 6 Northern252530207 Southern 273326378 Eastern 333735309 Western 243537451011-1213There are just a few more Graph14  15 commands worth mentioning.  16 -  17 - 18  19  20  21  22  23L Thu 03-Mar-88 7:52 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]-----2am e4 JHPN  NO CHANGE!+Na1 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Create, modify, view or save a graph ) a b c d e  f g h i1 2 3 4 5 6 $7 8 Tocreateagraph,you would9 10 select the Graph command.11 12 $13 14 15 16 17 18 19 20 21 22 23 Thu 03-Mar-88 7:53 PM; Macro  Edit  Name Abs    Go To  Window Query Table  Calc  Graph -/$$$$$2am h JHPN  9NO CHANGE!+ Na1 MENU Type X A B C D E F Reset View Save Options Name Quit Save the current graph a b  c  d    f g 1 2 Sales By Region 345 1984 1985 1986 1987 6 Northern252530207 Southern 273326378 Eastern 333735309 Western 243537451011 1213To return to aTo save currentTo return1415graph's originalgraph settingsto the main1617settings, usein your worksheetcommands1819Reset.to use later on,menu, use2021use Name.Quit.2223 Thu 03-Mar-88 7:52 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph LLLL @LLL           2am !f JHPN  )NO CHANGE!+!NWa1 MENU Type X A B C D E F Reset View Save Options Name Quit Enter graph type 4 a b c  e f g h i1! - 2 3 4 5 This is the Graph command menu.6 7 These commands let you create, view,8 9 save, and modify your graph. Let's10 11 take a closer look at these commands.12 13 )14 15 16 17 18 19 20 21 22 23 Thu 03-Mar-88 7:41 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph =":)))))))))  2am ee JHPN   8NO CHANGE!+NQa1 MENU Type X A B C D E F Reset View Save Options Name Quit Ener graph typeB  a b c d e f g h i1 M 2 3 4 (5 6 The Type command lets you choose the7 8 type of graph, or chart, to create:9 10 11 Line12 13 Bar14 15 XY16 17 Stacked-Bar18 19 Pie20 21 (22 23 Thu 03-Mar-88 7:41 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  ]2am dm JHPN   ONO CHANGE!+NIntroduction to GraphsPIf you don't specify a type, then abar graph is created by default.(4030 20       10        |(~1984198519861987P###2am Fe JHPN  -NO CHANGE!+NIntroduction to GraphsPThere are several parts to a graph .(4030 20       10        |(~1984198519861987 P&   @NO CHANGE!FNIntroduction to GraphsPThere are several parts to a graph .Y Axis( 40Worksheet Data -30 represented by20       the bars10        |(~1984198519861987 X AxisP&t2am f1 JHPN   ONO CHANGE!+Na1 MENU Type X A B C D E F Reset View Save Options Name Quit Enter -rangeI a b c d e f g 1 I 2 SalesByRegion3 4 5 19841985198619876 Northern 252530207 Southern273326378 Eastern333735309 Western2435374510 11 12 13 14 The X Axis values, or X Range, are defined15  16 using the X command. In this example, the17 18 X Range consists of the years, 1984 to 1987. 19 20 021 22 23 Thu 03-Mar-88 7:50 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph M/0000002am fq JHPN  INO CHANGE!+N#a1 MENU Type X A B C D E F Reset View Save Options Name Quit Enter firt at rng @  c d e f g 1 7 2 SalesByRegion3 4 5 19841985198619876 Northern 252530207 Southern273326378 Eastern333735309 Western2435374510 11 812 13 A graph can have up to six data ranges. Data ranges14 15 define the Y Axis and the data to graph. Data is16 17 represented by bars in a bar graph, lines in a line18 19 graph and slices in a pie graph.20 21 822 23 Thu 03-Mar-88 7:51 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph   ; ! 2am f JHPN  *NO CHANGE!+Na1 MENU Type X A B C D E F Reset View Save Options Name Quit Enter first data rangeC a b c d e f g 1 C 2 SalesByRegion3 4 5 19841985198619876 Northern 252530207 Southern273326378 Eastern333735309 Western2435374510 11 12 13 14 15 This worksheet has four data ranges:16 17 A, B, C, and D. Each represents a18 19 different region.20 21 (22 23 Thu 03-Mar-88 7:51 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T0000(((((((2am lj JHPN   NO CHANGE!+N  @ MNO CHANGE!_Ns  In tG     2am /d JHPN  NO CHANGE!+/N Introduction to GraphsPIn this lesson, you will learnthe requirements necessaryfor creating and displaying graphshow a graph is createdhow a graph is displayedhow you can format your graphother uses of the graph commandP! Gh u f   t  p          w )NO CHANGE!;*NIn t G  Gh  a urenati fohdt  rs yda r\m rer.         we rNO CHANGE!lNIndutt Gra Gph pvid a uapresenati foksh dta  rps  yda r\m rer. " w  NO CHANGE!mN Indutioto Graps  Gaph pvid a uapresenatin oforkshe data raps a yodataa re= ndmc oreer.   w|  NO CHANGE!NRIntroduction to Graphs  Graphs prvide a visual presentation oforksheet data. Graphs can make your data eairt read:and muc moreinteresting.   v +NO CHANGE!=nNJIntroduction to GraphsI'Graphs provide a visual presentation ofworksheet data. Graphs can make your data easier to read and much more interesting., 3Iv   NO CHANGE! NIntroduction to GraphsPP,Graphs provide a visual presentation ofworksheet data. Graphs can make your data easier to readand much more interesting., Pv ANO CHANGE!1oNPrintingYourWorksheetP222Andfinally,Name: Michelle SmithyoucanEXPENSEREPORTTotalspecifyhow1/6/88Expenses.manycopiesAir,rail,bus$450.00$450.00Rentalcar$45.00$135.00youwantDailylodging$89.00$267.00Meals$25.00$75.00printed.Entertainment$75.00" .TotalExpenses$609.00$1002.00LessAdvances$1200.00BalanceDueToEmployeeBalanceDueFromEmployee$198.00XYZ Company2 P46:ner3 PU!#W2am 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 Ie JHPN  NO CHANGE!+N'! FNO CHANGE!INIntroduction to Graphs5To create a graph of your worksheet data,use the Graph commands.Solution Designer relies on either Artܫ'Designer or Chart Designer to display thegraph.!To learn how to graph your worksheetdata, see one of the following manuals: Getting Started With Art DesignerorGetting Started With Chart Designer.5($!#2am d6#  JHPN  %NO CHANGE!+NIntroduction to Graphs5The Graph commands are used to- choose the type of graph to create- create a graph- view a graph'- name a graph- add optional titles and labels to!a graph- reset a graph back to its defaultsettings 5MM2am e% JHPN  %NO CHANGE!+NIntroductiontoGraphs5The Graph commands are used to-choosethetypeofgraphtocreateYouhavereachedtheend-createagraphofthislesson.-viewagraphWesuggestyouproceed-nameagraphtothenextsection,-addoptionaltitlesandlabelstoGeneral Overview ofagraph Advanced Topics.-resetagraphbacktoitsdefaultPressNextPagetoreturnsettingstotheMainmenu. 55  5555555555555555  55555552am zd JHPN   NO CHANGE!+zN&Question Introduction to GraphsPT R U E o r F A L S E5In Chart Designer, you can modify yourgraph's appearance and also print your graph.5M (Select your answer by pressing one of the indicated selections)P55555*@2am c#  P Ggraphs>Rev.1Ggraphs>Rev.23Ggraphs>Rev.3HNInitial>mainmenu2am c P Ggraphs>TF4.TRUE!Lgraphs>TF4.common.path2am c P Ggraphs>TF4.false"Lgraphs>TF4.common.path2am ;e JHPN  9NO CHANGE!+;NIntroduction to GraphsPT R U E o r F A L S E5In Chart Designer, you can modify yourgraph's appearance and also print your graph. That's incorrect. This statement is true. ChartDesigner lets you modify your graph's appearance,and also print your graph. Note that to modifyyour data, however, you must do so in Solution Designer.pP55555;;;;;;;;; +;$ 2am !c N ! TRUE  FALSE 2am e JHPN  .NO CHANGE!+NIntroduction to GraphsPT R U E o r F A L S E5In Chart Designer, you can modify yourgraph's appearance and also print your graph. Correct. This statement is true. Chart Designerlets you modify your graph's appearance and alsoprint your graph. Note that to modify your data,however, you must do so in Solution Designer.P55555;;;;;;;;;ery Table  Calc  Graph 2! ouasprth  shes de.x ,NO CHANGE!>Nntin Wor$ Ypensrt ileteour ask printhe   senhe As Padepa.v@ M NO CHANGE!_ 9Nnting  WorksYoupense rt is lete.our neask isprint the re  send he Accs Payadepart.t NO CHANGE!N=Pnting Yo WorksheYour pense rert is colete.our nextask is tprint outhe repo send tohe Accous Payabldepartme.r9 ?FNO CHANGE!XNPrinting Your WorksheetP/Your expense report is complete.Your next task is to print out the report to send to the Accounts Payable department./ Pp%   L &YNO CHANGE!kN    NO CHANGE!-N !#%'%#!  GNO CHANGE!N!#%')+-/131/-+)'%#!  NO CHANGE!N')+-/13579;=?ACA?=;97531/-+)' T OaNO CHANGE!sN8:<>@BDFHJLNNLJHFDB@><:8  NO CHANGE!!?N/HJLNNLJH ` OmNO CHANGE!N   NO CHANGE!?N/HJLNNLJH  ONO CHANGE! N8:<>@BDFHJLNNLJHFDB@><:8   NO CHANGE! N')+-/13579;=?ACA?=;97531/-+)' b Go NO CHANGE! N!#%')+-/131/-+)'%#! $ 1 NO CHANGE!C N !#%'%#!  & NO CHANGE! N    ( NO CHANGE! N   X 0e NO CHANGE!w iNY    & NO CHANGE! UNE  T &aNO CHANGE!sAN1G H  ONO CHANGE!N    @NO CHANGE!NIntroductiontoGraphsP1Solution Designer provides commands to createmodify, view and save a graph.1 Pp.00 12 Less Advances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee( $198.00 15 16 17 18 19 20 21 22 23 Tue 01-Mar-88 10:59 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T C CNO CHANGE!CN;a11'TotalExpensesMENU RangeLinePageOptionsClearAlignGoExtendedQuitOutputthespecifiedrangetotheprinter 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 A% dvances2 $1,200.00 13 Balance Due To Employee3 14 Balance Due From Employee( $198.00 15 16 17 18 19 20 21 22 23 Tue 01-Mar-88 10:59 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T G  9GNO CHANGE!G0Nua11 ' Total ExpensesMENU Range Line Page Options Clear Align Go Extended Quit Output the specified range to the printer. 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 $00 $267.00 8 Meals 00 $75.00 9 Entertainment Your worksheet has just been $75.00 10 -- 11 Total Expenses printed to the file, Jan.ExpRpt!00 $1,002.00 12 Less Advances $1,200.00 13 Balance Due To Emplo$ 14 Balance Due From Employee $198.00 15 16 17 18 19 Press Next Page to continue20 21 22 23 Tue 01-Mar-88 10:52 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T %%%2am Ie JHPN  NO CHANGE!+IN Introduction to GraphsPThe Options commands lets you .]NorthernSouthernEasternWestern Annual Sales (in thousands)(40Title your30 Y-Axis20       10        |(~1984198519861987P!Lc  fileHeaders.sysmfd.syslog.sys sysImage.sys badBlk.sys crashDump.sysOCID8 8p& ֢SD-6monetc>fjg4K@YysSDSys'9|M^SysSD9{fileHeaders.sys Sys3SfSfSfŶmfd.sys Sys3UfUfNJglog.sysSysXfXfXff sysImage.sysSysZfZfZf badBlk.sysSys\f\f\f&  crashDump.sysSys^f^f^f format>all>FIB2sdfffformat>all>fib2.a000sdKfffKλ format>all>fib2.a002sdfff{  format>all>fib2.a999sd fff6 format>all>Gl.1 sd 3f fDff format>all>Gl.2 sd 3f fDfY format>all>Gl.3 sd 3f fDf' format>all>Glob sd3fL2fDfm nDYformat>all>Glob.pedal sd3fO2fDfK $format>all>def.5 sd3&fTgg 2format>all>def.4 sd3!fTggSQformat>all>def.2 sd3fTgg~ Aformat>all>i.3 sd3Lf fgcoformat>all>def.1 sd3fTggzformat>all>i.2 sd3Gf fg' 0format>all>i.1 sd3Bf fg*format>all>def.9 sd3=fTgTg< format>all>def.8 sd37fTgTgJBformat>all>def.7 sd32fTgTgformat>all>def.6 sd3,fTgg78format>all>def.3 sd3fTgg"format>all>initial.path sd3f fgt/format>all>mc1 sd3f fDf?( {format>all>MC1.common.path sd3 f&fDf format>all>mc1.correct sd3'ffDfL format>all>MC1.F001.Path sd 31f4fDfKQq!format>all>MC1.F002.Path sd!3@fFf)fM,m"format>all>MC1.F003.Path sd"3HfKf)fMi#format>all>MC1.F004.Path sd#3MfRf)fM$format>all>mc1.incorrect sd$3Tff)fN[%format>all>MC1.legend sd%3dfhfDf4( Z&format>all>Pr.1 sd&3jf f gH 'format>all>Pr.2 sd'3qf f g>:(format>all>Pr.3 sd(3wf f gE)format>all>Pr.4 sd)3f f g  *format>all>Pr.5 sd*3f f gN+format>all>Pr.6 sd+3f f g,format>all>Pr.7 sd,3f f gq  !-format>all>Pr.8 sd-3f f g$$) .format>all>Prot sd.3fgg),s/format>all>Prot.pedal sd/3fgg0format>all>rev.1 sd03£f fDfC1format>all>rev.2 sd13ȣf fEf]|2format>all>rev.3 sd23Σf fEf{3 print>rev.3 sd33 f fBflv4format>all>fib5sd5 f f f5format>all>fib2sd  f f f) Da6format>all>tf2 sd63f fDf7format>all>tf2.common.path sd73f fDfx 8format>all>TF2.F001.Path sd83f f fH9format>all>TF2.F002.Path sd93f fDfIv:format>all>tf2.false sd:3f fDf;format>all>TF2.legend sd;3f fDf*<format>all>tf2.true sd<3 f f fE=format>all>TF3 sd=3fɄfDf* SM>format>all>TF3.common.path sd>3ffDf  2?format>all>TF3.F001.Path sd?3f%fDfHF@format>all>TF3.F002.Path sd@3+f1f7+fIAformat>all>TF3.false sdA32f΄f1+f DJBformat>all>TF3.legend sdB38f>fDf*aCformat>all>TF3.true sdC3@fӄfDf FODformat>all>TF4 sdD3Ef fDf$Eformat>all>TF4.common.path sdE3Jf f f(* Fformat>all>TF4.F001.Path sdF3Of f fH,Gformat>all>TF4.F002.Path sdG3Wf fDfI0?Hformat>all>TF4.false sdH3\f fDf4Iformat>all>TF4.legend sdI3cf fDf*:_Jformat>all>TF4.true sdJ3if f f.>0KFormat>Return>Initial.pathsdnfrfrf"DL print>fib1 sdL3sfu ftBfHk|Mprint>fib1.a000 sdM3yfg fg fL+ Nprint>FIB1.A000.Path sdN3}fi fi f@P'/Oprint>fib1.a999 sdO3fs fzBfTbEPprint>FIB1.A999.Path sdP3fn f{Bf@X Qprint>FIB1.answers sdQ3fp fvBfF\U%Rprint>fib1.common.path sdR3fl fBf`S print>file sdS3f[2fNfKdvRB Tprint>File.pedal sdT3f^2fNfU print>i.1 sdU3ɤf f gGv+  V print>i.2 sdV3Τf f gW print>i.3 sdW3Ԥf f g>|DX print>op.1 sdX3fTgTg4PY print>op.10 sdY3fTgTgZ print>op.11 sdZ3fTgTgNv9[ print>op.12 sd[3fTgTg NVvd\ print>op.13 sd\3 fTgTgcf] print>op.14 sd]3fTgTg, ^ print>op.15 sd^3fTgTgVU_ print>op.2 sd_3fTgTg_` print>op.3 sd`3/fTgTg a print>op.4 sda38fTgTgJb print>op.5 sdb3=fTgTgN:c print>op.6 sdc3DfTgTg(md print>op.7 sdd3WfTgTgVe print>op.8 sde3`fTgTg, :f print>op.9 sdf3ffTgTg -g print>ptr sdg3ufc2f"g*&vR m}hPrint>Ptr.pedal sdh3f`2f"gFi Print>qseg1 sdi3ff OfHMyj Print>Rev.1 sdj3f fBfL;k Print>Rev.2 sdk3f fBfRt)l print>TF2 sdl3f fBfXmprint>tf2.common.path sdm3f fBf^\- nprint>TF2.F001.Path sdn3f fBf>`Voprint>TF2.F002.Path sdo3f f f?dpprint>TF2.false sdp3Хf f fhXqprint>TF2.legend sdq3ڥf fBf*nrprint>TF2.true sdr3ߥf fBfrLns graphs>def.1 sds3f墬ggx vdt graphs>def.2 sdt3f碬gg|e7u graphs>def.3 sdu3fꢬgg- Thv graphs>def.4 sdv3f좬gg9w graphs>def.5 sdw3fggx graphs>Def.6 sdx3fgg=ROy graphs>fib1 sdy3 fd fg\zgraphs>fib1.a000 sdz31ffj0fm{graphs>FIB1.A000.Path sd{38ffib1.a999 sd|3>ffg}graphs>FIB1.A999.Path sd}3DfHfgB. ~graphs>FIB1.answers sd~3IfMfgygraphs>FIB1.common.path sd3OfSfg0 graphs>how.1 sd3Ufgg graphs>how.10 sd3\fggo graphs>how.11 sd3bfggF] graphs>how.12 sd3hfgg@ graphs>how.13 sd3vfggg.8 graphs>how.14 sd3~fgg. s graphs>how.15 sd3fggni graphs>how.16 sd3fggti graphs>how.17 sd3fggo graphs>how.18 sd3f ggU graphs>how.19 sd3f gg2 graphs>how.2 sd3fgg graphs>how.20 sd3¦fgg5ȍ graphs>how.3 sd3˦fggL/  graphs>how.4 sd3Цfgg graphs>how.5 sd3fggi graphs>how.6 sd3fgg[ S% graphs>how.7 sd3f gg4 graphs>how.8 sd3f"gg#g graphs>how.9 sd3 f%gg"K Graphs>I.1 sd3fV fg!(0Iϕ Graphs>I.2 sd3 fX fgZ,/ c print>op.20 sd37fTgTg쵗 print>op.19 sd3fTgTgDܛformat>all>rev.4 sd3 f f Ef! print>op.16 sd3fTgTg print>op.21 sd3LfTgTg7 print>op.18 sd3fTgTg< print>op.17 sd3fTgTg Graphs>qseg2 sd3ifnfgT0  B graphs>Rev.1 sd3ofggOX graphs>Rev.2 sd3}fgg^à graphs>Rev.3 sd3fggd Graphs>TF4 sd3ffgjˆgraphs>TF4.common.path sd3ffganNgraphs>TF4.F001.Path sd3ffg@rƀgraphs>TF4.F002.Path sd3ff#CfAvGraphs>TF4.false sd3ff!Cffz0 Egraphs>TF4.legend sd3ffg*:0Graphs>TF4.true sd3ffgJOCIDsysifqf,g;format>all>qseg2 sd3ffDfBformat>all>qseg1 sd3ffDf.1print>initial.path sd3fMf#gjgraphs>initial.path sd3fIfgnͭ1 ̮˯ʰɱȲdzƴŵ1 Ķ÷¸~}|2 {zyxwvut2 srqponml3 kjihgfed3 cba`_^]\4 [ZYXWVUT4 SRQPONML5 KJI{format>all>Gl.1 format>all>MC1.F002.Path!format>all>Pr.2'format>all>tf2.true<format>all>TF3.legendB print>op.8e Print>Rev.2kprint>TF2.F002.Pathoprint>TF2.falsep graphs>how.1 graphs>how.10 graphs>how.18 graphs>how.9 graphs>Rev.2format>all>qseg2print>initial.pathgraphs>initial.pathformat>all>def.5format>all>i.3 print>op.17format>all>Gl.2 format>all>MC1.common.pathformat>all>MC1.F003.Path"format>all>Pr.3(format>all>TF3.trueCformat>all>TF4.legendI print>op.1X print>op.10Y print>op.9f print>ptrgprint>tf2.common.pathm graphs>def.1s graphs>how.11 graphs>how.19 graphs>how.2 graphs>how.20 graphs>Rev.3 Graphs>TF4graphs>TF4.F001.Pathformat>all>def.6 print>op.18 print>rev.33format>all>Gl.3 format>all>Globformat>all>MC1.F004.Path#format>all>Pr.4)format>all>rev.10format>all>tf26format>all>TF2.F001.Path8format>all>TF4.trueJprint>FIB1.A999.PathP print>op.11Z print>op.2_ graphs>def.2tgraphs>FIB1.A999.Path} graphs>how.12 graphs>how.3graphs>TF4.F002.PathGraphs>TF4.falseformat>all>def.7 print>op.19 print>op.20format>all>Pr.5*format>all>Prot.format>all>rev.21format>all>TF2.F002.Path9format>all>tf2.false:format>all>TF3=format>all>TF3.F001.Path? print>fileS print>i.1U print>op.12[ print>op.3` graphs>def.3u graphs>how.13 graphs>how.4 Graphs>I.1graphs>TF4.common.pathformat>all>initial.pathformat>all>def.8 print>op.21format>all>MC1.legend%format>all>Pr.6+format>all>rev.32format>all>tf2.common.path7format>all>TF3.F002.Path@format>all>TF3.falseAformat>all>TF4Dformat>all>TF4.F001.PathFprint>fib1.a000M print>i.2V print>op.13\ print>op.4a Print>qseg1iprint>TF2.legendq graphs>def.4vgraphs>fib1.a000z graphs>how.14 graphs>how.5 Graphs>I.2format>all>def.1format>all>def.95 format>all>Pr.7,format>all>TF3.common.path>format>all>TF4.F002.PathGformat>all>TF4.falseH print>fib1L print>i.3W print>op.14] print>op.5bPrint>Ptr.pedalhprint>TF2.truer graphs>def.5w graphs>fib1y graphs>how.15 graphs>how.6 Graphs>qseg2format>all>def.2format>all>rev.4format>all>Glob.pedalformat>all>mc1.incorrect$format>all>Pr.8-format>all>TF4.common.pathEprint>FIB1.answersQ print>op.15^ print>op.6c graphs>Def.6xgraphs>FIB1.answers~ graphs>how.16 graphs>how.7graphs>TF4.legendformat>all>def.3format>all>i.1format>all>mc1format>all>mc1.correctformat>all>MC1.F001.Path format>all>Pr.1&format>all>Prot.pedal/format>all>TF2.legend;print>FIB1.A000.PathNprint>fib1.a999Oprint>fib1.common.pathRprint>File.pedalT print>op.7d Print>Rev.1j print>TF2lprint>TF2.F001.Pathngraphs>FIB1.A000.Path{graphs>fib1.a999|graphs>FIB1.common.path graphs>how.17 graphs>how.8 graphs>Rev.1Graphs>TF4.trueformat>all>qseg1format>all>def.4format>all>i.2 print>op.16p.16SD $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 18N 19N 20N 21N 22N 23N Tue 01-Mar-88 10:52 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T K" OX"NO CHANGE!j"N2a11 ' Total ExpensesMENU Range Line Page Options Clear Align Go Extended Quit Output the specified range to the printer. 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 18N 19N 20N 21N 22N 23N Tue 01-Mar-88 10:52 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 3& :@&NO CHANGE!R&bNa11 ' Total ExpensesMENU Range Line Page Options Clear Align Go Extended Quit Output the specified range to the printer. 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 $135.00 7 Daily lodging 89.00 $267.00 8 Meals And your worksheet has6 25.00 $75.00 9 Entertainment $75.00 10 -been sent to the printer! - 11 Total Expenses 59.00 $1,002.00 12 Less Advances A printed copy should be$1,200.00 13 Balance Due To Employee 14 Balance Due From Employready and waiting for you. $198.00 15 16 17 18 19 Press Next Page to continue20 21 22 23 Tue 01-Mar-88 10:52 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T %%%8z7y6x5w4v3u6 2t1s0r /q  .p  -o  ,n  +m 7 *l)k(j'i&h%g$f#e7 "d2am 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 a`_^]8 \[ Z !Y!"X"#W#$V$%U%&8 T&'S'(R()Q)*P*+ O+, N,- M-.9  L./ K/0J01I12H23G34F452am c99  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 . . .;.3333C78B89@9:?:;>;<=<=<=>: ;>?:?@9@A8AB7BC6CD5DE4EF: 3FG2GH1HI0IJ/JK.KL-LM,MN; +NO*OP)PQ(QR'RS2am c P GPrint>I.1GPrint>I.2-GPrint>I.3?ZCarla.fontRZSD.fontbXprint>PtrtXprint>FileZsd.fontZcarla.fontGprint>Op.1Zcarla.fontZsd.fontGprint>Op.2Gprint>Op.3Gprint>Op.4Gprint>Op.5,Gprint>op.6?Gprint>op.7RGprint>op.8eGprint>op.9xGprint>op.10Gprint>op.11Gprint>op.12Gprint>op.13Gprint>op.14Gprint>op.15Gprint>op2am c;  P Ggraphs>I.1Ggraphs>I.2/Ggraphs>Def.1DGgraphs>Def.2YGgraphs>Def.3nGgraphs>Def.4Ggraphs>Def.5Ggraphs>def.6ZCarla.fontZSD.fontGgraphs>how.1Ggraphs>how.2Ggraphs>how.3Ggraphs>how.4$ZSD.font4ZFont3.fontGGgraphs>how.5\Ggraphs>how.6qZFont3.fontZSD.fontGgraphs>how.7Ggraphs>how.8Ggraphs>how.9Ggraphs>how.10Zsd.fontZfont3.font Ggraphs>how.11"Ggraphs>how.128ZFont3.fontKZSD.font[Ggraphs>how.13qGgraphs>how.14ZSD.fontZFont3.fontGgraphs>how.15Ggraphs>how.16Ggraphs>how.17Ggraphs>how.18ZFont3.fontZSD.font%Ggraphs>how.19;Ggraphs>how.20QZSD.fontaZCarla.fonttGgraphs>qseg2 graphs>FIB12am c P Gformat>all>i.1 Gformat>all>i.27Gformat>all>i.3NGformat>all>def.1gZCarla.fontzZSD.fontGformat>all>def.2Gformat>all>def.3Gformat>all>def.4Gformat>all>def.5Gformat>all>def.6Gformat>all>def.7 Gformat>all>def.89Gformat>all>def.9RZSD.fontbZCarla.fontuGformat>all>pr.1Gformat>all>pr.2Gformat>all>pr.3Gformat>all>pr.4Gformat>all>pr.5Gformat>all>pr.6ZCarla.fontZSD.font(Gformat>all>pr.7@Gformat>all>pr.8XXformat>all>ProtpZSD.fontZCarla.fontGformat>all>qseg1format>all>MC12am Vd JHPN   ONO CHANGE!+N  @  $MNO CHANGE!_VN6Formatting the Entire WorksheetP<4The Worksheet/Global commands are used to setup standards that affect the entire worksheet.Such standards include formatting, column-width,label prefixes and protection, to name a few.4P{2am e!<  JHPN   $NO CHANGE!+N a1 MENU Format Label-Prefix Column-Width Recalculation Protection Default Zero Specify global format / a b c d  e f g 1 2 3 4 5 Global commands are available through6 7 the Worksheet/Global commands menu.8 9 .10 11 12 13 14 15 16 17 18 19 20 21 22 23 Wed 24-Feb-88 12:01 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph KJ]2am ep JHPN  FNO CHANGE!+NMa1 MENU Format Label-Prefix Column-Width Recalculation Protection Default ZeroSpeify globalformat 6  a b c  d e f g 1 2 3 &4  5 Some of these commands should look familiar to you,6 7 in particular, Format, Label-Prefix,8 9 and evenColumn-Width.10 11 712 13 14 15 16 17 18 19  20 21 22 23 Wed 24-Feb-88 12:01 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph K( ]2am Uf JHPN  FNO CHANGE!+UNa1 MENU Format Label-Prefix Column-Width Recalculation Protection Default ZeroSpecify global format / a b c d e f g 1 2 3 74 5 Some of these commands should look familiar to you,6 7 in particular, Format, Label-Prefix,8 9 and evenColumn-Width.10 11 12 13 Format and Label-Prefix have related Range14 15 commands, Format and Label.16 17 718 19 20 21 22 23 Wed 24-Feb-88 12:01 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph KF]33333< 2am fZ JHPN  FNO CHANGE!+N a1 MENU Format Label-Prefix Column-Width Recalculation Protection Default ZeroSpecify global format / a b c d e f g 1 2 3 74 5 Some of these commands should look familiar to you,6 7 in particular, Format, Label-Prefix,8 9 and evenColumn-Width.10 11 12 13 FormatandLabel-PrefixhaverelatedRange14 15 commands,FormatandLabel.16 17 18 Column-Width is a Worksheet command19 20 that was introduced in an earlier lesson.21 22 723 Wed 24-Feb-88 12:01 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph KF]333333333332am f JHPN  #NO CHANGE!+ Noa1 MENU Format Label-Prefix Column-Width Recalculation Protection Default Zero Specify global format / a b c d e f g 1 2 3 74 5 The main difference between those commands and6 7 these global commands is that8 9 global commands affect the entire worksheet10 11 rather than just a specific cell range.12 13 714 15 16 17 18 19 20 21 22 23 Wed 24-Feb-88 12:01 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph KJ]2am f=  JHPN  #NO CHANGE!+Na1 MENU Format Label-Prefix Column-Width Recalculation Protection Default Zero Specify global format / a b c d e f g 1 2 3 74 5 The main difference between those commands and6 7 these global commands is that8 9 global commands affect the entire worksheet10 11 rather than just a specific cell range.12 13 714 15 16 17 18 Press Next Page for a description 19 20 of each of these global commands.21 22 23 Wed 24-Feb-88 12:01 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph KJ]+!!!+2am e/ JHPN  NO CHANGE!+Na1 MENU Format Label-Prefix Column-Width Recalculation Protection Default Zero Speify globa format    Controls recalculation forthe entire worksheetDetermines column width for entire worksheetAligns all labels to the left, right, or center of cell Determines the way values are displayed for the entire worksheet.Format choices are the same as those in the Range/Format menu.J [2am dc JHPN  8NO CHANGE!+Na1 MENU . Recalculation Protection Default Zero  When yes is specified, zerovalues are displayed as "0"instead of a blank cellDefines default settings to be usedwith every worksheetEnables or disables protection for the entireworksheetPp= 2am #d JHPN   NO CHANGE!+AN)Formatting the Entire WorksheetPpPpl AyNO CHANGE!NFormatting the Entire WorksheetP3Up until now, you have been performing commandson specific cell ranges within a worksheet. PpJ AWNO CHANGE!iNFormatting the Entire WorksheetP3Up until now, you have been performing commandson specific cell ranges2am cA JHPN   CNO CHANGE!+NFormatting the Entire WorksheetP7Now, we'll focus on how to changethe entire worksheet rather than just a part of it.7Pp2am jd JHPN  NO CHANGE!+jN9Formatting the Entire WorksheetPIn this lesson, you will learnhow to protect your worksheethow to set up a particular format forall values in your worksheethow to change the column width of yourentire worksheethow to change label alignment for yourentire worksheetP''( 2am c JHPN  &NO CHANGE!+AN1G H l &yNO CHANGE!UNE   0NO CHANGE!iNY   h (uNO CHANGE!N  >   &%NO CHANGE!7N    NO CHANGE!N !#%'%#!  GNO CHANGE!N!#%')+-/131/-+)'%#! ^ kNO CHANGE!}N')+-/13579;=?ACA?=;97531/-+)'   O-NO CHANGE!?N8:<>@BDFHJLNNLJHFDB@><:8  NO CHANGE!?N/HJLNNLJH , O9NO CHANGE!KN  .16Gprint>op.17Gprint>op.18,Gprint>op.19@Gprint>op.20TGprint>op.21hZSD.fontxZCarla.fontGprint>qseg1 print>FIB12am dG JHPN  +NO CHANGE!+NPrintingYourWorksheetPYou can also display the actual cell contentsand format information for each cell.For example, this is what your printout mightlook like for cells a5 to g5. .a5 ' Air, rail, busb5 c5 d5 (C2) [W12] 587e5f5g5 (C2) [W12] +f5+e5+d5.  P2555155nt $7.00 $75.00 10 .-- 11 Total Expenses $609.00 $23.00 $159.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 18 The Extended command menu lets you select a19 20 different print orientation and font size.21 22 /23 Tue 01-Mar-88 11:00 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  2! > 2am g JHPN  9NO CHANGE!+Na11'TotalExpensesMENU OrientationFont-SizePitchQuit Settheprintorientation a b c d e f g 1 EXPENSE REPORT  21  Total 3 Date 01/06/88 01/07/8 01/08/88 Expenses 4 .-- 5 Air, rail, bus $450.00  $450.00 6 Rental car $45.00 $4.00 $45.00 $135.00 7 Daily lodging $89.00 $8.00 $89.00 $267.00 8 Meals $25.00 $2.00 $25.00 $75.00 9 Entertainment $7.00 $75.00 10 .-- 11 Total Expenses $609.00 $23.00 $159.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 18 The Extended commands menu lets you select 19 20 a different print orientation and font size.21 22 023 Tue 01-Mar-88 11:00 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc2am e JHPN  @NO CHANGE!+N\PrintingYourWorksheetP2Name: Michelle Smith There are two typesEXPENSEREPORTof print orientation:Total1/6/88Expenses. Portrait .Air,rail,bus$450.00$450.00Rentalcar$45.00$135.00Dailylodging$89.00$267.00Meals$25.00$75.00Entertainment$75.00.TotalExpenses$609.00$1002.00LessAdvances$1200.00BalanceDueToEmployeeBalanceDueFromEmployee$198.00XYZ Company2 P( 2am e JHPN  &NO CHANGE!+NPrintingYourWorksheetPNName: Michelle SmithEXPENSEREPORTTotal1/6/88Expenses.Air,rail,bus$450.00$450.00Rentalcar$45.00$135.00Dailylodging$89.00$267.00Meals$25.00$75.00Entertainment$75.00.TotalExpenses$609.00$1002.00LessAdvances$1200.00BalanceDueToEmployeeBalanceDueFromEmployee$198.00XYZ Com? panyN. and Landscape. P? 0Tue 01-Mar-88 11:00 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph K9 2am gc JHPN  ANO CHANGE!+NCa11 ' Total ExpensesMENU Range Line Page Options Clear Align Go Extended Quit Return to READY mode a b c  d e f g 1 EXPENSE REPORT   2  Total 3 Date 01/06/88 01/07/88 0108/88 Expenses 4 5-- 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 5-- 11 Total Expenses  $609.00 $234.00 $159.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 The Quit command returns you to READY mode.18 19 (And the Quit command in the Options commands20 21 menu returns you to this menu.)22 23 1Tue 01-Mar-88 11:00 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph K9  within a worksheet. These ranges consisted of one cell or aa group of cells.Pp| ANO CHANGE!#N Formatting the Entire WorksheetP3Up until now, you have been performing commandson specific cell ranges within a worksheet. These ranges consisted of one cell or aa group of cells.3NPp *NO CHANGE!#N Formatting the Entire WorksheetP3Up until now, you have been performing commandson specific cell ranges within a worksheet. These ranges consisted of one cell or aa group of cells.3.Pp? 2am e JHPN  ONO CHANGE!+NFormattingtheEntireWorksheet5To align labels in the entire worksheetat the left, right, or center of the cell,Youhavereachedtheendselecttheofthislesson,andtheWorksheet/Global/Label-Prefixcommand.endoftheFormat section.Wesuggestyouproceedtothenextsection,Printing Your Worksheet.PressNextPagetoreturntotheFormat menu.  555 '5 )5555555555555555555555  Graph  2!  JHPN  NO CHANGE!+Nf- Question 1 -Formatting the Entire WorksheetPFILLINTHEBLANKNNNN<  The keystroke combination to disable protection of a  cell in your worksheetis ~~ .  < NNNNN(Type your answer and press GO when ready)P 3J*2am d# JHPN   NO CHANGE!+Ne- Question -Formatting the Entire WorksheetPFILLINTHEBLANKNNNN<  The keystroke combination to change the column width  of the entire worksheetis ~~ .  < NNNNN(Type your answer and press GO when ready)P 3J*2am Ae@  JHPN  NO CHANGE!+ANPrintingYourWorksheet5To format the printed copy of yourworksheet,usethePrint/Optionsand YouhavereachedtheendPrint/Extendedcommandmenus. of this lesson.Wesuggestyouproceedto the next section,Introduction to Graphs.PressNextPagetoreturntotheMain menu. 555 " 5  "55555555555555555555552am g JHPN  #NO CHANGE!+Na11 ' Total ExpensesMENU Range Line Page Options Clear Align Go Extended Quit Reset some or all print settins7 a b c  d e f g 1 EXPENSE REPORT 1 2 ' Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 -0- 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 -0- 11 Total Expenses  $609.00 $234.00 $159.00 $1,002.00 12 Less Advances $1,200.00 13 Balance Due To Employee 14 Balance Due From Employe $198.00 15 16 !17 18 And finally, the Clear command resets your19 20 print settings back to the default settings.21 22 023 Tue 01-Mar-88 11:00 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph K5 2am dp JHPN  0NO CHANGE!+NIntroduction to Graphs5The Graph commands are used to- choose the type of graph to create- create a graph- view a graph'- save a graph- name a graph!- add optional titles and labels toa graph- change a graph's font and orientation- reset a graph back to its original settings@ 5M2am e JHPN  NO CHANGE!+NIntroductiontoGraphs5The Graph commands are used to-choosethetypeofgraphtocreate-createagraphYouhavereachedthe-viewagraphendofthislesson.-saveagraphPressNextPage-nameagraphtoreturnto-addoptionaltitlesandlabelstotheGraphs menu.agraph-changeagraph'sfontandorientation-resetagraphbacktoitsoriginalsettings 55  55555555555555555555555552am |d JHPN   NO CHANGE!+|N(Question 1Introduction to GraphsPT R U E o r F A L S E5In Chart Designer, you can modify yourgraph's appearance and also print your graph.5M (Select your answer by pressing one of the indicated selections)P55555*@2am c P Ggraphs>Rev.1Ggraphs>Rev.23Ggraphs>Rev.3HNInitial>mainmenuA 2am c P Ggraphs>TF4.TRUE!Lgraphs>TF4.common.path2am c P Ggraphs>TF4.false"Lgraphs>TF4.common.path2am Fe JHPN  !NO CHANGE!+FNQuestion 1Introduction to GraphsPT R U E o r F A L S E5In Chart Designer, you can modify yourgraph's appearance and also print your graph. That's incorrect. This statement is true. ChartDesigner lets you modify your graph's appearance,and also print your graph. Note that to modifyyour data, however, you must be in Solution Designer.pP55555;;;;;;;;; +;2am !cA  N ! TRUE  FALSE 2am *e JHPN  NO CHANGE!+*NQuestion 1Introduction to GraphsPT R U E o r F A L S E5In Chart Designer, you can modify yourgraph's appearance and also print your graph. Correct. This statement is true. Chart Designerlets you modify your graph's appearance and alsoprint your graph. Note that to modify your data,however, you must be in Solution Designer.P55555;;;;;;;;;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 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 . . .;.3333B 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 mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm2am 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 SDmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmB mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmC mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmC mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmD mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm2am c P GPrint>I.1GPrint>I.2-GPrint>I.3?ZCarla.fontRZSD.fontbXprint>PtrtXprint>FileGprint>Op.1Gprint>Op.2Gprint>Op.3Gprint>Op.4Gprint>Op.5Gprint>op.6Gprint>op.7 Gprint>op.8Gprint>op.92Gprint>op.10FGprint>op.11ZGprint>op.12nGprint>op.13Gprint>op.14Gprint>op.15ZSD.fontZCarla.fontGprint>qseg1 print>FIB12am c P Ggraphs>I.1Ggraphs>I.2/Ggraphs>Def.1DGgraphs>Def.2YGgraphs>Def.3nGgraphs>Def.4Ggraphs>Def.5Ggraphs>def.6ZCarla.fontZSD.fontGgraphs>how.1Ggraphs>how.2Ggraphs>how.3Ggraphs>how.4$ZSD.font4ZFont3.fontGGgraphs>how.5\Ggraphs>how.6qZFont3.fontZSD.fontGgraphs>how.7Ggraphs>how.8Ggraphs>how.9Ggraphs>how.10Ggraphs>how.11D ZSD.fontZFont3.font"Ggraphs>how.128ZFont3.fontKZSD.font[Ggraphs>how.13qGgraphs>how.14Ggraphs>how.15ZSD.fontZFont3.fontGgraphs>how.16Ggraphs>how.17Ggraphs>how.18Ggraphs>how.19ZFont3.font+ZSD.font;Ggraphs>how.20QZSD.fontaZCarla.fonttGgraphs>qseg2 graphs>FIB12am c P Gadvanc>dbases>I.1#Gadvanc>dbases>I.2=Gadvanc>dbases>I.3WGadvanc>DBases>Def.1sGadvanc>DBases>Def.2Gadvanc>DBases>Def.3Gadvanc>DBases>Def.4Gadvanc>DBases>Def.5Gadvanc>DBases>Def.6Gadvanc>DBases>Def.7Gadvanc>DBases>Def.87Gadvanc>DBases>Def.9SGadvanc>DBases>Def.10pGadvanc>DBases>Def.11Gadvanc>dbases>Def.12ZCarla.fontZSD.fontGadvanc>dbases>cr.1Gadvanc>dbases>cr.2Gadvanc>dbases>cr.3Gadvanc>dbases>cr.49Gadvanc>dbases>cr.5TGadvanc>dbases>f.1nGadvanc>dbases>f.2Gadvanc>dbases>f.3Gadvanc>dbases>f.4Gadvanc>dbases>f.5Gadvanc>dbases>f.6Gadvanc>dbases>f.7 ZSD.fontZCarla.font-Gadvanc>dbases>qseg2Iadvanc>dbases>mc1mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmE mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmE mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmF mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmF mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmG G H H I I J J K K L L