IMD 1.18: 15/05/2012 10:08:33 solution designer tutorial sd-5 5 of 7 71-03155-07  SD-5monetcfTgKD$ysSD 9|M^2am g JHPN  /NO CHANGE!+NOg12 @SUM(g8..g4)READYW a b c d e f g h1 EXPENSE REPORT> 2B Total 3    Expenses 4 Air, rail, bus  450  450 5 Rental car  45  45  45 135 6 Daily lodging  89  89  89 267 7 Me  75 8 En 75 9 Your expense report is coming along just fine. The next 10 11 thing to do is to enter dates above the expense columns. 12 To 1002 13 LeTo do this, you're going to use the @DATE function. 1200 14 Ba -198 15 Ba< 198 16 17 !18 19 Using the Go To function,20 21 go to cell d3.22 23 !Sun 21-Feb-88 5:31 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T!!!!!> CKNO CHANGE!]fNg12 @SUM(g8..g4)POINTEnter address to go to: 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9 10 11 12 Total Expenses 609234159 1002 13 Less Advances  1200 14 Balance Due To Employee  -198 15 Balance Due From Employee 198 16 Go to d3.17 18 19 20 21 22 23 Sun 21-Feb-88 5:31 PM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE! Nlg12 @SUM(g8..g4)EDIT Enter address to go to: d 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88  5:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE! Njg12 @SUM(g8..g4)EDIT Enter address to go to: d3 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159100213 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:31 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   *NO CHANGE!,Nd3 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 Dai$ 89 89 267 7 Mea 25 25 75 8 EntGood. Now, the date function,  75 75 9 10 @DATE(year,month,day), returns 11 12 Tota date serial number from the 2341591002 13 Les1200 14 Balyear, month and day that you  15 Bal 16 specify as arguments. The datesEnter the first 17 18 to enter are January 6th, 7th,date function:19 20 and 8th, 1988.@date(88,1,6).21 22 $23 Sun 21-Feb-88 5:31 PM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE!-Nd3 VALUE@ @date(88,1,6)  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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16$  17$  18$  19$  20$  21N 22N 23N Sun 21-Feb-88 5:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T  NO CHANGE!1Nhd3 VALUE@d  @date(88,1,6) = 0 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T 6 CNO CHANGE!UNid3 VALUE@da  @date(88,1,6) = 0 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T [ hNO CHANGE!zNjd3 VALUE@dat  @date(88,1,6) = 0 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T ! !NO CHANGE!!Nkd3 VALUE@date  @date(88,1,6) = 0 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T $ $NO CHANGE!$ Nld3 VALUE@date(  @date(88,1,6)  = 0 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T ' 'NO CHANGE!' Nmd3 VALUE@date(8  @date(88,1,6) = 0 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T * +NO CHANGE!+ Nnd3 VALUE@date(88  @date(88,1,6) = 0 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 lo dging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T #.  0.NO CHANGE!B. Nod3 VALUE@date(88,  @date(88,1,6) = 0 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T N1  [1NO CHANGE!m1 Npd3 VALUE@date(88,1  @date(88,1,6) = 0 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T z4  4NO CHANGE!4Nqd3 VALUE@date(88,1,  @date(88,1,6) = 0 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T 7  7NO CHANGE!7Nrd3 VALUE@date(88,1,6  @date(88,1,6) = 0 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T :  :NO CHANGE!:NOd3 VALUE@date(88,1,6) 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 267 7 Meals 25 25 25 75 8 En tertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T = (=NO CHANGE!=>Nad3 [W12] @DATE(88,1,6)READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3  32148 Expenses 4 Air, rail, bus  450 450 5 Rental car  45 45 45 135 6 Dai89 89 89 267 7 Mea25 25 25 75 8 EntNotice that the result is 75 75 9 10 the date serial number. 11  12 Tot0You will format the dates002 13 Less Advances200 14 Balance Due To Employee later on. For now, enter198 15 Balance Due From Employee198 16 the next date function.17 18 19 ,20 21 Move cell pointer once to the right.22 23 ,Sun 21-Feb-88 5:35 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  ,,,;B (HBNO CHANGE!ZBsNe3 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 Expenses 4 Air, rail, bus 450 450 5 Rental car 45  45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9 10 11 12 Total Expenses 6092341591002 13 Less Advances 1200 14 Balance Due To Employee -198 15 Balance Due From Employee 198 16 17 Enter the date function,18 19 @date(88,1,7).20 21 22 23 Sun 21-Feb-88 5:35 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  E ENO CHANGE!E Noe3 VALUE@  @date(88,1,7) = 0 a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:36 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T H INO CHANGE!I Npe3 VALUE@d  @date(88,1,7) = 0 a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:36 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T  $L 1LNO CHANGE!CLNqe3 VALUE@da  @date(88,1,7) = 0 a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:36 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T QO ^ONO CHANGE!pONre3 VALUE@dat  @date(88,1,7) = 0 a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:36 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T R RNO CHANGE!RNse3 VALUE@date  @date(88,1,7) = 0 a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:36 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T U UNO CHANGE!UNte3 VALUE@date(  @date(88,1,7) = 0 a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:36 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T X XNO CHANGE!XNue3 VALUE@date(8  @date(88,1,7) = 0 a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:36 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T  \ \NO CHANGE!.\Nve3 VALUE@date(88  @date(88,1,7) = 0 a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:36 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T A_  N_NO CHANGE!`_Nwe3 VALUE@date(88,  @date(88,1,7) = 0 a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:36 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T tb  bNO CHANGE!bNxe3 VALUE@date(88,1  @date(88,1,7) = 0 a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:36 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T e  eNO CHANGE!eNye3 VALUE@date(88,1,  @date(88,1,7) = 0 a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:36 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T h  hNO CHANGE!hNze3 VALUE@date(88,1,7  @date(88,1,7) = 0 a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:36 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T  l   lNO CHANGE!2lNWe3 VALUE@date(88,1,7) a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:36 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T $o )1oNO CHANGE!CoN4e3 [W12] @DATE(88,1,7)READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 32149 Expenses 4 Air, rail, bus 450  450 5 Rental car 45 45 45 135 6 Dail 89 89 267 7 Meal 25 25 75 8 EnteGreat. Again, the date 75 75 9  10 serial number is displayed. 11 12 Tota2341591002 13 Less Advances 1200 14 Bala? 15 Bala 16 I'll help you out and enter the last date function for you.17 18 ? 19 020 21 Move the cell pointer once to the right.22 23 0Sun 21-Feb-88 5:36 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 000=s  )JsNO CHANGE!\s;Nf3 VALUEW a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 32149 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9 10 11 12 Total Expenses 6092341591002 13 Less Advances 1200 14 Balance Due To Employee -198 15 Balance Due From EmployeeThank you. 198 16 17 18 19 20 21 22 23 Sun 21-Feb-88 5:37 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T  v   vNO CHANGE!vPNf3 VALUE@date(88,1,8) a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 32149 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances  1200 14 Balance Due To Employee   -198 15 Balance Due From Employee Thank you.  198 16%   17%  18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:37 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T z @zNO CHANGE!%z%Nf3 [W12] @DATE(88,1,8)READY a b c d e f g h1 EXPENSE REPORT  2%  Total 3$ 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9 10 11 12 Total Expenses 591002 13 Less Advances 1200 14 Balance Due To Employee -198 15 Balan ce Due From Employee 198 16 17 18 19 20 21 22 23 Sun 21-Feb-88 5:37 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T J} W}NO CHANGE!i}6Nf3 [W12] @DATE(88,1,8)$READYAll three dates are now entered.  a b c d  e  f  g h1 EXPENSE REPORT  2&  Total 3$ 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9 10  11 12 Total Expenses Now let's add a label.591002 13 Less Advances 1200 14 Balance Due To Employee -198 15 Balance Due From Employee 198 16 17 &18 19 Use the Go To function to move20 21 the cell pointer to cell a3.22 23 &Sun 21-Feb-88 5:37 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph $T &&&&& ?NO CHANGE!wNf3 [W12] @DATE(88,1,8)POINTEnter address to go to: f3 a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9 10 11 12 Total Expenses 6092341591002 13 Less Advances 1200 14 Balance Due To Employee -198 15 Balance Due From EmployeeGo to a3. 198 16 17 18 19 20 21 22 23 Sun 21-Feb-88 5:41 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 5 BNO CHANGE!T Nf3 [W12] @DATE(88,1,8)EDIT Enter address to go to: a a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:41 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T t NO CHANGE! Nf3 [W12] @DATE(88,1,8)EDIT Enter address to go to: a3 a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:41 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  6NO CHANGE!ҋfNa3 READY a b c d e   f g h1 EXPENSE REPORT> 2B Total 3$ 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9 10 11  12 Total Expenses 1591002 13 Less Advances Enter the label,1200 14 Balance Due To Employee -198 15 Balance Due From EmployeeDate. 198 16 17 18 19 20 21 22 23 Sun 21-Feb-88 5:41 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 8 ENO CHANGE!WN\a3 LABEL D a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:41 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T I VNO CHANGE!hN]a3 LABEL Da a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:41 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T [ hNO CHANGE!zN^a3 LABEL Dat a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:41 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T n {NO CHANGE!N^a3 LABEL Date a b c d e f g h1 EXPENSE REPORT> 2B Total 3$ 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:41 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  5NO CHANGE!Na3 ' Date READY a b c d e f g h1 EXPENSE REPORT> 2B Total  3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9 10 11   12 Total Expenses 159 1002 13 Less Advances And finally, save 1200 14 Balance Due To Employee -198 15 Balance Due From Employeeyour worksheet. 198 16 17 18 19 20 21 22 23 Sun 21-Feb-88 5:42 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T $ 51NO CHANGE!CNa3 ' Date 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> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:42 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ˢ 5آNO CHANGE!XNa3 ' Date 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 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:42 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T B ONO CHANGE!a Na3 ' Date EDIT Enter save filename: ExpenseReport a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:42 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  ONO CHANGE!2Na3 ' DateMENU CancelReplaceCanceloperation;don'toverwritefile a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Sun 21-Feb-88 5:42 PM; Macro    Edit  Name Abs  Go To  Window Query Table  Calc  Graph T Ҭ @߬NO CHANGE!Na3 ' Date READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air=450 5 Ren135 6 DaiGood job! Note that you could have simply typed in the267 7 Mea 75 8 F5 d d 3 ~ You are going to cell d3. ~ ~~ ~~ ~ Dismiss this message and type '3' ... ~ ~~ 3 0x0A Return @ ShiftLeft 2 d d a a t t e e ( ShiftRight 9 8 8 8 8 , Comma 1 1 , Comma 6 6 ) ShiftRight 0 0x0A Return  RightArrow @ ShiftLeft 2 d d a a t t e e ( 8 8 , 1 , 7 ) 0x0A Return  time time time  F5 a a 3 ~~ ~ You are going to cell a3. ~ ~~ ~~ ~~ 3 0x0A Return D ShiftLeft d a ~ You are currently entering the label, Date. ~ ~~ ~~ ~~ ~~ t e 0x0A Return / Slash f f s s 0x0A Return r ~ You are saving your worksheet. To do so, ~ ~ select the Replace command to save your changes ~ ~ to the existing file. ~ ~~ ~~ r time2am c JHPN  &NO CHANGE!+NCalculating With FunctionsP6Arguments are always separated by a comma: ,@AVG(20,a4,c4..f4)PY2am }c JHPN   NO CHANGE!+}N]Calculating With FunctionsP6And, not all functions require arguments:5@TODAYPY2am c-  JHPN   9NO CHANGE!+NCalculating With FunctionsP#There is an advantage of usingfunctions rather than formulas.#PY2am c  JHPN  NO CHANGE!+NkCalculating With FunctionsPTake a look at the following formula:+c7+c7+c8+c9+c10+c11+c12PY=2am cW JHPN  ONO CHANGE!+NCalculating With FunctionsPTake a look at the following formula:+c7+c7+c8+c9+c10+c11+c12bNow, take a look at its equivalent function:@SUM(c7..c12)BPY=n B2am e JHPN   NO CHANGE!+N  @ MNO CHANGE!_Nhange how numbers, formulas and fayed in any given range of the woccomplished using the Range/Forma@  NO CHANGE!Nou can change how numbers, formulas and functionsre displayed in any given range of the worksheet.his is accomplished using the Range/Format comman`m  NO CHANGE!1N b c d  e f g You can change how numbers, formulas and functionsare displayed in any given range of the worksheet.This is accomplished using the Range/Format commands.6 ! 8 .ENO CHANGE!WNa1 READY a b c d e f g h1 2 3 4 95 6 You can change how numbers, formulas and functions 7 8 are displayed in any given range of the worksheet.9 10 This is accomplished using the Range/Format commands.11 12 913 14 15 16 17 18 19 20 21 22 23 Sun 21-Feb-88 5:43 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am eX JHPN   :NO CHANGE!+NCa1MENU FixedScientificCurrency,General+/-PercentDateTextHiddenResetFixednumberofdecimalpoints a b c d e f g h1 2 3 4 5 6 This is the Range/Format commands menu.7 8 As you can see, there are several9 10 different formats to choose from.11 12 +13 14 15 16 17 18 19 20 21 22 23 Sun 21-Feb-88 5:43 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph K]2am lf JHPN  NO CHANGE!+lNa1MENU FixedScientificCurrency,General+/-PercentDateTextHiddenResetFiednumberofdecimalpoints  a b c d e f g h1 2 3 4 +5 6 This is the Range/Format commands menu.7 8 As you can see, there are several9 10 different formats to choose from.11 12 The command menu shows formats from13 14Fixed to Reset.15 16 +17 18 19 20 21 22 23 Sun 21-Feb-88 5:43 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph K]'&&&&2am fC  JHPN  NO CHANGE!+Na1MENU FixedScientificCurrency,General+/-PercentDateTextHiddenResetFixednumberofdecimalpoints  a b c d e f g h1 2 3 4 +5 6 This is the Range/Format commands menu.7 8 As you can see, there are several9 10different formats to choose from.1112The command menu shows formats from1314Fixed to Reset.15 16 However, there is one more command17 18 not currently shown: Visible.19 20 +21 22 23 Sun 21-Feb-88 5:43 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph K]'&&&&&&&& NO CHANGE!Na1MENU Currency,General+/-PercentDateTextHiddenResetVisibleCellwilldisplayandprint a b c d e f g  h i1 2 3 4 +5 6 This is the Range/Format commands menu.7 8 As you can see, there are several9 10different formats to choose from.1112The command menu shows formats from1314Fixed to Reset.15 16 However, there is one more command17 18 not currently shown: Visible.19 20 +21 22 23 Sun 21-Feb-88 5:43 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ? ]'&&&&&&&&2am e+ JHPN  NO CHANGE!+Na1MENU Currency,General+/-PercentDateTextHiddenResetVisibleCellwilldisplayandprint a b c d e f g h i1 2 3 4 5 6 7 8 Press Next Page for a9 10description and example1112of each of the formats.131415 16 17 18 19 20 21 22 23 Sun 21-Feb-88 5:43 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ? ]2am ug  JHPN   HNO CHANGE!+uN a1MENU Fixed Scientific Currency , General +/- Percent Date Text Hidden ResetFied numbe of decima point    Displays the number of plussigns represented by a positivenumber and the number of minussigns represented by a negativenumber; can be used to create ahorizontal bar graphE.g., + represents 4,- represents -3Default format setting for all valuesDisplays values in Currency format, butwithout the dollar signE.g., 10,0.00, 9,9.99Displays values with a dollar sign and thespecified number of decimal places E.g., $100.00, $1,0.00 Displays values in exponential formatE.g., 2.15E+03, -4.67E-01Displays values with a fixed number of decimal places (from 0-15)E.g., 98.6, 25.99, 3.145K  2am bf JHPN  6NO CHANGE!+bN#a1MENU . +/- Percent Date Text Hidden Reset Visible Cell will diplay an prin    Causes hidden cells tobecome visibleResets cells back to thedefault format settingHides cell contents so that nothing isdisplayed in the worksheetDisplays the text of a formula instead of itsvalueE.g., @SUM(a1..e1), @AVG(c5..g5)Displays date serial numbers in several formatsE.g., 12/19, 10/14/88, 15-Feb-88 Displays values in percent formE.g., 20%, 18.2%- G  2am c- JHPN   CNO CHANGE!+NCalculatingWithFunctionsP:You used two of the many functions available, @SUM and @DATE.:[  Pp 2am 'd JHPN   NO CHANGE!+'NCalculatingWithFunctionsP:You used two of the many functions available, @SUM and @DATE.And these two may be the onlyfunctions that you ever use.:{  P---2am du JHPN  NO CHANGE!+NCalculatingWithFunctionsP:You used two of the many functions available, @SUM and @DATE.And these two may be the onlyfunctions that you ever use.Just remember, functions are simple to enter,and they make it easy for you to perform calculations,whether simple or complicated!:  P--2am =g JHPN   NO CHANGE!+N  @ 3MNO CHANGE!_Ng6 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 9 ! 10 11 Create a function that adds up the 12 Total Expenses 13 Less Advances Daily lodging expenses. Use the 1200 14 Balance Due To Employ -1200 15 Balance Due From Emplfunction, @SUM, to do this.1200 16 17 &18 19 20 21 Type @sum.22 23  Tue 16-Feb-88 10:41 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   )NO CHANGE!;NBg6 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 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  19 20 21 22 23 Tue 16-Feb-88 10:42 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  % NO CHANGE!7 N(g6 VALUE@s 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 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:42 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE! N)g6 VALUE@su 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 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:42 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!Ng6 VALUE@sum 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 , 9   10 The @SUM function returns the sum of the  11   12 Total Expensesarguments in the list. Arguments are  13 Less Advances   1200 14 Balance Due Toenclosed in parentheses ().   -1200 15 Balance Due Fr  1200 16 ,17 18 19 !20 21 Type the Left Parenthese.22 23 !Tue 16-Feb-88 10:42 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T    NO CHANGE!Ng6 VALUE@sum( 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 ( 9  10 There is only one argument, a range 11  12 Total Expensesconsisting of cells, d6 to f6. 13 Less Advances 1200 14 Balance Due ToEnter this range into your function.  -1200 15 Balance Due Fr 1200 16 (17 18 (19 20 Move the cell pointer to the f6.21 22 (23 Tue 16-Feb-88 10:42 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  $$ DNO CHANGE!"Nxf6 [W12] 89 POINT@sum(f6 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 Advan  ces4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 17 ,18 19 Anchor the cell pointer at cell, f6.20 21 ,22 23 Tue 16-Feb-88 10:42 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ,,, NO CHANGE!2Nf6 [W12] 89 POINT@sum(f6..f6 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 16 17 618 19 Now include cells, e6 and d6, into your range.20 21 622 23 Tue 16-Feb-88 10:54 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 666* 7NO CHANGE!IN:e6 [W12] 89 POINT@sum(f6..e6 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 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:54 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 3+ NO CHANGE!= Nd6 [W12] 89 POINT@sum(f6..d6 2 The range is defined a b c f g h1 EXPENSE REPORT and highlighted. 2  Total 3   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 16 %17 18 Complete the function by19 20 typing the Right Parentheses.21 22 %23 Tue 16-Feb-88 10:54 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph $%%%%%$  )$NO CHANGE!;$}Ng6 VALUE@sum(f6..d6)  0 Your function is complete.  a b c  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 16 17 18 19 Enter the function20 21 into your worksheet.22 23 Tue 16-Feb-88 10:55 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  ' 'NO CHANGE!'Ng6 @SUM(f6..d6) 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 267 7 Meals 25 25 25 8 Entertainment! 75 9  10 11 Good job. Now do the same 12 Total Expenses 13 Less Advances thing for the Meals expense. 1200 14 Balance Due To Employee -1200 15 Balance Due From Employee 1200 16 17 / 18  19 First, move the cell pointer down once. 20  21 / 22 23 Tue 16-Feb-88 10:55 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ///+ @+NO CHANGE!+Ng7 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 267 7 Meals 25 25 25 8 Entertainment! 75 9 10 11 & 12 Total Expenses  13 Less Advances Using the @SUM function again, 1200 14 Balance Due To Emp-1200 15 Balance Due From Ecalculate the total Meals expense. 1200 16 17 &18 219 20 First, type the at sign and function name.21 22 223 Tue 16-Feb-88 10:46 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 222O/ \/NO CHANGE!n/N-g7 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 267 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 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:46 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 62 C2NO CHANGE!U2N.g7 VALUE@s 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 267 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 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:46 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 5 +5NO CHANGE!=5N/g7 VALUE@su 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 267 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 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:46 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   8 8NO CHANGE!&8Ng7 VALUE@sum 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 267 7 Meals 25 25 25 8 Entertainment! 75 9 10 - 11 12 Total Expenses  Then, type in the argument, enclosed 13 Less Advances 1200 14 Balance Due To in parentheses.-1200 15 Balance Due Fro 1200 16 (The argument is the range of cells17 18 containing the Meals expense values.)19 20 -21 22 23 Tue 16-Feb-88 10:46 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ---------; ;NO CHANGE!<N/g7 VALUE@sum( 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 267 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 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:46 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T > >NO CHANGE!>N 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 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 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:46 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T A ANO CHANGE!AN@f7 [W12] 25 POINT@sum(f7..f7 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 267 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 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:56 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T D DNO CHANGE!DN@e7 [W12] 25 POINT@sum(f7..e7 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 267 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 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:56 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph TG GNO CHANGE!GN@d7 [W12] 25 POINT@sum(  f7..d7 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 267 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 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 10:56 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$J  JNO CHANGE!J!Nwg7 VALUE@sum(f7..d7) 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 267 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 16 17 18 (19 20 And finally, enter the function.21 22 (23 Tue 16-Feb-88 10:56 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T (((M NNO CHANGE!N(Nbg7 @SUM(f7..d7) 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 9 = 10    11 Good job! You have one more expense left to total, the  12 Tot   13 LesEntertainment expense. Since you are performing the same200 14 Bal  200 15 Balfunction, copy the function in cell g7 to cell g8. 200 16    17 = 18 +19 20 You should know by now how to copy.21 22 Start whenever you're ready.23 Tue 16-Feb-88 10:57 PM + Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T +++++ 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 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 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:04 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T U UNO CHANGE!UN]g7 @SUM(f7..d7) POINTEnter range to copy FROM: g7..g7 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 267 7 Meals 25 25 25 75 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 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:04 PM; Macro  Ed  it  Name Abs  Go To  Window Query Table  Calc  Graph T X XNO CHANGE!XNxg7 @SUM(f7..d7) POINTEnter range to copy FROM: g7..g7 Enter range to copy TO: g7j 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 267 7 Meals 25 25 25 75 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 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:05 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T \ \NO CHANGE!%\Njg8 POINTEnter range to copy FROM: g7..g7 Enter range to copy TO: g8j 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 267 7 Meals 25 25 25 75 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 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:05 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T *_ ?7_NO CHANGE!I_Ng7 @SUM(f7..d7) READY) ?  a b f g h1 EXPENSE REPORT Excellent! Now look at the 2  Total 3 function in cell g7. Expenses 4 Air, rail, bus 450 5 Rental car  45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 17 .18 19 Move the cell pointer down to cell g8.20 21 .22 23 Tue 16-Feb-88 11:05 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  ...b cNO CHANGE!c8Ng8 @SUM(f8..d8) READY) ?   a b f g h1 EXPENSE REPORT And look at the function 2  Total 3 in cell g8. Expenses 4 Air, rail, bus 450 5 Rental car  45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9  10 11 The functions are the same 12 Total Expenses 13 Less Advances except for the cell ranges: 1200 14 Balance Due To Employee -1200 15 Balance Due From Employeeg7 @SUM(f7..d7) 1200 16 g8@SUM(f8..d8)17 18 19 #20 21 Press Next Page to continue22 23 #Tue 16-Feb-88 11:05 PM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  Mg  6ZgNO CHANGE!lgNg8 @SUM(f8..d8) 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 !89 89 267 7 Meals 25 25 75 8 EntertNow calculate Total Expenses. 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 Use the Go To function19 20 to move to cell g12.21 22 23 Tue 16-Feb-88 11:05 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T j  & kNO CHANGE!kKNg8 @SUM(f8..d8) POINTEnter address to go to: g8 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses  13 Less Advances   1200 14 Balance Due To Employee  Go to g12.  -1200 15 Balance Due From Employee   1200 16   17   18  19N 20N 21N 22N 23N Tue 16-Feb-88 11:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T hn unNO CHANGE!nN]g8 @SUM(f8..d8) 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T q qNO CHANGE!qN^g8 @SUM(f8..d8) 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T t tNO CHANGE!tN]g8 @SUM(f8..d8) EDIT Enter address to go to: 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T w GwNO CHANGE!wNg12 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 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 19 Using the @SUM function, total all the expenses. 20 21 That is, add the values in the cell range, g8 to g4.22 23 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T Z~ g~NO CHANGE!y~N9g12 VALUE@s 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T M ZNO CHANGE!lN:g12 VALUE@su 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T A NNO CHANGE!`N;g12 VALUE@sum 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 6 CNO CHANGE!UN:g12 VALUE@sum( 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 4  5 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T * 7NO CHANGE!IN=g11 POINT@sum(g11 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ! .NO CHANGE!@N=g10 POINT@sum(g10 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  %NO CHANGE!7N;g9 POINT@sum(g9 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!,NIg8 @SUM(f8..d8) POINT@sum(g8 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE!/NMg8 @SUM(f8..d8) POINT@sum(g8..g8 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 3 17 1   18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  $NO CHANGE!6NMg7 @SUM(f7..d7) POINT@sum(g8..g7 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  # 0NO CHANGE!BNMg6 @SUM(f6..d6) POINT@sum(g8..g6 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   4 ANO CHANGE!SNKg5 +f5+e5+d5 POINT@sum(g8..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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:08 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T    H UNO CHANGE!gNKg4 +f4+e4+d4 POINT@sum(g8..g4 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:09 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T     a  nNO CHANGE!NAg12 VALUE@sum(g8..g4) 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses< 13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 3 17 1 18N 19N 20N 21N 22N 23N Tue 16-Feb-88 11:09 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   \  !iNO CHANGE!{N1g12 @SUM(g8..g4) 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9  10 Notice that the two 11  12 Total Expenses balances changed from 1002 13 Less Advances  1200 14 Balance Due To Employee -1200 and 1200 to -198 -198 15 Balance Due From Employee 198 16 and 198, respectively.17 18 19 You're doing great!20 21 22 Press Next Page to continue23 Tue 16-Feb-88 11:09 PM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T %  %%%% NO CHANGE!N8g12 @SUM(g8..g4) 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9  10  11  12 Total Expenses   1002 13 L 1200 14 B -198 15 BLast but not least,   198 16 17 sum up the expenses by%18 19 column. To do this,Copy the function in cell g1220 21 use the Copy command.to cells, f12, e12 and d12.22 23 %Tue 16-Feb-88 11:09 PM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T %%%%% NO CHANGE!dNg12 @SUM(g8..g4) 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> 2B Total 3B Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses3 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 10:51 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ! O.NO CHANGE!@Nag12 @SUM(g8..g4) POINTEnter range to copy FROM: g12..g12W 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses3 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 10:52 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T < INO CHANGE![N}g12 @SUM(g8..g4) POINTEnter range to copy FROM: g12..g12 Enter range to copy TO: g12g 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses3 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 10:52 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T s NO CHANGE! Nnf12 POINTEnter range to copy FROM: g12..g12 Enter range to copy TO: f12g 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses3 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 10:52 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!Nsf12 POINTEnter range to copy FROM: g12..g12 Enter range to copy TO: f12..f12b 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses3 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 10:52 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!Nse12 POINTEnter range to copy FROM: g12..g12 Enter range to copy TO: f12..e12b 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses3 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 10:52 AM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T NO CHANGE!Nd12 POINTEnter range to copy FROM: g12..g12 Enter range to copy TO: f12..d12b 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses3 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 10:53 AM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$2 &?NO CHANGE!QNg12 @SUM(g8..g4) 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 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Le1200 14 Ba-198 15 BaExcellent. Now take 198 16 17 a look at the functions18 Move cell pointer once19 you just copied.20 to the left.21 22 23 Mon 22-Feb-88 10:53 AM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE! !N8f12 [W12] @SUM(f8..f4)READY" @ % a b f g h1 EXPENSE REPORT The function was copied, 2  Total 3 but notice that the range Expenses 4 Air, rail, bu 450 5 Rental car now reflects a new range 45 45 135 6 Daily lodging 89 89 267 7 Meals of cells. 25 25 75 8 Entertainment 75 75 9  10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16 17 018 19 Move cell pointer once more to the left.20 21 022 23 Mon 22-Feb-88 10:53 AM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph " 000A  NNO CHANGE!`Ne12 [W12] @SUM(e8..e4)READY 7 1  d e f g h1 EXPAgain, the function * 2  Total 3 reflects a new range Expenses 4 A 450 450 5 Rof cells. 45 45 45 135 6 D 89 89 89 267 7 M 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16 17 18 Move cell pointer to the19 20 left one last time.21 22 23 Mon 22-Feb-88 10:54 AM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 3       O  \NO CHANGE!n=Nfd12 [W12] @SUM(d8..d4)!READY  a b c d eSame function, h1 EXPENSE REPORT 2 different range.l 3 nses 4 Air, rail, bus450  450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment 75 75 9 10 11  12 Total Expenses 609 234 159 1002 13 Less Advances 1200 14 *-198 15 One last thing: You may have noticed 198 16 17 this message suddenly appear. This is18 Press Next Page19 just CT-Mail doing its job!20  to continue21 22 23 Mon 22-Feb-88 10:54 AM  You have mail Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph /  ***** f h ~ The Format command menu is displayed. ~ ~ To hide the value, select Hidden. ~ ~~ ~~ ~ Dismiss this message and type 'h'. ~ h 0x0A Return timetime @ ~ You are currently typing in the function, ~ ~~ ~ @SUM ~ ~~ ~ Dismiss this message and type '@' ... ~ ShiftLeft 2 s ~ You are currently typing in the function, ~ ~~ ~  @SUM ~ ~~ ~ Dismiss this message and type 's' ... ~ s u ~ You are currently typing in the function, ~ ~~ ~ @SUM ~ ~~ ~ Dismiss this message and type 'u' ... ~ u m ~ You are currently typing in the function, ~ ~~ ~ @SUM ~ ~~ ~ Dismiss this message and type 'm'. ~ m ( ShiftRight 9  ~ Use the Left Arrow to move the cell pointer ~ ~~ ~ one cell to the left. ~ ~~ ~ Dismiss this message and press Left Arrow. ~ LeftArrow . ~ To anchor the cell pointer, type a period. ~ ~~ ~~ ~~ ~ Dismiss this message and type '.'. ~ Period  LeftArrow  LeftArrow ) ShiftRight 0 0x0A Return DownArrow @ ~ You are to type in the @SUM function. ~ ~~ ~~ ~~ ~ Dismiss this message and type '@' ... ~ ShiftLeft 2 s ~ You are currently typing in the function, ~ ~~ ~  @SUM ~ ~~ ~ Dismiss this message and type 's' ... ~ s u ~ You are currently typing in the function, ~ ~~ ~ @SUM ~ ~~ ~ Dismiss this message and type 'u' ... ~ u m m ( ~ Your argument is (f7..d7). ~ ~ ~ ~ First, type the left parentheses. ~ ~~ ~ Dismiss this message and type '('. ~ ShiftRight 9  ~  Now define your argument, f7..d7. ~ ~ Use the Left Arrow to move the cell pointer ~ ~ to cell f7. ~ ~ ~ ~ Dismiss this message and press Left Arrow. ~ LeftArrow . ~ Anchor the cell pointer at f7. ~ ~ Use the Left Arrow to move the cell pointer ~ ~ To do this, type a period. ~ ~ ~ ~ Dismiss this message and type '.'. ~ Period  ~ Use the Left Arrow to define the rest of the ~ ~~ ~ range, f7..d7. ~ ~~ ~ Dismiss this message and press the Left Arrow. ~ LeftArrow  ~ You have one more cell to include in your range. ~ ~~ ~ ~ ~~ ~ Dismiss this message and press Left Arrow. ~ LeftArrow ) ~Your argument is defined. Complete the function ~ ~ ~ ~ by typing the right parentheses. ~ ~~ ~ Dismiss this messagea and type ')'. ~ ShiftRight 0 0x0A Return / Slash c c 0x0A Return DownArrow 0x0A Return DownArrow 0x0C  F5 g g 1 1 2 2 0x0A Return @ ~ Since you are using2am ez  JHPN   'NO CHANGE!+N  @ 'MNO CHANGE!_Nating With FunctionsCPp  'NO CHANGE!)\N&ating With FunctionsCCCWe already discufunctions.2am d JHPN  'NO CHANGE!+NbCalculatingWithFunctionsP6Functions are organized into the following groups:Arithmetic and StatisticalDateFinancialLogicalLookup, Choose, and IndexText and LabelsTrigonometricDatabase6  Pp2am cM JHPN   CNO CHANGE!+NCalculatingWithFunctionsPK7There are many functions available to you,however, you will probably use just a select group.7  Pp2am d| JHPN   NO CHANGE!+NCalculatingWithFunctionsP:And, depending on the complexity of your calculations,using functions rather than formulas may be the better choice for you.:  Pp2am kd  JHPN  NO CHANGE!+kNCalculatingWithFunctionsPIn this lesson, you will learnwhat a function iswhat functions are availablewhat a function looks likehow to enter functions into your worksheethow to use the @SUM functionhow to use the @DATE function  P****"*02am c P GCalc>Functn>I.1!GCalc>Functn>I.29GCalc>Functn>I.3QGCalc>Functn>I.4iGCalc>Functn>I.5GCalc>Functn>Def.1GCalc>Functn>Def.2GCalc>Functn>Def.3GCalc>Functn>Def.4GCalc>Functn>Def.5GCalc>Functn>Def.6GCalc>Functn>Def.77GCalc>Functn>Def.8QGCalc>Functn>Def.9kGCalc>Functn>Def.10GCalc>Functn>Def.11GCalc>Functn>Def.12GCalc>Functn>Def.13GCalc>Functn>Def.14GCalc>Functn>Def.15 GCalc>Functn>Def.16(GCalc>Functn>Def.17CZCarla.fontVZSD.fontfGCalc>Functn>Seg.1GCalc>Functn>Seg.2GCalc>Functn>Seg.3GCalc>Functn>Seg.4GCalc>Functn>Seg.5GCalc>Functn>Seg.6XCalc>Functn>EntZSD.font*ZCarla.font=Gcalc>functn>qseg1WCalc>Functn>MC12am d  JHPN  CNO CHANGE!+N-QuestionCalculating With FunctionsP@MWhich of the following is not a formula:UCLHTF1 - a1-a2OIF2 - @SUM(a1..a3)IPF3 - 10-a3CLF4 - They are all formulasEEF5 - None of the above(Select your answer by pressing one of the indicated selections)P00j ))@2am c P Calc>Functn>MC2 2am e JHPN  CNO CHANGE!+NCalculating With FunctionsPTWhich of the following is not a formula:Correct! a1-a2 is notF1 - a1-a2a formula. In order F2 - @SUM(a1..a3)for it to be a F3 - 10-a3formula, you must F4 - They are all formulasprecede the first cellF5 - None of the abovereference with a plussign, in other words,+a1-a2.P002am $c P  GCalc>Functn>MC1.correct)$LCalc>Functn>MC1.common.path2am $c P "GCalc>Functn>MC1.incorrect+$LCalc>Functn>MC1.common.path2am $c  P "GCalc>Functn>MC1.incorrect+$LCalc>Functn>MC1.common.path2am $c P "GCalc>Functn>MC1.incorrect+$LCalc>Functn>MC1.common.path2am $c P "GCalc>Functn>MC1.incorrect+$LCalc>Functn>MC1.common.path2am ;e JHPN  CNO CHANGE!+;NCalculating With FunctionsPTWhich of the following is not a formula:l F1 - a1-a2 F2 - @SUM(a1..a3)F3 - 10-a3F4 - They are all formulasF5 - None of the aboveFThat's incorrect. The correct answer is F1. a1-a2 is not aformula. In order for it to be a formula, the first cell reference must be preceded by a plus sign, in other words, +a1-a2.FP00j  FFFFF 2am 2c N 2 F1  F2  F3  F4  F5 2am d& JHPN  CNO CHANGE!+NQuestion Calculating With FunctionsP@MHow many arguments are in the function,U@SUM(1300,c3,a4..c4,(+a2+a4))CLHTF1 - 4OIF2 - 6IPF3 - 8CLF4 - None of the aboveEE(Select your answer by pressing one of the indicated selections)P000  1  )@2am c P ZCarla.fontZSD.font,XCalc>Functn>DateEZSD.fontUZCarla.fonthGcalc>functn>qseg1Calc>Functn>MC32am e JHPN  CNO CHANGE!+N9Calculating With FunctionsPTHow many arguments are in the function,@SUM(1300,c3,a4..c4,(+a2+a4))$F1 - 4F2 - 6 F3 - 8Correct! There areF4 - None of the above4 arguments: 1300,c3, a4..c4, and(+a2+a4).DP0001    M2am $c P  GCalc>Functn>MC2.correct)$LCalc>Functn>MC2.common.path2am $c P "GCalc>Functn>MC2.incorrect+$LCalc>Functn>MC2.common.path2am $c P "GCalc>Functn>MC2.incorrect+$LCalc>Functn>MC2.common.path2am $c  P "GCalc>Functn>MC2.incorrect+$LCalc>Functn>MC2.common.path2am Ie JHPN  CNO CHANGE!+INCalculating With FunctionsPTHow many arguments are in the function,@SUM(1300,c3,a4..c4,(+a2+a4))F1 - 4F2 - 6F3 - 8F4 - None of the above@That's incorrect. The correct answer is F1. There are 4arguments: 1300, c3, a4..c4, and (+a2+a4). Arguments canbe numeric values, cell references, cell ranges or formulas.@P0001@@@@@@@2am +c N + F1  F2  F3  F4 2am d; JHPN  CNO CHANGE!+NJQuestion Calculating With FunctionsPThe value that the @DATE functionM calculates is calledUCLHTF1 - the date serial numberOIF2 - the date format numberIPF3 - the MM-DD-YY valueCLF4 - None of the aboveEE(Select your answer by pressing one of the indicated selections)P+&+++       @ 2am c P GCalc>Functn>E.1!GCalc>Functn>E.29GCalc>Functn>E.3QGCalc>Functn>Rev.1kGCalc>Functn>Rev.2GCalc>Functn>Rev.3NCalc>Menu2am Be JHPN  CNO CHANGE!+BNCalculating With FunctionsPThe value that the @DATE function calculates is calledj F1 - the date serial numberF2 - the date format number F3 - the MM-DD-YY valueCorrect. The valueF4 - None of the abovethat the @DATEfunction calculatesis called the dateserial number.P+&+++    2am $c P  GCalc>Functn>MC3.correct)$LCalc>Functn>MC3.common.path2am $c  P "GCalc>Functn>MC3.incorrect+$LCalc>Functn>MC3.common.path2am $c P "GCalc>Functn>MC3.incorrect+$LCalc>Functn>MC3.common.path2am $c P "GCalc>Functn>MC3.incorrect+$LCalc>Functn>MC3.common.path2am .e JHPN  CNO CHANGE!+.NCalculating With FunctionsPThe value that the @DATE function calculates is called'F1 - the date serial numberF2 - the date format numberF3 - the MM-DD-YY valueF4 - None of the above&That's incorrect. The correctanswer is F1. The @DATE functioncalculates the date serial number.&P+&+++&&&&&&& 2am +c N + F1  F2  F3  F4 2am qe JHPN  NO CHANGE!+N'! ONO CHANGE!qN1Calculating With Functions5A function is a "built-in formula" thatmakes it easy for you to calculate values.A function begins with the at sign (@).۫'Functions can also begin with any oneof the following characters: + - $ (!In this tutorial, the at sign (@) is used.The format of a function is@FUNCTION(arguments).Arguments can be values, cell references,ranges, formulas, or labels.5 >, 2am fe JHPN   5NO CHANGE!+fNCalculating With Functions5Arguments are always separated by a comma.Not all functions require arguments.'Enter functions in the same way that youױ!would enter formulas, labels and values.The @SUM function returns the sum of thearguments in the list.The @DATE function returns a date serialnumber from the year, month and day usedin the argument.5 7N  2am Zf JHPN  6NO CHANGE!+ZN~CalculatingWithFunctions5Argumentsarealwaysseparatedbyacomma.Youhavereachedtheendofthislesson,andtheNot all functionsrequirearguments. end of the Calc section.WesuggestyouproceedEnter functionsinthesamewaythatyoutothenextsection,wouldenterformulas,labelsandvalues.Formatting Your Worksheet.The @SUM functionreturnsthesumofthePressNextPagetoreturnargumentsinthelist.totheCalcmenu.The @DATE functionreturnsadate serialnumberfromtheyear,monthanddayusedintheargument.555  "555 555 55555  55555   5 %552am Lf JHPN  NO CHANGE!+LNg6 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 10 11 12 Total Expenses 13 Less Advances 1200 14 Balance Due To Employee -1200 15 Balance Due From Employee 1200 16  17 18 This is what your worksheet 19 20 currently looks like. 21 22  23N Tue 16-Feb-88 10:41 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am cf JHPN  NO CHANGE!+cNg6 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3 =Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 H7 Meals 25 25 25  8 Entertainment  75  9 +  10 , 11 12 Total ExpensesLet's take a look at what you've done so far. 13 Less Advances 14 Balance Due To EmployeFirst, you calculated to tal values for the 15 Balance Due From Emplo 16 first two expenses.17 18 119 20 21 22 23 Tue 16-Feb-88 10:41 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T2am Zf JHPN   NO CHANGE!+ZNg6 READY a b c d e f g h1 EXPENSE REPORT> 2 * Total 3  Expenses 4 Air, railThen, you entered a value for Advances 450 5 Rental ca 45 135 6 Daily lodand created formulas to calculate the 89 7 Meals 25 8 Entertainappropriate balances.  9  10 *  11  12 G13 Less Advances4 1200 14 Balance Due To Employee) -1200 15 Balance Due From Employee( 1200 16 G17 18 19 20 21 22 23 Tue 16-Feb-88 10:41 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am f. JHPN  GNO CHANGE!+Ng6 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 9 - 10 - 11 - 12 Total Expenses  - 13 Less Advances $ 1200 14 Balance Due To Emp#1200 15 Balance Due From E 1200 16 Now, you are going to total the remaining  17 -  18 expenses, and calculate Total Expenses.  19 -  20 - 21  22  23N Tue 16-Feb-88 10:41 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph TJJ -  2am Nf  JHPN  NO CHANGE!+NNg6 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 10 11 12 Total Expenses 13 Less Advances  1200 14 Balance Due To Employee -1200 15 Balance Due From Employee 1200 16 ( 17 18 Only this time, you are going to use 19 ( 20 functions instead of formulas. 21 ( 22 ( 23N Tue 16-Feb-88 10:41 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am Bg JHPN  NO CHANGE!+BNpg6 READY a b c d e f g h1 EXPENSE REPORT> 2 5Total 3 Expenses 4 Air, rBefore we start, let me mention two things: 450 5 Rental 135 6 Daily 7 Meals 1) Enter functions the same way you enter 8 Entert 9  formulas, text and numbers. 10 11 12 Total 13 Less A2) It was stated earlier that functions begin 1200 14 Balanc -1200 15 Balancwith the at sign (@). Functions can also 1200 16 17 begin with any one of the following 18 19 characters:+-$( 20 21  You will use the at sign (@) in this lesson. 22 23 5 Tue 16-Feb-88 10:41 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T , 2am fy JHPN   NO CHANGE!+Nja1MENU Fixed Scientific Currency , General +/- Percent Date Text Hidden ResetFixed number of decimal points9 a b c d e f g h1A 2 3 4 5 6 -7 8 Note that formatting is for display only.9 10 Calculations performed on values ignore11 12 any rounding or other formatting that13 14 appears to change the full value.15  16 -17 18 19 20 21 22 23 Sat 20-Feb-88 11:50 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am eR JHPN  8NO CHANGE!+NCa1MENU Fixed Scientific Currency , General +/- Percent Date Text Hidden ResetFixed number of decimal points9 a b c d e f g h1A 2 3 "4 5 The formats that will be6 7 introduced in this lesson are:8 9 10 Currency11 12 Date13 14 Hidden15 16 Reset17 18 "19 20 21 22 23 Sat 20-Feb-88 11:50 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ]2am %c P Gformat>some>FIB1.a003'%Lformat>some>FIB1.common.patho  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T % %%%% Entfollowing labels for your dates: 1/6/88, 1/7/88, 1/8/88. 75 9  10 Two reasons for using the @DATE function are: 11  12 Tot1) You can use the Range/Format/Date command, which002 13 Les200 14 Balgives you several different choices for displaying 198 15 Bal198 16 the date in your worksheet, and17 18 2) You can perform date arithmetic, for example, to19 20 calculate the total number of day ------- 2am ag JHPN  NO CHANGE!+aNRd3 (D4) [W12] @DATE(88,1,6)READY a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16 17 -18 19 You've just learned how to format numbers20 21 using the Range/Format command menu.22 23 -Mon 22-Feb-88 5:34 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ++++++++++++2am g JHPN  FNO CHANGE!+N'd3 (D4) [W12] @DATE(88,1,6)READY a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16 17 418 19 You are now going to learn how to format labels.20 21 422 23 Mon 22-Feb-88  5:34 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 00000000000 02am eW JHPN  ANO CHANGE!+N0a1READY a b c d e f g1 2 <3 4 You can format the way labels are displayed in a column.5 6 Labels are displayed in one of three ways:7 8 <9 10 (1)(2)(3)11 12 LeftCenterRight13 14 15 JanuaryFebruaryMarch16 17 18 %19 20 This is known as label alignment.21 22 %23 Mon 22-Feb-88 5:34 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T    2am Ve JHPN   2NO CHANGE!+VNa1READY a b c d e f g1 2 $3 4 All labels are left-aligned when5 6 first entered into a worksheet.7 8 $9 10 (1)11 12 Left13 14 15 January16 February17 March18 April19 20 21 22 23 Mon 22-Feb-88 5:34 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am e#  JHPN  .NO CHANGE!+Na1READY a b c d e f g1 2 3 4 5 3 6 7 To change label alignment, there are two ways:8 9 10 1)Use the Range/Label-Prefix command menu11 12 2)Enter the label preceded by a label-prefix13 14 character15 16 317 18 19 20 21 22 23 Mon 22-Feb-88 5:34 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  2am Of JHPN   4NO CHANGE!+ONa1 MENU Left Right Center= Align labes with left edges of cells2 a  b c d e f g h i1 @ 2 3 Let's look at the first way:4 5 the Range/Label-Prefix command menu6 7 48 9 The Range/Label-Prefix command menu gives you10 11 three alignment choices, Left, Right and Center.12 13 You select the desired alignment as well as the14 15 range of cells to align.16 17 418 19 20 21 22 23 Mon 22-Feb-88 5:48 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  ]###2am d% JHPN  ONO CHANGE!+NFormatting Your WorksheetPThe second way to align a label is to entera label preceded by a label-prefix character.3The following label-prefix characters determinethe way a label is to be aligned in a column:'= Left"= Right ^= Center\= Repeat3P---B2am *e  JHPN  ONO CHANGE!+*NFormattingYourWorksheetPThe second way to align a label is to entera label preceded by a label-prefix character.3The following label-prefix characters determinethe way a label is to be aligned in a column:'= Left"= Right ^= Center\=RepeatThe Repeat label-prefix character repeats alabel in the cell as many times as it can fit. 3  P---B2am pe JHPN  NO CHANGE!+^N(FormattingYourWorksheetPThe second way to align a label is to entera label preceded by a label-prefix character.3The following label-prefix characters determinethe way a label is to be aligned in a column:'= Left"= Right ^= Center\=RepeatThe Repeat label-prefix character repeats alabel through the entire cell.4To use a label-prefix character, enter the label  P--- ONO CHANGE!HNFormattingYourWorksheetPThe second way to align a label is to entera label preceded by a label-prefix character.3The following label-prefix characters determinethe way a label is to be aligned in a column:'= Left"= Right ^= Center\=Repeat4To use a label-prefix character, enter the labelin the normal way, but in addition, type the  P--- NO CHANGE!pN:FormattingYourWorksheetPThe second way to align a label is to entera label preceded by a label-prefix character.3The following label-prefix characters determinethe way a label is to be aligned in a column:'= Left"= Right ^= Center4To use a label-prefix character, enter the labelin the normal way, but in addition, type theappropriate label-prefix before the label.4  P---2am g@  JHPN  NO CHANGE!+Nd3 (D4) [W12] @DATE(8 READY . Here is your expense report.  a b  f g 1 EXPENSE REPORT  2B Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:53 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph   NO CHANGE!eNd3 (D4) [W12] @DATE(8 READYHere is your expense report. a b  f g 1 EXPENSE REPORT  2B Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car )6 Daily lodging 7 Meals Take a look at your labels. Most of8 Entertainment 9" them do not need to be realigned.10! 11! You could, however, center the label,12 Total Expenses 13 Less Advances Total Expenses, in column g.14 Balance Due To Employee 15 Balance Due From EmployeeGo ahead and do that.16 17 )18 *19 20 First, use the Right Arrow to move 21 22 the cell pointer to cell g3.23 Mon 22-Feb-88 5:53 PM * Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  *****H U NO CHANGE!g eNe3 (D4) [W12] @DATE(88,1,7)READY a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:57 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE! eNf3 (D4) [W12] @DATE(88,1,8)READY a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:57 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T P  ]NO CHANGE!oN:g3 [W12] 'Expenses READY O D  d e f g 3 The label-prefix& Total 01/06/88 01/07/88  01/08/88 Expenses character indicates $450.00 $450.00  $45.00 $45.00 $45.00 $135.00 that "Expenses" is $89.00 $89.00 $89.00 $267.00  $25.00 $25.00 $25.00 $75.00 currently left-aligned. $75.00 $75.00 3 3 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances $1,200.00 14 Balance Due To Employee 15 Balance Due From Employee $198.00 16 17 .18 19 Select the Range/Label/Center command.20 21 .22 23 Mon 22-Feb-88 5:58 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 3 ...U bNO CHANGE!tNOg3 [W12] 'Expenses MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:58 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ] jNO CHANGE!|N+g3 [W12] 'Expenses MENU Format Label Erase Name Justify Protect Unprotect Input Value TransposeFormat one or more cells? a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:58 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T A ONNO CHANGE!`N g3 [W12] 'Expenses MENU Left Right Center= Align labels with left edges of cells2 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances $1,200.00 14 Balance Due To Employee 15 Balance Due From Employee $198.00 16 17 18 19 20 21 22 23 Mon 22-Feb-88 5:58 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ! -!NO CHANGE!&! NWg3 [W12] 'Expenses POINTEnter range of labels: g3..g3 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00  $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances $1,200.00 14 Balance Due To Employee 15 Balance Due From Employee $198.00 16 #17 18 Use the Up Arrow to include19 20 cell g2 in your range.21 22 #23 Mon 22-Feb-88 5:58 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T #####0% =%NO CHANGE!O%Nfg2 [W12] 'Total POINTEnter range of labels: g3..g2Your range is defined. a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances $1,200.00 14 Balance Due To Employee 15 Balance Due From Employee $198.00 16 17 18 *19 20 Press Return to center the labels.21 22 *23 Mon 22-Feb-88 5:59 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  ***d) Fq)NO CHANGE!)Ng3 [W12] ^Expenses READY a  b c d e f g 1 EXPENSEREPORT 9 2 / Total 3 Date  01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Re 45.00 $45.00 $45.00 $135.00 6 Da89.$267.00 7 MeNotice the label-prefix25. $75.00 8 En Now, use the repeat label $75.00 9 character for centered 10  prefix to draw a line 11 labels is displayed. 12 To09.between rows 3 and 4. To,002.00 13 Le,200.00 14 Balance Due To Employee do this, first insert a 15 Balance Due From Employee$198.00 16 blank row above column 4. 17 18 19 820 21 First, move the cell pointer down once to row 4.22 23 8Mon 22-Feb-88 5:59 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 888J. @W.NO CHANGE!i.-Nug4 (C2) [W12] +f4+e4+d4 READY a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $.00 $75.00 8 Entertainment $75.00 9 Remember that blank rows are 10  11 inserted above the cell pointer. 12 Total Expenses .00 $1,002.00 13 Less Advances $$1,200.00 14 Balance Due To Employee 15 Balance Due From Employee $198.00 16 17 $18 19 Use the Worksheet/Insert/Row20 21 command to insert a row.22 23 $Mon 22-Feb-88 6:03 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  $$$$$2 2NO CHANGE!2NSg4 (C2) [W12] +f4+e4+d4 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:03 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 6 6NO CHANGE!6N6g4 (C2) [W12] +f4+e4+d4 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Specify global worksheet parameters4 a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:03 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T : :NO CHANGE!:Ng4 (C2) [W12] +f4+e4+d4 MENU Column RowE Insert one or more columns to the left of the current cell a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:04 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T Y> 4f>NO CHANGE!x>Ng4 (C2) [W12] +f4+e4+d4 "POINTEnter row insert range: g4..g4 The prompt displays the number,  a b c of rows you want to insert. g 1 EXPENSE REPORT " 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals " $75.00 8 Entertainment $75.00 9" The current range shows that 10! 11! only one row will be inserted. 12 Total Expenses ,002.00 13 Less Advances ",200.00 14 Balance Due To Employee 15 Balance Due From Employee$198.00 16 17 18 This is what you want,19 20 so press Return.21 22 23 Mon 22-Feb-88 6:04 PM Macro   Edit  Name Abs  Go To  Window Query Table  Calc  Graph ""#"  B  # CNO CHANGE!C;Nug4 "READYAnd the row has been inserted. a b c   g 1 EXPENSE REPORT  " 2 * Total 3 Date  01/06/88 01/07/88 01/08/88 Expenses 4O 5 Air, rail, bus $450.00 $450.00 6 Rental ca7135.00 7 Daily lod267.00 8 Meals Now, draw a line from cell g4 to cell a4.$75.00 9 Entertain$75.00 10 To do this, first use the repeating label-prefix 11  12 character (\) followed by the hyphen character (-). 13 Total Exp002.00 14 Less Adva7200.00 15 Balance Due To Employee 16 Balance Due From Employee $198.00 17 18 !19 20 Enter the label,\-.21 22 !23 Mon 22-Feb-88 6:04 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph "" " WG dGNO CHANGE!vGPNg4 LABEL\ a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4O 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:05 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T J JNO CHANGE!JONg4 LABEL\- a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4O 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:05 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 4N OANNO CHANGE!SN)Ndg4 [W12] \- READY a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 48  - 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 67.00 8 Meals $25.00 75.00 9 Entertainment The hyphen is repeated75.00 10)  11) through the entire cell. 12)  13 Total Expenses $609.00 02.00 14 Less Advances $1,200.00 15 Balance Due To Employee 16 Balance Due From Employee $198.00 17 18 619 20 Then, draw the rest of the line by copying the21 22 contents of this cell to cells, f4 to a4.23 Mon 22-Feb-88 6:05 PM 6 Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  66666|R RNO CHANGE!RNLg4 [W12] \- MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4B - 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:05 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T V VNO CHANGE!V|Ng4 [W12] \- POINTEnter range to copy FROM: g4..g4 a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4B - 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T Z )ZNO CHANGE!;ZNg4 [W12] \- POINTEnter range to copy FROM: g4..g4 Enter range to copy TO: g4j a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4B - 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00  10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ] ]NO CHANGE!]Nf4 POINTEnter range to copy FROM: g4..g4 Enter range to copy TO: f4j a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4B - 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ~a aNO CHANGE!aNf4 POINTEnter range to copy FROM: g4..g4 Enter range to copy TO: f4..f4f a b c  d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4B - 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T .e ;eNO CHANGE!MeNe4 POINTEnter range to copy FROM: g4..g4 Enter range to copy TO: f4..e4f a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4B - 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:06 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph Th hNO CHANGE!hNd4 POINTEnter range to copy FROM: g4..g4 Enter range to copy TO: f4..d4f a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4B - 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$l lNO CHANGE!lNc4 POINTEnter range to copy FROM: g4..g4 Enter range to copy TO: f4..c4f a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4B - 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T->p KpNO CHANGE!]pNb4 POINTEnter range to copy FROM: g4..g4 Enter range to copy TO: f4..b4f a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4B - 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Enter tainment $75.00 $75.00 10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T6s sNO CHANGE! tNa4 POINTEnter range to copy FROM: g4..g4 Enter range to copy TO: f4..a4f a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4B - 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:07 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph TCw wNO CHANGE!w+N}g4 [W12] \- READY a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10N 11 $ 12  13 Total Expenses Good job. Remember that you can $1,002.00 14 Less Advances $1,200.00 15 Balance Due To Employerepeat any character in a cell. 16 Balance Due From Emplo $198.00 17 Draw another line in row 10.18 19 $20 21 22 First, Go To cell a10.23 Mon 22-Feb-88 6:07 PM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T { #{NO CHANGE!|Ng4 [W12] \- POINTEnter address to go to: g4 a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17 18 19 Go to a10.20 21 22 23 Mon 22-Feb-88 6:12 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!wNg4 [W12] \- EDIT Enter address to go to: a a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To  Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:12 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T P ]NO CHANGE!oxNg4 [W12] \- EDIT Enter address to go to: a1 a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:12 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!wNg4 [W12] \- EDIT Enter address to go to: a10 a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:12 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T } NO CHANGE!N a10 READY a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances $1,200.00 15 Balance Due To Employee 16 Balance Due From Employee $198.00 17 18 '19 20 Repeat the hyphen in this cell.21 22 '23 Mon 22-Feb-88 6:12 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T '''M ZNO CHANGE!lQNa10 LABEL\ a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:12 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  ʑNO CHANGE!ܑPNa10 LABEL\- a b  c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10N 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:12 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T , @9NO CHANGE!KNa10 \- READY a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 -C 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances $1,200.00 15 Balance Due To Employee 16 Balance Due From Employee $198.00 17 18 019 20 And copy this cell to cells, b10 to g10.21 22 023 Mon 22-Feb-88 6:12 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 000 NO CHANGE!.NLa10 \- MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 -C 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:13 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!/zNa10 \- POINTEnter range to copy FROM: a10..a10 a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 -C 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:13 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!ȠNa10 \- POINTEnter range to copy FROM: a10..a10 Enter range to copy TO: a10g a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00  7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 -C 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:13 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ^ kNO CHANGE!}Nb10 POINTEnter range to copy FROM: a10..a10 Enter range to copy TO: b10g a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 -C 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:13 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE!2Nb10 POINTEnter range to copy FROM: a10..a10 Enter range to copy TO: b10..b10b a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 -C 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:14 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ͫ ګNO CHANGE!Nc10 POINTEnter range to copy FROM: a10..a10 Enter range to copy TO: b10..c10b a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 -C 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:14 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T NO CHANGE!Nd10 POINTEnter range to copy FROM: a10..a10 Enter range to copy TO: b10..d10b a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 -C 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16  Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:14 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph TA NNO CHANGE!`Ne10 POINTEnter range to copy FROM: a10..a10 Enter range to copy TO: b10..e10b a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 -C 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:14 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T* NO CHANGE!Nf10 POINTEnter range to copy FROM: a10..a10 Enter range to copy TO: b10..f10b a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 -C 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:14 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T6 ºNO CHANGE!ԺNg10 POINTEnter range to copy FROM: a10..a10 Enter range to copy TO: b10..g10b a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 -C 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:14 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph TBn ;{NO CHANGE! N_a10 \- READY +#  a b Excellent! That's all you're going to g 1 EXPENSE REPORT  2 do with labels. Right now, let's get Total 3 Date  Expenses 4 -rid of a couple of unnecessary rows.- 5 Air, rail, bu $450.00 6 Rental car Let's delete rows 11 and 12.00 $135.00 7 Daily lodging00 $267.00 8 Meals +00 $75.00 9 Entertainment$75.00 $75.00 10 K- 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17 18 -19 20 Move the cell pointer down to row 11.21 22 -23 Mon 22-Feb-88 6:15 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph   --- NO CHANGE!N/a11 READY a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17 )18 19 Use the Worksheet/Delete/Row20 21 command to delete rows 11 and 12.22 23 )Mon 22-Feb-88 6:15 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ))))) NO CHANGE!NEa11 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:15 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!N(a11 MENU Global Insert Delete Column-Width Erase Titles Window Status Page Specify global worksheet parameters4 a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:15 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!wNa11 MENU Column RowE Delete one or more columns= a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00  17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:15 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   $NO CHANGE!6xNa11 POINTEnter range of rows to delete: a11..a11 a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:16 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!xNa12 POINTEnter range of rows to delete: a11..a12 a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11N 12N 13 Total Expenses $609.00 $234.00 $159.00 $1,002.00 14 Less Advances2 $1,200.00 15 Balance Due To Employee3 16 Balance Due From Employee( $198.00 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 6:16 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  E DRNO CHANGE!dN*a11 ' Total Expenses READY a b c d e f g 1 EXPENSE REPORT> 2E Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 K- 5 Air, rail, bus $450.00 $450.00 6 Rental car $45.00 $45.00 $45.00 $135.00 7 Daily lodging $89.00 $89.00 $89.00 $267.00 8 Meals $25.00 $25.00 $25.00 $75.00 9 Entertainment $75.00 $75.00 10 K- 11 Total Expenses $609.00 $234.00 $159.00 $1,002.00 12 Less Advances $1,200.00 13 Balance Due To Employee 14 Balance Due From Employee $198.00 15 16 17 18 Your expense report is almost done!19 20 21  Press Next Page to continue 22 23 Mon 22-Feb-88 6:16 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T -#----s.21 Press Next Page22 023 to continueSun 21-Feb-88 5:43 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T time  RightArrow  RightArrow  RightArrow / ~You are practicing centering labels. To do this, ~ ~ first display the main command menu. ~ ~~ ~~ ~ Dismiss this message and type '/'. ~ Slash r ~ Now select the Range command. ~ ~ ~ ~~ ~~ ~ Dismiss this message and type 'r'. ~ r l ~ Then, select the Label command. ~ ~ ~ ~~ ~~ ~  2am g JHPN   NO CHANGE!+N  @ MNO CHANGE!_N{a3 ' Date READYW a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances 1200 14 Balance Due To Employee -198 15 Balance Due From Employee 198 16 17 18 19 20 21 22 23 Mon 22-Feb-88 5:14 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T p >}NO CHANGE!Na3 ' Date READYW a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances &1200 14 Balance Due To Employ-198 15 Balance Due From EmplThe first thing to do is to format 198 16 17 all the numeric values.18 19 &20 21 22 Go To cell d4.23 Mon 22-Feb-88 5:14 PM  Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T $$$$$$$$$w  NO CHANGE! ZNa3 ' Date POINTEnter address to go to: a3 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16 17 18 19 Go to d4.20 21 22 23 Mon 22-Feb-88 5:14 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE! Na3 ' Date EDIT Enter address to go to: d a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:14 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   ( 5NO CHANGE!GNa3 ' Date EDIT Enter address to go to: d4 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:14 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T _ -lNO CHANGE!~Nd4 (F0) [W12] 450 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9 4 10 11 Use the Range/Format/Currency command to display 12 Total Ex 1002 13 Less Advall the numeric values in monetaryform.1200 14 Balance -198 15 Balance 4 198 16 17 !18 19 Display the command menu.20 21 !22 23 Mon 22-Feb-88 5:14 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T !!!@ CMNO CHANGE!_NKd4 (F0) [W12] 450 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16 17 118 19 Select the Range/Format/Currency command.20 21 122 23 Mon 22-Feb-88 5:14 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 111T !aNO CHANGE!soNd4 (F0) [W12] 450 MENU Format Label Erase Name Justify Protect Unprotect Input Value TransposeFormat one or more cells? a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:15 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  CNO CHANGE!uNd4 (F0) [W12] 450 MENU Fixed Scientific Currency , General +/- Percent Date Text Hidden ResetFixed number of decimal points9 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses   4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:15 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T v"  "NO CHANGE!"Nd4 (F0) [W12] 450 #EDIT Enter number of decimal points: 0 A prompt displays the number of+ a b c dplaces after the decimal point. h1 EXPENSE REPORT # 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances 1200 14 Balance Due To Employee -198 15 Balance Due From Employee 198 16 17  18 19 Enter 2.20 21 22 23 Mon 22-Feb-88 5:15 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ##%#  l& Hy&NO CHANGE!&N7d4 (F0) [W12] 450 POINTEnter range to format: d4..d4 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Re 45 45 45 135 6 Da 89 89 89 267 7 MeNow enter the range 25 25 25 75 8 En 75 75 9 to format, which is/ 10 / 11 cells, d4 to g15./ 12 To 609 234 159 1002 13 Le1200 14 Balance Due To Employee -198 15 Balance Due From Employee 198 16 17 )18 19 First, use the Down Arrow to move20 21 the cell pointer to cell d15.22 23 )Mon 22-Feb-88 5:15 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T )))))* 7*NO CHANGE!*Nd5 (F0) [W12] 45 POINTEnter range to format: d4..d5 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances 1200 14 Balance Due To Employee -198 15 Balance Due From Employee 198 16 17 18 19 20 21 Move cell pointer here.22 23 Mon 22-Feb-88 5:16 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  C. OP.NO CHANGE!b.Nd6 (F0) [W12] 89 POINTEnter range to format: d4..d6 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13!  Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16& ' 17& ' 18& ' 19  20   21  Move cell pointer here.  22   23  Mon 22-Feb-88 5:17 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   1 O2NO CHANGE!2Nd7 (F0) [W12] 25 POINTEnter range to format: d4..d7 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16& ' 17& ' 18& ' 19  20   21  Move cell pointer here.  22   23  Mon 22-Feb-88 5:17 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T    5 O5NO CHANGE!5Nd8 POINTEnter range to format: d4..d8 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16& ' 17& ' 18& ' 19  20   21  Move cell pointer here.  22   23  Mon 22-Feb-88 5:17 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T     V9 Oc9NO CHANGE!u9Nd9 POINTEnter range to format: d4..d9 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16& ' 17& ' 18& ' 19  20   21  Move cell pointer here.  22   23  Mon 22-Feb-88 5:17 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T      = O=NO CHANGE!&=Nd10 POINTEnter range to format: d4..d10 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45  45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16& ' 17& ' 18& ' 19  20   21  Move cell pointer here.  22   23  Mon 22-Feb-88 5:17 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ! T       @ O@NO CHANGE!@Nd11 POINTEnter range to format: d4..d11 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16& ' 17& ' 18& ' 19  20   21  Move cell pointer here.  22   23  Mon 22-Feb-88 5:17 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T        |D ODNO CHANGE!DNd12 [W12] @SUM(d8..d4)POINTEnter range to format: d4..d12 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16& ' 17& ' 18& ' 19  20   21  Move cell pointer here.  22   23  Mon 22-Feb-88 5:17 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T         PH O]HNO CHANGE!oHNd13 POINTEnter range to format: d4..d13 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16& ' 17& ' 18& ' 19  20   21  Move cell pointer here.  22   23  Mon 22-Feb-88 5:17 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T          L O$LNO CHANGE!6LNd14 POINTEnter range to format: d4..d14 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16& ' 17& ' 18& ' 19  20   21  Move cell pointer here.  22   23  Mon 22-Feb-88 5:17 PM; Macro  Edit  Name Abs  Go To  Window Query Table   Calc  Graph T           O ONO CHANGE" !PNd15 POINTEnter range to format: d4..d15 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16 17 /18 19 Then, use the Right Arrow to select the20 21 numeric values in columns e, f and g.22 23 /Mon 22-Feb-88 5:18 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T            /////S SNO CHANGE! TON}e15 POINTEnter range to format: d4..e15 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:18 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T\W CiWNO CHANGE!{WZNg15 +g13-g12 POINTEnter range to format: d4..g15 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:18 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$$$$$$$$$$$$Z ZNO CHANGE!ZNg15 +g13-g12 )TEnter range to format: d4..g15 ) The range is defined and highlighted. a b c h1 EXPENSE REPORT  28 Total 3 Date 32148 32149  32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances4 1200 14 Balance Due To Employee* -198 15 Balance Due From Employee) 198 16 17 18 *19 20 Press Return to format the values.21 22 *23 Mon 22-Feb-88 5:18 PM; Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph ))")------------***^ H_NO CHANGE!_Ntd4 (C2) [W12] 450 READY O O a b c d e f g h6 ) Total The format of the 32148 32149 32150 Expenses $450.00 $450.00 current cell is $45" .00 $45.00 $45.00 $135.00 $89.00 $89.00 $89.00 $267.00 displayed. C2 $25.00 $25.00 $25.00 $75.00  $75.00 $75.00 means the value is6 6 displayed as6 $609.00 $234.00 $159.00 * Currency, with 2) * loyee  ($198.00) decimal places.mployee $198.00 All numeric values are now18 displayed in monetary form.19 20 21 22 Press Next Page to continue23 Mon 22-Feb-88 5:19 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph P ##time time  F5 d d 4 ~~ ~ You are going to cell d4. ~ ~~ ~~ ~~ 4 0x0A Return / Slash r r f ~ Select the Format/Currency command. ~ ~~ ~~ ~~ ~ ~ c ~ Select the Currency command. ~ ~~ ~~ ~~ ~~ 2 2 DownArrow DownArrow DownArrow DownArrow DownArrow DownArrow DownArrow DownArrow DownArrow DownArrow  RightArrow  ~ Select two more columns, ~ ~~ ~ columns, f and g. ~ ~~ ~~ RightArrow  ~ Select one more column, ~ ~~ ~ column g. ~ ~~ ~~ RightArrow 0x0A Return timeDDD   'NO CHANGE!Nating With FunctionsCCCWe already discussed one way to calculate values: use formulas.Another way to calculate valuesis to use functions.DDD   'NO CHANGE!Nating With Functions777)We already discussed one way to calculate values: use formulas.Another way to calculate valuesis to use functions.)777  ' (NO CHANGE!NRCalculating With FunctionsP777)We already discussed one way to calculate values: use formulas.Another way to calculate valuesis to use functions.)777P  '# 2am Ed JHPN  NO CHANGE!+=N%Formatting a Range of CellsPpPph uNO CHANGE!ENFormatting a Range of CellsPYou're almost there!If you are at cell b3, the keystroke combinationto display the cell value, 1200, as $1,200.00 is/rfc2.Type / to first display the command menu.Type 2 to indicate two decimal places.FP4/f NO CHANGE!(Na3 ' Date READY! ; ! a b c  f g h1 EXPENSE REPORT  2  Total 3 Date  32150 Expenses 4 Air, rail, bus  450 5 Rental car  45 135 6 Daily lodging  89 267 7 Meals  25 75 8 Entertainment  75 9  10  11  12 Total Expenses  159 1002 13 Less Advances 1200 14 Balance Due To Employee  -198 15 Balance Due From Employee 198 16  entered17 18 ..19 20  21 22 23 Sun 21-Feb-88 5:43 PM Macro  Edit  Name Abs   Table  Calc  Graph !            ! NO CHANGE!( pNa3 ' Date READY% E ' a b c d e f g h1 EXPENSE REPORT 2$  Total 3 Date 32149 32150 Expenses 4 Air, rail, bus  450 5 Rental car   45 45 135 6 Daily lodging  89 89 267 7 Meals  25 25 75 8 Entertainment  75 75 9$ 10# 11# 12 Total Expenses  234 159 1002 13 Less Advances 1200 14 Balance Due To Employee -198 15 Balance Due From Employee 198 16 u have entered17 18 bels .19 20 21 22 23 Sun 21-Feb-88 5:43 PM Macro  Edit  Name Abs  Go T Query Table  Calc  Graph %$  /NO CHANGE!N:a3 ' Date READY) J ( a b c d  e f g h1 EXPENSE REPORT ! 2(  Total 3 Date 3214 32149 32150 Expenses 4 Air, rail, bus 45 450 5 Rental car 4 45 45 135 6 Daily lodging 8 89 89 267 7 Meals 2 25 25 75 8 Entertainment  75 75 9( ! 10' ! 11' ! 12 Total Expenses 60 234 159 1002 13 Less Advances 1200 14 Balance Due To Employee -198 15 Balance Due From Employee 198 16 # So ou have entered17 18  abels .19 20 21 22 23 Sun 21-Feb-88 5:43 PM Macro  Edit  Name Abs  Go To   Query Table  Calc  Graph )% ANO CHANGE!Na3 ' Date READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances 1200 14 Balance Due To Employee -198 15 Balance Due From Employee 198 16 So far, you have entered17 18  labels .19 20 21 22 23 Sun 21-Feb-88 5:43 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T Dismiss this message and type 'l'. ~ l c ~ You want to center the label. ~ ~ ~ ~~ ~~ ~ Dismiss this message and type 'c'. ~ c  UpArrow 0x0A Return DownArrow / ~ You are to insert a row. ~ ~ The keystroke combination to do this is /wir ~ ~~ ~~ ~ Dismiss this message and type '/'. ~ Slash w ~ Select the Worksheet command. ~ ~  ~ ~~ ~~ ~ Dismiss this message and type 'w'. ~ w i ~ Select the Insert command. ~ ~ ~ ~~ ~~ ~ Dismiss this message and type 'i'. ~ i r ~ You are to insert a row. ~ ~ ~ ~~ ~~ ~ Dismiss this message and type 'r'. ~ r 0x0A Return \ ~ To enter a label, simply type it in. ~ ~ You are to enter the label, \- ~ ~~ ~~ ~ Dismiss this message and type '\'. ~ ShiftRight Num8 - Hyphen 0x0A ~ To enter the label into your worksheet, ~ ~ press Return. ~ ~~ ~~ ~ Dismiss this message and press Return. ~ Return / Slash c c 0x0A Return  LeftArrow . Period  LeftArrow  LeftArrow  LeftArrow  LeftArrow  LeftArrow 0x0A Return  F5 a a 1 1 0 0 0x0A Return \ ShiftRight Num8 - Hyphen 0x0A Return / Slash c c 0x0A Return  RightArrow . Period  RightArrow  RightArrow  RightArrow  RightArrow  RightArrow 0x0A Return DownArrow / Slash w w d d r r DownArrow 0x0A Return time$  the @SUM function to ~ ~ ~ ~ add up all the expenses, type in '@SUM'. ~ ~~ ~ Dismiss this message and type '@' ... ~ ShiftLeft 2 s ~ You are currently typing in  ~ ~ ~ ~ the @SUM function. ~ ~~ ~ Dismiss this message and type 's' ... ~ s u ~ You are currently typing in ~ ~  ~ ~ the @SUM function. ~ ~~ ~ Dismiss this message and type 'u' ... ~ m ~ You are currently typing in ~ ~ ~ ~ the @SUM function. ~ ~~ ~ Dismiss this message and type 'm' ... ~ ( ~ Now, enter your arguments. ~ ~ ~ ~ The first thing to do is type Left Parentheses. ~ ~~ ~ Dismiss this message and type '(' ... ~ ShiftRight 9  ~ Now, enter your argument, which is the cell ~ ~ range, g8..g4. To define this range, first use ~ ~the Up Arrow to move the cell pointer to cell g8. ~ ~ Dismiss this message and press the Up Arrow ~ ~ until you reach cell g8. ~ UpArrow  UpArrow  UpArrow  UpArrow . ~ Next, anchor the cell pointer at cell g8. ~ ~ ~ ~  ~ ~ ~ ~ Dismiss this message and tyep '.' ~  ~ Then, define the rest of the range. ~ ~ The range to define is g8..g4. ~ ~  ~ ~ Dismiss this message and press Up Arrow until ~ ~ you reach cell g4. ~    ) ~ Your range is defined. Finally, to complete ~ ~ ~ ~ your function, type the Right Parentheses. ~ ~ ~ ~ Dismiss this message and type ')'. ~ 0x0A ~ To enter the function in your worksheet, ~ ~~ ~press Return.  ~ ~~ ~ Dismiss this message and press Return. ~ 0x0C / Slash c c 0x0A Return  LeftArrow . Period  LeftArrow  LeftArrow 0x0A Return  LeftArrow  LeftArrow  LeftArrow time2am <g JHPN  HNO CHANGE!+N@g13 (C2) [W12] +g12-g13 READY a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee  ($198.00) 15 Balance Due From Employee  $198.00 16 17 18 Now let's talk 19 20 about this value.21 22 23 Mon 22-Feb-88 5:24 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T $  HNO CHANGE!$Nqg13 (C2) [W12] +g12-g13 READY a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9 & 10  11 There are two things to note here. 12 Total Expenses 9.00 $1,002.00 13 Less Advances First of all, negative values  $1,200.00 14 Balance Due To E ($198.00) 15 Balance Due From formatted as currency are placed $198.00 16  17 in parentheses. 18  19 & 20N 21N 22N 23N Mon 22-Feb-88 5:24 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 3  @ NO CHANGE!R <Ng13 (C2) [W12] +g12-g13 READY a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rai* $450.00 5 Rental c $45.00 $135.00 6 Daily loSecondly, for purposes of this expense $89.00 $267.00 7 Meals $25.00 $75.00 8 Entertaireport, this negative balance is not a $75.00 9  10 necessary piece of information. Your  11  12 Total Exfirst thought might be to erase it. $159.00 $1,002.00 13 Less Adv $1,200.00 14 Balance However, remember this cell containsa ($198.00) 15 Balance $198.00 16 formula that could be used again, so 17  18 let's hide it instead. 19  20 * 21N 22N 23N Mon 22-Feb-88 5:24 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am dN JHPN  BNO CHANGE!+NqQuestion Calculating With FunctionsPT R U E o r F A L S E9The function in cell c10 is copied to cell b10.If the function in cell c10 is @SUM(c4..c8), thenthe function in cell b10 is @SUM(b4..b8).9 (Select your answer by pressing one of the indicated selections)P;9999999,@mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm% mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm2am <d JHPN   2NO CHANGE!+<N Calculating With FunctionsPTake a look at the following formula:+c7+c7+c8+c9+c10+c11+c12bNow, take a look at its equivalent function:@SUM(c7..c12)=Functions are "built-in formulas" that are easy to enter.=PY=n B2am d~ JHPN  ANO CHANGE!+NCalculating With FunctionsP3But more importantly, functions make it easy to perform those calculations thatare just not feasible to perform with formulas.3PY2am cB%  JHPN  @NO CHANGE!+NCalculating With FunctionsP1Now let's return to Solution Designerand enter some functions into your worksheet.1oPY2am #d JHPN  ONO CHANGE!+N  @ OMNO CHANGE!_<N$Calculating With FunctionsPpPp &NO CHANGE!yNaCalculating With FunctionsP Pp3 $@NO CHANGE!RNnCalculating With FunctionsP Pp "NO CHANGE!NCalculating With FunctionsPa "built-inor you to c ages, or st name a fewPp 0NO CHANGE!NCalculating With FunctionsPonis a "built-in formueasy for you to calcula , averages, or standardto name a few.PL" NO CHANGE! NCalculating With FunctionsP'functionis a "built-in formula" thes it easy for you to calculate val s sums, averages, or standard deviato name a few.'PF" 'NO CHANGE!#NCalculating With FunctionsP3A functionis a "built-in formula" thatmakes it easy for you to calculate values such as sums, averages, or standard deviations,to name a few.3~PF"fileHeaders.sysmfd.syslog.sys sysImage.sys badBlk.sys crashDump.sysOCID& SD-5monetcfTgKD$ysSD 9|M^SysSD 9{fileHeaders.sys Sys3,f,f,f  ! mfd.sys Sys3.f.fefblog.sysSys1f1f1fT sysImage.sysSys3f3f3fm badBlk.sysSys5f5f5f&   crashDump.sysSys7f7f7fmcalc>functn>Date sd3vfggwcalc>functn>Date.pedal sd3fggA format>some>def.4 sd 3fvgKg  i format>some>def.2 sd 3֝fpgHg 7 calc>functn>def.14 sd 3Ɲf fg T calc>functn>def.12 sd 3f fgm calc>functn>def.10 sd 3f fg' σcalc>functn>def.8 sd3f fg' -format>some>def.9 sd3fgQg format>some>def.7 sd3f~gOg-format>some>def.5 sd3fygLgPformat>some>def.3 sd3ܝfsgJgmformat>some>def.1 sd3НfngGg>calc>functn>def.13 sd3f fgWcalc>functn>def.11 sd3f fg' Jcalc>functn>def.9 sd3f fgU Ԥcalc>functn>def.7 sd3f fg Elformat>some>def.8 sd3fgPg+format>some>def.6 sd3f|gMgcalc>functn>E.1 sd3gff gtcalc>functn>E.2 sd3lff"gRcalc>functn>E.3 sd3|ff#g'5calc>functn>Ent sd3fhfunctn>Ent.pedal sd3flfunctn>I.1 sd3f fg^ X calc>functn>I.2 sd 3f fg!calc>functn>I.3 sd!3f fg"calc>functn>I.4 sd"3f fg.&#calc>functn>I.5 sd#3f fg$calc>functn>initial.path sd$3ffgoy%calc>functn>mc1 sd%3f)Tgg( Ռ&Calc>Functn>MC1.common.path sd&3ffg! 9'calc>functn>mc1.correct sd'3f,Tgg (Calc>Functn>MC1.F001.Path sd(3ffgMr)Calc>Functn>MC1.F002.Path sd)3f fjfO*Calc>Functn>MC1.F003.Path sd*3 ff@fO+Calc>Functn>MC1.F004.Path sd+3ffZAfO",Calc>Functn>MC1.F005.Path sd,3ffwAfO&R-calc>functn>mc1.incorrect sd-3f.Tg.Tgf*) HV.Calc>Functn>MC1.legend sd.3 f$fg;0Ef/calc>functn>mc2 sd/3&f1Tgg4Ľ0calc>functn>mc2.common.path sd03+f/fg8]1calc>functn>mc2.correct sd130f4Tg g3<2Calc>Functn>MC2.F001.Path sd236f:f gMB33Calc>Functn>MC2.F002.Path sd33<f@f@fOF4Calc>Functn>MC2.F003.Path sd43GfRf@fOJ=5Calc>Functn>MC2.F004.Path sd53TfWfyAfON) y6calc>functn>mc2.incorrect sd63Xf6Tg6TgtRT7Calc>Functn>MC2.legend sd73_fcfg4XD8calc>functn>mc3 sd83ef9Tgg\)9Calc>Functn>MC3.common.path sd93sfyf2g`:calc>functn>mc3.correct sd:3{fFunctn>MC3.F001.Path sd;3ffgMjH<Calc>Functn>MC3.F002.Path sd<3ff@fOn =Calc>Functn>MC3.F003.Path sd=3ff@fOr* U>Calc>Functn>MC3.F004.Path sd>3ffAfOvG?calc>functn>mc3.incorrect sd?3f>Tg>TgYzC@Calc>Functn>MC3.legend sd@3ffg4Acalc>functn>rev.1 sdA3fcg%gwBcalc>functn>rev.2 sdB3ffg(gCcalc>functn>rev.3 sdC3fhg*gKDcalc>functn>Seg.1 sdD3ffgw,Ecalc>functn>Seg.2 sdE3ffg*  Fcalc>functn>Seg.3 sdF3ffgQGcalc>functn>Seg.4 sdG3ffgHcalc>functn>Seg.5 sdH3ffgyɼIcalc>functn>Seg.6 sdI3 ffgmJformat>some>fib1.a003 sdJ37 f9 f9 f`Kcalc>functn>TF4monetsd?TgATgATgLformat>some>FIB1.A003.Path sdL3( f* f* fLjMcalc>functn>qseg1 sdM3ffgr  + hNformat>some>al.1 sdN3&fCTggQOformat>some>al.2 sdO3-fFTgg=?5Pformat>some>al.3 sdP34fITgg -Qformat>some>al.4 sdQ3:fKTggcRformat>some>al.5 sdR3AfNTggSformat>some>al.6 sdS3PfbTggzZTformat>some>al.7 sdT3XfdTggUformat>some>al.8 sdU3^fgTggU+ Vformat>some>al.9 sdV3lfiTgg  WWformat>some>al2 sdW3wf2fgH8Xformat>some>al2.pedal sdX3f2fgxYformat>some>Curr sdY3fegYg)cd Zformat>some>Curr.pedal sdZ3fhgYgT&[calc>functn>def.6 sd[3f fg) 9\calc>functn>def.5 sd\3f fg P]calc>functn>def.4 sd]3f fg , Z^calc>functn>def.3 sd^3f fg Ϣ_calc>functn>def.2 sd_3f fg| 8`calc>functn>def.1 sd`3f fg& akacalc>functn>def.17 sda3{f fgl0bcalc>functn>def.16 sdb3vf fg0xccalc>functn>def.15 sdc3qf fgg0dformat>some>DR sdd3fggeformat>some>DR.pedal sde3fgg1h , 3[fformat>some>FIB1 sdf3f4 fagngformat>some>fib1.a000 sdg3f1 f1 fthformat>some>FIB1.A000.Path sdh3,f" f" fLxn?iformat>some>fib1.a002 sdi34f6 f6 f`|jformat>some>FIB1.A002.Path sdj3<f. f. fLYkformat>some>fib1.a999 sdk3Mf, fggl clformat>some>FIB1.A999.Path sdl3Uf' fhgLzmformat>some>FIB1.answers sdm3[f; fdg\- {nformat>some>FIB1.common.path sdn3hf% fng!Koformat>some>FIB6 sdo3pfL fgpformat>some>FIB6.a000 sdp3ufI fI fM/qformat>some>FIB6.A000.Path sdq3{f> f> fLrformat>some>FIB6.a999 sdr3fE fgsformat>some>FIB6.A999.Path sds3fB fgLgtformat>some>FIB6.answers sdt3fG fg)Guformat>some>fib6.common.path sdu3f@ fgz- 'v format>some>H sdv3fjg}gwformat>some>H.pedal sdw3fmg}gYxformat>some>hide.1 sdx3fgsg!yformat>some>hide.2 sdy3fgug:zformat>some>hide.3 sdz3fgvggAp{format>some>i.1 sd{3fQ f>gdH_|format>some>i.2 sd|3fT f@g9}format>some>i.3 sd}3fV fAg. )Y~format>some>i.4 sd~3fX fBg1format>some>i.5 sd3f[ fCg format>some>i.6 sd3f^ fDgڔformat>some>initial.path sd3fsgeg+ Pڂformat>some>MC2 sd3fpflgformat>some>mc2.common.path sd3fuggڄformat>some>MC2.correct sd3fpfB"f(format>some>MC2.F001.Path sd3fpfqgO". "format>some>MC2.F002.Path sd3fpf"fO&-format>some>MC2.F003.Path sd3fpfD"fM*(format>some>MC2.F004.Path sd3fpfU"fO.{format>some>MC2.F005.Path sd3fpfg"fO2format>some>MC2.incorrect sd3fpfpg6dformat>some>MC2.legend sd3fpfkg;<format>some>MC3 sd3 ffg @z format>some>MC3.common.path sd3ffg!D/ Ďformat>some>MC3.correct sd3ff#fXH format>some>MC3.F001.Path sd3ffgONbformat>some>MC3.F002.Path sd3 f$f#fMR獑format>some>MC3.F003.Path sd3&f*fgOVformat>some>MC3.F004.Path sd3,f/f6#fOZ/format>some>MC3.incorrect sd31ffg^ǔformat>some>MC3.legend sd36f:fg4d`format>some>MC5 sd3<ffgbh/ jformat>some>MC5.common.path sd3AfDfg"n1format>some>MC5.correct sd3Fffc$frformat>some>MC5.F001.Path sd3LfPf8gKxuformat>some>MC5.F002.Path sd3QfUfk$fM|5format>some>MC5.F003.Path sd3Wf[fgKformat>some>MC5.F004.Path sd3\f`f$fKformat>some>MC5.F005.Path sd3bfff$fKW format>some>MC5.f1inc sd3gff7g0 žformat>some>MC5.f3inc sd3lf#fgŸformat>some>MC5.f4inc sd3qf)f$fformat>some>MC5.f5inc sd3wf.f$fformat>some>MC5.legend sd3}ffg;mformat>some>MC7 sd3f3f&fEۣformat>some>MC7.common.path sd3ff&f!F`format>some>MC7.correct sd3fׂfq&fqformat>some>MC7.F001.Path sd3ffU&fO0 fformat>some>MC7.F002.Path sd3fff&fOeformat>some>MC7.F003.Path sd3ffy&fM^lformat>some>MC7.F004.Path sd3ff&fO format>some>MC7.incorrect sd3f݂f&fuGformat>some>MC7.legend sd3ff}&f4{format>some>MC8 sd3f9f&faformat>some>MC8.common.path sd3ff'f@format>some>MC8.correct sd3ff&f1 fformat>some>MC8.F001.Path sd3ff&fMYformat>some>MC8.F002.Path sd3ff&fOVformat>some>MC8.F003.Path sd3ff&fOg_format>some>MC8.F004.Path sd3ff&fOformat>some>MC8.incorrect sd3ff&fMformat>some>MC8.legend sd3ff&f4some>rev.1 sd3f` f` f4+Yformat>some>rev.2 sd3fc fc fA 1  format>some>rev.3 sd3ff ff f #format>some>rev.4 sd3fh fh fo format>some>TF4 sd3ffg "format>some>tf4.common.path sd3ffg >aformat>some>TF4.F001.Path sd3ffgJ format>some>TF4.F002.Path sd3f fgK (̼format>some>TF4.false sd3 ffg"  format>some>TF4.legend sd3ffg*( 2 _format>some>TF4.true sd3ffg ,  format>some>W sd3fyg^g92 :8Yformat>some>W.pedal sd3#f|g^gn 'OCIDsysSf]fgp  lformat>some>qseg1 sd3(f-fgv vut2 srqponml3 kjihgfed3 cba`_^]\4 [ZYXWVUT4 SRQPONML5 KJIHGFED5 CBA@?>=~<}6 ;|9{8z7y6x5w4v4{6 calc>functn>I.4"Calc>Functn>MC1.common.path&Calc>Functn>MC1.F003.Path*Calc>Functn>MC2.F002.Path3Calc>Functn>MC3.common.path9calc>functn>Seg.4Gformat>some>al.2Oformat>some>fib6.common.pathuformat>some>MC5.F001.Pathformat>some>MC7.common.pathformat>some>MC7.correctformat>some>TF4.legendcalc>functn>def.15ccalc>functn>def.8calc>functn>Date.pedalcalc>functn>I.5#Calc>Functn>MC2.F003.Path4Calc>Functn>MC3.F002.Path<calc>functn>Seg.5Hformat>some>al.3Pformat>some>DR.pedaleformat>some>FIB1.common.pathnformat>some>H.pedalwformat>some>mc2.common.pathformat>some>MC5.F002.Pathformat>some>MC5.F004.Pathformat>some>MC5.f3incformat>some>MC5.legendformat>some>MC7.incorrectformat>some>rev.1format>some>TF4format>some>TF4.truecalc>functn>def.16bcalc>functn>def.9format>some>def.1calc>functn>Ent.pedalcalc>functn>mc3.correct:Calc>Functn>MC3.F003.Path=calc>functn>Seg.6Iformat>some>al.4Qformat>some>FIB6oformat>some>FIB6.A000.Pathqformat>some>MC2.incorrectformat>some>MC5.correctformat>some>MC5.F005.Pathformat>some>MC5.f4incformat>some>MC7.F001.Pathformat>some>MC8.incorrectformat>some>rev.2 format>some>Wformat>some>qseg1calc>functn>def.17aformat>some>def.2 calc>functn>Datecalc>functn>mc1.incorrect-calc>functn>rev.1Aformat>some>al.5Rformat>some>FIB1.A000.Pathhformat>some>FIB1.A002.Pathjformat>some>FIB6.a000pformat>some>FIB6.A999.Pathsformat>some>i.1{format>some>MC2format>some>MC2.correctformat>some>MC2.F003.Pathformat>some>MC3.incorrectformat>some>MC5.f5incformat>some>MC7.F004.Pathformat>some>MC8.F001.Pathformat>some>rev.3format>some>TF4.F001.Pathcalc>functn>def.1`format>some>def.3calc>functn>mc1.correct'Calc>Functn>MC1.F001.Path(calc>functn>mc2.incorrect6Calc>Functn>MC2.legend7calc>functn>rev.2Bformat>some>al.6Sformat>some>FIB1.A999.Pathlformat>some>FIB6.a999rformat>some>hide.1xformat>some>i.2|format>some>MC2.F004.Pathformat>some>MC3format>some>MC3.correctformat>some>MC3.F003.Pathformat>some>MC8.F004.Pathformat>some>rev.4format>some>TF4.F002.Pathcalc>functn>qseg1Mcalc>functn>def.2_format>some>def.4 format>some>FIB1.A003.PathLCalc>Functn>MC1.F004.Path+Calc>Functn>MC1.legend.calc>functn>mc2.common.path0calc>functn>mc2.correct1Calc>Functn>MC2.F001.Path2calc>functn>mc3.incorrect?calc>functn>rev.3Cformat>some>al.7Tformat>some>hide.2yformat>some>i.3}format>some>MC3.F004.Pathformat>some>MC8.common.pathcalc>functn>def.3^calc>functn>def.10 format>some>def.5calc>functn>initial.path$calc>functn>mc1%Calc>Functn>MC1.F005.Path,Calc>Functn>MC2.F004.Path5Calc>Functn>MC3.F001.Path;format>some>al.8Uformat>some>fib1.a000gformat>some>FIB1.answersmformat>some>hide.3zformat>some>i.4~format>some>initial.pathformat>some>MC2.legendformat>some>MC3.common.pathformat>some>MC5format>some>MC5.common.pathformat>some>MC5.F003.Pathformat>some>MC8.legendformat>some>W.pedalcalc>functn>def.4]calc>functn>def.11format>some>def.6calc>functn>E.1calc>functn>I.1calc>functn>mc2/Calc>Functn>MC3.F004.Path>Calc>Functn>MC3.legend@calc>functn>Seg.1Dformat>some>al.9Vformat>some>CurrYformat>some>FIB1fformat>some>fib1.a999k format>some>Hvformat>some>i.5format>some>MC2.F001.Pathformat>some>MC7.F002.Pathformat>some>MC7.legendformat>some>MC8.correctformat>some>tf4.common.pathcalc>functn>def.5\calc>functn>def.12 format>some>def.77 calc>functn>E.2calc>functn>Entcalc>functn>I.2 calc>functn>mc38calc>functn>Seg.2Eformat>some>al2Wformat>some>al2.pedalXformat>some>fib1.a002iformat>some>i.6format>some>MC2.F002.Pathformat>some>MC3.F001.Pathformat>some>MC7format>some>MC7.F003.Pathformat>some>MC8.F002.Pathformat>some>TF4.falsecalc>functn>def.6[calc>functn>def.13format>some>def.8calc>functn>E.3calc>functn>I.3!Calc>Functn>MC1.F002.Path)calc>functn>Seg.3Fformat>some>al.1Nformat>some>Curr.pedalZformat>some>DRdformat>some>FIB6.answerstformat>some>MC2.F005.Pathformat>some>MC3.F002.Pathformat>some>MC3.legendformat>some>MC5.f1incformat>some>MC8format>some>MC8.F003.Pathcalc>functn>def.7calc>functn>def.14 format>some>def.9format>some>fib1.a003J2am xg JHPN  NO CHANGE!+(Nkg14 (HREADY    Now let's work on  d  e  f  g 1 EXPformatting the dates.  2   Total 3 D 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee  15 Balance Due From Employee  $198.00 16 17 Go To cell d3.18 19 20 21 22 23 Mon 22-Feb-88 5:25 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph 2 S 1`NO CHANGE!rN)g14 (H) [W12] +g12-g13 POINTEnter address to go to: g14 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16%  17   18  Go to d3.  19   20  21 22N 23N Mon 22-Feb-88 5:26 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T D Q NO CHANGE!c Ng14 (H) [W12] +g12-g13 EDIT Enter address to go to: d a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 7 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:26 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE!Ng14 (H) [W12] +g12-g13 EDIT Enter address to go to: d3 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:26 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  INO CHANGE!N@d3 [W12] @DATE(88,1,6) READY a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16 ,17 18 Select the Range/Format/Date command19 20 from the command menu.21 22 ,23 Mon 22-Feb-88 5:26 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ,,,,, NO CHANGE!NXd3 [W12] @DATE(88,1,6) MENU Worksheet Range Copy Move  File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:26 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!N4d3 [W12] @DATE(88,1,6) MENU Format Label Erase Name Justify Protect Unprotect Input Value TransposeFormat one or more cells? a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 18 3 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:27 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!N:d3 [W12] @DATE(88,1,6) MENU Fixed Scientific Currency , General +/- Percent Date Text Hidden ResetFixed number of decimal points9 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:27 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ! ?!NO CHANGE!!PNd3 [W12] @DATE(88,1,6) MENU 1 (DD-M-YY) 2 (DD-M) 3 (M-YY) 4 (Long Intn'l) 5 (Short Intn'l) Time Day-Month-YearI a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental4 $135.00 6 Daily  $267.00 7 Meals As you can see, there are several date formats $75.00 8 Entert $75.00 9 to choose from. You want to use the Short 10  11 International format to display all three dates. 12 Total  $1,002.00 13 Less A4$1,200.00 14 Balance Due To Employee 15 Balance Due From Employee $198.00 16 17 18 Enter 5.19 20 21 22 23 Mon 22-Feb-88 5:27 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T % #&NO CHANGE!&xNd3 [W12] @DATE(88,1,6) POINTEnter range to format: d3..d3 The prompt displays6  a b c dthe range to format. g 1 EXPENSE REPORT  2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances $1,200.00 14 Balance Due To Employee 15 Balance Due From Employee $198.00 16 *17 18 Use the Right Arrow to include the19 20 other two date cells in your range.21 22 *23 Mon 22-Feb-88 5:29 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph # ****** *NO CHANGE!*Ne3 [W12] @DATE(88,1,7) POINTEnter range to format: d3..e3 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 78  Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:29 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T7. KD.NO CHANGE!V.N:f3 [W12] @DATE(88,1,8) POINTEnter range to format: d3..f3 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16 17 -18 19 And press Return to format the dates.20 21 -22 23 Mon 22-Feb-88 5:29 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$---:2 GG2NO CHANGE!Y20Nhd3 (D5) [W12] @DATE(88,1,6)READY a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06 01/07 01/08 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Dail6 $267.00 7 Meal $75.00 8 EnteThe dates are now displayed in Short International $75.00 9  10 format. You can reset the dates back to their 11  12 Totadate serial numbers if you wish. Let's do it. $1,002.00 13 Less $1,200.00 14 Bala6 15 Balance Due From Employee( $198.00 16 ! 17 18 Select Range/Format/Reset19 20 from the command menu.21 22 !23 Mon 22-Feb-88 5:29 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T !!!!!6 6NO CHANGE!6N[d3 (D5) [W12] @DATE(88,1,6)MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06 01/07 01/08 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:30 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T : :NO CHANGE!:N7d3 (D5) [W12] @DATE(88,1,6)MENU Format Label Erase Name Justify Protect Unprotect Input Value TransposeFormat one or more cells? a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06 01/07 01/08 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.009  $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:30 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph  T > >NO CHANGE!>N=d3 (D5) [W12] @DATE(88,1,6)MENU Fixed Scientific Currency , General +/- Percent Date Text Hidden ResetFixed number of decimal points9 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06 01/07 01/08 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:30 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T B ABNO CHANGE!BNDd3 (D5) [W12] @DATE(88,1,6)POINTEnter range to format: d3..d3 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06 01/07 01/08 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16 17 418 19 Define the range to include all three dates.20 21 422 23 Mon 22-Feb-88 5:30 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 444F FNO CHANGE!FNe3 (D5) [W12] @DATE(88,1,7)POINTEnter range to format: d3..e3 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06 01/07 01/08 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00  7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:30 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T;J HJNO CHANGE!ZJNf3 (D5) [W12] @DATE(88,1,8)POINTEnter range to format: d3..f3 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06 01/07 01/08 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O9  10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:31 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$M  6MNO CHANGE!NENqd3 [W12] @DATE(88,1,6) READY a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental + $45.00 $135.00 6 Daily l $89.00 $267.00 7 Meals Excellent! Remember that you can reset $25.00 $75.00 8 Enterta $75.00 9 any formatted cell back to its default 10  11 format using the Range/Format/Reset 12 Total E $159.00 $1,002.00 13 Less Adcommand. $1,200.00 14 Balance 15 Balance+ $198.00 16 217 18 Format the dates again, but this time, use19 20 the Long International format.21 22 223 Mon 22-Feb-88 5:31 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 22222GR TRNO CHANGE!fRNXd3 [W12] @DATE(88,1,6) MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:31 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T YV fVNO CHANGE!xVN4d3 [W12] @DATE(88,1,6) MENU Format Label Erase Name Justify Protect Unprotect Input Value TransposeFormat one or more cells? a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:31 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T GZ TZNO CHANGE!fZN:d3 [W12] @DATE(88,1,6) MENU Fixed Scientific Currency , General +/- Percent Date Text Hidden ResetFixed number of decimal points9 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 :  7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:31 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ;^ H^NO CHANGE!Z^N*d3 [W12] @DATE(88,1,6) MENU 1 (DD-M-YY) 2 (DD-M) 3 (M-YY) 4 (Long Intn'l) 5 (Short Intn'l) Time Day-Month-YearI a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:32 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T b ,bNO CHANGE!>bNd3 [W12] @DATE(88,1,6) POINTEnter range to format: d3..d3 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:32 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T e eNO CHANGE!eNe3 [W12] @DATE(88,1,7) POINTEnter range to format: d3..e3 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:32 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph Tii viNO CHANGE!iNf3 [W12] @DATE(88,1,8) POINTEnter range to format: d3..f3 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N:  23N Mon 22-Feb-88 5:32 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T$m mNO CHANGE!-m]Nd3 (D4) [W12] @DATE(88,1,6)READY a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances  $1,200.00 14 Balance Due To Employee  15 Balance Due From Employee  Fantastic! You've done  $198.00 16 17 quite a bit of work so18 19 far. Go ahead and save20 21 your worksheet.22 23 Mon 22-Feb-88 5:32 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  q qNO CHANGE!qNdd3 (D4) [W12] @DATE(88,1,6)MENU Worksheet Range Copy Move File Print  Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00  5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:33 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T u uNO CHANGE!uN4d3 (D4) [W12] @DATE(88,1,6)MENU Retrieve Save Combine Xtract Erase List Import Directory Read in a spreadsheet file= a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:34 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T y yNO CHANGE!yNd3 (D4) [W12] @DATE(88,1,6)EDIT Enter save filename: ExpenseReport a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance D; ue From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:34 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T L} Y}NO CHANGE!k}Nd3 (D4) [W12] @DATE(88,1,6)MENU CancelReplaceCanceloperation;don'toverwritefile a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:34 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  6$NO CHANGE!6N d3 (D4) [W12] @DATE(88,1,6)READY a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 01/06/88 01/07/88 01/08/88 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee3 15 Balance Due From Employee( $198.00 16 17 18 Good job!19 20 21 Press Next Page to continue22 23 Mon 22-Feb-88 5:34 PM You have mail" Macr F5 d d 3 3 0x0A Return / Slash r ~ Select the Range/Format/Date command menu. ~ ~~ ~~ ~~ ~ Dismiss this message and type 'r'. ~ r f ~ Select the Format/Dates command menu. ~ ~~ ~~ ~~ ~ Dismiss this message and type 'f'. ~ d ~ Select the Date command menu. ~ ~~ ~~ ~~ ~ Dismiss this message and type 'd'. ~ 5 5  RightArrow  RightArrow 0x0A Return / Slash r ~ Select the Range/Format/Reset command. ~ ~~ ~~ ~~ ~ Dismiss this message and type 'r'. ~ r f ~ Select the Format/Reset command. ~ ~~ ~~ ~~ ~ Dismiss this message and type 'f'. ~ r ~ Select the Reset command. ~ ~~ ~~ ~~ ~ Dismiss this message and type 'r'. ~  RightArrow  RightArrow 0x0A Return / ~ Select the Range/Format/Date command. ~ ~~ ~ ~ ~~ ~ Dismiss this message and type 'r'. ~ Slash r ~  Select the Range/Format/Date command. ~ ~~ ~ ~ ~~ ~ Dismiss this message and type 'r'. ~ f ~ Select the Format/Date command. ~ ~~ ~  ~ ~~ ~ Dismiss this message and type 'f'. ~ d ~ Select the Date command. ~ ~~ ~ ~ ~~ ~ Dismiss this message and type 'd'. ~ 4 ~ 2am dU;  JHPN  ONO CHANGE!+N- Question -Formatting a Range of CellsPFILLINTHEBLANKNNN;  You are at cell b3, which contains the value, 1200.  The keystroke combination to display this value as  $1,200.00 is ~~ .  ; NNNN(Type your answer and press GO when ready)Pf 3*2am d JHPN  NO CHANGE!+=N%Formatting a Range of CellsPpPph uNO CHANGE!NFormatting a Range of CellsPThat's right!However, note that the complete keystroke combinationto display the cell value, 1200, as $1,200.00 is/rfc2.Type 2 to indicate two decimal places.P402am %c P Gformat>some>FIB1.a000'%Lformat>some>FIB1.common.path2am cR JHPN  ONO CHANGE!+=N%Formatting a Range of CellsPpPph $uNO CHANGE!NFormatting a Range of CellsPExcellent!If you are at cell b3, the keystroke combinationto display the cell value, 1200, as $1,200.00 is/rfc2.P47< 2am %c P Gformat>some>FIB1.a002'%Lformat>some>FIB1.common.path2am df JHPN  5NO CHANGE!+NFormatting a Range of CellsPThat's incorrect.If cell b3 contains the value, 1200, thekeystroke combination to display this value as $1,200.00 is/rfc2./displays the command menu,rdisplays the Range commands menu,fdisplays the Format commands menu,cselects the Currency format, and2specifies two decimal places.2am %c P Gformat>some>FIB1.a999'%Lformat>some>FIB1.common.path2amch!p/rfc(a/rfc2Carfc< 2am c P format>some>MC22am d) JHPN   'NO CHANGE!+No- Question -Formatting a Range of CellsPFILLINTHEBLANKNNNN?To put back the default format information for a rangeof cells, use the Range/Format/ ~~ command.?NNNNN(Type your answer and press GO when ready)Ph 5H*2am c? JHPN  ONO CHANGE!+=N%Formatting a Range of CellsPpPph  'uNO CHANGE!NFormatting a Range of CellsPThat's correct!To put back the default format informationof a range of cells, use theRange/Format/Reset command.P2am %c P Gformat>some>FIB6.a000'%Lformat>some>FIB6.common.path= 2am cC JHPN   )NO CHANGE!+NFormatting a Range of CellsPThat's not correct.To put back the default format informationof a range of cells, use theRange/Format/Reset command.P2am %c P Gformat>some>FIB6.a999'%Lformat>some>FIB6.common.path2amch!pReset2am c P ZCarla.fontZSD.font,Gformat>some>Al.1EGformat>some>Al.2^Gformat>some>Al.3wGformat>some>Al.4Gformat>some>Al.5Gformat>some>Al.6Gformat>some>Al.7Gformat>some>Al.8Gformat>some>Al.9 Xformat>some>al2%ZSD.font5ZCarla.fontHGformat>some>qseg1bformat>some>MC7= 2am {g JHPN  HNO CHANGE!+N5g14 (C2) [W12] +g12-g13 READY a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee) ($198.00) 15 Balance Due From Employee( $198.00 16 17 ;18 19 To do this,select the Range/Format/Hidden command.20 21 ;22 23 Mon 22-Feb-88 5:24 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T -7-  HNO CHANGE!(Nbg14 (C2) [W12] +g12-g13 MENU Worksheet Range Copy Move File Print Graph Data Advanced Quit Global, Insert, Delete, Column-Width, Erase, Titles, Window, Status a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee) ($198.00) 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:24 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T $ H1 NO CHANGE!C N>g14 (C2) [W12] +g12-g13 MENU Format Label Erase Name Justify Protect Unprotect Input Value TransposeFormat one or more cells? a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee) ($198.00) 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:25 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  H(NO CHANGE!:NDg14 (C2) [W12] +g12-g13 MENU Fixed Scientific Currency , General +/- Percent Date Text Hidden ResetFixed number of decimal points9 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.> 00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee) ($198.00) 15 Balance Due From Employee( $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:25 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  H%NO CHANGE!7{Ng14 (C2) [W12] +g12-g13 POINTEnter range to format: g14..g14  2 Good! A prompt displays a b c d g 1 EXPENSE REPORT the range to hide. 2)  3 Date 32148ses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances $1,200.00 14 Balance Due To Employee  ($198.00) 15 Balance Due From Employee $198.00 16 %17 18 The range is already defined,19 20 so just press Return.21 22 %23 Mon 22-Feb-88 5:25 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph (  %%%%% ONO CHANGE!N[g14 (H) [W12] +g12-g13 READY a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment  $75.00 9  10 Well done. Remember that 11  12 Total Expenses the value is not erased, $159.00 $1,002.00 13 Less Advances $1,200.00 14 Balance Due To Emplobut just hidden from view. 15 Balance Due From Emp $198.00 16 17 18 19 20 Press Next Page to continue21 22 23 Mon 22-Feb-88 5:25 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T %%%%%/ ~ You are to hide the value in cell g14. ~ ~ The keystroke combination to do this is /rfh ~ ~~ ~~ ~ Dismiss this message and type '/'. ~ Slash r ~ The main command menu is displayed. ~ ~ Select the Range command. ~ ~~ ~~ ~ Dismiss this message and type 'r'. ~ r f ~ The Range command menu is displayed. ~ ~ Select the Format command. ~ ~~ ~~ ~ Dismiss this message and type 'f'. ~ 2am fS>  JHPN  HNO CHANGE!+N@g13 (C2) [W12] +g12-g13 READY a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee  ($198.00) 15 Balance Due From Employee  $198.00 16 17 18 Now let's talk 19 20 about this value.21 22 23 Mon 22-Feb-88 5:24 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am g JHPN  HNO CHANGE!+Nqg13 (C2) [W12] +g12-g13 READY a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9 & 10  11 There are two things to note here. 12 Total Expenses 9.00 $1,002.00 13 Less Advances First of all, negative values  $1,200.00 14 Balance Due To E ($198.00) 15 Balance Due From formatted as currency are placed $198.00 16  17 in parentheses. 18  19 & 20N 21N 22N 23N Mon 22-Feb-88 5:24 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am <g?  JHPN   NO CHANGE!+<Ng13 (C2) [W12] +g12-g13 READY a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rai* $450.00 5 Rental c $45.00 $135.00 6 Daily loSecondly, for purposes of this expense $89.00 $267.00 7 Meals $25.00 $75.00 8 Entertaireport, this negative balance is not a $75.00 9  10 necessary piece of information. Your  11  12 Total Exfirst thought might be to erase it. $159.00 $1,002.00 13 Less Adv $1,200.00 14 Balance However, remember this cell containsa ($198.00) 15 Balance $198.00 16 formula that could be used again, so 17  18 let's hide it instead. 19  20 * 21N 22N 23N Mon 22-Feb-88 5:24 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am gF JHPN   NO CHANGE!+N  @ OMNO CHANGE!_Nsa3 ' @READY @ @ a@ h1 EXPE@ 2 @ 3 Da@ses 4 Ai@450 5 Re@135 6 Da@267 7 Me@ 75 8 En@ 75 9 @ 10 @ 11 @ 12 To@002 13 Le@200 14 Ba@198 15 Ba@198 16 @17 @18 @19 @20 @21 @22 @23 @Sun 21-F@ Macro @ Graph   ONO CHANGE!Nta3 ' Date )READY )' ) a b ) g h1 EXPENSE REPORT ) 2 ) Total 3 Date )50 Expenses 4 Air, rail, bus ) 450 5 Rental car )45 135 6 Daily lodging )89 267 7 Meals )25 75 8 Entertainment ) 75 9 ) 10 ) 11 ) 12 Total Expenses )59 1002 13 Less Advances )1200 14 Balance Due To Em)-198 15 Balance Due From ) 198 16 )17 )18 )19 )20 )21 )22 )23 )Sun 21-Feb-88 5:43 PM) Macro  Edit  Name ) Calc  Graph  2am f-?  JHPN  ;NO CHANGE!+Na3 ' Date READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances 1200 14 Balance Due To Employee -198 15 Balance Due From Employee 198 16 .values, .17 18 19 20 21 22 23 Sun 21-Feb-88 5:43 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T& &E2am f  JHPN  @NO CHANGE!+Na3 ' Date READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances 1200 14 Balance Due To Employee -198 15 Balance Due From Employee 198 16 . formulas, .17 18 19 20 21 22 23 Sun 21-Feb-88 5:43 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph TDD >DDEEEEEEEE2am f+ JHPN  ?NO CHANGE!+Na3 ' Date READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Rental car 45 45 45 135 6 Daily lodging 89 89 89 267 7 Meals 25 25 25 75 8 Entertainment! 75 75 9O 10N 11N 12 Total Expenses 609 234 159 1002 13 Less Advances 1200 14 Balance Due To Employee -198 15 Balance Due From Employee 198 16 and functions into your17 18 worksheet.19 20 21 22 23 Sun 21-Feb-88 5:43 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph TGG >GG<<<$@ 2am fO JHPN  NO CHANGE!+Na3 ' Date READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus 450 450 5 Renta2 45 135 6 Daily 89 267 7 MealsIt all looks nice, however, you could improve 25 75 8 Enter 75 9 its appearance. Dates need to be formatted,  10  11 some labels could be realigned, and the values 12 Total159 1002 13 Less need to be presented in a more meaningful way.1200 14 Balan-198 15 Balan 198 16 You need to format your worksheet.17 18 219 20 21 22 23 Sun 21-Feb-88 5:43 PM Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 2am Wd JHPN  NO CHANGE!+WN&Formatting a Range of CellsPIn this lesson, you will learnwhat kinds of formatting options are availablehow to format values as currencyhow to format dateshow to hide values from viewhow to unformat formatted valueshow to change label alignmentP***p2am c P ZCarla.fontZSD.font,GFormat>Some>I.1DGFormat>Some>I.2\GFormat>Some>I.3tGformat>some>I.4Gformat>some>I.5Gformat>some>I.6GFormat>Some>Def.1Gformat>some>Def.2Gformat>some>Def.3 Gformat>some>Def.4$Gformat>some>Def.5>Gformat>some>Def.6XGformat>some>Def.7rGformat>some>Def.8Gformat>some>Def.9Xformat>some>CurrXformat>some>WZSD.fontZCarla.fontG@ format>some>qseg1 format>some>FIB12am de JHPN   ONO CHANGE!+NcQuestion Formatting a Range of CellsPThe format information and contents of cell b3 areM(C2) [W12] 60UHow does the value appear in the worksheet?CLHTF1 - $60.00OIF2 - $60IPF3 - $6,0.00CLF4 - 60EEF5 - None of the above(Select your answer by pressing one of the indicated selections)P<<<<<<< )'@2am c P ZCarla.fontZSD.font,Gformat>some>Hide.1GGformat>some>Hide.2bGformat>some>Hide.3}Xformat>some>HZSD.fontZCarla.fontGformat>some>qseg1format>some>MC32am e JHPN  ENO CHANGE!+NFormatting a Range of CellsPThe format information and contents of cell b3 are(C2) [W12] 60How does the value appear in the worksheet?F1 - $60.00F2 - $60F3 - $6,0.00F4 - 60F5 - None of the above5Excellent! The format, (C2), displays a value as currencywith two decimal places, a dollar sign and a comma. And[W12] means that the column width of A cell b3 is 12.>P<<<<<<<        >>>>>2am $c P "Gformat>some>MC2.incorrect+$Lformat>some>MC2.common.path2am $c P "Gformat>some>MC2.incorrect+$Lformat>some>MC2.common.path2am $c P  Gformat>some>MC2.correct)$Lformat>some>MC2.common.path2am $cA  P "Gformat>some>MC2.incorrect+$Lformat>some>MC2.common.path2am $c P "Gformat>some>MC2.incorrect+$Lformat>some>MC2.common.path2am e* JHPN  %NO CHANGE!+NFormatting a Range of CellsPThe format information and contents of cell b3 are(C2) [W12] 60How does the value appear in the worksheet?F1 - $60.00F2 - $60F3 - $6,0.00F4 - 60F5 - None of the aboveLThat's incorrect. The correct answer is F3. The format, (C2), displays the value, 60, as currency, with two decimal places, a dollar sign anda comma. [W12] means the column width of cell b3 is 12.LP<<<<<<<        LLLLL2am 2c N 2 F1  F2  F3  F4  F5 B 2am dW JHPN  NO CHANGE!+NtQuestion Formatting a Range of CellsP@MA cell that is filled with asterisks (*) meansUCLHTF1 - the cell value is hiddenOIF2 - the cell value is too long to be displayedIPF3 - the cell contains a formula that produced an errorCLF4 - None of the aboveEE(Select your answer by pressing one of the indicated selections)P88888888882am c P format>some>TF42am -e JHPN  9NO CHANGE!+-NFormatting a Range of CellsPPA cell that is filled with asterisks (*) meansF1 - the cell value is hiddenF2 - the cell value is too long to be displayedF3 - the cell contains a formula that produced an errorF4 - None of the above4Correct. A cell that is filled with asterisks (*)means that the cell value is too long to be displayed.:P888888777:::::2am $cB  P "Gformat>some>MC3.incorrect+$Lformat>some>MC3.common.path2am $c P  Gformat>some>MC3.correct)$Lformat>some>MC3.common.path2am $c P "Gformat>some>MC3.incorrect+$Lformat>some>MC3.common.path2am $c P "Gformat>some>MC3.incorrect+$Lformat>some>MC3.common.path2am YeC  JHPN  ,NO CHANGE!+YNFormatting a Range of CellsPPA cell that is filled with asterisks (*) meansF1 - the cell value is hidden1F2 - the cell value is too long to be displayed1F3 - the cell contains a formula that produced an errorF4 - None of the above4That's incorrect. The correct answer is F2. A cell that is filled with asterisks (*) meansthat the cell value is too long to be displayed.4P888888744444442am +c N + F1  F2  F3  F4 2am 7e JHPN  NO CHANGE!+7NQuestion Formatting a Range of CellsPThe date serial number for April 5, 1988 is M32238. To display this number as 04/05/88,UCLF1 - use the Range/Format/Date/Short InternationalHcommandTOF2 - use the Range/Format/Date/Long InternationalIcommandIPF3 - Simply type in 04/05/88CLF4 - @DATE(88,4,5)EEF5 - None of the above(Select your answer by pressing one of the indicated selections)P5555522222222222@2am cC  P  format>some>FIB62am e0 JHPN  NO CHANGE!+NFormatting a Range of CellsPThe date serial number for April 5, 1988 is 32238. To display this number as 04/05/88,F1 - use the Range/Format/Date/Short InternationalcommandF2 - use the Range/Format/Date/Long InternationalcommandF3 - Simply type in 04/05/88F4 - @DATE(88,4,5)That's correct. The Range/Format/F5 - None of the aboveDate/Long International commanddisplays a date as MM/DD/YY, forexample, 04/05/88.&P5555522222  &&&&&&&&&2am $c P Gformat>some>MC5.f1inc'$Lformat>some>MC5.common.path2am $c P  Gformat>some>MC5.correct)$Lformat>some>MC5.common.pathD 2am $c P Gformat>some>MC5.f3inc'$Lformat>some>MC5.common.path2am $c P Gformat>some>MC5.f4inc'$Lformat>some>MC5.common.path2am $c P Gformat>some>MC5.f5inc'$Lformat>some>MC5.common.path2am eK JHPN  NO CHANGE!+NNFormatting a Range of CellsPThe date serial number for April 5, 1988 is 32238. To display this number as 04/05/88,F1 - use the Range/Format/Date/Short Internationalcommand3F2 - use the Range/Format/Date/Long Internationalcommand3F3 - Simply type in 04/05/88F4 - @DATE(88,4,5)F5 - None of the aboveJF1 is incorrect. The correct answer is F2. Long International displays a D date as MM/DD/YY, for example, 04/05/88.Short International displays a date as MM/DD, for example, 04/05.JP5555522222 JJJJJ2am e JHPN  NO CHANGE!+NFormatting a Range of CellsPThe date serial number for April 5, 1988 is 32238. To display this number as 04/05/88,F1 - use the Range/Format/Date/Short Internationalcommand3F2 - use the Range/Format/Date/Long Internationalcommand3F3 - Simply type in 04/05/88F4 - @DATE(88,4,5)F5 - None of the above0F3 is incorrect. The correct answer is F2. If you type in 04/05/88, Solution Designerwill interpret this as a value, not a label.0P5555522222 000002am e JHPN  NO CHANGE!+NFormatting a Range of CellsPThe date serial number for April 5, 1988 is 32238. To display this number as 04/05/88,F1 - use the Range/Format/Date/Short Internationalcommand3F2 - use the Range/Format/Date/Long Internationalcommand3F3 - Simply type in 04/05/88F4 - @DATE(88,4,5)F5 - None of the above1F4 is incorrect. The correct answer is F2. @DATE(88,4,5) returns the date serial number.It does not format the date.1P5555522222 11112am e(E  JHPN  NO CHANGE!+N+Formatting a Range of CellsPThe date serial number for April 5, 1988 is 32238. To display this number as 04/05/88,F1 - use the Range/Format/Date/Short Internationalcommand3F2 - use the Range/Format/Date/Long Internationalcommand3F3 - Simply type in 04/05/88F4 - @DATE(88,4,5)F5 - None of the above7That's incorrect. The correct answer is F2.The Range/Format/Date/Long International commanddisplays a date as MM/DD/YY, for example, 04/05/88.7P5555522222 777772am 2c N 2 F1  F2  F3  F4  F5 2am d6 JHPN   ONO CHANGE!+N0Question Formatting a Range of CellsPCell d3 contains the label, "\ch".MHow might the label appear in the worksheet?UCLHTF1 - \chOIF2 - chIPF3 - chchchchcCLF4 - None of the aboveEE(Select your answer by pressing one of the indicated selections)P6&2,6''''@2am c P format>some>MC8E 2am {e JHPN  ;NO CHANGE!+{NFormatting a Range of CellsPCell d3 contains the label, "\ch".How might the label appear in the worksheet?6F1 - \chVery good. F3 is theF2 - chcorrect answer. "\" isF3 - chchchchcthe repeat label-prefixF4 - None of the abovecharacter. It repeatsthe label, "ch", throughout the entirecell.P6&2,62am $c P "Gformat>some>MC7.incorrect+$Lformat>some>MC7.common.path2am $c P "Gformat>some>MC7.incorrect+$Lformat>some>MC7.common.path2am $cF  P  Gformat>some>MC7.correct)$Lformat>some>MC7.common.path2am $c P "Gformat>some>MC7.incorrect+$Lformat>some>MC7.common.path2am Je JHPN  'NO CHANGE!+JNFormatting a Range of CellsPCell d3 contains the label, "\ch".How might the label appear in the worksheet?oF1 - \chF2 - chF3 - chchchchcF4 - None of the above5That's incorrect. The correct answer is F3. "\"is the repeat label-prefix character. It repeatsthe label, "ch", throughout the entire cell.5P6&2,6  55555552am +c N + F1  F2  F3  F4 F 2am dm JHPN   ONO CHANGE!+NpQuestion Formatting a Range of CellsPCell a1 has a column width of 9. If this cell is Mright-aligned, the label, EXPENSE REPORT, wouldUappear in this cell asCLHTOF1 - SE REPORTIIF2 - EXPENSE RPCF3 - EXPENSE REPORTLEF4 - None of the aboveE(Select your answer by pressing one of the indicated selections)P;;;;;;; @2am c P Gformat>some>Rev.1#Gformat>some>Rev.2=Gformat>some>Rev.3WGformat>some>Rev.4qNformat>menu2am e JHPN  ;NO CHANGE!+NFormatting a Range of CellsPCell a1 has a column width of 9. If this cell is right-aligned, the label, EXPENSE REPORT, wouldappear in this cell as|F1 - SE REPORT F2 - EXPENSE RF3 - EXPENSE REPORTF4 - None of the above%Correct! Since the label is right-aligned and thereis no column to the left of column a, then only theportion of the label that fits the cell is displayed.9P;;;;;;;9999999G 2am $c P  Gformat>some>MC8.correct)$Lformat>some>MC8.common.path2am $c P "Gformat>some>MC8.incorrect+$Lformat>some>MC8.common.path2am $c P "Gformat>some>MC8.incorrect+$Lformat>some>MC8.common.path2am $c P "Gformat>some>MC8.incorrect+$Lformat>some>MC8.common.pathG 2am e JHPN  NO CHANGE!+N Formatting a Range of CellsPCell a1 has a column width of 9. If this cell is right-aligned, the label, EXPENSE REPORT, wouldappear in this cell as*F1 - SE REPORTF2 - EXPENSE RF3 - EXPENSE REPORTF4 - None of the above;That's incorrect. The correct answer is F1. Since thelabel is right-aligned andthere is no column to theleft of column a, then only the portion of the labelthat fits the cell is displayed.;P;;;;;;;;;;;;;;2am +c N + F1  F2  F3  F4 2am .e JHPN  ONO CHANGE!+N'! DNO CHANGE!.NFormatting a Range of Cells5To format one or more cells,select the Range/Format command menu.To display numeric values as currency,ܫ'select the Range/Format/Currency command.!To format a date serial number,select the Range/Format/Date command.To hide one or more cells from view,select the Range/Format/Hidden command.5%#8H 2am e JHPN  NO CHANGE!+NFormattingaRangeofCells5To reset one or more cells back to itsdefault format, select theRange/Format/Reset command.'If asterisks (*) are displayed in a cell,then the value in the cell is too long !to be displayed.Negative values displayed as currencyare displayed in parentheses. 5&(%2am be JHPN   ONO CHANGE!+bN FormattingaRangeofCells5To modify label alignment, select theRange/Label-Prefix command or use theappropriate label-prefix character.'There are four types of label-prefix۱!characters that define label alignment:'Left-aligned label"Right-aligned label^Centered label\Repeat labelThe repeat label repeats a label in thecell as many times as it can fit. 5$&2am Df JHPN  ONO CHANGE!+DNsFormattingaRangeofCells5Tomodifylabelalignment,selecttheRange/Label-PrefixcommandorusetheYouhavereachedtheappropriatelabel-prefixcharacter.endofthislesson.WesuggestyouproceedThere are four types of label-prefixtothenextlesson,characters that define label alignment:Formatting the Entire'Left-alignedlabel Worksheet."Right-alignedlabelPressNextPagetoreturnH ^CenteredlabeltotheFormat menu.\RepeatlabelThe repeat labelrepeatsalabelinthecellasmanytimesasitcanfit. 55555555555 $5 &55 555555555 552am rd JHPN   NO CHANGE!+rNQuestion Formatting a Range of CellsPT R U E o r F A L S E*$$The Range/Format/Hidden command$$erases a value from the worksheet.$$*S (Select your answer by pressing one of the indicated selections)P*$***$@2am c P ZCarla.fontZSD.font,Xformat>some>DRCZSD.fontSZCarla.fontfGformat>some>qseg1format>some>MC52am $c P Gformat>some>TF4.true&$Lformat>some>TF4.common.path2am $cI  P Gformat>some>TF4.false'$Lformat>some>TF4.common.path2am d_ JHPN  NO CHANGE!+NnFormatting a Range of CellsPT R U E o r F A L S E*$$The Range/Format/Hidden command$$erases a value from the worksheet.$$ !Correct. This statement is false.!!The Range/Format/Hidden command does!not erase a value from the worksheet. It simply hides it from view.P*$***/////////2am !c N ! TRUE  FALSE 2am dY JHPN  #NO CHANGE!+NhFormatting a Range of CellsPT R U E o r F A L S E*$$The Range/Format/Hidden command$$erases a value from the worksheet.$$ "That's incorrect. This statement is""false. The Range/Format/Hidden "command does not erase a value. It simply hides it from view.P*$***........I .2am g JHPN  ENO CHANGE!+Nd4 (C2) [W12] 450 READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Mea, $25.00 $75.00 8 Ent $75.00 9 Notice the asterisks in these two cells. 10  11 If a value is too long to be displayed 12 Tot $159.00 * 13 Lesin a cell, then asterisks will be * 14 Bal ($198.00) 15 Baldisplayed instead of the actual value. $198.00 16 17 One thing to do is make the column wider18 19 so that the value can be displayed. Go To cell g12.20 21 ,225 235 Mon 22-Feb-88 5:20 PM You have mail Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  ENO CHANGE!N#d4 (C2) [W12] 450 POINTEnter address to go to: d4 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 * 13 Less Advances0 * 14 Balance Due To Employee& ($198.00) 15 Balance Due From Employee% $198.00 16  17 18 Go to g12. 19 20  21 22 23 Mon 22-Feb-88 5:20 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T   NO CHANGE! Nd4 (C2) [W12] 450 EDIT Enter address to go to: g  a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 * 13 Less Advances0 * 14 Balance Due To Employee& ($198.00) 15 Balance Due From Employee% $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:20 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T J @ MNO CHANGE!_Nd4 (C2) [W12] 450 EDIT Enter address to go to: g1 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 * 13 Less Advances0 * 14 Balance Due To Employee& ($198.00) 15 Balance Due From Employee% $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:20 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  NO CHANGE!Nd4 (C2) [W12] 450 EDIT Enter address to go to: g12 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 * 13 Less Advances0 * 14 Balance Due To Employee& ($198.00) 15 Balance Due From Employee% $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:20 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  ENO CHANGE!N?g12 (C2) @SUM(g8..g4) READY a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 * 13 Less Advances0 * 14 Balance Due To Employee& ($198.00) 15 Balance Due From Employee% $198.00 16 )17 18 Select Worksheet/Column-Width/Set19 20 from the command menu.21 22 )23 Mon 22-Feb-88 5:20 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ))))) ENO CHANGE!NZg12 (C2) @SUM(g8..g4) 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> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 * 13 Less Advances0 * 14 Balance Due To Employee& ($198.00) 15 Balance Due From Employee% $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:21 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T  ENO CHANGE!N=g12 (C2) @SUM(g8..g4) MENU Global InseJ rt Delete Column-Width Erase Titles Window Status Page Specify global worksheet parameters4 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 * 13 Less Advances0 * 14 Balance Due To Employee& ($198.00) 15 Balance Due From Employee% $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:21 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ! E!NO CHANGE!!Ng12 (C2) @SUM(g8..g4) MENU Set Reset Hide Display7 Set width of a single column; a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 * 13 Less Advances0 * 14 Balance Due To Employee& ($198.00) 15 Balance Due From Employee% $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:22 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T c% p%NO CHANGE!%,Nxg12 (C2) @SUM(g8..g4) EDIT Enter column width (1..72): 9 a b c d e f g h1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 * 13 Less Advances0 * 14 Balance Due To Employee& ($198.00) 15 Balance Due From Employee% $198.00 16 17 218 19 Using the Right Arrow, increase the column20 21 width until you see the values displayed.22 23 2Mon 22-Feb-88 5:22 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 22222) )NO CHANGE!))Ng12 (C2) [W10] @SUM(g8..g4)EDIT Enter column width (1..72): 10 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $75.00 8 Entertainment $75.00 9 And here are the values.  10   11   12 Total Expenses $609.00$234.00$159.00 $1,002.00 13 Less Advances $1,200.00 14 Balance Due To Employee ($198.00) 15 Balance Due From Employee $198.00 16 17 18 (19 20 Increase the column width to 12.21 22 (23 Mon 22-Feb-88 5:23 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T (((- K .NO CHANGE!.Ng12 (C2) [W11] @SUM(g8..g4)EDIT Enter column width (1..72): 11 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances1 $1,200.00 14 Balance Due To Employee( ($198.00) 15 Balance Due From Employee' $198.00 16N 17N 18N 19N 20N 21N 22N 23N Mon 22-Feb-88 5:23 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 1 1NO CHANGE!1NUg12 (C2) [W12] @SUM(g8..g4)EDIT Enter column width (1..72): 12 a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances $1,200.00 14 Balance Due To Employee ($198.00) 15 Balance Due From Employee $198.00 16 17 718 19 And press Return to enter the new column width.20 21 722 23 Mon 22-Feb-88 5:23 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T 7775 H5NO CHANGE!5Ng12 (C2) [W12] @SUM(g8..g4)READY a b c d e f g 1 EXPENSE REPORT> 2B Total 3 Date 32148 32149 32150 Expenses 4 Air, rail, bus $450.00 $450.00 5 Rental car $45.00 $45.00 $45.00 $135.00 6 Daily lodging $89.00 $89.00 $89.00 $267.00 7 Meals $25.00 $25.00 $25.00 $75.00 8 Entertainment $75.00 $75.00 9O 10N 11N 12 Total Expenses $609.00 $234.00 $159.00 $1,002.00 13 Less Advances2 $1,200.00 14 Balance Due To Employee) ($198.00) 15 Balance Due From Employee( $198.00 16 17 18  Good job!19 20 (Press Next Page to continue)21 22 23 Mon 22-Feb-88 5:23 PM You have mail" Macro  Edit  Name Abs  Go To  Window Query Table  Calc  Graph T ' '''P F5 g g 1 1 2 2 0x0A Return / ~ You are to increase the column width. ~ ~ The keystroke combination to do this is /wcs ~ ~~ ~~ ~ Dismiss this message and type '/'. ~ Slash w w c c s s  RightArrow  RightArrow  RightArrow 0x0A Return timeK SD2am c9 JHPN  NO CHANGE!+N9;I T ' S T I M E T O S E EW H A T Y O U H A V E L E A R N E D . . .;.33332am c9 JHPN  NO CHANGE!+N9;I T ' S T I M E T O S E EW H A T Y O U H A V E L E A R N E D . . .;.3333@2am c JHPN  'NO CHANGE!+NjCalculating With FunctionsPSTake a look at the format of a function:@FUNCTION(arguments)PML 2am cI JHPN  :NO CHANGE!+NCalculating With FunctionsPSTake a look at the format of a function:@FUNCTION(arguments)Functions are precededby the at sign. BPS)2am cQ JHPN  :NO CHANGE!+NCalculating With FunctionsPSTake a look at the format of a function:@FUNCTION(arguments)The name of the functionimmediately follows.PS) 2am cf JHPN   9NO CHANGE!+NCalculating With FunctionsPSTake a look at the format of a function:@FUNCTION(arguments) A function canhave arguments, whichare listed in parentheses.PS)  2am dw JHPN  CNO CHANGE!+NCalculating With FunctionsPHere are some examples of functions:Arithmetic and@AVG(20,a4,c4..f4)Statistical:@SUM(d6..f6)Date:@DATE(88,2,15)@TODAYFinancial:@FV(b10,b11,b12)@PMT(b1,b2,b3)Logical:@IF(c15=250,15,25)@TRUELookup, Choose,@CHOOSE(b12,b1..b10)and Index:@INDEX(b2..j3,2,3)@LOOKUP(3,b2..j3)Text and Label:@DOLLAR(2.715)@LEN("Charles")Trigonometric:@PI@SIN(2.12)Database:@DAVG(a1..h25,7,j2..j3)L @DSUM(a1..h25,7,j2..j3)Pp2am c: JHPN   NO CHANGE!+NCalculating With FunctionsPArguments can be . values, cell references, ranges, @AVG(20,a4,c4..f4) %Px2am cu JHPN  #NO CHANGE!+NCalculating With FunctionsPArguments can be . values, cell references, ranges, @AVG(20,a4,c4..f4)formulas . @IF(c15=250,15,25) %Px2am *d JHPN  NO CHANGE!+*N Calculating With FunctionsPArguments can be . values, cell references, ranges, @AVG(20,a4,c4..f4)formulas, @IF(c15=250,15,25)  or labels. @LEN("Charles")PxSelect the Long Intn'l format. ~ ~~ ~~ ~~ ~ Dismiss this message and type '4'. ~ 4  ~ Define the rest of your range, which is d3..f3. ~ ~~ ~~ ~~ ~ Dismiss this message and press Right Arrow. ~ RightArrow  RightArrow 0x0A  Return / Slash f f s s 0x0A Return r r time