Answer Happy

Finale Home Insert Draw Page Layout Formulas Data Review View Developer Tell me X Calibri (body - 11 • АА Pw Wrap Test General nen Olete CC Merge & Center %% Conditional Format Cat Formatting estable Styles Format Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you lot of 016 Transactions for account: 000956543 betwem Ote Date of transaction Bonde Accomber Traited check it 1201577352145687340120180125400 4125154012506524150120186500 5 SH125436779110455012011564213 62340121012053967150120180164573 15241577736511307150120180119541 11401015274315012018? 11 331463150120180955 10120155462371256315012018041554 11 20156423510950150120180109958 12 23433545555825431501205503094 13 0363669245791290150320180203445 14 9863669056999957150320142752 156140101 71501201813108 16 72615 5832115001014137 19 13401214882811811501251C500 10 1761540337558282150120160122275 19140301933045909160120114107 2016 10416012018023000 21 7146 11160120110210776 22 78016012011040167 23 5801601201807834 28 4011601201816731 25 430160120180409450 26 2016032038C110899 27 struction Metawrows at the top of the spreadsheet and format table Merge casino ang call formatted as a nie in at least) a 34 points font Un test formules and decret och transaction codes • the first grand place this in the Transmitted check digit colum the most and display these as the Bank ortcode for example the dette 240912 the bank sort code would be displayed a 24-09-12 thers and display these in the Date is comin et sand play thereat Account number Pace formulare in column to display the date of each transaction. The date is held in column as dits in the form ddmmyy. Oplay this date so that if the call in column contain 12012018 the date should be displayed 13 auary 2011 15 points ABSHEE 23 30 31 32 23 34 35 36 37 36 39 40 41 Task 2 Ready 대

tion Bank sort code Account number Transmitted check digit Instruction. Insert a new rows at the top of the spreadsheet and format table. Merge cells B2:L2 into a single cell formatted as a title in (at least) a 24 point sans serif font. Use relevant text formulas and decript each transaction codes. • the first digit and place this in the Transmitted check digit column • the next 6 digits and display these as the Bank sort code, for example if the digits are 240912 the bank sort code would be displayed as 24-09-12 the next 9 digits and display these as a 9-digit Account number • the next 8 digits and display these in the Date digits column Place formulae in column C to display the date of each transaction. The date is held in column as digits in the form ddmmyyyy. Display this date so that if the cell in column B contains 12012018 the date should be displayed as 12 January 2018 [5 points]

Your recent changes were saved. Do you want to continue working where you left off? F H C D Transactions for account: 000966543 between ca> and <b> Date digits Date of transaction Bank sort code Account number Transmitted check digit 00 3 3 3 7 5 Instruction, Insert a new rows at the top of the spreadsheet and format table. Merge cells B2:12 into a single cell formatted as a title in (at least) a 24 point sans serif font. 3 5 그 4 Use relevant text formulas and decript each transaction codes. - the first digit and place this in the Transmitted check digit column • the next 6 digits and display these as the Bank sort code, for example if the digits are 240912 the bank sort code would be displayed as 24-09-12 • the next 9 digits and display these as a 9-digit Account number the next 8 digits and display these in the Date digits column Place formulae in column C to display the date of each transaction. The date is held in column B as digits in the form ddmmyyyy. Display this date so that if the cell in column B contains 12012018 the date should be displayed as 12 January 2018 5 [5 points) 5 3

= > B < Paste I U ali Open recovered workbooks? Your recent changes were saved. Do you wa 016 А B Transactions for account: 000966543 betwe Date digits Date of tran 1 2 3 1261577352145687140120180125400 4 126154401254852415012018C6500 5 534125436279130415012018C564213 6 234012101205296715012018D168573 7 526157773651330715012018C139543 8 114010185962784215012018D395807 9 136366948933146315012018C309855 10 726155462371836115012018043554 11 9261544423590952150120180109958 12 23412545555825431501201809094 13 036366924679129015012018C403445 14 9363669056999957150120181424752 15 6140101801782857150120181313104 16 726154498446832315012018D14137 17 134012148828118115012018C3500 18 3261544337558282150120180122275 19 214010193304590916012018C184107 20 336366942777110416012018D21800 21 7140101231023411160120180230776 22 1341254013002780160120180401678 23 534012112337658016012018078148 24 036366922669040116012018C36733 25 4340121264484420160120180409450 26 026155459978318016012018C310899 27 28 29 30 31 32 33 34 35 36