IMD 1.18: 15/05/2012 10:01:18 solution designer tutorial sd-4 4 of 7 71-03155-07  }FSD-4monetcOf;g ECysSD {9|M^2am f& JHPN   NO CHANGE!+NCalculatingWithFormulasP You have already entered thelabelsandexpense values. EXPENSE REPORTTotal1/6/881/7 881/8/88Expenses Air, rail, bus 450 450Rental car 45 45 45 135Daily lodging 89 89 89 267Meals 25 25 25 75Entertainment 75 75 Total Expenses 609 234 159 1002Less Advances 1200Balance Due To EmployeeBalance Due From Employee 198N P2am eS JHPN  <NO CHANGE!+NJCalculatingWithFormulasPNow, the expense valuesneed to betotaled by rows, and by columns.B EXPENSE REPORTTotal1/6/881/7/881/8/88ExpensesCAir, rail, bus 450 450Rental car 45 45 45 135Daily lodging 89 89 89 267Meals 25 25 25 75Entertainment 75 75CTotal Expenses 609 234 159 1002Less Advances 1200Balance Due To EmployeeBalance Due From Employee 198N P777C55555C:BBB 2am e< JHPN  &NO CHANGE!+N=CalculatingWithFormulasPOne way that you're going to accomplish thisis by using formulas.NEXPENSE REPORTTotal1/6/881/7/881/8/88ExpensesCAir, rail, bus 450 450Rental car 45 45 45 135Daily lodging 89 89 89 267Meals 25 25 25 75Entertainment 75 75CTotal Expenses 609 234 159 1002Less Advances 1200Balance Due To EmployeeBalance Due From Employee 198N Pi:::::::::::::::2am d0 JHPN  ONO CHANGE!+Nv- Question -Modifying an Existing WorksheetPFILLINTHEBLANKNNNN>When using the Edit function key to modify a cell, themode indicator changes from READY to ~~ mode.>NNNNN(Type your answer and press GO when ready)Pg 4I*2am c@ JHPN   'NO CHANGE!+NModifying an Existing WorksheetPThat's correct.When you use the Edit function to modify a cell,the mode indicator changes from READY to EDIT mode.PW2am &c  P GUsing>Modify>FIB2.a000(&LUsing>Modify>FIB2.common.path2am c? JHPN   7NO CHANGE!+NModifying an Existing WorksheetPThat's incorrect.When you use the Edit function to modify a cell,the mode indicator changes from READY to EDIT mode.PW2amch!pEDIT2am c P ZCarla.fontZSD.font,XUsing>Modify>NosEZSD.fontUZCarla.fonthGusing>modify>qseg1Using>Modify>MC32am d_  JHPN  NO CHANGE!+N- Question -Modifying an Existing WorksheetPFILLINTHEBLANKNNN 8 If the main command menu is currently displayed, the keystroke combination to delete one or more rows from your worksheet is ~~ . 8 NNNN(Type your answer and press GO when ready)Pd1*2am cr JHPN  ONO CHANGE!+>N&Modify an Existing WorksheetPpPpi  'vNO CHANGE!NModify an Existing WorksheetPbVery good!You noticed that the main commandis already displayed, and therefore,the keystroke combination to delete one or more rows is wdr.P2am &c P GUsing>Modify>FIB8.a000(&LUsing>Modify>FIB8.common.path2am d JHPN  %NO CHANGE!+NModify an Existing WorksheetPYThat's correct, but remember,the main command menu is already displayed,so it is not necessary to type the slash.The keystroke combination todelete one or more rows iswdr.FP 2am &c P GUsing>Modify>FIB8.a002(&LUsing>Modify>FIB8.common.path2am d  JHPN  %NO CHANGE!+NpModify an Existing WorksheetPThat's incorrect.With the main command menu already displayed,the keystroke combination todelete one or more rows iswdr.wdisplays the Worksheet commands menu,ddisplays the Delete command, andrdeletes one or more rows.P2am &c P GUsing>Modify>FIB8.a999(&LUsing>Modify>FIB8.common.path2amch!p/wdr(a/wdr 2am c P GUsing>Modify>Rev.1$GUsing>Modify>Rev.2?GUsing>Modify>Rev.3ZNUsing>Menu2am cw JHPN  NO CHANGE!+NCalculatingWithFormulasPIn this lesson, you will learnwhat a formula iswhat a formula looks likehow to enter a formula in your worksheett P***** *.t2am dN JHPN  NO CHANGE!+NCalcuatingWitFormulas In thi lesson, ou will larnhat a forula ishat a forula lookslikeow to entr a formua in yourworksheett                                t NO CHANGE!NCalcuingWitormulasIn thiesson, will lnt a fora ist a fora lookske to enta formuin yourrksheettt NO CHANGE!NCalcungWitrmulasIn thisson, will l a for is a for lookseto ent formun yourksheettt NO CHANGE!sNalcuWitulas  thion, ll l fors forooks entormuyourheetttC P NO CHANGE!b $Necuitashi, lororksntmuurettt  NO CHANGE! N   < NO CHANGE! mNNhFormulas )A formula is a mathematical statement }F <S NO CHANGE!e NculatingWithFormulas)A formula is a mathematical statementused to calculate a numeric value.)1r$ <1 NO CHANGE!C NCalculatingWithFormulas")A formula is a mathematical statementused to calculate a numeric value.) "5b < NO CHANGE!+ NCalculatingWithFormulas.)A formula is a mathematical statementused to calculate a numeric value.) .9R <NO CHANGE!NCalculatingWithFormulas<)A formula is a mathematical statementused to calculate a numeric value.) <;B <NO CHANGE!NCalculatingWithFormulasF)A formula is a mathematical statementused to calculate a numeric value.) F <NO CHANGE!NCalculatingWithFormulasP)A formula is a mathematical statementused to calculate a numeric value.)s P2am dC JHPN   NO CHANGE!+N  @ OMNO CHANGE!_&NDng WorksheetD DDDDMMMDDDDDDDDDMMMDDDDDDDD  ' ONO CHANGE!UN5fying an Existing Worksheet55555MMM555ust fine,55d to be made.55.55MMM55555555' ONO CHANGE!N-&Modifying an Existing Worksheet&*&&&&MMM& && coming along just fine,&&hanges that need to be made.&&s is no problem. 2am c P ZCarla.fontZSD.font,GUsing>Modify>I.1EGUsing>Modify>I.2^Gusing>modify>i.3wXUsing>Modify>TextZSD.fontZCarla.fontGusing>modify>qseg1Using>Modify>TF1vao ksow  u nlulc  b v   EEE9 FNO CHANGE!X-Nlatih FoCCC farhaveed land valuo yoksheow luse numlueslculbra valCCC  NO CHANGE! N2Clatingh FormAAA far, have eed laband nuvalueso yourksheetow letuse t numbelues tlculatbrand valueAAAR _NO CHANGE!qNaCallating Wh Formul ??? far, yohave ented labeland numbvalues io your wksheet. ow let'suse tho number lues to lculatebrand n values.???Y fNO CHANGE!xNWCalculating With FormulasPH???1So far, you have entered labels and numbervalues into your worksheet. Now let'suse those number values to calculatebrand new values.1???P. JHPN  ONO CHANGE!+CNQuestion 2Modifying an Existing WorksheetPYThe Worksheet/Insert commandF1 - inserts a column to the left of the cell pointerF2 - inserts a row above the cell pointerF3 - allows you to insert more than one column at a timeF4 - All of the aboveF5 - None of the above/That's correct, however, all three choices are correct. F4 is the appropriate answer./P&&a88888!!!"/////2am dG JHPN   ONO CHANGE!+N]Question Modifying an Existing WorksheetPYou can modify a cell byMUCLF1 - Using the Edit function keyHTF2 - Using the Range/Erase commandOIF3 - Entering a new label or valueIPF4 - All of the aboveCLF5 - None of the aboveEE(Select your answer by pressing one of the indicated selections)P""n""$""""""@ 2am c P Using>Modify>TF42am +e JHPN  NO CHANGE!++NModifying an Existing WorksheetPYou can modify a cell byF1 - using the Edit function keyF2 - using the Range/Erase commandF3 - entering a new label or valueF4 - All of the aboveF5 - None of the above=Correct! The Edit function key, the Range/Erase command, andentering a new label or value are all ways of modifying a cell.CP""n""""""" CCCCC2am %c P #Gusing>modify>mc3.incorrect,%LUsing>Modify>MC3.common.path2am %c  P #GUsing>Modify>MC3.incorrect,%LUsing>Modify>MC3.common.path2am %c P #Gusing>modify>mc3.incorrect,%LUsing>Modify>MC3.common.path2am %c P !GUsing>Modify>MC3.correct*%LUsing>Modify>MC3.common.path2am %c P %GUsing>Modify>MC3.f5incorrect.%LUsing>Modify>MC3.common.path2am Ve  JHPN  .NO CHANGE!+VNModifying an Existing WorksheetPYou can modify a cell byF1 - using the Edit function keyF2 - using the Range/Erase commandF3 - entering a new label or valueF4 - All of the aboveF5 - None of the above:That's incorrect. F4 is the correct answer. The Editfunction key, the Range/Erase command and entering anew label or value, are all ways of modifying a cell.:P""n""""""" :::::::2am e JHPN  NO CHANGE!+NModifying an Existing WorksheetPYou can modify a cell byF1 - using the Edit function keyF2 - using the Range/Erase commandF3 - entering a new label or valueF4 - All of the aboveF5 - None of the aboveCThat's right, however, the appropriate answer is F4, all of theabove. The Edit function key, the Range/Erase command, and entering a new label or value are all ways of modifying a cell.CP""n"""""   CCCCCCC2am 2c N 2 F1  F2  F3  F4  F5 2am Ze  JHPN   <NO CHANGE!+ZNQuestion Modifying an Existing WorksheetPThe command panel contains the following information: Mc9 [W14] 150UWhich of the following statements is true?CLHTOF1 - The cell pointer is at column w, row 14.IIF2 - Cell c9 contains the value, 150, Pcurrently displayed in monetary form.CLF3 - The width of column c is 14.EEF4 - None of the above(Select your answer by pressing one of the indicated selections)P9:99999 --------@2am c P using>modify>mc72am e4 JHPN  $NO CHANGE!+NModifying an Existing WorksheetPThe command panel contains the following information: c9 [W14] 150Which of the following statements is true?eF1 - The cell pointer is at column w, row 14.F2 - Cell c9 contains the value, 150, currently displayed in monetary form.F3 - The width of column c is 14.F4 - None of the above=Excellent! Cell c9 has the format information, [W14], whichmeans that the width of cell c9, and the entire column c, is 14.DP9:9999 -------DDDDD2am %c  P %GUsing>Modify>MC5.f1incorrect.%LUsing>Modify>MC5.common.path2am %c P %GUsing>Modify>MC5.f2incorrect.%LUsing>Modify>MC5.common.path2am %c P !GUsing>Modify>MC5.correct*%LUsing>Modify>MC5.common.path2am %c P #GUsing>Modify>MC5.incorrect,%LUsing>Modify>MC5.common.path2am f  JHPN  NO CHANGE!+NjModifying an Existing WorksheetPThe command panel contains the following information: c9 [W14] 150Which of the following statements is true?eF1 - The cell pointer is at column w, row 14.F2 - Cell c9 contains the value, 150, currently displayed in monetary form.%F3 - The width of column c is 14.%F4 - None of the aboveKF1 is incorrect. The cell pointer is at column c, row 9, not column w, row 14. The correct answer is F3. The format information, [W14], means the width of cell c9, and the entire column c, is 14.KP9:9999 ----# # #KKEKK2am f JHPN   ONO CHANGE!+NtModifying an Existing WorksheetPThe command panel contains the following information: c9 [W14] 150Which of the following statements is true?eF1 - The cell pointer is at column w, row 14.F2 - Cell c9 contains the value, 150, currently displayed in monetary form.%F3 - The width of column c is 14.%F4 - None of the aboveLF2 is incorrect. Cell c9 does contain the value, 150, however there isno currency format. The correct answer is F3. The format information,[W14] means the width of cell c9, and the entire column c, is 14.LP9:9999 ----# # #LLLLL2am eQ JHPN   ONO CHANGE!+N/Modifying an Existing WorksheetPThe command panel contains the following information: c9 [W14] 150Which of the following statements is true?eF1 - The cell pointer is at column w, row 14.F2 - Cell c9 contains the value, 150, currently displayed in monetary form.%F3 - The width of column c is 14.%F4 - None of the aboveKThat's incorrect. The correct answer is F3. The format information,[W14], means that the width of cell c9, and the entire column c, is 14.KP9:9999 ----# # #KKKKK 2am +c N + F1  F2  F3  F4 2am d$ JHPN   ONO CHANGE!+NK- Question -Modifying an Existing WorksheetP@MThe Worksheet/Insert commandUCLHTF1 - inserts a column to the left of the cell pointerOIF2 - inserts a row above the cell pointerIPF3 - allows you to insert more than one column at a timeCLF4 - All of the aboveEEF5 - None of the aboveP&&a8888888882am c P  Using>Modify>FIB82am ye  JHPN  NO CHANGE!+yNModifying an Existing WorksheetPYThe Worksheet/Insert commandF1 - inserts a column to the left of the cell pointerF2 - inserts a row above the cell pointerF3 - allows you to insert more than one column at a timeF4 - All of the aboveF5 - None of the aboveCCorrect! The Worksheet/Insert command inserts a column to theleft of the cell pointer, inserts a row above the cell pointer,and lets you insert more than one column at a time.CP&&a88888888"CCCCC2am %c P #GUsing>Modify>MC7.incorrect,%LUsing>Modify>MC7.common.path2am %c P #GUsing>Modify>MC7.incorrect,%LUsing>Modify>MC7.common.path2am %c P #GUsing>Modify>MC7.incorrect,%LUsing>Modify>MC7.common.path 2am %c P !GUsing>Modify>MC7.correct*%LUsing>Modify>MC7.common.path2am %c P %GUsing>Modify>MC7.f5incorrect.%LUsing>Modify>MC7.common.path2am e JHPN  NO CHANGE!+NModifying an Existing WorksheetPYThe Worksheet/Insert commandF1 - inserts a column to the left of the cell pointerF2 - inserts a row above the cell pointerF3 - allows you to insert more than one column at a timeF4 - All of the aboveF5 - None of the aboveThat's incorrect. Thecorrect answer is F4.IP&&a88888!   c2am 5e   JHPN  NO CHANGE!+5NModifying an Existing WorksheetPYThe Worksheet/Insert commandF1 - inserts a column to the left of the cell pointerF2 - inserts a row above the cell pointerF3 - allows you to insert more than one column at a timeF4 - All of the aboveF5 - None of the above/That's correct, however, all three choices are correct. F4 is the appropriate answer./P&&a88888!!!"/////2am 2c N 2 F1  F2  F3  F4  F5 2am Pg JHPN  $NO CHANGE!+PNa17 ' Balance Due From EmployeeREADY a b c d e f g h i1 EXPENSE REPORT2 3 Now to change numbers.4 5 After looking at your6 Air, rail, bus 450 7 Rental car 40 40 40receipts, you find that8 Daily lodging 68 68 689 Meals 25 25 25the Rental car and10 Entertainment 75 11 Daily lodging values12 13 are incorrect.14 Total Expenses 15 Less Advances Let's change them.16 Balance Due To Employee 17 Balance Due From Employee 18 )19  20  Using the Go To function (F5),21  22  move the cell pointer to cell c7.23  Tue 09-Feb-88 11:27 AM ) Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ))))){ *NO CHANGE!Nla17 ' Balance Due From EmployeePOINTEnter address to go to: a17 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses   15 Less Advances Move to cell c7.16 Balance Due To Employee 17 Balance Due From Employee18 19 20 21 22 23 Tue 09-Feb-88 11:28 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE! N!a17 ' Balance Due From EmployeeEDIT Enter address to go to: c a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:28 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE! N:a17 ' Balance Due From EmployeeEDIT Enter address to go to: c7 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances 16 Balance Due To Employee 17 Balance Due From Employee18 19 20 21 22 23 Tue 09-Feb-88 11:28 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T p I}NO CHANGE!=Nc7 [W9] 40 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 Change the value 40 to 45.14 Total Expenses 15 Less Advances 16 Balance Due To Employee 17 Balance Due From Employee&18 19 To do this, just type 45 .20 21 &22 23 Tue 09-Feb-88 11:29 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!Nc7 [W9] 40 VALUE4 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:29 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T | NO CHANGE!"Nnc7 [W9] 40 VALUE45 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 !13 14 Total Expenses Enter the new value by15 Less Advances 16 Balance Due To Employee pressing the Right Arrow.17 Balance Due From Employee18 !19 20 21 22 23 Tue 09-Feb-88 11:29 AM Macro  Edit  Name Abs  Go To  Window Query Tabl  e  Calc  Graph T !!!!! GNO CHANGE!Nd7 [W9] 40 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 Good. Now, do it again.14 Total Expenses 15 Less Advances Change 40 to 45. This time,16 Balance Due To Employee 17 Balance Due From Employeeuse the Edit function (F2).18 19 20 %21 22 Select the Edit function key.23 Tue 09-Feb-88 11:30 AM % Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T %%%e rNO CHANGE!2Nd7 [W9] 40 EDIT 40 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 #12 13 14 Total Expenses Type the Backspacekey15 Less Advances 16 Balance Due To Employee 17 Balance Due From Employeeto erase the 0.18 19 #20 21 22 23 Tue 09-Feb-88 11:30 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE!N]d7 [W9] 40 EDIT 4 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances Now type5.16 Balance Due To Employee 17 Balance Due From Employee 18 19 20 21 22 23 Tue 09-Feb-88 11:30 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T " "NO CHANGE!"#Nod7 [W9] 40 EDIT 45 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 !13 14 Total Expenses And press the Right Arrow15 Less Advances 16 Balance Due To Employee to enter the new value.17 Balance Due From Employee18 !19 20 21 22 23 Tue 09-Feb-88 11:30 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T !!!!!& :'&NO CHANGE!9&ENe7 [W9] 40 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 One last time.14 Total Expenses 15 Less Advances Change 40 to 45.16 Balance Due To Employee 17 Balance Due From Employee  18 19 20 Simply type45.21 22 23 Tue 09-Feb-88 11:31 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  ~) )NO CHANGE!)Ne7 [W9] 40 VALUE4 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:31 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ., ;,NO CHANGE!M,FNe7 [W9] 40 VALUE45 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances And this time,16 Balance Due To Employee 17 Balance Due From Employee press the Down Arrow18 19 to enter the new value.20 21 22 23 Tue 09-Feb-88 11:31 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T / :/NO CHANGE!/Ne8 [W9] 68 READY a b c d e f g h i1 EXPENSE REPORT2 3 4 5 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 =12 13 Great! Now for something different. Change the Daily14 Total15 Lesslodging values from 68 to 89. To do this, you are going 16 Balan17 Balanto erase the values first using the Range/Erase command.18 19 =20 !21 22 Display the command menu.23 Tue 09-Feb-88 11:33 AM ! Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  ; ]3 7j3NO CHANGE!|3N e8 [W9] 68 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances Typerto select16 Balance Due To Employee 17 Balance Due From Employee18 the Range commands menu.19 20 21 22 23 Tue 09-Feb-88 11:34 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  57 OB7NO CHANGE!T7iNe8 [W9] 68 MENU Format Label Erase Name Justify Protect Unprotect Input Value TransposeFormat one or more cells? a b c d e f g h i  1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 )13 14 Total Expenses 15 Less Advances Then, typeeto select Erase.16 Balance Due To Employee 17 Balance Due From Employee18 )19 20 21 22 23 Tue 09-Feb-88 11:34 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  : !:NO CHANGE!:NVe8 [W9] 68 POINTEnter range to erase: e8..e8 O & a b c d e  f g h i1 EXPENSE REPORT2 A prompt displays asking you to enter3 4 the range of cells to erase.5 )6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 %12 13 You want to erase cells e8 to c8.14 Total Expenses 15 Less Advances Highlight these cells.16 Balance Due To Employee 17 Balance Due From Employee%18 19 )20  21  To do this, press the Left Arrow.22  23 )Tue 09-Feb-88 11:34 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T))) )))> M>NO CHANGE! ? Nkd8 [W9] 68 POINTEnter range to erase: e8..d8 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 '14 Total Expenses 15 Less Advances Press the Left Arrow once more.16 Balance Due To Employee 17 Balance Due From Employee '18 19 20 21 22 23 Tue 09-Feb-88 11:35 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph TB #"BNO CHANGE!4BNc8 [W9] 68 POINTEnter range to erase: e8..c8 a b c d e f g h i1 EXPENSE REPORT 20 30 The range to erase is4! 5!  highlighted.6 Air, rail, bus 450  7 Rental car 45 45 45 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75 11 12 13 14 Total Expenses *15 Less Advances 16 Balance Due To Employee Press Return to erase these cells.17 Balance Due From Employee18 *19 20 21 22 23 Tue 09-Feb-88 11:35 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T***E ENO CHANGE!ENe8 READY a b c d e f g h i1 EXPENSE REPORT2 3 4 5 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging= 9 Meals 25 25 25 10 Entertainment . 11  12 The Daily lodging values have been erased.13 14 Total ExpensesYou are now going to enter the value 8915 Less Advances16 Balance Due To Emplinto cells c8 to e8.17 BalanceDue From Em18 .19 20 /21   22 First,enter the value 89 into cell e8.23  Tue 09-Feb-88 11:35 AM / Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .).I INO CHANGE!IxNe8 VALUE8 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging= 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:36 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T L *LNO CHANGE! 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging= 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances 16 Balance Due To Employee 17 Balance Due From Employee18 19 20 21 22 23 Tue 09-Feb-88 11:36 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T N INNO CHANGE!NNe8 [W9] 89 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 9 Meals 25 25 25 10 Entertainment 75) 11 +12 13  Good. Nowuse the Copy command to copy14 Total Expenses 15 Less Advances the value 89 into cells c8 and d8.16 Balance Due To Employee 17 Balance Due From Employe+18 /19 20 What is the first thing to do?21 22 If you don't remember, just press Help.23 Tue 09-Feb-88 11:36 AM / Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T '/////R <RNO CHANGE!RNe8 [W9] 89 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances Good! Now select16 Balance Due To Employee 17 Balance Due From Employee the Copy command.18 19 20 21 22 23 Tue09-Feb-8811:36AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T GV +TVNO CHANGE!fV>Ne8 [W9] 89 POINTEnter range to copy FROM: e8..e8 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 9 Meals 25 25 25 10 Entertainment 75) 11 012 13 You want to copy cell e8 to cells, c8 and d8.14 Total Expenses 15 Less Advances 016 B  alance Due To Employee 17 Balance Due From Employee18 19 20 What do you do next?21 22 23 Tue 09-Feb-88 11:37 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T Y )YNO CHANGE!YNe8 [W9] 89 POINTEnter range to copy FROM: e8..e8 Enter range to copy TO: e8j a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 !14 Total Expenses 15 Less Advances Good for you!16 Balance Due To Employee 17 Balance Due From EmployeeYou take it from here .18 19 (Remember to press Help20 21 if you need it.)22 23 !Tue 09-Feb-88 11:37 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T          a] n]NO CHANGE!]Nd8 POINTEnter range to copy FROM: e8..e8 Enter range to copy TO: d8j a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:37 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 5` B`NO CHANGE!T`Nd8 POINTEnter range to copy FROM: e8..e8 Enter range to copy TO: d8..d8f a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:38 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  c cNO CHANGE!,cNc8 POINTEnter range to copy FROM: e8..e8 Enter range to copy TO: d8..c8f a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:38 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph Te MeNO CHANGE!faNe8 [W9] 89 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11 '12 13 I'm impressed! Now one last thing.14 Total Expenses 15 Less Advances '16 Balance Due To Employee 17 Balance Due From Employee18 19 620 21  Save   your changes in your file, ExpenseReport.22 23 6Tue 09-Feb-88 11:38 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ##666ei riNO CHANGE!iN}e8 [W9] 89 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:40 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T l lNO CHANGE!lNMe8 [W9] 89 MENU Retrieve Save Combine Xtract Erase List Import Directory Read in a spreadsheet file= a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:40 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T o oNO CHANGE!oNe8 [W9] 89 EDIT Enter save filename: ExpenseReport a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:40 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T rr KrNO CHANGE!rNBe8 [W9] 89 MENU Cancel ReplaceA Cancel operation; don't overwrite file1 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances 16 Balance Due To Employee 17 Balance Due From Employee18 19 20 21 22 23 Tue 09-Feb-88 11:41 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T nu K{uNO CHANGE!uN e8 [W9] 89 WAIT a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances 16 Balance Due To Employee 17 Balance Due From Employee18 19 20 21 22 23 Tue 09-Feb-88 11:41 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T    F5 c c 7 7 0x0A Return 4 4 5 5  RightArrow  ~ The Edit (F2) function key is one way to edit ~ ~ ~ ~ current cell contents. ~ ~~ ~ Dismiss this message and press f2. ~ F2  BackSpace 5 5  RightArrow 4 4 5 5 DownArrow / Slash r r e e  LeftArrow  LeftArrow 0x0A Return 8 ~ To enter the value, 89, first type it in, ~ ~ ~ ~ then press Return. ~ ~~ ~ Dismiss this message and type '8' ... ~ 8 9 ~ To enter the value, 89, first type it in, ~ ~ ~ ~ then press Return. ~ ~~ ~ Dismiss this message and type '9' ... ~ 9 0x0A ~ To enter the value, 89, first type it in, ~ ~ ~ ~ then press Return. ~ ~~ ~ Dismiss this message and press Return. ~ Return / ~ In order to use the Copy command, the first ~ ~~ ~ thing to do is display the command menu. ~ ~~ ~ Dismiss this message and type '/' . ~ c ~ To select a command, type the first letter of ~ ~~ ~ the command name. ~ ~~ ~ Dismiss this message and type 'c' for Copy. ~ c 0x0A ~Since the range to copy FROM is already defined, ~ ~press Return to display the next Copy command ~ ~prompt.  ~ ~~ ~Dismiss this message and press Return. ~  ~Define the range to copy TO, which would be ~ ~d8..c8. Move the cell pointer to the ~ ~beginning cell. ~ ~~ ~Dismiss this message and press Left Arrow. ~ . ~Anchor the cell pointer at cell d8. ~ ~~ ~ ~ ~~ ~Dismiss this message and type a period. ~  ~Define the rest of your range. Your range  ~ ~currently includes cell d8. Include cell c8 ~ ~in your range. ~ ~ ~ ~Dismiss this message and press Left Arrow. ~ 0x0A ~Finally, to perform the copy, press Return. ~ ~~ ~~ ~~ ~Dismiss this message and press Return. ~ / ~ ~ ~~ ~ First, display the command menu. ~ ~~ ~~ Slash f ~ 2am c9 JHPN  NO CHANGE!+N9;I T ' S T I M E T O S E EW H A T Y O U H A V E L E A R N E D . . .;.33332am cA   JHPN  'NO CHANGE!+NFL E T ' S T E S TY O U R K N O W L E D G EB Y A N S W E R I N GA F E W Q U E S T I O N S!F 2am ug JHPN  )NO CHANGE!+NJe8 [W9] 89 READY a b c d e f g h i1 EXPENSE REPORT 2 D3 Finally, let's change the appearance of your worksheet slightly.4 D5 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11 .12 The first thing to do is make all columns13 14 Total Expenses with numbers a little wider.15 Less Advances 16 Balance Due To Employee The cell pointer is currently in column e,17 Balance Due From Employee 18 so let's widen column e first.19 .20 !21 22 Display the command menu.23 Tue 09-Feb-88 11:41 AM ! Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T !!! I)NO CHANGE!;rNe8 [W9] 89 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11 12 "13 14 Total Expenses Select the Worksheet menu.15 Less Advances 16 Balance Due To Employee "17 Balance Due From Employee18 19 20 21 22 23 Tue 09-Feb-88 2:36 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  L NO CHANGE! XNe8 [W9] 89 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Specify global worksheet parameters4 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 %14 Total Expenses 15 Less Advances Select the Column-Width menu.16 Balance Due To Employee 17 Balance Due From Employee%18 19 20 21 22 23 Tue 09-Feb-88 2:36 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T $ :1 NO CHANGE!C Noe8 [W9] 89 MENU Set Reset Hide Display7 Set width of a single column; a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7  Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances Select Set.16 Balance Due To Employee 17 Balance Due From Employee18 19 20 21 22 23 Tue 09-Feb-88 2:37 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  R _NO CHANGE!qCNe8 [W9] 89 (EDIT Enter column width (1..72): 9  E  a b c d e  f  g h i1 EXPENSE REPORT   2 Note that the default column width is 9, 3  4 and the column width is displayed next to 5  6 Air, rail, bus 450 the contents of the current cell. 7 Rental car 45 - 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11 12 '13 14 Total Expenses Change the width of column e to 12.15 Less Advances 16 Balance Due To Employee '17 Balance Due From Employee 18 !19 20 To do this, type 12.21 22 !23 Tue 09-Feb-88 2:37 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T-----  NO CHANGE!Ne8 [W9] 89 EDIT Enter column width (1..72): 1 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 2:37 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!9Ne8 [W9] 89 EDIT Enter column width (1..72): 12 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances Press Return to enter16 Balance Due To Employee 17 Balance Due From Employeethe new column width.18 19 20 21 22 23 Tue 09-Feb-88 2:37 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!Ne8 [W12] 89 READY  4 4 a b c d e f g h   Notice the format  information. [W12] 450  means the width of 45 45 45   89 89 89  cell e8 is 12. But 25 25 25 75) also note that the  width of the entire Now go ahead and changethe column e is 12. width of column d to 12.oyee ployee18 19 120  21  First, move the cell pointer to column d. 22  23 1Tue 09-Feb-88 2:38 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  P +11 /NO CHANGE!Nd8 [W9] 89 READY a b c d e f g h 1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75 # 11 12 Bring up the Column Width menu.13 14 Total Expenses I'll help you out by giving you15 Less Advances 16 Balance Due To Employee the keystrokes to enter.17 Balance Due From Employee18 #19 20 21 Type/wcs.22 23 Tue 09-Feb-88 2:38 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T A" N"NO CHANGE!`"N|d8 [W9] 89 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 1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 2:39 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T w% %NO CHANGE!%N_d8 [W9] 89 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Specify global worksheet parameters4 a b c d e f g h 1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 2:39 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T ( (NO CHANGE!(N(d8 [W9] 89 MENU Set Reset Hide Display7 Set width of a single column; a b c d e f g h 1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 2:40 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T r+ +NO CHANGE!+!Nwd8 [W9] 89 EDIT Enter column width (1..72): 9 a b c d e f g h 1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances Good! Now type in16 Balance Due To Employee 17 Balance Due From Employeethe value 12.18 19 20 21 22 23 Tue 09-Feb-88 2:40 PM Macro  Edit  Name Abs  Go To  Window Query Table   Calc  Graph T . .NO CHANGE!.Nd8 [W9] 89 EDIT Enter column width (1..72): 1 a b c d e f g h 1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 2:40 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T }1 1NO CHANGE!1<Nd8 [W9] 89 EDIT Enter column width (1..72): 12 a b c d e f g h 1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances  16 Balance Due To Employee And press Return to enter17 Balance Due From Employee18 the new column width.19 20 21 22 23 Tue 09-Feb-88 2:40 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 4 %4NO CHANGE!4cNd8 [W12] 89 READY a b c d e f g h 1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75& 11 12 "13 14 Total Expenses Great! You now have the width15 Less Advances 16 Balance Due To Employee of column c left to change.17 Balance Due From Employee18 "19 *20 21 Move the cell pointer to column c.22 23 *Tue 09-Feb-88 2:41 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T "Z8 (g8NO CHANGE!y8dNc8 [W9] 89 READY a b c d e f g h 1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75& 11 #12 13 Bring up the Column Width menu.14 Total Expenses 15 Less Advances #16 Balance Due To Employee 17 Balance Due From Employee+18 19 Remember the keystroke combination?20 21 If not, just press Help.22 23 +Tue 09-Feb-88 2:41 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T +++++; ;NO CHANGE!;N|c8 [W9] 89 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 1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75& 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18 N 19N 20N 21N 22N 23N Tue 09-Feb-88 2:42 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ?  ?NO CHANGE!2?N_c8 [W9] 89 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Specify global worksheet parameters4 a b c d e f g h 1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75& 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 2:42 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ,B 9BNO CHANGE!KBN(c8 [W9] 89 MENU Set Reset Hide Display7 Set width of a single column; a b c d e f g h 1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75& 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 2:42 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T E ENO CHANGE!-ENc8 [W9] 89 EDIT Enter column width (1..72): 9 O  a b c d e f  g h 1 EXPENSE REPORT-  2  3 4 5>  6 Air, rail, bus 450!  7 Rental car 45 45 45  8 Daily lodging 89 89 89  9 Meals 25 25 25  10 Entertainment 75  11 12 ' 13  14 Total Expenses  Good! Now instead of typing 12, press 15 Less Advances 0 16 Balance Due To Emthe Right Arrow until the value 12 displays.17 Balance Due From 18 419 20 21 22 23 Tue 09-Feb-88 2:43 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 44444H HNO CHANGE!HNRc8 [W10] 89 EDIT Enter column width (1..72): 10 O  a b c d e f  g h 1 EXPENSE REPORT,  2*  3=  4=  5=  6 Air, rail, bus 450  7 Rental car 45 45 45  8 Daily lodging 89 89 89  9 Meals 25 25 25  10 Entertainment 75  11!  12! 13! Notice how the column width increases 14 Total Expenses   15 Less Advances as you increase the number. 16 Balance Due To Employee 17 Balance Due From Employee ) 18 )19   20  Continue to press the Right Arrow 21  22  until you reach 12. 23 ) Tue 09-Feb-88 2:46 PM ) Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ))))))))))M MNO CHANGE!!MN3c8 [W11] 89 EDIT Enter column width (1..72): 11 O  a b c d e f  g h 1 EXPENSE REPORT,  2=  3=  4=  5=  6 Air, rail, bus 450  7 Rental car 45 45   45  8 Daily lodging 89 89 89  9 Meals 25 25 25  10 Entertainment 75  11!  12! 13! Notice how the column width increases 14 Total Expenses   15 Less Advances as you increase the number. 16 Balance Due To Employee 17 Balance Due From Employee ) 18! ) 19! ) 20!  Continue to press the Right Arrow 21! ) 22!  until you reach 12. 23! ) Tue 09-Feb-88 2:47 PM ) Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T )))))1Q >QNO CHANGE!PQNBc8 [W12] 89 EDIT Enter column width (1..72): 12 O  a b c d e f g h1 EXPENSE REPORT,  2=  3=  4=  5=  6 Air, rail, bus 450  7 Rental car 45 45 45  8 Daily lodging 89 89 89  9 Meals 25 25 25  10 Entertainment 75  11 12 13 Notice how the column width increases 14 Total Expenses   15 Less Advances as you increase the number. 16 Balance Due To Employee 17 Balance Due From Employee)18 )19 20 ContinuetopresstheRightArrow21 22 untilyoureach12.23 Tue 09-Feb-88 2:48 PM ) Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T )))))oU |UNO CHANGE!U Ncc8 [W12] 89 EDIT Enter column width (1..72): 12 a b c d e f g h1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 450/ 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75# 11 12 13 ,14 Total Expenses 15 Less Advances Finally, enter the new column width.16 Balance Due To Employee 17 Balance Due From Employee,18 19 20 21 22 23 Tue 09-Feb-88 2:48 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ,,,X KXNO CHANGE!XN>c8 [W12] 89 READY a b c d e f g h1 EXPENSE REPORT * 2 Good! Notice that columns c, d, and e3 4 are wider than the other columns.  5 * 6 Air, rail, bus 450/ 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75# 11 .12 Now insert a column.13 14 Total Expenses The cell pointer is currently in column c.15 Less Advances 16 Balance Due To Employee Insert a column to the left of column c.17 Balance Due From Employee.18 19 !20 21 Display the command menu.22 23 !Tue 09-Feb-88 2:48 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T*** \ K\NO CHANGE!\oNc8 [W12] 89 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 h1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 450/ 7 Rental car 45 45 45 8 Daily lodgin g 89 89 89 9 Meals 25 25 25 10 Entertainment 75# 11 12 13 14 Total Expenses "15 Less Advances 16 Balance Due To Employee Select the Worksheet menu.17 Balance Due From Employee18 "19 20 21 22 23 Tue 09-Feb-88 2:51 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2` ,?`NO CHANGE!Q`YNc8 [W12] 89 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Specify global worksheet parameters4 a b c d e f g h1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 450/ 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75# 11 12 13 14 Total Expenses 15 Less Advances 16 Balance Due To Employee Select the Insert menu.17 Balance Due From Employee18 19 20 21 22 23 Tue 09-Feb-88 2:51 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T c .cNO CHANGE!cNc8 [W12] 89 MENU Column Row 0 Insert one or more columns to the left of the current cell  a b c d e f  g h1 EXPENSE REPORT2 3 Column is currently highlighted.4 5 $6 Air, rail, bus 450/ 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75# 11 12 13 14 Total Expenses 15 Less Advances $16 Balance Due To Employee 17 Balance Due From EmployeeType c to select Column.18 19 $20 21 22 23 Tue 09-Feb-88 2:51 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$$$    g gNO CHANGE!guNc8 [W12] 89 POINTEnter column insert range: c8..c8  O ) a b c d  e f g h1 EXPENSE REPORT 2 The prompt indicates the number of columns3  4 to insert and at what column to insert it.5 . 6 Air, rail, bus 450/ 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75# 11 +12 Columns are inserted to the left of13 14 Total Expenses the column containing the cell pointer.15 Less Advances 16 Balance Due To Employee(And rows are inserted above the row17 Balance Due From Employee18 containing the cell pointer.)19 +20 :21  22  Press Return to insert the column before column c. 23  Tue 09-Feb-88 2:51 : Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T... 2 l L-lNO CHANGE!?lNc8 READY a b c d e f g h1 EXPENSE REPORT> 2O 3 4O 5O 6 Air, rail, bus 450& 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment! 75 11 *12 13 Good job! Now let's remove some rows.14 Total Expenses 15 Less Advances Remove rows 4 and 5.16 Balance Due To Employee 17 Bal ance Due From Employee*18 '19 20 First, use the Up Arrow to move21 22 the cell pointer to row 5.23 Tue 09-Feb-88 2:52 PM ' Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T '''''o oNO CHANGE!oNc7 READY a b c d e f g h1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 450& 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment! 75 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 2:54 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T br orNO CHANGE!rNc6 READY a b c d e f g h1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 450& 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment! 75 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Balance Due From Employee1 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 2:54 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T u NuNO CHANGE! uN?c5 READY a b c d e f g h1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 450& 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment! 75 11 12 13 ,14 Total Expenses 15 Less Advances Good. Now display the command menu.16 Balance Due To Employee 17 Balance Due From Employee,18 19 20 21 22 23 Tue 09-Feb-88 2:54 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T &w 0 xNO CHANGE!xdNc5 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 h1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 450& 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment! 75 11 12 13 "14 Total Expenses 15 Less Advances Select the Worksheet menu.16 Balance Due To Employee 17 Balance Due From Employee"18 19 20 21 22 23 Tue 09-Feb-88 2:54 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T { ({NO CHANGE!{INc5 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Specify global worksheet parameters4 a b c d e f g h1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 450& 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment! 75 11 12 13 14 Total Expenses 15 Less Advances And select Delete.16 Balance Due To Employee 17 Balance Due From Employee18 19 20 21 22 23 Tue 09-Feb-88 2:55 PM Macr o  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ~ 0~NO CHANGE! Nc5 MENU Column Row % Delete one or more columns a b c d e  f g h1 EXPENSE REPORT  2  3 Column is currently highlighted.  4# $  5# $ 6 Air, rail, bus 450& 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment! 75 11! 12! 13! &14 Total Expenses  15 Less Advances  Since you want to remove rows, 16 Balance Due To Employee    17 Balance Due From Employee  type r to select Row.   18!    19! & 20!  21!  22! 23N Tue 09-Feb-88 2:55 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$$$ ߂ "NO CHANGE!N8c5 POINTEnter range of rows to delete: c5..c5  O a b c d e  f g h1 EXPENSE REPORT2 The prompt displays the range to delete.3 4 The range currently includes row 5.5 , 6 Air, rail, bus 450& 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment! 75 11 ' 12 13 Include row 4 as part of the range.14 Total Expenses  15 Less Advances '16 Balance Due To Employee 17 Balance Due From Employee ,18  19  To do this, press the Up Arrow once. 20  21 ,22 23  Tue 09-Feb-88 2:55 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T,,, ,,, $NO CHANGE! Nc4 POINTEnter range of rows to delete: c5..c4 O a b c d e  f g h1 EXPENSE REPORT  2)  3) The range is highlighted and 4  5) the prompt is updated. 6 Air, rail, bus 450 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment! 75 11 12 (13 14 Total Expenses Press Return to delete the rows.15 Less Advances 16 Balance Due To Employee (17 Balance Due From Employee18 19 20 21 22 23 Tue 09-Feb-88 2:55 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T     (((  1NO CHANGE!ÊN6c5 READY a b c d e f g h1 EXPENSE REPORT> 2O 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9 10 11 12 Total Expenses 13 Less Advances 14 Balance Due To Employee You're doing great!15 Balance Due From Employee16 17 (Press Next Page to Continue)18 19 20 21 22 23 Tue 09-Feb-88 2:56 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T %  %%%%  ~ ~~ ~ Select the File commands menu. ~ ~~ ~~ f s ~ ~ ~~ ~ Select the Save command. ~ ~~ ~~ s 0x0A ~ ~ ~  Press Return to save your changes ~ ~~ ~ in the file, ExpenseReport. ~ ~~ r ~ You are practicing saving your changes to the ~ ~ file, ExpenseReport. To do this, you must use ~ ~ the Replace command.  ~ ~~ ~ Dismiss this message and type r for Replace. ~ time time/ Slash w w c c s s 1 1 2 2 0x0A Return  LeftArrow / Slash w w c c s s 1 1 2 2 0x0A Return  LeftArrow / ~ The keystroke combination is /wcs. ~ ~~ ~~ ~~ ~ Dismiss this message and type '/' ... ~ Slash w ~ The main command menu is displayed. ~ ~~ ~ Now select the Worksheet command. ~ ~~ ~ Dismiss this message and type 'w' ... ~ w c ~ The Worksheet command menu is displayed. ~ ~~ ~ Now select the Column-Width command. ~ ~~ ~ Dismiss this message and type 'c' ... ~ c s ~ The Column-Width command menu is displayed. ~ ~~ ~ Select Set to set a new column width. ~ ~~ ~ Dismiss this message and type 's' ... ~ s  ~ You are to use the Right Arrow to set the ~ ~~ ~ column width. ~ ~~ ~ Dismiss this message and press the Right Arrow. ~ RightArrow  RightArrow  RightArrow time 0x0A ~To enter the new column width, press Return. ~ 2am ?e JHPN   ONO CHANGE!+N'!  GNO CHANGE!?NModifyinganExistingWorksheet5There are two ways to modify labels or values:1)Simply type in the new label or value2)Use the Edit (F2) function key'!To Erase the contents of one or more cells,select the Range/Erase command.To change the column width of a singlecolumn,select the Worksheet/Column-Width/Setcommand.  5&*&2am d  JHPN   -NO CHANGE!+N\ModifyinganExistingWorksheet5To insert one or more columns or rows,select the Worksheet/Insert command.To remove one or more columns or rows,'select the Worksheet/Delete command.ܱ!  5%%2am e" JHPN  NO CHANGE!+NModifyinganExistingWorksheet5To insert one or more columns or rows,YouhavereachedtheendselecttheWorksheet/Insertcommand.ofthislesson,andtheendoftheUsingsection.To remove one or more columns or rows,WesuggestyouproceedselecttheWorksheet/Deletecommand.tothenextsection,Performing Calculations in Your Worksheet.PressNextPagetoreturntotheUsingmenu.  555 %55555 %555555555555555552am g, JHPN  NO CHANGE!+Na1 READY a b c d e f g h i1O 2 3 )4 5 The first thing you're going to do is6 7 change a couple of labels.8 9 )10 11 12 13 '14 15 Display the main commands menu.16 17 '18 19 20 21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]+++++++  NO CHANGE!N@a1 MENU Worksheet Range  Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h i1O 2 3 4 5 6 *7 8 Retrieve your file, ExpenseReport.9 10 Do you remember how to do it?11 12 If not, just press Help.13 14 *15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 12:30 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]*******  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 i1A 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Mon 08-Feb-88 1:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] O NO CHANGE!# N]a1 MENU Enter filename of new spreadsheet: *.wk?( ExpenseReport.wkt 2 a b c d e f g h i1O 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Tue 09-Feb-88 11:14 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  % NO CHANGE!7 Nd10 [W9] 75 READY a b c d e f g h i1 EXPENSE REPORT> 21 31 41 51 6 Air, rail, bus 450 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75 11 12 13 14 Total Expenses 15 Less Advances 16 Bal Due To Emp 17 Bal Due From Emp18 19 20 21 22 23 Tue 09-Feb-88 11:18 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!N%d10 [W9] 75 READY a b c d e f g h i1 EXPENSE REPORT> 2 6 3  4 Good job. Now let's get to work. You decide that 5 4 6 Air, rail, bus the two labels, "Bal Due To Emp" and "Bal Due From  7 Rental car 8 Daily lodging Emp", would look better if they were spelled out. 9 Meals 10 Entertainment Well, let's change those labels.11 12 /13 14 Total Expenses #15 Less Advances 16 Bal Due To Emp Press Next Page to Continue17 Bal Due From Emp18 #19 20 21 22 23 Tue 09-Feb-88 11:18 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T### ONO CHANGE!wNd10 [W9] 75 READY a b c d e f g h i1 EXPENSE REPORT> 21 31 41 51 6 Air, rail, bus 450 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75 11 12 /13 14 Total Expenses Your cell pointer is currently at cell d10.15 Less Advances 16 Bal Due To Emp /17 Bal Due From Emp+18 19 Use the Go To function (F5) to move20 21 the cell pointer cell to a16.22 23 +Tue 09-Feb-88 11:18 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T +++++W 7dNO CHANGE!vNGd10 [W9] 75 POINTEnter address to go to: d10 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances Go to cell a16.16 Bal  Due To Emp 17 Bal Due From Emp 18 19 20 21 22 23 Tue 09-Feb-88 11:19 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ] jNO CHANGE!|Nd10 [W9] 75 EDIT Enter address to go to: a3 W a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:19 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  #NO CHANGE!5Nd10 [W9] 75 EDIT Enter address to go to: a13 W a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:19 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!Nd10 [W9] 75 EDIT Enter address to go to: a16 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances 16 Bal Due To Emp 17 Bal Due From Emp 18 19 20 21 22 23 Tue 09-Feb-88 11:19 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ! <!NO CHANGE!!Na16 ' Bal Due To Emp READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 '12 13 Good. Now change "Bal Due to Emp".14 Total Expenses 15 Less Advances '16 Bal Due To Emp 017 Bal Due From Emp 18 To do this, simply type in the new label19 20 21 Balance Due To Employee.22 23 Tue 09-Feb-88 11:20 AM 0 Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ($P% ]%NO CHANGE!o%Na16 ' Bal Due To Emp LABEL B a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T '  (NO CHANGE!(Na16 ' Bal Due To Emp LABEL Ba a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T * *NO CHANGE!*Na16 ' Bal Due To Emp LABEL Bal a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T E- R-NO CHANGE!d-Na16 ' Bal Due To Emp LABEL Bala a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T / /NO CHANGE! 0Na16 ' Bal Due To Emp LABEL Balan a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2 2NO CHANGE!2Na16 ' Bal Due To Emp LABEL Balanc a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T C5  P5NO CHANGE!b5Na16 ' Bal Due To Emp LABEL Balance a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 7  7 NO CHANGE!8Na16 ' Bal Due To Emp LABEL Balance a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T :  :NO CHANGE!:Na16 ' Bal Due To Emp LABEL Balance D a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T J=  W=NO CHANGE!i=Na16 ' Bal Due To Emp LABEL Balance Du a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ?  @NO CHANGE!@Na16 ' Bal Due To Emp LABEL Balance Due a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T B BNO CHANGE!BNa16 ' Bal Due To Emp LABEL Balance Due a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ZE gENO CHANGE!yENa16 ' Bal Due To Emp LABEL Balance Due T a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   H HNO CHANGE!+HNa16 ' Bal Due To Emp LABEL Balance Due To a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T J JNO CHANGE!JNa16 ' Bal Due To Emp LABEL Balance Due To a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T sM MNO CHANGE!MNa16 ' Bal Due To Emp LABEL Balance Due To E a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T (P 5PNO CHANGE!GPNa16 ' Bal Due To Emp LABEL Balance Due To Em a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T R RNO CHANGE!RNa16 ' Bal Due To Emp LABEL Balance Due To Emp a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T U UNO CHANGE!UNa16 ' Bal Due To Emp LABEL Balance Due To Empl a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  MX ZXNO CHANGE!lXNa16 ' Bal Due To Emp LABEL Balance Due To Emplo a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T [ [NO CHANGE!%[Na16 ' Bal Due To Emp LABEL Balance Due To Employ a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ] ]NO CHANGE!]Na16 ' Bal Due To Emp LABEL Balance Due To Employe a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T {` `NO CHANGE!`N_a16 ' Bal Due To Emp LABEL Balance Due To Employee a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 015 Less Advances 16 Bal Due To Emp And press Return to enter the new label.17 Bal Due From Emp 18 019 20 21 22 23 Tue 09-Feb-88 11:20 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T0 00c NcNO CHANGE!clNa16 ' Balance Due To Employee READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 (12 13 Good!14 Total Expenses 15 Less Advances Now change the label below this one.16 Balance Due To Employee 17 Bal Due From Emp (18 19 /20 21 First,move the cell pointer down once.22 23 /Tue 09-Feb-88 11:21 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T (///&g ?3gNO CHANGE!EgoNa17 ' Bal Due From Emp READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Dail y lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 012 13 You're going to learn something new here.14 Total Expenses 15 Less Advances To change this label, use the Edit function.16 Balance Due To Employee17 Bal Due From Emp 018 19 20 21 Press f2, Edit.22 23 Tue 09-Feb-88 11:22 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T j jNO CHANGE!jNa17 ' Bal Due From Emp EDIT ' Bal Due From Emp   The contents of cell a17 a b c d  i1 EXPENSE REPORT are displayed. You make 2 3 your edits here. Also, 4 5 notice the mode changed 6 Air, rail, bus 450  7 Rental car 40 40 from READY to EDIT. 8 Daily lodging 68 68  9 Meals 25 25  10 Entertainment 75) 11 (12 13 The first thing to do is move the14 Total Expenses 15 Less Advances cursor to the beginning of the line.16 Balance Due To Employee17 Bal Due From Emp (18 19 .20 21  To do this, pressShiftUpArrow.22 23 .Tue 09-Feb-88 11:23 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph +  o oNO CHANGE!oN+a17 ' Bal Due From Emp EDIT ' Bal Due From Emp a b c d e f g h i1 EXPENSE REPORT2 3 4 5 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances 16 Balance Due To Employee17 Bal Due From Emp 18 19 20 21 22 23 Tue 09-Feb-88 11:25 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T fr srNO CHANGE!rNba17 ' Bal Due From Emp EDIT ' Bal Due From Emp O / a b c d  e f g h i1 EXPENSE REPORT "2 3 The cursor is at the beginning of the line.4 5 /6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 #12 13 Move the cursor to the position14 Total Expenses 15 Less Advances after the l in Bal.16 Balance Due To Employee17 Bal Due From Emp #18 -19 20 To do this, press the Right Arrow21 22 until you reach the desired position.23 Tue 09-Feb-88 11:25 AM - Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T/// %%%v vNO CHANGE!vN a17 ' Bal Due From Emp EDIT ' Bal Due From Emp a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15  Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:25 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T Zy gyNO CHANGE!yyN a17 ' Bal Due From Emp EDIT ' Bal Due From Emp a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:25 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T | &|NO CHANGE!8|N a17 ' Bal Due From Emp EDIT 'Bal Due From Emp a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:25 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ~ ~NO CHANGE!~NO CHANGE!  NO CHANGE!(NO CHANGE!: GNO CHANGE!Y2Na17 ' Bal Due From Emp EDIT 'BalDue From Emp a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 Good!14 Total Expenses 15 Less Advances 16 Balance Due To Employee Now type ance.17 Bal Due From Emp 18 19 20 21 22 23 Tue 09-Feb-88 11:25 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!Na17 ' Bal Due From Emp EDIT ' BalaDue From Emp9 W a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:26 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T N [NO CHANGE!mNa17 ' Bal Due From Emp EDIT ' BalanDue From Emp9 W a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:26 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T    NO CHANGE!1Na17 ' Bal Due From Emp EDIT ' BalancDue From Emp9 W a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:26 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ֊  NO CHANGE!Na17 ' Bal Due From Emp EDIT ' BalanceDue From Emp a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75 11 12 Now spell out "Employee".13 14 Total Expenses But first, move the cursor15 Less Advances 16 Balance Due To Employeeto the end of the label.17 Bal Due From Emp 18 19 ,20 21 To do this, press the Bound key.22 23 ,Tue 09-Feb-88 11:26 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   ˎ ؎NO CHANGE!N*a17 ' Bal Due From Emp EDIT ' BalanceDue From Emp a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances 16 Balance Due To Employee 17 Bal Due From Emp 18 19 20 21 22 23 Tue 09-Feb-88 11:26 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!ɑNza17 ' Bal Due From Emp EDIT ' BalanceDue From Emp a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances Now typeloyee.16 Balance Due To Employee 17 Bal Due From Emp 18 19 20 21 22 23 Tue 09-Feb-88 11:26 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!Na17 ' Bal Due From Emp EDIT ' BalanceDue From Empl a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:26 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!ɗNa17 ' Bal Due From Emp EDIT ' Balance Due From Emplo a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:26 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T o |NO CHANGE!Na17 ' Bal Due From Emp EDIT ' BalanceDue From Employ a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:26 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 5 BNO CHANGE!TNa17 ' Bal Due From Emp EDIT ' BalanceDue From Employe a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:26 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE! Nia17 ' Bal Due From Emp EDIT ' BalanceDue From Employee a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 013 14 Total Expenses And press Return to enter the new label.15 Less Advances 16 Balance Due To Employee017 Bal Due From Emp 18 19 20 21 22 23 Tue 09-Feb-88 11:26 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T000 & 73NO CHANGE!ENIa17 ' Balance Due From EmployeeREADY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses Fantastic!15 Less Advances 16 Balance Due To Employee 17 Balance Due From Employee (Press Next Page to Continue)18 19 20 21 22 23 Tue 09-Feb-88 11:27 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T%  %% %% / ~To display the command menu, type the slash. ~ ~~ ~~ ~~ ~Dismiss this message and type '/'. ~ f ~ To retrieve a file, you must first select ~ ~ ~ ~ the File command. ~ ~ ~ ~ Dismiss this message and type 'f' for File. ~ r ~Select Retrieve from the File commands menu. ~ ~~ ~ ~ ~~ ~Dismiss this message and type 'r' for Retrieve. ~ 0x0A ~Highlight the file you want to retrieve, then ~ ~press Return to read in your file. Your file ~ ~is already highlighted. ~ ~  ~ ~Dismiss this message and press Return. ~ time 0x0C  F5 a a 1 ~The cell you want to go to is a16. ~ ~~ ~~ ~~ ~Dismiss this message and type '1' ... ~ 1 6 ~The cell you want to go to is a16. ~ ~~ ~~ ~~ ~Dismiss this message and type '6'. ~ 6 0x0A ~You just finished typing the cell address to ~ ~go to. To move the cell pointer to this ~ ~cell address, press Return. ~ ~~ ~Dismiss this message and press Return. ~ B ~ The label to type in is ~ ~~ ~ Balance Due To Employee ~ ~~ ~ Dismiss this message and type 'B' ... ~ ShiftLeft b a ~ The label you are currently typing in is  ~ ~~ ~ Balance Due To Employee ~ ~~ ~ Dismiss this message and type 'a' ... ~ a l ~ The label you are currently typing in is ~ ~~ ~ Balance Due To Employee ~ ~~ ~ Dismiss this message and type 'l' ... ~ l a ~ The label you are currently typing in is ~ ~~ ~ Balance Due To Employee ~ ~~ ~ Dismiss this message and type 'a' ... ~ a n ~ The label you are currently typing in is  ~ ~~ ~ Balance Due To Employee ~ ~~ ~ Dismiss this message and type 'n' ... ~ n c ~ The label you are currently typing in is ~ ~~ ~ Balance Due To Employee ~ ~~ ~ Dismiss this message and type 'c' ... ~ c e ~ The label you are currently typing in is ~ ~~ ~ Balance Due To Employee ~ ~~ ~ Dismiss this message and type 'e' ... ~ e 0x20 ~ The label you are currently typing in is  ~ ~~ ~ Balance Due To Employee ~ ~~ ~ Dismiss this message and press spacebar ... ~ Space D ~ The label you are currently typing in is ~ ~~ ~ Balance Due To Employee ~ ~~ ~ Dismiss this message and type 'D' ... ~ ShiftLeft d u u e e 0x20 Space T ~ The label you are currently typing in is ~ ~~ ~ Balance Due To Employee ~ ~~ ~ Dismiss this message and type 'T' ... ~ ShiftLeft t o o 0x20 Space E ~ The label you are currently typing in is ~ ~~ ~ Balance Due To Employee ~ ~~ ~ Dismiss this message and type 'E' ... ~ ShiftLeft e m ~ The label you are currently typing in is ~ ~~ ~  Balance Due To Employee ~ ~~ ~ Dismiss this message and type 'm' ... ~ m p l o y e e 0x0A Return DownArrow  ~ The Edit (F2) function key is one way to edit ~ ~~ ~ existing labels. ~ ~~ ~ Dismiss this message and press f2. ~ F2 ~To move to the first character of the label, ~ ~press Shift, Up Arrow. ~ ~ ~ ~Dismiss this message, then hold the Shift key ~ ~down while pressing Up Arrow. ~ ShiftRight UpArrow time  ~Press the Right Arrow to move the cursor to the ~ ~position after the l in 'Bal'. ~ ~~ ~~ ~Dismiss this message and press Right Arrow.   ~ RightArrow  ~Continue to press the Right Arrow until you reach ~ ~the position after the l in 'Bal'. ~ ~~ ~~ ~Dismiss this message and press Right Arrow. ~  ~Continue to press the Right Arrow until you reach ~ ~the position after the l in 'Bal'. ~ ~~ ~~ ~Dismiss this message and press Right Arrow. ~  RightArrow  RightArrow  RightArrow a ~Spell out the word Balance. ~ ~~ ~~ ~~ ~Dismiss this message and type 'a' ... ~  a n ~ You are currently spelling out the word, ~ ~~ ~ Balance. ~ ~~ ~ Dismiss this message and type 'n' ... ~ c c e e ~ You are to move the cursor to the end of the ~ ~~ ~ label. To do this, use the Bound key. ~ ~~ ~ Dismiss this message and press Bound. ~ Bound time l ~Spell out the word, Employee. ~ ~~ ~~ ~~ ~Dismiss this message and type 'l' ... ~ l o ~ You are currently spelling out the word, ~ ~~ ~ Employee. ~ ~~ ~ Dismiss this message and type 'o' ... ~ y y e e e e 0x0A Return time2am d" JHPN   NO CHANGE!+NJQuestion Modifying an Existing WorksheetPT R U E o r F A L S E0To modify a label, move the cell pointerto the label, type in the new label,then press Return.0 (Select your answer by pressing one of the indicated selections)P((&('@2am c P  Using>Modify>FIB22am %c  P GUsing>Modify>TF1.true'%LUsing>Modify>TF1.common.path2am %c P GUsing>Modify>TF1.false(%LUsing>Modify>TF1.common.path2am @e JHPN  &NO CHANGE!+@NModifying an Existing WorksheetPT R U E o r F A L S E0To modify a label, move the cell pointerto the label, type in the new label,then press Return. %That's incorrect. This statement%%is true. Modifying a label is athree-step process: Move cell pointer to existing label, typenew label, then press Return.P((&(+++++++++ +2am !c N ! TRUE  FALSE  2am 6e JHPN  #NO CHANGE!+6NModifying an Existing WorksheetPT R U E o r F A L S E0To modify a label, move the cell pointerto the label, type in the new label,then press Return. %Correct. This statement is true.%%Modifying a label is a three-stepprocess: Move cell pointer to existing label, type new label,then press Return. P((&(++++++++++2am :d JHPN   NO CHANGE!+:NQuestion Modify an Existing WorksheetPT R U E o r F A L S E8To modify a cell, you must first erase itscontents before entering the new label or value.8L P88888+2am c P ZCarla.fontZSD.font,XUsing>Modify>RCDZSD.fontTZCarla.fontgGusing>modify>qseg2Using>Modify>MC52am %c  P GUsing>Modify>TF4.true'%LUsing>Modify>TF4.common.path2am %c P GUsing>Modify>TF4.false(%LUsing>Modify>TF4.common.path2am dL JHPN  NO CHANGE!+NmModify an Existing WorksheetPT R U E o r F A L S E8To modify a cell, you must first erase itscontents before entering the new label or value.Correct. This statement is false. You do nothave to erase the contents first. Simply enter the new label or value.P8888888888887~~ ~~ ~~ ~~ Return / Slash w w i i c c 0x0A Return  UpArrow  UpArrow  UpArrow / Slash w w d d r r  UpArrow 0x0A Return time2am !c N ! TRUE  FALSE  2am dT JHPN  NO CHANGE!+NuModify an Existing WorksheetPT R U E o r F A L S E8To modify a cell, you must first erase itscontents before entering the new label or value.That's incorrect. This statement is false. You do not have to erase the contents first. Simply enter the new label or value.P88888666666692am h/ JHPN  NO CHANGE!+NModifyinganExistingWorksheetPA  oolaogigenrktour hxpen e retort vs cosing ylongwjusthfinehweve, thsre afe a tew ciangeu thar ne to e mae.ceakinu chaiges s noprobem.mraosrwdu  PP<>>?>?> NO CHANGE!&NModifyinganExistingWorksheetPB t lonoullarowcgeisg eln r kstur hapen e retirt va cos ng yoongwoustheineheve thsee afo a tiw cinngeurtharknetto ma.che kinumchaides norobm.moroanols irtwsd um  PP<>@??@>   NO CHANGE! NModifyinganExistingWorksheetPC th leon,ou ll arnow chge istg lelsn yr wkshtr hanen exretint valcos ig youngworstheenehveethse afora tio cin geur harkseto machae cinumnhaidts noob.movrowandolusinrt ws d cumn  PP<A@@@AA NO CHANGE!NModifyinganExistingWorksheetPDI thi leson, ou wll larn ow tchage eistig laels n yor wokshet hangn exieting valuos in yourgworktheeteheerhse iaform tioncin yeur warksheet achane conumn aidth obrmoverowsand olumsinsrt rws ad coumns  PN<AAAAFAc pNO CHANGE!iN.Modifying an Existing WorksheetPNIn this lesson, you will learn how tochange existing labels in your worksheetchange existing values in your worksheeterase information in your worksheetchange column widthremove rows and columnsinsert rows and columnsPN%BBB && MMM&&&&&&&&*       #' ONO CHANGE!NQModifying an Existing Worksheet6MMM,se report is coming along just fine, are a few changes that need to be made.aking changes is no problem.,MMM6,,,,,,,/'k OxNO CHANGE!No Modifying an Existing Worksheet E MMM ;  Your expense report is coming along just fine,  however, there are a few changes that need to be made.  Making changes is no problem.  ;MMM E;;;;;;;8'T a NO CHANGE!s N?Modifying an Existing WorksheetPALLL>Your expense report is coming along just fine,however, there are a few changes that need to be made.Making changes is no problem.>LLLP>>>>>>>8'3x 3@xNO CHANGE!RxN;e8 [W9] 89 READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 45 45 45 8 Daily lodging 89 89 89 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 Excellent job!14 Total Expenses 15 Less Advances 16 Balance Due To Employee (Press Next Page to Continue)17 Balance Due From Employee18 19 20 21 22 23 Tue 09-Feb-88 11:41 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T %  %%%%2am 8d JHPN  +NO CHANGE!+8NCalculatingWithFormulasP1If a formula begins with a cell reference,then the formula must start with a plus sign.+ a1+a2+b2 - c41 P 2am d JHPN  :NO CHANGE!+ NCalculatingWithFormulasP+An operand can also be another formula.The formula is enclosed in parentheses.(200 + 5) - 100+b3 / (a1 * a2)+ Pp2am 7g JHPN  >NO CHANGE!+7Ng15 +g13-g12 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3 =ses 4 Air, =450 5 Renta/135 6 Daily 7 MealsThe nice advantage of a formula is that  8 Enter 9 you don't have to perform any calculations, 10  11  whether simple or complicated. 12 Total 13 Less Just create the formula and200 14 Balan200 15 Balanlet Solution Designerdo the rest.200 16  17 / 18 = 19 = 20N 21N 22N 23N Wed 17-Feb-88 9:38 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph KTLL/////////+LLL2am f JHPN   NO CHANGE!+NTg15 +g13-g12 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3 >ses 4 Air,>450 5 Rent0135 6 Dail 7 MealAnd, the use of cell references in a formula 8 Ente 9 gives you the flexibility to modify 10  11 cell values with ease. 12 Tota 13 Less0200 14 Bala>200 15 Bala>200 16N 1 7N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:38 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph KTLL0000000,LLLLLLL2am 9f JHPN   7NO CHANGE!+Na1 READYP  a b c d e f g h i1O 2 3 (4 5 Enter a formula in the same way that6 7 you would enter labels and values.8 9 (10 11 12 &13 14 Enter the formula,27+34.15 16 &17 18 19 20 21 22 23 Wed 17-Feb-88 3:44 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ] NO CHANGE!Na1 VALUE2J  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 Wed 17-Feb-88 3:46 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]p }NO CHANGE!Na1 VALUE27J  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 Wed 17-Feb-88 3:46 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]- :NO CHANGE!LN a1 VALUE27+J  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 Wed 17-Feb-88 3:46 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  NO CHANGE! N a1 VALUE27+3J  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 Wed 17-Feb-88 3:46 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]  NO CHANGE! N a1 VALUE27+34K  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 Wed 17-Feb-88 3:46 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]h u NO CHANGE! Na1 27+34READYP  a b c d e f g h i1 61D 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12 N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 3:46 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]- 9:NO CHANGE!LN%a1 27+34READY 1  a b c  d e f g h i1 61 1 2  (3 4 The result is displayed in the worksheet, although5 6 the cell itself contains the actual formula.7 8 69 10 11 12 (13 14 Move the cell pointer down once.15 16 (17 18 19 20 21 22 23 Wed 17-Feb-88 3:46 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]66666(((/ <NO CHANGE!NN a2 READYP  a b c d e f g h i1 61D 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 3:46 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE!+Na2 READYP  a b c d e f g h i1 61D 2O 3 4 5 6 -7 8 9 Type in another formula,81/9-3.10 11 12 -13 14  15 16 17 18 19 20 21 22 23 Wed 17-Feb-88 3:46 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 9 FNO CHANGE!XN*a2 VALUE8 81/9-3  a b c d e f g h i1 61D 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 3:47 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T  *NO CHANGE!<N.a2 VALUE81 81/9-38  a b c d e f g h i1 61D 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 3:47 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T  NO CHANGE!$N/a2 VALUE81/ 81/9-38  a b c d e f g h i1 61D 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 3:47 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T  NO CHANGE! N0a2 VALUE81/9 81/9-38  a b c d e f g h i1 61D 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 3:47 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T  NO CHANGE!N 1a2 VALUE81/9- 81/9-38  a b c d e f g h i1 61D 2O 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 3:47 PM; Macro  Edit  Name Abs   Go To  Window Query Table  Calc  Graph  T  NO CHANGE!|Na2 VALUE81/9-3I  a b c d e f g h i1 61D 2O 3 !4 5 And to enter the formula,6 7 8 press theDown Arrow9 10 11 instead of Return.12 13 14 !15 16 17 18 19 20 21 22 23 Wed 17-Feb-88 3:47 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   ^" k"NO CHANGE!}"Na3 READYP  a b c d e f g h i1 61D 2 6D 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 3:47 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T "$  )/$NO CHANGE!A$Na3 READYP  a b ' h i1 61  2 6 The result is displayed, but again,  3  4 remember that the cell contains the5  6 actual formula.7 8 (Press Next Page to continue.)9 10 '11 12 13 14 15 16 17 18 19 20 21 22 23 Wed 17-Feb-88 3:47 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph '' ''''''&  'NO CHANGE!'9Na3 VALUEP  a b c d e f g h i1 61 2 6 3 4 5 A6 7 Now, subtract 6 from 61, or 61 - 6. To do this, use cell8 9 references in your formula, in other words, a1 - a2.10 11 Remember that since the formula begins with a cell reference,12 13 you must first type a plus sign.14 15 A16 17 18 (19 20 Do that right now. Type +.21 22 (23 Wed 17-Feb-88 3:47 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  O* \*NO CHANGE!n*Na3 VALUE+O  a b c d e f g h i1 61D 2 6D 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 3:47 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T , !,NO CHANGE!3,~Na3 VALUE+N  a b c d e f g h i1 61D 2 6D 3O 4O 5O 6  7 3 8 3  9  Now, the formula you want to enter is a1 - a2.  10 3 11 3 12N 13 = 14 =  15  Use the Up Arrow to move the cell pointer to cell a1. 16 =  17 = 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 3:47 PM; Macro  Edit  Name Abs  Go To  Window Query T able  Calc  Graph T ===. .NO CHANGE!.Na2 81/9-3POINT+a2M  a b c d e f g h i1 61D 2 6D 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 3:47 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ~0 O0NO CHANGE!0NGa1 27+34 POINT+a1 (  a b c d e f g h i1 61 2 6 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23N Wed 17-Feb-88 3:48 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]z2  2NO CHANGE!2Na1 27+34 POINT+a1 "(  a b c d  e f g h i1 61 2 6 3  4 ( 5 Cell a1 is included in your formula. 6 (  7 ( 8O 9O 10 , 11 !   12  Now, type in the minus sign, - .  13 !   14 , 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 3:48 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ](((C5 P5NO CHANGE!b5Na3 VALUE+a1-L  a b c d e f g h i1 61D 2 6D 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 3:48 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  7 7NO CHANGE!*7\Na3 VALUE+a1-K  a b c d e f g h i1 61D 2 6D 3O 4 5 .6 7 You want to subtract cell a2 from cell a1.8 9 .10 11 -12 13 Move your cell pointer up to cell a2.14 15 -16 17 18 19 20 21 22 23 Wed 17-Feb-88 3:48 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T %9 9NO CHANGE!9Na2 81/9-3POINT+a1-a2J  a b c d e f g h i1 61D 2 6D 3O 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 3:48 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T V;  c;NO CHANGE!u;Na2 81/9-3POINT+a1-a2 (  a b c d  e f g h i1 61 ( 2 6 3 4 Your formula is complete: + a1 - a25 6 (7 8 9 10 *11 12 Press Return to enter the formula.13 14 *15 16 17 18 19 20 21 22 23 Wed 17-Feb-88 3:48 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T (((*** =   >NO CHANGE!>Na3 +a1-a2READY a b c d e f g h i1 61D 2 6D 3 55D 4O 5O 6O 7O 8O 9O 10N 11N 12N 13N 14N 15N 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 3:50 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ? (?NO CHANGE!?UNa3 +a1-a2READY a b c d e f g h i1 61  2 6  3 55 And the result is displayed.  4 5 6 7 8 9 10 11 12 13 14 15 Press Next Page to continue16 17 18 19 20 21 22 23 Wed 17-Feb-88 3:50 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T    %%%2 2 7 ~ The formula you are currently entering is ~ ~~ ~ 27+34 ~ ~~ ~ Dismiss this message and type '7' ... ~ 7 + ~ The formula you are currently entering is ~ ~~ ~ 27+34 ~ ~~ ~ Dismiss this message and type '+' ... ~ ShiftRight Equal 3 ~ The formula you are currently entering is ~ ~~ ~ 27+34 ~ ~~ ~ Dismiss this message and type '3' ... ~ 3 4 4 0x0A ~ You just finished typing in your formula. ~ ~~ ~ To enter it into your worksheet, ~ ~~ ~ dismiss this message and press Return. ~ time DownArrow time 8 8 1 ~ The formula you are currently entering in is ~ ~~ ~ 81/9-3 ~ ~~ ~ Dismiss this message and type '1' ... ~ 1 / ~ The formula you are currently entering in is ~ ~~ ~ 81/9-3 ~ ~~ ~  Dismiss this message and type '/' ... ~ Slash 9 ~ The formula you are currently entering in is ~ ~~ ~ 81/9-3 ~ ~~ ~ Dismiss this message and type '9' ... ~ 9 - Hyphen 3 3 ~ You just finished typing in the formula. ~ ~~ ~ To enter it into your worksheet, ~ ~~ ~ dismiss this message and press Return. ~ time 0x0C + ShiftRight Equal time  UpArrow  ~ You want to move the cell pointer to cell a1. ~ ~~ ~~ ~~ ~ Dismiss this message and press Up Arrow. ~ UpArrow time - Hyphen time  UpArrow time 0x0A Return time time2am g JHPN   NO CHANGE!+INg3 'ExpensesREADY a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9 10 11 "12 Total Expenses 13 Less Advances Good! Now to enter a formula.14 Balance Due To Employee 15 Balance Due From Employee"16 17  ,18 19 Move the cell pointer down one cell.20 21 ,22 23 Tue 16-Feb-88 10:08 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ,,,t NO CHANGE!Ng4 VALUE a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:25 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ' 24NO CHANGE!F NDg4 VALUE a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodgin5 7 Meals  8 Entertainmen Total the Air, rail, bus expense. Although there 9 10 is only one value, in cell d4, you should create11 12 Total Expensa formula that includes cells e4 and f4 since13 Less Advance 14 Balance Due you may want to enter more values later on.15 Balance Due 16 517 +18 19 Your formula will start with a cell20  21  reference, so what do you do first?22  23 +Tue 16-Feb-88 10:25 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T +++++S ` NO CHANGE!r Ng4 VALUE+ a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:25 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!%N6g4 VALUE+ a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 3 8 Entertainment   9 That's right. Type the plus sign. Now, create10 11 a formula that adds up the Air, rail, bus 12 Total Expenses 13 Less Advances expenses. The formula should look like this:14 Balance Due To E 15 Balance Due From +f4+e4+d4.16  17 318 )19 20 To include f4 in your formula,21 22 move the cell pointer to cell f4.23 Tue 16-Feb-88 10:25 PM ) Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ))))) !NO CHANGE!3Nf4 POINT+f4 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7  Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:26 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NNO CHANGE!fNf4 'POINT+f4  Cell f4 is included in the formula. ' ' a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9 10 11 '12 Total Expenses 13 Less Advances Since you're adding the values,14 Balance Due To Employee 15 Balance Due From Employeetype the plus sign again.16 17 '18 19 20 21 22 23 Tue 16-Feb-88 10:26 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 'T ''''N [NO CHANGE!mNg4 VALUE+f4+ a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:30 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!#Ng4 VALUE+f4+ a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45  6 Daily lodging 89 89 89  7 Meals !  8 Entertainment   9 Notice that the cell pointer10 11 returns to the original cell.12 Total Expenses 13 Less Advances !14 Balance Due To Employee 15 Balance Due From Employee&16 17 Use the Left Arrow to move the18 19 cell pointer to cell e4.20 21 &22 23 Tue 16-Feb-88 10:30 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T !!!!!&&&&& NO CHANGE!Nf4 POINT+f4+f4 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T " "NO CHANGE!"Ne4 POINT+f4+e4 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Empl  oyee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T H% U%NO CHANGE!g%0Ne4 +POINT+f4+e4  Cell e4 is now included in the formula. + a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10!  11!  12 Total Expenses  Type another plus sign.  13 Less Advances  14 Balance Due To Employee  15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph +T ( (NO CHANGE!(Ng4 VALUE+f4+e4+ a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:32 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T P+ ]+NO CHANGE!o+Ng4 VALUE+f4+e4+ a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10$ & 11$ & 12 Total Expenses You have one more cell to include 13 Less Advances & 14 Balance Due To Employee in your formula. That is cell d4. 15 Balance Due From Employee & 16$ & 17! $ 18! $  19!  Use the Left Arrow once more20! $  21!  to move to cell d4.  22! $  23! $ Tue 16-Feb-88 10:32 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T $$$$$/  /NO CHANGE!2/Nf4 POINT+f4+e4+f4 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:32 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 1 1NO CHANGE!1Ne4 POINT+f4+e4+e4 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:32 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph   T 4 4NO CHANGE!4N d4 [W12] 450POINT+f4+e4+d4 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:32 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T M7  MZ7NO CHANGE!l7ZNd4 [W12] 450!POINT+f4+e4+d4 ! - Your formula is now complete.  a b c g h1 EXPENSE REPORT ! 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9 10 11 *12 Total Expenses 13 Less Advances Press Return to enter the formula.14 Balance Due To Employee 15 Balance Due From Employee*16 17 18 19 20 21 22 23 Tue 16-Feb-88 10:32 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph !!! ***:  M:NO CHANGE!:Ng4 +f4+e4+d4READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:37 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T = 9=NO CHANGE!=Ng4 +f4+e4+d4READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9 "10 11 That wasn't so bad, was it?12 Total Expenses 13 Less Advances Go ahead and add the same type14 Balance Due To Employee 15 Balance Due From Employeeof formula for the Rental car16 17 expense values.18 19 "20 (21 22 Move the cell pointer down once.23 Tue 16-Feb-88 10:37 PM ( Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  (((iA "vANO CHANGE!ANg5 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:38 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ! !D =.DNO CHANGE!@DNg5 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9 -10 11 I'll let you do this formula on your own.12 Total Expenses 13 Less Advances Use the Left Arrow and the plus sign to14 Balance Due To Employe15 Balance Due From Emplocreate the formula, +f5+e5+d5.16 17 Remember to press Help if you need it.18 19 -20 $21 22 Start whenever you're ready.23 Tue 16-Feb-88 10:38 PM $ Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   $$$H #HNO CHANGE!5HNg5 VALUE+ a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:38 PM; Macro  Edit   Name Abs  Go To  Window Query Table  Calc  Graph T J JNO CHANGE!JN f5 [W12] 45 POINT+f5 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:38 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T M MNO CHANGE!MNg5 VALUE+f5+ a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:39 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T OP \PNO CHANGE!nPN f5 [W12] 45 POINT+f5+f5 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:39 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T S #SNO CHANGE!5SN e5 [W12] 45 POINT+f5+e5 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 6 Daily lodging!  89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:39 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T U UNO CHANGE!UNg5 VALUE+f5+e5+ a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:39 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T X XNO CHANGE!XNf5 [W12] 45 POINT+f5+e5+f5 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:40 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T f[ s[NO CHANGE![Ne5 [W12] 45 POINT+f5+e5+e5 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:40 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 0^ =^NO CHANGE!O^Nd5 [W12] 45 POINT+f5+e5+d5 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:40 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ` DaNO CHANGE!aN g5 +f5+e5+d5READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:40 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T c 2cNO CHANGE!cNTg5 +f5+e5+d5READY"  a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9 10 11 12 Total Expenses 13 Less Advances 14 Balance Due To Employee Excellent!15 Balance Due From Employee16 17 Press Next Page to continue18 19 20 21 22 23 Tue 16-Feb-88 10:40 PM Macro  Edit   Name Abs  Go To  Window Query Table  Calc  Graph T %  %%%% DownArrow time + ~ Since your formula starts with a cell reference, ~ ~~ ~ you must first type a plus sign. ~ ~~ ~ Dismiss this message and type '+'. ~ ShiftRight Equal time  ~ Use the Left Arrow to move to cell f4.  ~ ~~ ~~ ~~ ~ Dismiss this messagea and press Left Arrow. ~ LeftArrow time + ~ Since you are doing addition, ~ ~~ ~ you must enter a plus sign. ~ ~~ ~ Dismiss this message and type '+'. ~ Shi%%2am Sg JHPN  NO CHANGE!+NKModifying an Existingorksheet On tis lsson,yo wilea owtochane eisting laes in yoworksheetchan eisti values in your worksheeterase information in your worksheetchange column widthremove rows and colmnsinsertrows and omns O!        NO CHANGE!NcModifying anExingorsheetOn tilsso,yo ilea oochneising laes n oworkheetchaneisti value n yourworkheeterase information in your worksheetchange column widthremov ows nd colinertrws an oms O "      NO CHANGE!SNCodfyinExingrsheOn issoyol ochnein les noorhetcaeisti value nourworkheeteseinforaion in yur worksheethange column widthremo ws nd linrts an osO    )  6 NO CHANGE!H NoiEingrPn iso cheile noretai vau nourwokhsforio iyur orkeethag clun widthmows nd inrts an osP  ONO CHANGE!'Npoi`oouokhoi iueaunsdnr os` ONO CHANGE!eN2uh%uns$- O:NO CHANGE!LN  a OnNO CHANGE!=N-change a couple of labels.  NO CHANGE!zNjThe first thing you're going to do ischange a couple of labels. V OcNO CHANGE!uNThe first thing you're going to do ischange a couple of labels.  NO CHANGE!&N" " The first thing you're going to do ischange a couple of labels.M  ONO CHANGE!&Na1 READY a b c d e f g h i1O 2 3 )4 5 The first thing you're going to do is6 7 change a couple of labels.8 9 )10 11 12 13 14 15 16 17 18 19 20  21 22 23 Mon 08-Feb-88 12:29 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]# ftRight Equal time  LeftArrow  LeftArrow time + ShiftRight Equal time  LeftArrow  ~ You are currently moving the cell pointer ~ ~~ ~ to cell d4. ~ ~~ ~ Dismiss this message and press Left Arrow. ~ LeftArrow  ~ You are currently moving the cell pointer ~ ~~ ~ to cell d4. ~ ~~ ~ Dismiss this message and press Left Arrow. ~ LeftArrow time 0x0A Return time DownArrow time + ~Since your formula begins with a cell reference, ~ ~ you must first type the plus sign. ~ ~~ ~~ ~ Dismiss this message and type '+'. ~ ShiftRight Equal  ~ Your formula should look like +f5+e5+d5. ~ ~  ~ ~ Use the Left Arrow to include cell f5 in your ~ ~ formula. ~ ~ Dismiss this message and press Left Arrow. ~ LeftArrow + ~ You are currently creating the formula ~ ~~ ~  +f5+e5+d5 ~ ~~ ~ Dismiss this message and type '+' . ~ ShiftRight Equal  ~ You are currently creating the formula ~ ~ +f5+e5+d5 ~ ~  ~ ~ Dismiss this message and press Left Arrow ~ ~ until you reach cell e5. ~ LeftArrow  LeftArrow + ~ You are currently creating the formula ~ ~~ ~ +f5+e5+d5 ~ ~~ ~ Dismiss this message and type '+'. ~ ShiftRight Equal  ~ You are currently creating the formula ~ ~ +f5+e5+d5 ~ ~ ~ ~ Dismiss this message and press Left Arrow ~ ~ until you reach cell d5. ~ LeftArrow  LeftArrow  LeftArrow 0x0A ~ Finally, enter the formula. ~ ~~ ~~ ~~ ~ Dismiss this message and press Return. ~ Return time timeN]a1 MENU Enter filename of new spreadsheet: *.wk?( ExpenseReport.wkt 2 a b c d e f g h i1O 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Tue 09-Feb-88 11:14 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]   NO CHANGE! Nd10 [W9] 75 READY a b c d e f g h i1 EXPENSE REPORT> 21 31 41 51 6 Air, rail, bus 450 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75 11 12 13 14 Total Expenses 15 Less Advances 16 Bal Due To Emp 17 Bal Due From Emp18 19 20 21 22 23 Tue 09-Feb-88 11:18 AM Macro  Edit  Name Abs  Go To  Window Q# uery Table  Calc  Graph T  NO CHANGE!N%d10 [W9] 75 READY a b c d e f g h i1 EXPENSE REPORT> 2 6 3  4 Good job. Now let's get to work. You decide that 5 4 6 Air, rail, bus the two labels, "Bal Due To Emp" and "Bal Due From 7 Rental car 8 Daily lodging Emp", would look better if they were spelled out. 9 Meals 10 Entertainment Well, let's change those labels.11 12 /13 14 Total Expenses #15 Less Advances 16 Bal Due To Emp Press Next Page to Continue17 Bal Due From Emp18 #19 20 21 22 23 Tue 09-Feb-88 11:18 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T### ONO CHANGE!wNd10 [W9] 75 READY a b c d e f g h i1 EXPENSE REPORT> 21 31 41 51 6 Air, rail, bus 450 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75 11 12 /13 14 Total Expenses Your cell pointer is currently at cell d10.15 Less Advances 16 Bal Due To Emp /17 Bal Due From Emp+18 19 Use the Go To function (F5) to move20 21 the cell pointer cell to a16.22 23 +Tue 09-Feb-88 11:18 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T +++++. 7;NO CHANGE!MNGd10 [W9] 75 POINTEnter address to go to: d10 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances Go to cell a16.16 Bal Due To Emp 17 Bal Due From Emp 18 19 20 21 22 23 Tue 09-Feb-88 11:19 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 4 ANO CHANGE!SNd10 [W9] 75 EDIT Enter address to go to: a3 W a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:19 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE! Nd10 [W9] 75 EDIT Enter address to go to: a13 W a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:19 AM; Macro  Edit  Name Abs  Go To  Window Query T$ able  Calc  Graph T  NO CHANGE!Nd10 [W9] 75 EDIT Enter address to go to: a16 a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances 16 Bal Due To Emp 17 Bal Due From Emp 18 19 20 21 22 23 Tue 09-Feb-88 11:19 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T |! <!NO CHANGE!!Na16 ' Bal Due To Emp READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 '12 13 Good. Now change "Bal Due to Emp".14 Total Expenses 15 Less Advances '16 Bal Due To Emp 017 Bal Due From Emp 18 To do this, simply type in the new label19 20 21 Balance Due To Employee.22 23 Tue 09-Feb-88 11:20 AM 0 Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ($'% 4%NO CHANGE!F%Na16 ' Bal Due To Emp LABEL B a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ' 'NO CHANGE!'Na16 ' Bal Due To Emp LABEL Ba a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T t* *NO CHANGE!*Na16 ' Bal Due To Emp LABEL Bal a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T - )-NO CHANGE!;-Na16 ' Bal Due To Emp LABEL Bala a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lo$ dging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T / /NO CHANGE!/Na16 ' Bal Due To Emp LABEL Balan a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T o2 |2NO CHANGE!2Na16 ' Bal Due To Emp LABEL Balanc a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 5  '5NO CHANGE!95Na16 ' Bal Due To Emp LABEL Balance a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 7  7NO CHANGE!7Na16 ' Bal Due To Emp LABEL Balance a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T s:  :NO CHANGE!:Na16 ' Bal Due To Emp LABEL Balance D a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T !=  .=NO CHANGE!@=Na16 ' Bal Due To Emp LABEL Balance Du a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8%  Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ?  ?NO CHANGE!?Na16 ' Bal Due To Emp LABEL Balance Due a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T B BNO CHANGE!BNa16 ' Bal Due To Emp LABEL Balance Due a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 1E >ENO CHANGE!PENa16 ' Bal Due To Emp LABEL Balance Due T a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T G GNO CHANGE!HNa16 ' Bal Due To Emp LABEL Balance Due To a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T J JNO CHANGE!JNa16 ' Bal Due To Emp LABEL Balance Due To a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T JM WMNO CHANGE!iMNa16 ' Bal Due To Emp LABEL Balance Due To E a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail% , bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T O  PNO CHANGE!PNa16 ' Bal Due To Emp LABEL Balance Due To Em a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T R RNO CHANGE!RNa16 ' Bal Due To Emp LABEL  Balance Due To Emp a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T lU yUNO CHANGE!UNa16 ' Bal Due To Emp LABEL Balance Due To Empl a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T $X 1XNO CHANGE!CXNa16 ' Bal Due To Emp LABEL Balance Due To Emplo a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AMfileHeaders.sysmfd.syslog.sys sysImage.sys badBlk.sys crashDump.sysOCID0`?& &SD-4monetcOf*g ECysSD 9|M^SysSD 9{fileHeaders.sys Sys3cfcfcfemfd.sys Sys3efefvflog.sysSysgfgfgfU= sysImage.sysSysjfjfjf badBlk.sysSyslflflf& x crashDump.sysSysnfnfnfeBusing>modify>mc2.f5incorrectsd* f, f, fNBxusing>modify>mc2.correctsd' f) f) fH using>modify>fib1 sd3 f f fB using>modify>mc3.f001.path sd 3fSg_"gQ Y using>modify>FIB2 sd 3f fcgV using>modify>FIB2.a000 sd 3f fQf~ Using>Modify>FIB2.A000.Path sd 3f fQfN' using>modify>FIB2.a999 sd3f fhg"Using>Modify>FIB2.answers sd3f ffg(&kusing>modify>fib2.common.path sd3f f{g*ȍusing>modify>FIB8 sd3f fg.using>modify>FIB8.a000 sd3ff^f4Using>Modify>FIB8.A000.Path sd3ffifN8Eusing>modify>FIB8.a002 sd3ffzfD<NUsing>Modify>FIB8.A002.Path sd3ffzfN@' 8using>modify>FIB8.a999 sd3fƁfgD@Using>Modify>FIB8.A999.Path sd3ffgNHUsing>Modify>FIB8.answers sd3ffgBL6Using>Modify>FIB8.common.path sd3ffgmPcalc>formla>def.10 sd30f4fg^d calc>formla>def.1 sd3*f.fgu` }using>modify>initial.path sd3 f& f^gpJcalc>formla>fib3.a002 sd3 foSgoSgO:( lusing>modify>text-oldsdŞfОfОfХb$ *hjtp @nFJZ<88$ using>modify>i.3 sd3f*g*gHp using>modify>i.1 sd 3f*g*g jp@FJт!using>modify>MC3 sd!3(fSgJ"g;4"Using>Modify>MC3.common.path sd"3-fSg"g"#using>modify>MC3.correct sd#33fSgz"gV+$calc>formla>FIB3.A002.Path sd$3 ftSgtSgL>%Using>Modify>MC3.F002.Path sd%3>fSg"gQ(  &Using>Modify>MC3.F003.Path sd&3BfSge"gQ9'Using>Modify>MC3.F004.Path sd'3GfSg0"gO(Using>Modify>MC3.F005.Path sd(3MfSg"gS)using>modify>MC3.f5incorrect sd)3SfSg5"g*using>modify>MC3.incorrect sd*3XfSg"g+Using>Modify>MC3.legend sd+3^fSgO"g;,using>modify>MC5 sd,3dfSg"g&-Using>Modify>MC5.common.path sd-3jfSg"g") .using>modify>MC5.correct sd.3ofSg"g/Using>Modify>MC5.F001.Path sd/3ufSgU"gS 0Using>Modify>MC5.F002.Path sd03{fSg"gS1Using>Modify>MC5.F003.Path sd13fSgj"gO2Using>Modify>MC5.F004.Path sd23fSg:"gQc3using>modify>MC5.f1incorrect sd33fSg?"gA4using>modify>MC5.f2incorrect sd43fSg"gH5using>modify>MC5.incorrect sd53fSg "g) =6using>modify>MC5.legend sd63fSg"g4D7using>modify>MC7 sd73f Tg"g*8Using>Modify>MC7.common.path sd83fSg"g#ti9using>modify>MC7.correct sd93f*g*g:Using>Modify>MC7.F001.Path sd:3fTgZ"gQ;Using>Modify>MC7.F002.Path sd;3fTg%"gQ<Using>Modify>MC7.F003.Path sd<3fSgu"gQ =Using>Modify>MC7.F004.Path sd=3fTgE"gO* r>Using>Modify>MC7.F005.Path sd>3fTg"gSX(?using>modify>MC7.f5incorrect sd?3f*g*g9A@using>modify>MC7.incorrect sd@3f*g*g`AUsing>Modify>MC7.legend sdA3fSg*"g;$ѶBusing>modify>Nos sdB3f~gqgL{(xxCusing>modify>Nos.pedal sdC3f~gqgO @ )Dusing>modify>qseg1 sdD3ffsgEusing>modify>qseg2 sdE3ffg* ^Fusing>modify>RC sdF3f1fgGusing>modify>RC.pedal sdG3f1fgDJ_Husing>modify>rev.1 sdH3fQ fgEHQ}Iusing>modify>rev.2 sdI3fS fgN>}Jusing>modify>rev.3 sdJ3 fV fgRvKusing>modify>Text sdK3fSgUgBXLusing>modify>Text.pedal sdL3fSgUgFMusing>modify>TF1 sdM3ff[g+  Nusing>modify>TF1.common.path sdN3$fa fgg#%Ousing>modify>TF1.F001.Path sdO3)f,fagLnPusing>modify>TF1.F002.Path sdP3.f2ffM"Qusing>modify>TF1.false sdQ33fffk&* Rusing>modify>TF1.legend sdR39f<fZg*,Susing>modify>TF1.true sdS3>ff`ga0RTusing>modify>TF4 sdT3Df fge6sUusing>modify>tf4.common.path sdU3IfLfg:+ 5VUsing>Modify>TF4.F001.Path sdV3NfQfgL>b3WUsing>Modify>TF4.F002.Path sdW3SfWffMB"Xusing>modify>TF4.false sdX3XfffF;YUsing>Modify>TF4.legend sdY3^fafg*LZusing>modify>TF4.true sdZ3cffgP[calc>formla>i.5 sd[3~f fg K \calc>formla>i.2 sd\3jf fg ]calc>formla>def.9 sd]3afdfg} , -^calc>formla>i.4 sd^3wf fg6o_calc>formla>i.3 sd_3qf fg I`calc>formla>i.1 sd`3ef fg tn$acalc>formla>def.8 sda3[f_fg5  busing>modify>i.2 sdb3f*g*gV@nFJ%^ccalc>formla>i.8 sdc3f fgXNdcalc>formla>i.7 sdd3f fg)T ecalc>formla>i.6 sde3f fg, Tfcalc>formla>E.1 sdf3ffrgbgcalc>formla>E.2 sdg3ffpg9hcalc>formla>Ent1 sdh3ffg?BFB icalc>formla>Ent1.pedal sdi3ffg}lLjcalc>formla>Ent2 sdj3f<formla>Ent2.pedal sdk3f?formla>Ent3 sdl3f^Sgg8p0mcalc>formla>Ent3.pedal sdm3faSgg0jt- ncalc>formla>FIB3 sdn3fjSg|g2Mocalc>formla>FIB3.a000 sdo3flSglSgD6pcalc>formla>FIB3.A000.Path sdp3fvSgvSgL:\qcalc>formla>FIB3.a999 sdq3ffSgzgR>rcalc>formla>FIB3.A999.Path sdr3fcSgzgLBlscalc>formla>FIB3.answers sds3fhSg}g`Ftcalc>formla>FIB3.common.path sdt3fqSgxg"J7gucalc>formla>FIB4 sdu3fSgwgN- {Kvcalc>formla>FIB4.a000 sdv3fSgSgDR}wcalc>formla>FIB4.A000.Path sdw3fSgSgLVq%xcalc>formla>FIB4.a999 sdx3fSgtgZycalc>formla>FIB4.A999.Path sdy3fSgtgL^Tyzcalc>formla>FIB4.answers sdz3 fSgwgFb{calc>formla>fib4.common.path sd{3fSgrgf|calc>formla>def.7 sd|3VfYfgc '}calc>formla>def.6 sd}3RfTfgO~ . 5~calc>formla>def.5 sd~3LfPfgTz DMcalc>formla>def.4 sd3GfJfgv Scalc>formla>def.3 sd3AfEfgar (9calc>formla>def.11 sd3:f>fgn qqcalc>formla>def.2 sd36f9fgtj calc>formla>initial.path sd3;f f g8calc>formla>mc1 sd3@fSgd!g)calc>formla>MC1.common.path sd3Ff f!g!. ꢆcalc>formla>mc1.correct sd3LfSg!gˇcalc>formla>MC1.F001.Path sd3Rf f!gMcalc>formla>MC1.F002.Path sd3Xf f!gOʼncalc>formla>MC1.F003.Path sd3\f f!gOʊcalc>formla>MC1.F004.Path sd3af f~!gOcalc>formla>MC1.F005.Path sd3hf f!gOƌcalc>formla>MC1.F006.Path sd3of f!gOZcalc>formla>mc1.incorrect sd3tfSgi!g/ calc>formla>MC1.legend sd3wf f!gB ccalc>formla>mc2 sd3}f*g*gbcalc>formla>mc2.common.path sd3f f!go>֑calc>formla>mc2.correct sd3fSg!g(calc>formla>mc2.F001.Path sd3f f!gOGcalc>formla>mc2.F002.Path sd3f fy!gMcalc>formla>mc2.F003.Path sd3f f!gO!calc>formla>mc2.F004.Path sd3f f!gO/ `calc>formla>mc2.incorrect sd3fSgo!gޗcalc>formla>mc2.legend sd3f f!g4Acalc>formla>rev.1 sd3f fogScalc>formla>rev.2 sd3f f f=Ścalc>formla>rev.3 sd3f f f&Λcalc>formla>Seg1 sd3ffgh2calc>formla>Seg2.1 sd3ff6g۝calc>formla>Seg2.2 sd3ff9g5 0 calc>formla>Seg2.3 sd3ff@gp#Ucalc>formla>Seg3.1 sd3ffKgecalc>formla>Seg3.2 sd3ffNgFcalc>formla>Seg3.3 sd3ffOg"wOCIDsys=fFfg(գcalc>formla>qseg1 sd3Üfǜf}gdcalc>formla>text sd3FfLformla>text.pedal sd3JfIModify>FIB2.A999.Path etsd3Kf figNusing>modify>mc2.incorrectsd- f/ f/ f`T#using>modify>mc2sd0 f2 f2 fZѩЪϫάͭ1 ̮˯ʰɱȲdzƴŵ1 Ķ÷¸~}|2 {zyxwvut2 srqponml3 kjihgfed3 cba`_^]\4 [ZYXWVUT4 SR{using>modify>MC3.incorrect*using>modify>MC5.f2incorrect4using>modify>MC5.incorrect5Using>Modify>MC7.common.path8using>modify>MC7.incorrect@using>modify>rev.3Jusing>modify>TF1.F001.PathOUsing>Modify>TF4.F001.PathVcalc>formla>mc1calc>formla>mc1.incorrectcalc>formla>mc2.incorrectcalc>formla>def.6}calc>formla>i.8cusing>modify>FIB2.a000 using>modify>FIB2.a999Using>Modify>FIB2.answersusing>modify>FIB8Using>Modify>FIB8.common.pathusing>modify>MC5.correct.Using>Modify>MC5.F002.Path0Using>Modify>MC7.F002.Path;Using>Modify>MC7.legendAusing>modify>qseg1Dusing>modify>TF4.falseXcalc>formla>FIB3.A000.Pathpcalc>formla>FIB4.a000vcalc>formla>FIB4.A000.Pathwcalc>formla>mc2calc>formla>mc2.F002.Pathcalc>formla>Seg2.1Using>Modify>FIB2.A999.Pathcalc>formla>def.7|Using>Modify>MC3.F004.Path'using>modify>MC3.f5incorrect)Using>Modify>MC5.F004.Path2using>modify>MC5.f1incorrect3Using>Modify>MC7.F004.Path=using>modify>Nos.pedalCusing>modify>qseg2Eusing>modify>TextKcalc>formla>Ent1.pedalicalc>formla>FIB3ncalc>formla>MC1.F004.Pathcalc>formla>MC1.legendcalc>formla>mc2.common.pathcalc>formla>mc2.F004.Pathcalc>formla>rev.1calc>formla>Seg2.2calc>formla>Seg3.1calc>formla>def.8acalc>formla>i.1`calc>formla>FIB3.A002.Path$Using>Modify>FIB8.A999.Pathusing>modify>RC.pedalGcalc>formla>Ent1hcalc>formla>Ent3.pedalmcalc>formla>FIB3.answersscalc>formla>FIB4ucalc>formla>FIB4.a999xcalc>formla>MC1.F006.Pathcalc>formla>rev.2calc>formla>Seg2.3calc>formla>Seg3.2calc>formla>qseg1calc>formla>def.9]calc>formla>i.2\using>modify>FIB2 Using>Modify>FIB2.A000.Path using>modify>FIB8.a000using>modify>MC3!Using>Modify>MC3.legend+Using>Modify>MC5.F001.Path/Using>Modify>MC7.F001.Path:using>modify>NosBusing>modify>TF1.F002.PathPusing>modify>TF1.falseQusing>modify>TF1.legendRcalc>formla>Ent2jcalc>formla>FIB3.a000ocalc>formla>mc1.correctcalc>formla>MC1.F001.Pathcalc>formla>mc2.legendusing>modify>mc3.f001.path calc>formla>def.1calc>formla>i.3_using>modify>i.1 endrmla>mc2.legendusing>modify>fib2.common.pathUsing>Modify>MC3.F003.Path&Using>Modify>MC5.F003.Path1using>modify>MC7.correct9Using>Modify>MC7.F003.Path<using>modify>Text.pedalLusing>modify>TF1Musing>modify>tf4.common.pathUcalc>formla>Ent3lcalc>formla>fib4.common.path{calc>formla>MC1.F003.Pathcalc>formla>mc2.F001.Pathcalc>formla>mc2.F003.Pathcalc>formla>rev.3calc>formla>Seg3.3calc>formla>text.pedalcalc>formla>def.2calc>formla>i.4^using>modify>i.2bg>modify>mc2.correct5 Using>Modify>FIB8.A000.Pathusing>modify>FIB8.a002using>modify>FIB8.a999Using>Modify>FIB8.answersusing>modify>MC3.correct#Using>Modify>MC3.F005.Path(using>modify>MC5,using>modify>MC7.f5incorrect?using>modify>TF1.common.pathNUsing>Modify>TF4.F002.PathWusing>modify>TF4.trueZcalc>formla>FIB3.a999qcalc>formla>FIB4.answerszcalc>formla>initial.pathcalc>formla>def.3calc>formla>i.5[using>modify>i.3calc>formla>fib3.a002orrectUsing>Modify>FIB8.A002.Pathusing>modify>initial.pathUsing>Modify>MC3.common.path"using>modify>rev.1Hcalc>formla>E.1fcalc>formla>Ent2.pedalkcalc>formla>FIB3.A999.Pathrcalc>formla>FIB3.common.pathtcalc>formla>FIB4.A999.Pathycalc>formla>MC1.common.pathcalc>formla>MC1.F005.Pathcalc>formla>mc2.correctcalc>formla>Seg1calc>formla>def.10calc>formla>def.4calc>formla>i.6eUsing>Modify>MC3.F002.Path%Using>Modify>MC5.common.path-using>modify>MC5.legend6using>modify>MC77Using>Modify>MC7.F005.Path>using>modify>RCFusing>modify>rev.2Iusing>modify>TF1.trueSusing>modify>TF4TUsing>Modify>TF4.legendYcalc>formla>E.2gcalc>formla>MC1.F002.Pathcalc>formla>textcalc>formla>def.11calc>formla>def.5~calc>formla>i.7d2am Dg JHPN   %NO CHANGE!+Ng5 +f5+e5+d5 READYW a b c d e f g h1 EXPENSE REPORT> 2B Total 3 ! Expenses 4 Air, 450 5 RentThe first thing to do is 45 45 135 6 Dail 89 89 7 Mealenter your Travel Advance, 25 25 8 Ente 75 9 which should go in cell, g13.10 11 !12 Total Expenses 13 Less Advances 14 Balance Due To Employee 15 Balance Due From Employee16 &17 18 Use the Go To function to move19 20 the cell pointer to cell g13.21 22 &23 Wed 17-Feb-88 9:32 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  F&&&&& # NO CHANGE!N*g5 +f5+e5+d5 POINTEnter address to go to: g5 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:32 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   (NO CHANGE!Nsg5 +f5+e5+d5 POINTEnter address to go to: g5 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals5  25 25 25 8 Entertainment! 75 9 10 11 12 Total Expenses 13 Less Advances 14 Balance Due To Employee Go to g13.15 Balance Due From Employee16 17 18 19 20 21 22 23 Wed 17-Feb-88 9:32 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  ) NO CHANGE!; N+g5 +f5+e5+d5 EDIT Enter address to go to: g a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45  45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:33 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE! N,g5 +f5+e5+d5 EDIT Enter address to go to: g1 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:33 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!N+g5 +f5+e5+d5 EDIT Enter address to go to: g13 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:33 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!Ng13 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:33 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  &NO CHANGE! Nbg13 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee16 #17 18 Enter the value,1200.19 20 #21 22 23 Wed 17-Feb-88 9:33 AM Macro  Edit  Name Abs  Go To  Window Query T6 able  Calc  Graph T  NO CHANGE!Ng13 VALUE1 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:34 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T v NO CHANGE!N g13 VALUE12 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:34 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 9 F NO CHANGE!X N g13 VALUE120 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:34 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T "  #NO CHANGE!#N g13 VALUE1200 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:34 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T % %NO CHANGE!%Ng13 1200 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:34 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T (  :(NO CHANGE!({Ng13 1200 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car  45 135 6 Daily lodging 89 7 Meals Good. Now calculate the 25 8 Entertainment  9 Balance Due To Employee. 10 6  11  12 Total Expenses 13 Less Advances  1200 14 Balance Due To Employee 15 Balance Due From Employee16 17 318 19 First, move the cell pointer down one cell.20 21 322 23 Wed 17-Feb-88 9:34 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 333', 4,NO CHANGE!F,N g14 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:34 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .  .NO CHANGE! /=Npg14 7READY 3  Let's take a look at how to calculate this value.  a g h1 EXPENSE If Total Expenses > Advances, then there is a 2 tal 3 balance due to the employee. The formula would be penses 4 Air, r  450 5 Rental Total Expenses minus Advances, or cell g12 minus 135 6 Daily 5 7 Meals cell g13. Let's create this formula. 8 Entert5 9 710 11 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee3 15 Balance Due From Employee1 16 ,17 18 Since the formula begins with a cell19 20 reference, what do you type first?21 22 ,23 Wed 17-Feb-88 9:34 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph   ,,,,,I3 V3NO CHANGE!h3Ng14 VALUE+ a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:34 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 6 6NO CHANGE!06Ng14 VALUE+ a b c d e f g h1 EXPENSE REPORT> 2B Total 3 / Expenses 4 Air, rail,  450 5 Rental car Good. Now subtract the Advance from the  135 6 Daily lodgi 7 Meals Total Expenses, which is found in cell g12. 8 Entertainme 9 / 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee3 15 Balance Due From Employee1 16 17 $18 19 Using the Up Arrow, move the20 21 cell pointer to cell, g12. 22 23 $Wed 17-Feb-88 9:34 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T $$$$$9 9NO CHANGE!9Ng13 1200 POINT+g13 a b7  c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:35 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T < <NO CHANGE!<Ng12 POINT+g12 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:35 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T N? [?NO CHANGE!m?N g12 (POINT+g12Cell g12 is included in the formula. ( a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9  10 11 Subtract Advances from 12 Total Expenses 13 Less Advances Total Expenses. 1200 14 Balance Due To Employee 15 Balance Due From Employee 16 17 18 19 What do you type now?20 21 22 23 Wed 17-Feb-88 9:35 AM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph (T #C 0CNO CHANGE!BCNg14 VALUE+g12- a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:35 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T E ENO CHANGE!FN3g14 VALUE+g12- A a That's right. You had to type the minus sign. Now, complete h1 EXPENSE 2 the formula by subtracting the Advance, 1200, from the Total 3 4 Air, Expenses. You could type the value, 1200, but instead use a 5 Renta 6 Dailycell reference to refer to cell g13, which contains 1200. 7 Meals 8 EnterA 9 10 11 12 Total Expenses 13 Less Advances  1200 14 Balance Due To Employee 15 Balance Due From Employee 16 $17 18 Use the Up Arrow to move the19 20 cell pointer to cell, g13.21 22 $23 Wed 17-Feb-88 9:35 AM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph   $$$$$7 J JNO CHANGE!-JNg13 1200 POINT+g12-g13 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:35 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T L !LNO CHANGE!McNg13 1200 POINT+g12-g13  O , a b c d  e f g h1 EXPENSE REPORT % 2)  Total 3  Expenses 4 Air, rail, bus  450 5 Rental car Your formula is complete. 45 135 6 Daily lodging  89 7 Meals  25 8 Entertainment! 75 9 10 11 12 Total Expenses 13 Less Advances  1200 14 Balance Due To Employee 15 Balance Due From Employee 16 17 18 Enter the formula.19 20 21 22 23 Wed 17-Feb-88 9:35 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T eP !rPNO CHANGE!PNg14 +g12-g13 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:35 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T >S KKSNO CHANGE!]SDNbg14 +g12-g13 READYe / a b g h1 EXPENSE REPORT Since there is currently no value for Total 2 al 3 Expenses, the result is a negative valueenses 4 Air, rail, bus 450 5 Rental car (0 - 1200 = -1200). This value will change 135 6 Daily lodging 7 Meals as soon as we calculate Total Expenses. 8 Entertainment  9  10 11 if no value, use 0 12 Total Expenses  13 Less Advances  1200 14 Balance Due To Employee  -1200 15 Balance Due From Employee 16 17 ,18 19 Move the cell pointer down one cell.20 21 ,22 23 Wed 17-Feb-88 9:35 AM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ///////// ,,,W WNO CHANGE!WNg15 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:36 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T8  oZ |ZNO CHANGE!Z8Nfg15 READY /  a bNow to calculate Balance Due From Employee. g h1 EXPENSE REPOR 2 If Advances > Total Expenses, then there isTotal 3 Expenses 4 Air, rail, a balance due from employee. Thus, the  450 5 Rental car  135 6 Daily lodgiformula would be Advances minus Total 7 Meals 8 EntertainmeExpenses, or cell g13 minus cell g12. 9 10 / 11 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee1 16 17 %18 19 Create this formula using the20 21 appropriate cell references.22 23 %Wed 17-Feb-88 9:36 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  %%%%%^ ^NO CHANGE!^Ng15 VALUE+ a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:36 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T a aNO CHANGE!aN#g14 +g12-g13 POINT+g14 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:36 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T rd dNO CHANGE!dNg14 1200 POINT+g13 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:36 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T Kg XgNO CHANGE!jgNg15 VALUE+g13- a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:36 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 8 j +jNO CHANGE!=jN'g14 +g12-g13 POINT+g13-g14 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:36 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T l  mNO CHANGE!mN#g13 1200 POINT+g13-g13 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:36 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T o oNO CHANGE!oNg12 POINT+g13-g12 a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:37 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T r rNO CHANGE!rN&g15 +g13-g12 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:37 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T u ?uNO CHANGE!uNg15 +g13-g12 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3 2penses 4 Air, rail,  450 5 Rental car Very good. Let me say again that this value 135 6 Daily lodgi 7 Meals will change when you calculate Total Expenses. 8 Entertainme 9 2 10 11 12 Total Expenses 13 Less Advances  1200 14 Balance Due To Employee  -1200 15 Balance Due From Employee 1200 16 17 )18 19 Go ahead and save your worksheet.20 21 )22 23 Wed 17-Feb-88 9:37 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T )))8y EyNO CHANGE!WyKNg15 +g13-g12 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, S9 tatus a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:38 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T | |NO CHANGE!|Ng15 +g13-g12 MENU Retrieve Save Combine Xtract Erase List Import Directory Read in a spreadsheet file= a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:38 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!NHg15 +g13-g12 EDIT Enter save filename: ExpenseReport a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:38 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ނ NO CHANGE!Nag15 +g13-g12MENU Cancel ReplaceCancel operation; don't overwrite file a b c d e f g h1 EXPENSE REPORT2B Total3B Expenses4 Air, rail, bus 450 4505 Rental car 45 45 45 1356 Daily lodging 89 89 897 Meals 25 25 258 Entertainment! 759 10 11 12 Total Expenses13 Less Advances 120014 Balance Due To Employee -120015 Balance Due From Employee 1200 16 17 18 19 20 21 22 23 Wed 17-Feb-88 9:38 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  KNO CHANGE!N%g15 +g13-g12 WAIT a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16N 17N 18N 19N 20N 21N 22N 23N Wed 17-Feb-88 9:38 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T ؈ %NO CHANGE!ANg15 +g13-g12 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainmen9  F5 time g g 1 1 3 3 0x0A Return time 1 1 2 2 0 ~ You are currently entering the value, 1200. ~ ~~ ~~ ~~ ~ Dismiss this message and type '0' ... ~ 0 0 0 0x0A Return time DownArrow time + ~ Since the formula begins with a cell reference, ~ ~~ ~ the first thing to enter is a plus sign. ~ ~~ ~ Dismiss this message and type '+'. ~ ShiftRight Equal time  UpArrow  UpArrow time - ~ Since you are performing subtraction, ~ ~~ ~ you must en2am d JHPN  DNO CHANGE!+Nd- Question -Calculating With FormulasPFILLINTHEBLANKNNNN 8 To enter a formula, move cell pointer to desired cell, ~ ~ the formula, and press Return. 8 NNNNN(Type your answer and press GO when ready)P 1L*2am c8 JHPN  DNO CHANGE!+;N#Calculating With FormulasPpPpf DsNO CHANGE!NCalculating With FormulasPcCorrect!To enter a formula, move cell pointer to desired cell, type in the formula,then press Return.0P2am %c P Gcalc>formla>FIB3.a000'%Lcalc>formla>FIB3.common.path2am 'd:  JHPN  DNO CHANGE!+'NCalculating With FormulasP_That's incorrect.To enter a formula, move cell pointer to desired cell, type in the formula, then press Return. Remember, you enter formulas in the same waythat you enter labels or values.P2am %c P Gcalc>formla>FIB3.a999'%Lcalc>formla>FIB3.common.path2amch!pPtype+sPtypeinEaPenter2am c P  calc>formla>FIB42am d8:  JHPN  DNO CHANGE!+N~- Question -Calculating With FormulasPFILLINTHEBLANKNNN 8 What formula would you enter into cell g2 that adds the value in cell f1 to the value in cell f2? ~~ 8 NNNN(Type your answer and press GO when ready)P1*2am c8 JHPN  DNO CHANGE!+;N#Calculating With FormulasPpPpf DsNO CHANGE!NCalculating With FormulasPExcellent!The formula that adds the value in cell f1to the value in cell f2is either+f1+f2 or +f2+f1.0P/12am %c P Gcalc>formla>FIB4.a000'%Lcalc>formla>FIB4.common.path2am ]d JHPN  DNO CHANGE!+]N5Calculating With FormulasPThat's incorrect.The formula that adds the value in cell f1to the value in cell f2 is+f1+f2. Operator +f1+f2 Type a plussign first ifformula begins with a cell referenceOperandsP 2am %c;  P Gcalc>formla>FIB4.a999'%Lcalc>formla>FIB4.common.path2amch!pP+f1+f2-s+f2+f12am c P Gcalc>formla>E.1!Gcalc>formla>E.29Gcalc>formla>Rev.1SGcalc>formla>Rev.2mGcalc>formla>Rev.3NCalc>Menuter a minus sign. ~ ~~ ~ Dismiss this message and type '-'. ~ Hyphen time  UpArrow time 0x0A Return time DownArrow time + ~ Since the formula starts with a cell reference, ~ ~~ ~ you must enter a plus sign.  ~ ~~ ~ Dismiss this message and type '+'. ~ ShiftRight Equal  ~You are to subtract Total Expenses from Advances, ~ ~ in other words, cell g13 - cell g12. ~ ~ ~ ~ Dismiss this message and press Up Arrow until ~ ~ you reach cell g13. ~ UpArrow  UpArrow - ~ You are doing a subtraction, ~ ~~ ~ +g13-g12. ~ ~~ ~ Dismiss this message and type '-'. ~ Hyphen  ~You are subtracting Total Expenses from Advances, ~ ~ in other words cell g13 - cell g12. ~ ~~ ~ Dismiss this message and press Up Arrow ~ ~ until you reach cell g12. ~ UpArrow  UpArrow  UpArrow 0x0A ~ And finally, enter the formula ~ ~ ~ ~ into your worksheet. ~ ~~ ~ Dismiss this message and press Return. ~ Return time / Slash f f s s 0x0A Return r ~ You are currently saving the changes you have ~ ~ made to your worksheet. To do this, you must ~ ~ use the Replace command. ~ ~~ ~ Dismiss this message and type r for Replace. ~ r time; t! 75 9 10 11 12 Total Expenses 13 Less Advances  1200 14 Balance Due To Employee  -1200 15 Balance Due From Employee 1200 16 17 18 Keep up the good work!19 20 21 Press Next Page to continue22 23 Wed 17-Feb-88 9:38 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T %%%%% time.00Less Advances$1200.00Balance Due To EmployeeBalance Due From Employee$198.00N Pp2am f& JHPN   NO CHANGE!+NCalculatingWithFormulasP You have already entered thelabelsandexpense values. EXPENSE REPORTTotal1/6/881/7 881/8/88Expenses Air, rail, bus 450 450Rental car 45 45 45 135Daily lodging 89 89 89 267Meals 25 25 25 75Entertainment 75 75 Total Expenses 609 234 159 1002Less Advances 1200Balance Due To EmployeeBalance Due From Employee 198N P2am eS<  JHPN  <NO CHANGE!+NJCalculatingWithFormulasPNow, the expense valuesneed to betotaled by rows, and by columns.B EXPENSE REPORTTotal1/6/881/7/881/8/88ExpensesCAir, rail, bus 450 450Rental car 45 45 45 135Daily lodging 89 89 89 267Meals 25 25 25 75Entertainment 75 75CTotal Expenses 609 234 159 1002Less Advances 1200Balance Due To EmployeeBalance Due From Employee 198N P777C55555C:BBB2am e< JHPN  &NO CHANGE!+N=CalculatingWithFormulasPOne way that you're going to accomplish thisis by using formulas.NEXPENSE REPORTTotal1/6/881/7/881/8/88ExpensesCAir, rail, bus 450 450Rental car 45 45 45 135Daily lodging 89 89 89 267Meals 25 25 25 75Entertainment 75 75CTotal Expenses 609 234 159 1002Less Advances 1200Balance Due To EmployeeBalance Due From Employee 198N Pi:::::::::::::::2am cw JHPN  NO CHANGE!+NCalculatingWithFormulasPIn this lesson, you will learnWhat a formula isWhat a formula looks likeHow to enter a formula in your worksheett P***** *.t2am c<  P Gcalc>formla>i.1!Gcalc>formla>i.29Gcalc>formla>i.3QGcalc>formla>i.4iGcalc>formla>i.5Gcalc>formla>i.6Gcalc>formla>i.7Gcalc>formla>i.8Gcalc>formla>def.1Gcalc>formla>def.2Gcalc>formla>def.3Gcalc>formla>def.41Gcalc>formla>def.5KGcalc>formla>def.6eGcalc>formla>def.7Gcalc>formla>def.8Gcalc>formla>def.9Gcalc>formla>def.10Gcalc>formla>def.11ZCarla.fontZSD.font Gcalc>formla>Seg1%Xcalc>formla>Ent1>ZSD.fontNZCarla.fontaGcalc>formla>qseg1{calc>formla>MC12am dC JHPN  DNO CHANGE!+NFQuestion Calculating With FormulasPTake a look at the following formulas:M((a1*a3)/b3)35-15U+e4+e5CLHow many operators do you see?HTOIF1 - 4F4 - 7IPF2 - 5F5 - 8CLF3 - 6F6 - None of the aboveEE(Select your answer by pressing one of the indicated selections)P00000000 +1+81""@2am c P calc>formla>mc22am e JHPN  DNO CHANGE!+NCalculating With FormulasPTake a look at the following formulas:((a1*a3)/b3)35-15+e4+e5How many operators do you see?F1 - 4F4 - 7F2 - 5F5 - 8F3 - 6F6 - None of the above+That's correct. There are 4 operators: *, -, /, and +.The + before e4 indicates that the formula begins witha cell reference.<P00= 00    %  %  %  <<<<<<<2am $c P  Gcalc>formla>MC1.correct)$Lcalc>formla>MC1.common.path2am $c P "Gcalc>formla>MC1.incorrect+$Lcalc>formla>MC1.common.path2am $c P "Gcalc>formla>MC1.incorrect+$Lcalc>formla>MC1.common.path2am $c=  P "Gcalc>formla>MC1.incorrect+$Lcalc>formla>MC1.common.path2am $c P "Gcalc>formla>MC1.incorrect+$Lcalc>formla>MC1.common.path2am $c P "Gcalc>formla>MC1.incorrect+$Lcalc>formla>MC1.common.path2am e; JHPN  DNO CHANGE!+NCalculating With FormulasPTake a look at the following formulas:((a1*a3)/b3)35-15+e4+e5How many operators do you see?F1 - 4F4 - 7F2 - 5F5 - 8F3 - 6F6 - None of the above<That's incorrect. The correct answer is F1. There are4 operators: *, -, /, and +. The + before e4 indicatesthat the formula starts with a cell reference. <P0000  %% % <<<<<<<> 2am 9c N 9 F1  F2  F3  F4  F5  F6 2am d* JHPN  DNO CHANGE!+N7Question Calculating With FormulasPTake a look at the following formulas:M (a1*a3/b3)35-15=20U+e4+e5CLHow many operands do you see?HTOIIF1 - 6F3 - 8PCF2 - 7F4 - None of the aboveLEE(Select your answer by pressing one of the indicated selections)P000000000 +1+""@2am c P ZCarla.fontZSD.font,Gcalc>formla>seg2.1GGcalc>formla>seg2.2bGcalc>formla>seg2.3}Xcalc>formla>textXcalc>formla>Ent2Gcalc>formla>Seg3.1Gcalc>formla>Seg3.2Gcalc>formla>Seg3.3Xcalc>formla>Ent3ZSD.font)ZCarla.font<Gcalc>formla>qseg1V calc>formla>FIB32am `e JHPN  DNO CHANGE!+`NWCalculating With FormulasPTake a look at the following formulas: (a1*a3/b3)35-15=20+e4+e5How many operands do you see?mF1 - 6F4 - 8F2 - 7F5 - None of the aboveThat's correct. There are7 operands: a1, a3, b3, 35, 15, e4 and e5. P0000>   %%          2am $c P "Gcalc>formla>mc2.incorrect+$Lcalc>formla>mc2.common.path2am $c P  Gcalc>formla>mc2.correct)$Lcalc>formla>mc2.common.path2am $c P "Gcalc>formla>mc2.incorrect+$Lcalc>formla>mc2.common.path2am $c?  P "Gcalc>formla>mc2.incorrect+$Lcalc>formla>mc2.common.path2am ue JHPN  DNO CHANGE!+uNuCalculating With FormulasPTake a look at the following formulas:(a1*a3/b3)35-15=20+e4+e5How many operands do you see?mF1 - 6F4 - 8F2 - 7F5 - None of the above(That's incorrect. The correct answer is F2. There are 7 operands:a1, a3, b3, 35, 15, e4 and e5.(P0000  %$  (((((((2am +c N + F1  F2  F3  F4 2am Me JHPN  ONO CHANGE!+N'! HNO CHANGE!MN Calculating With Formulas5A formula is a mathematical statementused to calculate a number.A formula consists of operands and'operators.!? Operands are values that are acted uponin a formula. They can be numbers,cell references, or other formulas.Operators are symbols that indicate thethe operation to take place, for example,+, -, /, or *.5 x 2am e JHPN  ONO CHANGE!+NCalculating With Formulas5Enter a formula into your worksheet in thesame way that you enter labels and values.If a formula begins with a cell reference,٫'then you must first type a plus sign (+).!The result of a formula is displayed ina cell, although the actual cell contentsis the formula itself.5)'2am et JHPN  NO CHANGE!+N'CalculatingWithFormulas5Enter a formulaintoyourworksheetinthesamewaythatyouenterlabelsandvalues.Youhavereachedtheendofthislesson.If a formula begins with a cell reference,Wesuggestyouproceedthenyoumustfirsttypeaplussign(+).tothenextlesson,Calculating WithThe result of a formula is displayed inFunctions.a cell,althoughtheactualcellcontentsPressNextPagetoreturnistheformulaitself.totheCalcmenu. 55 55555 )55555 '5  &555555555502am =e@  JHPN  ANO CHANGE!+=Na1 READYP  a b c d e f g h i1O 2 3 4 5 36 7 Let's create some simple formulas that8 9 consist first of numbers, then cell references.10 11 312 13 14 15 16 17 18 19 20 21 22 23 Wed 17-Feb-88 3:44 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am eG JHPN  HNO CHANGE!+N8a1READY a b c d e f g h i1 2 3 4 5 76 7 The formulas that you create in your expense report8 9 will use cell references instead of number values.10 11 12 13 Remember: A formula that begins with a cell 14 15 reference must be preceded by a plus sign (+).16 17 718 19 20 21 22 23 Wed 17-Feb-88 3:50 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am f JHPN  DNO CHANGE!+ Noc5 READY a b c d e f g h1 EXPENSE REPORT> 2O 3 4 Air, rail, bus 450 5 Rental car 45 45 45 6 Daily lodging8989897 Meals  25 25  25 8 Entertainment  75 9 10 11 12 Total ExpensesThis is what your worksheet13 Less Advances 14 Balance Due To Employee currently looks like.15 Balance Due From Employee16 17 18 19 20 21 22 23 Tue 09-Feb-88 2:56 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T @ 2am Ef JHPN  NO CHANGE!+ENc5 READY a b c d e f g h1 EXPENSE REPORT> 2O 3 < 4 Air, rail, bus 450 5 Rental car 45 45 45 6 <7 Meals  25 25 25 8 Entertainment  75 9 10 "11 12 Total ExpensesThe first thing to do is enter formulas13 Less Advances 14 Balance Due Tothat calculate totals for the first two15 Balance Due Fr16 expenses: Air, rail, bus and Rental Car.17 18 /19 20 21 22 23 Tue 09-Feb-88 2:56 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am f  JHPN  JNO CHANGE!+Ng5 +f5+e5+d5 &POINT% ( &  a b So far, you created a formula that g h1 EXPENSE REPORT  2 totals the first two expenses:  Total 3 &  Expenses 4 Air, rail, bus  +f4+e4+d4 450 5 Rental car  +f5+e5+d5 135 6 Daily lodging 89 7 Meals &25 8 Entertainment! 75 9 10 11 12 Total Expenses 13 Less Advances 14 Balance Due To Employee 15 Balance Due From Employee16 17 18 19 20 21 22 23 Wed 17-Feb-88 9:32 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph     2am f JHPN  NO CHANGE!+Ng5 +f5+e5+d5 POINT a b c d e f g h1 EXPENSE REPORT> 23  Total 33  Expenses 4 Air, rail, bus  450 5 Rental car 45 135 6 Daily lodging You have yet to calculate 89 7 Meals 25 8 Entertainment the remaining expenses and 9 10 Total Expenses.11 12 Total Expenses 13 Less Advances A 14 Balance Due To Employee 15 Balance Due From Employee16 17 18 19 20 21 22 23 Wed 17-Feb-88 9:32 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T    2am f JHPN  NO CHANGE!+Ng5 +f5+e5+d5 POINT a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89  89 89 7 Meals 25 25 25 8 Entertainment! 75 9 10 11 12 Total Expenses We'll do that later.13 Less Advances 14 Balance Due To Employee Let's first work on 15 Balance Due From Employee16 calculating these values.17 18 19 20 21 22 23 Wed 17-Feb-88 9:32 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T SD To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:26 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 8 ENO CHANGE!WNa17 ' Bal Due From Emp EDIT ' BalanceDue From Emplo a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:26 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE!Na17 ' Bal Due From Emp EDIT ' BalanceDue From Employ a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:26 AM; Macro  Edit  NameA  Abs  Go To  Window Query Table  Calc  Graph T Ü МNO CHANGE!Na17 ' Bal Due From Emp EDIT ' BalanceDue From Employe a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:26 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE! Nia17 ' Bal Due From Emp EDIT ' BalanceDue From Employee a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 013 14 Total Expenses And press Return to enter the new label.15 Less Advances 16 Balance Due To Employee017 Bal Due From Emp 18 19 20 21 22 23 Tue 09-Feb-88 11:26 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T000  7NO CHANGE!ӢNIa17 ' Balance Due From EmployeeREADY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses Fantastic!15 Less Advances 16 Balance Due To Employee 17 Balance Due From Employee (Press Next Page to Continue)18 19 20 21 22 23 Tue 09-Feb-88 11:27 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T%  %% %%2am cC JHPN  DNO CHANGE!+;N#Calculating With FormulasPpPpf DsNO CHANGE!NCalculating With FormulasPcCorrect!To enter a formula, move cell pointer to desired cell, enter, or type in, the formula,then press Return.0P2am %cB  P Gcalc>formla>fib3.a002'%Lcalc>formla>FIB3.common.path2am d_ JHPN   NO CHANGE!+N- Question -Modifying an Existing WorksheetPFILLINTHEBLANKNNN 8 If the main command menu is currently displayed, the keystroke combination to delete one or more rows from your worksheet is ~~ . 8 NNNN(Type your answer and press GO when ready)Pd1*2am ye JHPN  NO CHANGE!+yNModifying an Existing WorksheetPYThe Worksheet/Insert commandF1 - inserts a column to the left of the cell pointerF2 - inserts a row above the cell pointerF3 - allows you to insert more than one column at a timeF4 - All of the aboveF5 - None of the aboveCCorrect! The Worksheet/Insert command inserts a column to theleft of the cell pointer, inserts a row above the cell pointer,and lets you insert more than one column at a time.CP&&a88888888"CCCCC2am e"B  JHPN  )NO CHANGE!+N!Modifying an Existing WorksheetPYThe Worksheet/Insert commandF1 - inserts a column to the left of the cell pointerF2 - inserts a row above the cell pointerF3 - allows you to insert more than one column at a timeF4 - All of the aboveF5 - None of the aboveGThat's incorrect. The correct answer is F4. The Worksheet/Insert command inserts a column to the left of the cell pointer, a rowabove the cell pointer, and inserts more than one column at a time.GP&&a88888!   GGGGG2am 5e JHPN  NO CHANGE!+5NModifying an Existing WorksheetPYThe Worksheet/Insert commandF1 - inserts a column to the left of the cell pointerF2 - inserts a row above the cell pointerF3 - allows you to insert more than one column at a timeF4 - All of the aboveF5 - None of the above/That's correct, however, all three choices are correct. F4 is the appropriate answer./P&&a88888!!!"/////2am dO JHPN   NO CHANGE!+NnQuestion 2Modifying an Existing WorksheetPYThe Worksheet/Insert commandF1 - inserts a column to the left of the cell pointerF2 - inserts a row above the cell pointerF3 - allows you to insert more than one column at a timeF4 - All of the aboveF5 - None of the above(Select your answer by pressing one of the indicated selections)P&&a888888888@C  P NInitial>MainMenu2am c92am c9 JHPN  NO CHANGE!+N9;I T ' S T I M E T O S E EW H A T Y O U H A V E L E A R N E D . . .;.3333 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 . . .;.3333SDmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmC mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmD mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmD mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmE 2am fP JHPN   <NO CHANGE!+N&c5 READY a b c d e f g h1 EXPENSE REPORT> 29  39  4 Air, rail, bus 450  5 Rental car 45 45  45 6 Daily lodging 89 89  89 7 Meals 25 25  25 8 Entertainment! 75  9  10 11 Before you do that, enter12 Total Expenses 13 Less Advances the label, "Total Expenses",14 Balance Due To Employee 15 Balance Due From Employeeat the top of column g.16 17 18 &19 20 Using the Go To function, move21  22 the cell pointer to cell g2. 23  Tue 09-Feb-88 2:56 PM & Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T &&&&& NO CHANGE!!Nc5 POINTEnter address to go to: c5 a b c d e f g h1 EXPENSE REPORT> 2O 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:05 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   ,NO CHANGE!N1c5 POINTEnter address to go to: c5 a b c d e f g h1 EXPENSE REPORT> 2O 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances  14 Balance Due To Employee   15 Balance Due From Employee  Go to g2.  16)   17)  18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:05 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE! Nc5 EDIT Enter address to go to: g a b c d e f g h1 EXPENSE REPORT> 2O 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T k xNO CHANGE!Nc5 EDIT Enter address to go to: g2 a b c d e f g h1 EXPENSE REPORT> 2O 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From EmployeeE 1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T " &/NO CHANGE!ANLg2 READY a b c d e f g h1 EXPENSE REPORT> 2O 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9 10 $11 12 Total Expenses Enter the label,Total.13 Less Advances 14 Balance Due To Employee $15 Balance Due From Employee16 17 18 19 20 21 22 23 Tue 16-Feb-88 10:07 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 5 BNO CHANGE!TNg2 LABELT a b c d e f g h1 EXPENSE REPORT> 2O 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!Ng2 LABELTo a b c d e f g h1 EXPENSE REPORT> 2O 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T v NO CHANGE!Ng2 LABELTot a b c d e f g h1 EXPENSE REPORT> 2O 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  %NO CHANGE!7Ng2 LABELTota a b c d e f g h1 EXPENSE REPORT> 2O 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!Ng2 LABELTotal a b c d e f g h1 EXPENSE REPORT> 2O 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14F  Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ]! (j!NO CHANGE!|!NHg2 'TotalREADY a b c d e f g h1 EXPENSE REPORT> 2B Total 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9 10 11 12 Total Expenses '13 Less Advances 14 Balance Due To Employee Move the cell pointer down once.15 Balance Due From Employee16 '17 18 19 20 21 22 23 Tue 16-Feb-88 10:07 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T '''k$ (x$NO CHANGE!$ Neg3 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9 10 11 '12 Total Expenses 13 Less Advances 14 Balance Due To Employee Enter the label,Expenses.15 Balance Due From Employee 16 17 '18 19 20 21 22 23 Tue 16-Feb-88 10:08 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ' 'NO CHANGE!'Ng3 LABELE a b c d e f g h1 EXPENSE REPORT> 2B Total 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T A* N*NO CHANGE!`*Ng3 LABELEx a b c d e f g h1 EXPENSE REPORT> 2B Total 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T , ,NO CHANGE! -Ng3 LABELExp a b c d e f g h1 EXPENSE REPORT> 2B Total 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T / /NO CHANGE!/Ng3 LABELExpe a b c d e f g h1 EXPENSEF  REPORT> 2B Total 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T E2 R2NO CHANGE!d2Ng3 LABELExpen a b c d e f g h1 EXPENSE REPORT> 2B Total 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 4 5NO CHANGE!5Ng3 LABELExpens a b c d e f g h1 EXPENSE REPORT> 2B Total 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 7 7NO CHANGE!7Ng3 LABELExpense a b c d e f g h1 EXPENSE REPORT> 2B Total 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T R: _:NO CHANGE!q:Ng3 LABELExpenses a b c d e f g h1 EXPENSE REPORT> 2B Total 3O 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9O 10N 11N 12 Total Expenses< 13 Less Advances= 14 Balance Due To Employee3 15 Balance Due From Employee1 16N 17N 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T = =NO CHANGE! =N\g3 'ExpensesREADY a b c d e f g h1 EXPENSE REPORT> 2B Total 3B Expenses 4 Air, rail, bus 450& 5 Rental car 45 45 45 6 Daily lodging 89 89 89 7 Meals 25 25 25 8 Entertainment! 75 9 10 11 12 Total Expenses 13 Less Advances 14 Balance Due To Employee 15 Balance Due From Employee16 17 Great. Now let's get to work!18 19 20 Press Next Page to continue21 22 23 Tue 16-Feb-88 10:08 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T (G (((( F5 time g g 2 2 0x0A Return T ShiftLeft t o ~ You are currently entering the label, ~ ~~ ~ Total ~ ~~ ~ Dismiss this message and type 'o' ... ~ o t ~ You are currently entering the label, ~ ~~ ~ Total ~ ~~ ~ Dismiss this message and type 't' ... ~ t a ~ You are currently entering the label, ~ ~~ ~ Total ~ ~~ ~ Di2am &c P GUsing>Modify>FIB2.a999(&LUsing>Modify>FIB2.common.pathsmiss this message and type 'a' ... ~ a l l 0x0A Return DownArrow E ShiftLeft e x ~ You are currently entering the label, ~ ~~ ~ Expenses ~ ~~ ~ Dismiss this message and type 'x' ...  ~ x p ~ You are currently entering the label, ~ ~~ ~ Expenses ~ ~~ ~ Dismiss this message and type 'p' ... ~ p e ~ You are currently entering the label, ~ ~~ ~ Expenses ~ ~~ ~ Dismiss this message and type 'e' ... ~ e n ~ You are currently entering the label, ~ ~~ ~ Expenses ~ ~~ ~ Dismiss this message and type 'n' ... ~ n s s e e s s 0x0A Return timeG H H I 2am %c P #Gusing>modify>mc3.incorrect,%LUsing>Modify>MC3.common.path; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T Z ZNO CHANGE!ZNa16 ' Bal Due To Emp LABEL Balance Due To Employ a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ] ]NO CHANGE!]Na16 ' Bal Due To Emp LABEL Balance Due To Employe a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Bal Due To Emp< 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:20 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T R` _`NO CHANGE!q`N_a16 ' Bal Due To Emp LABEL Balance Due To Employee a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 015 Less Advances 16 Bal Due To Emp And press Return to enter the new label.17 Bal Due From Emp 18 019 20 21 22 23 Tue 09-Feb-88 11:20 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T0 00rc NcNO CHANGE!clNa16 ' Balance Due To Employee READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 (12 13 Good!14 Total Expenses 15 Less Advances  Now change the label below this one.16 Balance Due To Employee 17 Bal Due From Emp (18 19 /20 21 First,move the cell pointer down once.22 23 /Tue 09-Feb-88 11:21 AM MacroI   Edit  Name Abs  Go To  Window Query Table  Calc  Graph T (///f 6 gNO CHANGE!gjNa17 ' Bal Due From Emp READY a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 012 13 You're going to learn something new here.14 Total Expenses 15 Less Advances To change this label, use the Edit function.16 Balance Due To Employee17 Bal Due From Emp 018 19 20 21 Press f2, Edit.22 23 Tue 09-Feb-88 11:22 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T j jNO CHANGE!jNa17 ' Bal Due From Emp EDIT ' Bal Due From Emp   The contents of cell a17 a b c d  i1 EXPENSE REPORT are displayed. You make 2 3 your edits here. Also, 4 5 notice the mode changed 6 Air, rail, bus 450  7 Rental car 40 40 from Ready to EDIT. 8 Daily lodging 68 68  9 Meals 25 25  10 Entertainment 75) 11 (12 13 The first thing to do is move the14 Total Expenses 15 Less Advances cursor to the beginning of the line.16 Balance Due To Employee17 Bal Due From Emp (18 19 .20 21  To do this, pressShiftUpArrow.22 23 .Tue 09-Feb-88 11:23 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph +  Xo eoNO CHANGE!woN+a17 ' Bal Due From Emp EDIT ' Bal Due From Emp a b c d e f g h i1 EXPENSE REPORT2 3 4 5 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances 16 Balance Due To Employee17 Bal Due From Emp 18 19 20 21 22 23 Tue 09-Feb-88 11:25 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 8r ErNO CHANGE!WrNba17 ' Bal Due From Emp EDIT ' Bal Due From Emp O / a b c d  e f g h i1 EXPENSE REPORT "2 3 The cursor is at the beginning of the line.4 5 /6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 #12 13 Move the cursor to the position14 Total Expenses 15 Less Advances after the l in Bal.16 Balance Due To Employee17 Bal Due From Emp #18 -19 20 To do this, press the Right Arrow21 22 until you reach the desired position.23 Tue 09-Feb-88 11:25 AM - Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T///J  %%%mv zvNO CHANGE!vN a17 ' Bal Due From Emp EDIT ' Bal Due From Emp a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:25 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ,y 9yNO CHANGE!KyN a17 ' Bal Due From Emp EDIT ' Bal Due From Emp a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:25 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T { {NO CHANGE! |N a17 ' Bal Due From Emp EDIT 'Bal Due From Emp a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:25 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ~ ~NO CHANGE!~NO CHANGE!~ ~NO CHANGE!~NO CHANGE!  NO CHANGE!+2Na17 ' Bal Due From Emp EDIT 'BalDue From Emp a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 Good!14 Total Expenses 15 Less Advances 16 Balance Due To Employee Now type ance.17 Bal Due From Emp 18 19 20 21 22 23 Tue 09-Feb-88 11:25 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ] jNO CHANGE!|Na17 ' Bal Due From Emp EDIT ' BalaDue From Emp9 W a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:26 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  -NO CHANGE!?Na17 ' Bal Due From Emp EDIT ' BalanDue From Emp9 W a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 J 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:26 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE!Na17 ' Bal Due From Emp EDIT ' BalancDue From Emp9 W a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance Due To Employee3 17 Bal Due From Emp: 18N 19N 20N 21N 22N 23N Tue 09-Feb-88 11:26 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE!NJNa17 ' Bal Due From Emp EDIT ' BalanceDue From Emp a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75 11 12 Now spell out "Employee".13 14 Total Expenses I'll give you a little help15 Less Advances 16 Balance Due To Employeeand move the cursor for you.17 Bal Due From Emp 18 19 %20 21 Please press the Right Arrow.22 23 %Tue 09-Feb-88 11:26 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T %%%Y fNO CHANGE!xN*a17 ' Bal Due From Emp EDIT ' BalanceDue From Emp a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances 16 Balance Due To Employee 17 Bal Due From Emp 18 19 20 21 22 23 Tue 09-Feb-88 11:26 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 8 ENO CHANGE!WNza17 ' Bal Due From Emp EDIT ' BalanceDue From Emp a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11 12 13 14 Total Expenses 15 Less Advances Now typeloyee.16 Balance Due To Employee 17 Bal Due From Emp 18 19 20 21 22 23 Tue 09-Feb-88 11:26 AM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T t NO CHANGE!Na17 ' Bal Due From Emp EDIT ' BalanceDue From Empl a b c d e f g h i1 EXPENSE REPORT> 2O 3O 4O 5O 6 Air, rail, bus 4502 7 Rental car 40 40 40 8 Daily lodging 68 68 68 9 Meals 25 25 25 10 Entertainment 75) 11N 12N 13N 14 Total Expenses< 15 Less Advances= 16 Balance DueK 2am Jd JHPN  <NO CHANGE!+JN"CalculatingWithFormulasP)Aformulaisamathematicalstatementusedtocalculateanumericvalue.Here are some examples:27+344/215*3-8) P2am 3e JHPN  'NO CHANGE!+3NhCalculatingWithFormulasP)The operators in the examples beloware * (multiplication), / (division),+ (addition), and - (subtraction).27+344/215*3-8+ a1+a2(200 + 5) - 100) P2am Id JHPN  ;NO CHANGE!+INCalculatingWithFormulasP 'A formula contains some combinationof operands and operators.27+344/215*3-8' P -2am }dK  JHPN  2NO CHANGE!+}N]CalculatingWithFormulasP(Together, operands and operators areused to calculate the end result.27+34=614/2=215*3-8=37+ a1+a2=27(200 + 5) - 100= 105( Pp2am 6d JHPN  7NO CHANGE!+6NCalculatingWithFormulasP &Operands are values that are actedupon in an operation.27+344/215*3-8& P2am jd JHPN   NO CHANGE!+jNCalculatingWithFormulasP 'In these examples, the operands are27, 34, 4, 2, 15, 3 and 8.27+344/215*3-8' P2am )d JHPN  <NO CHANGE!+)NCalculatingWithFormulasP )Operands can also be cell references, such as a1, a2, b2, c4, and so on.+ a1+a2+b2  - c4) P2am $dL  JHPN  +NO CHANGE!+$NCalculatingWithFormulasP 'Notice the plus sign (+) before the first cell reference.+ a1+a2+b2 - c4' P2am 8d JHPN  +NO CHANGE!+8NCalculatingWithFormulasP1If a formula begins with a cell reference,then the formula must start with a plus sign.+ a1+a2+b2 - c41 P2am d JHPN  :NO CHANGE!+ NCalculatingWithFormulasP+An operand can also be another formula.The formula is enclosed in parentheses.(200 + 5) - 100+b3 / (a1 * a2)+ Pp2am Rd JHPN  &NO CHANGE!+RN2CalculatingWithFormulasP'Operators are symbols that indicatethe operation to take place.27+344/215*3-8+ a1+a2(200 + 5) - 100' Pp2am gaL  JHPN   NO CHANGE!+N  @ MNO CHANGE!_Nlah EEE   fhaedan  2am dI JHPN  <NO CHANGE!+NCalculatingWithFormulasPUp to this point,your Expense Report looks something like this:NEXPENSE REPORTAir, rail, bus 450Rental car 45 45 45Daily lodging 89 89 89Meals 25 25 25Entertainment 75Total ExpensesLess AdvancesBalance Due To EmployeeBalance Due From EmployeeN Pp2am de JHPN  9NO CHANGE!+dNDCalculatingWithFormulasPYour Expense Report will eventually look like this:NEXPENSE REPORTTotal1/6/881/7/881/8/88ExpensesCAir, rail, bus$450.00$450.00Rental car$45.00$45.00 $45.00$135.00Daily lodging$89.00$89.00 $89.00$267.00Meals$25.00$25.00 $25.00$75.00Entertainment$75.00$75.00CTotal Expenses$609.00$234.00 $159.00$1002.00Less Advances$1200.00Balance Due To EmployeeBalance Due From Employee$198.00N Pp