Question: 2. Excel Project: Formatting Data Consistently You are preparing to analyze data about the Washington DC Public Schools from January 2009 to February 2019. Go

2. Excel Project: Formatting Data Consistently
2. 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.xlex". 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!