Excel Project: Formatting Data Consistently You are preparing to analyze data about the Washington DC Public Schools from January 2009 to February 2019. Go to the student download page at http://www.pearsonhighered.com/romney and download the data titled “P6-

6WashingtonDCData.xlsx”. You notice that the formatting of the data in the fields

“Transaction_Date” and “Transaction_Amount” has become corrupted and each entry can be formatted in many ways. 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.