Question: 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
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)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
