7. (LO 2.4) The Receivables Past Due data set contains a list of outstanding invoices for a fictional company, but the data aren’t ready for analysis yet. Using this data file, take the following steps to validate and clean the data for completeness and integrity in Excel:

a. The number of records should be 200. Ensure that this number matches your data set. Explain your method for checking completeness.

b. Notice that the Customer field contains some customer names that have extraneous spaces. In column E, use the TRIM(CLEAN()) functions to clean the data in the Customer field.

d. There are several empty values in the Days Past Due field. Either remove those values or replace them with the average. Explain which method you chose and why.

Also explain how you implemented the method.

e. After you have validated and cleaned the data, you can perform some preliminary exploratory analysis. Insert a pivot table:
i. Rows: New Customer ii. Values: Days Past Due iii. Adjust the method of summarizing the values from Sum to Maximum (Max).
iv. Explain how viewing the data in a pivot table can help you better understand the data set. How might management use this pivot table?