$(1)$

Required information

P $2\mathrm{.}7($LO $2\mathrm{.}4)$ The Chapter $2$ Problem dataset contains a list...

$[$The following information applies to the questions displayed below.$]$

The Chanter $2$ Problem dataset 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 valldate and clean the data for completeness and integrity in Excet:

P$2\mathrm{.}7($LO $2\mathrm{.}4)-$ Part b

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

Nore: Pleose submit your file atrachment response in one of the approved file formats; Excel file $(x|s|$ or $.x|sx|).$ Consult with your instructor preferred file attochment formar.