You are preparing to analyze data about the Washington DC Public Schools from January 2009 to February 2019. Note, all of the data in the Transaction_Date field contains a date (so any numbers are stored date values). All of the data listed in the Transaction_Amount column refer to dollar amounts.

REQUIRED

For the two fields, format the data in each field to be consistent within each column. Justify the choice you made for the data format you choose to use for each column. Describe the process you went through to make sure you formatted all the data correctly. The data in the Transaction_Date column only needs to be to be accurate to the day, month, and year level (so do not worry about time information in the column if it is present). The data in the Transaction_Amount column needs to be accurate to the penny level.

This problem cannot be done by just selecting the cells and changing the format. Some of the entries are saved in different formats and the problem requires using formulas and other means to correct the data. To do this, perform the following:

(What is needed is the explanation on what formatting goes on each field)

AutoSave FFA - P6-6Washington DCData Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments 7 D E F G H 1 L 2 8 C384074 xfx 1/17/2019 A 1 CBJECTID MGENCY TRANSACTION_DAT 37569 District of Columbia Public Schools 2010-04-27 3 38158 District of Columbia Public Schools 2010 05-04 38159 District of Columbia Public Schools 4-May-10 5 40061 District of Columbia Public Schools 6/3/10 6 41100 District of Columbia Public Schools 6/1/20 7 41231 District of Columbia Public Schools 6/3/10 42518 District of Columbia Public Schaals June 21, 2010 9 48165 District of Columbia Public Schools 40403 10 48928 District of Columbia Public Schools Friday, August 20, 2010 11 48929 District of Columbia Public Schools 2010-08-20 12 50432 District of Columbia Public Schools September 1, 2010 13 50478 District of Columbia Public Schools September 2, 2010 14 50479 District of Columbia Public Schaels Thursday, September 2, 2010 15 50542 District of Columbia Public Schools 3 3 Sep 2010 16 50842 District of Columbia Public Schools 13-Sep-2010 17 50900 District af Calumbia Public Schools 40429 18 50901 District of Columbia Public Schools 2010 09 08 19 50902 District of Columbia Public Schools S-Sep-2010 20 50903 District of Columbia Public Schools S-Sep-10 21 51013 District of Columbia Public Schools 2010 09 09 TCO:00 00.COOZ 22 51093 District of Columbia Public Schools 10-Sep-10 23 51094 District of Columbia Public Schools 9/10/10 24 51095 District of Columbia Public Schools 10 Sep 2010 25 51521 District of Columbia Public Schools 40437 26 51522 District of Columbia Public Schools September 17, 2010 27 515GO District of Columbia Public Schools 17 Sep 2010 28 51861 District of Columbia Public Schouls S/20/10 29 52237 District of Columbia Public Schools 21-ep-2010 30 52232 District of Columbia Public Schools 40443 32 52535 District of Columbia Public Schools S/23/10 32 52545 District af Calumbia Public Schools 9/22/10 33 55111 District of Columbia Public Schools 19 Oct 2010 34 56786 District of Columbia Public Schools 8-Nov-10 35 56787 District of Calumbia Public Schools 40490 36 59012 District of Columbia Public Schools 11/30/10 37 59383 District of Columbia Public Schouls 40518 38 59R81 District of Columbia Public Schools December 16, 2010 39 60528 District of Columbia Public Schools 23 Dec 10 40 60995 District of Columbia Public Schools December 21, 2010 41 61109 District of Columbia Public Schools E-lan-11 42 62055 District of Columbia Public Schools Friday, January 14, 2011 43 62060 District of Columbia Public Schools 40557 44 62921 District af Calumbia Public Schools 26-Jan-2011 45 E2922 District of Columbia Public Schools January 26, 2011 46 63281 District of Columbia Public Schouls January 27, 2011 47 6.3843 District of Columbia Public Schools 2011-01-31 48 64405 District of Columbia Public Schools February 10, 2011 6457 Mistrirframhin lieben 6/11 Population Ready TRANSACTION_AMOUNT VENDOR_NAME 2,400.000on WW GRAINGER 992.7GCOD WSHPOST*635GREQUESTFO 882.76000 WSHPOST"6351RECUEST FO 6.00000 WALMART 118.00COD THE GREEN SUPPLY -118.00000 THE GREEN SUPPLY 3,321.00000 SIX FLAGS AMERICA 702.11003 THE HOME DEPOT 12583 10,000,00003 AVGIFTCARDS 2,000.00000 AMD IFTCARDS 720.09000 AMAZON.COM 1.131.57000 AMAZON.COM 1,131.57000 AMAZON.COM 1,131.59000 AMAZON.COM 926 10000 AMAZON.COM 1,481.76000 AMAZON.COM 3,889.62000 AMAZON.COM 1.296.54000 AMAZON.COM 3,889.62000 AMAZON.COM 3,289.62000 AMAZON.COM 555 66000 AMAZON.COM 3,333.96000 AMAZON.COM 2,963.52000 AMAZON.COM 926.10090 AMAZON.COM 5,99R.80000 AMAZON MKTPLACE PAITS 2,323.84000 SCHOOL LINK TECHNOLOGI 926 10000 AMAZON.COM 50.00000 GOOGLE PAID STORAGE 214.99000 DMI DELL K-12 REL 331.43000 AMAZON.COM 8.23000 AMAZON MKTPLACE PMITS 2,400.00000 WWGRAINGER 366.60000 OFFICE DLPOT 15910 2,109.40000 OFFICE DEPOT 5910 999,00000 HOSPITALITY CAREERS ON 1.200.00000 DRIWWW.ELEMENTS.INFO 222.73000 AMAZON MKTPLACEPTS 77.52000 SOLID WASTE MGMT 23.64000 SOLID WASTE MGMT 18.30000 USPS 10497R01028916395 77.79000 AMAZON MKTPLACEPTS 144.99000 DMP DELL K-12 RE. 136 61000 SOLID WASTE MGMT 53.89000 SOLID WASTE WGMT 3,050.00000 GREENLIGHT BIOFUELS 161.19000 SOLID WASTE MGMT 131.89000 SOLID WASTE MGMT 52 non UN VASTE WERE VENDOR_STATE_PROVINCE MCC_DESCRIPTION MD Industrial Supplies, Not Flywhere Classified DC Advertising Services DC Devertising Services MD Discount Store CT Specialty Retail Stores Miscellaneous CT Specialty Retail Stures Miscellaneous MD Amur Parks, Circ.es & Carnival DC Home Supply Warehouse Scores wa Specialty Retail Stures-Miscellaneous WA Sancialty Retail Stores Miscellaneaus WA Book Scores wa Book Scores WA Boak eres WA Book Scores WA Book Seres WA Boak ere WA Book Scores WA Book Scores WA Boak ere WA Book Scores WA Book Scores WA Boak ere WA Book Scores WA Book Scores WA Boak 5:ores AZ Computers Computer Peripheral Ecuipmen, Software wa Book Scores CA General Merchandise TX Computers Computer Peripheral Ecuipmen, Software WA Book Scores WA Book Bores DC Industrial Supplies, Not Esewhere Classified PA Direct Marketine.Comb. Catalog & Retail Merchants PA Direct Marketing Comb. Catalog & Retail Merchants CO Busine Services Not Elsewhere Clazified MN Electronic Commerce Information Services WA Beakers DC Government Services, No: Elsewhere Classified DC Government Services, No: Use here Classified DC Postage Service-Government Only WA Book Scores TX Computers, Computer Peripheral Ecuipment, Software DC Government Service, Net Elsewhere Classified DC Government Services, No: Ulsewhere Classified Business Services Not Elsewhere Classified DC Government Services Nos Elsehere Classified DC Government Services, Ne: Usewhere Classifica GC Neuwawa + E- B + 100% AutoSave FFA - P6-6Washington DCData Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments 7 D E F G H 1 L 2 8 C384074 xfx 1/17/2019 A 1 CBJECTID MGENCY TRANSACTION_DAT 37569 District of Columbia Public Schools 2010-04-27 3 38158 District of Columbia Public Schools 2010 05-04 38159 District of Columbia Public Schools 4-May-10 5 40061 District of Columbia Public Schools 6/3/10 6 41100 District of Columbia Public Schools 6/1/20 7 41231 District of Columbia Public Schools 6/3/10 42518 District of Columbia Public Schaals June 21, 2010 9 48165 District of Columbia Public Schools 40403 10 48928 District of Columbia Public Schools Friday, August 20, 2010 11 48929 District of Columbia Public Schools 2010-08-20 12 50432 District of Columbia Public Schools September 1, 2010 13 50478 District of Columbia Public Schools September 2, 2010 14 50479 District of Columbia Public Schaels Thursday, September 2, 2010 15 50542 District of Columbia Public Schools 3 3 Sep 2010 16 50842 District of Columbia Public Schools 13-Sep-2010 17 50900 District af Calumbia Public Schools 40429 18 50901 District of Columbia Public Schools 2010 09 08 19 50902 District of Columbia Public Schools S-Sep-2010 20 50903 District of Columbia Public Schools S-Sep-10 21 51013 District of Columbia Public Schools 2010 09 09 TCO:00 00.COOZ 22 51093 District of Columbia Public Schools 10-Sep-10 23 51094 District of Columbia Public Schools 9/10/10 24 51095 District of Columbia Public Schools 10 Sep 2010 25 51521 District of Columbia Public Schools 40437 26 51522 District of Columbia Public Schools September 17, 2010 27 515GO District of Columbia Public Schools 17 Sep 2010 28 51861 District of Columbia Public Schouls S/20/10 29 52237 District of Columbia Public Schools 21-ep-2010 30 52232 District of Columbia Public Schools 40443 32 52535 District of Columbia Public Schools S/23/10 32 52545 District af Calumbia Public Schools 9/22/10 33 55111 District of Columbia Public Schools 19 Oct 2010 34 56786 District of Columbia Public Schools 8-Nov-10 35 56787 District of Calumbia Public Schools 40490 36 59012 District of Columbia Public Schools 11/30/10 37 59383 District of Columbia Public Schouls 40518 38 59R81 District of Columbia Public Schools December 16, 2010 39 60528 District of Columbia Public Schools 23 Dec 10 40 60995 District of Columbia Public Schools December 21, 2010 41 61109 District of Columbia Public Schools E-lan-11 42 62055 District of Columbia Public Schools Friday, January 14, 2011 43 62060 District of Columbia Public Schools 40557 44 62921 District af Calumbia Public Schools 26-Jan-2011 45 E2922 District of Columbia Public Schools January 26, 2011 46 63281 District of Columbia Public Schouls January 27, 2011 47 6.3843 District of Columbia Public Schools 2011-01-31 48 64405 District of Columbia Public Schools February 10, 2011 6457 Mistrirframhin lieben 6/11 Population Ready TRANSACTION_AMOUNT VENDOR_NAME 2,400.000on WW GRAINGER 992.7GCOD WSHPOST*635GREQUESTFO 882.76000 WSHPOST"6351RECUEST FO 6.00000 WALMART 118.00COD THE GREEN SUPPLY -118.00000 THE GREEN SUPPLY 3,321.00000 SIX FLAGS AMERICA 702.11003 THE HOME DEPOT 12583 10,000,00003 AVGIFTCARDS 2,000.00000 AMD IFTCARDS 720.09000 AMAZON.COM 1.131.57000 AMAZON.COM 1,131.57000 AMAZON.COM 1,131.59000 AMAZON.COM 926 10000 AMAZON.COM 1,481.76000 AMAZON.COM 3,889.62000 AMAZON.COM 1.296.54000 AMAZON.COM 3,889.62000 AMAZON.COM 3,289.62000 AMAZON.COM 555 66000 AMAZON.COM 3,333.96000 AMAZON.COM 2,963.52000 AMAZON.COM 926.10090 AMAZON.COM 5,99R.80000 AMAZON MKTPLACE PAITS 2,323.84000 SCHOOL LINK TECHNOLOGI 926 10000 AMAZON.COM 50.00000 GOOGLE PAID STORAGE 214.99000 DMI DELL K-12 REL 331.43000 AMAZON.COM 8.23000 AMAZON MKTPLACE PMITS 2,400.00000 WWGRAINGER 366.60000 OFFICE DLPOT 15910 2,109.40000 OFFICE DEPOT 5910 999,00000 HOSPITALITY CAREERS ON 1.200.00000 DRIWWW.ELEMENTS.INFO 222.73000 AMAZON MKTPLACEPTS 77.52000 SOLID WASTE MGMT 23.64000 SOLID WASTE MGMT 18.30000 USPS 10497R01028916395 77.79000 AMAZON MKTPLACEPTS 144.99000 DMP DELL K-12 RE. 136 61000 SOLID WASTE MGMT 53.89000 SOLID WASTE WGMT 3,050.00000 GREENLIGHT BIOFUELS 161.19000 SOLID WASTE MGMT 131.89000 SOLID WASTE MGMT 52 non UN VASTE WERE VENDOR_STATE_PROVINCE MCC_DESCRIPTION MD Industrial Supplies, Not Flywhere Classified DC Advertising Services DC Devertising Services MD Discount Store CT Specialty Retail Stores Miscellaneous CT Specialty Retail Stures Miscellaneous MD Amur Parks, Circ.es & Carnival DC Home Supply Warehouse Scores wa Specialty Retail Stures-Miscellaneous WA Sancialty Retail Stores Miscellaneaus WA Book Scores wa Book Scores WA Boak eres WA Book Scores WA Book Seres WA Boak ere WA Book Scores WA Book Scores WA Boak ere WA Book Scores WA Book Scores WA Boak ere WA Book Scores WA Book Scores WA Boak 5:ores AZ Computers Computer Peripheral Ecuipmen, Software wa Book Scores CA General Merchandise TX Computers Computer Peripheral Ecuipmen, Software WA Book Scores WA Book Bores DC Industrial Supplies, Not Esewhere Classified PA Direct Marketine.Comb. Catalog & Retail Merchants PA Direct Marketing Comb. Catalog & Retail Merchants CO Busine Services Not Elsewhere Clazified MN Electronic Commerce Information Services WA Beakers DC Government Services, No: Elsewhere Classified DC Government Services, No: Use here Classified DC Postage Service-Government Only WA Book Scores TX Computers, Computer Peripheral Ecuipment, Software DC Government Service, Net Elsewhere Classified DC Government Services, No: Ulsewhere Classified Business Services Not Elsewhere Classified DC Government Services Nos Elsehere Classified DC Government Services, Ne: Usewhere Classifica GC Neuwawa + E- B + 100%