- Review the data in the worksheet and make the conversions required to transform the data into a more usable form. For each transformation, you must use function(s). Insert new columns, as needed, write the necessary formulas - and leave the new columns in this worksheet. The formulas should be writing in Row 21 - and copied down to all rows - producing the correct data. - The ProviderlD is either a corporate tax-id (which is correctly formatted) or it is an individual's Social Security Number. Write a formula to either return the corporate tax-id, or build the SSN - inserting dashes to produce the 999-99-9999 format that is easier to read. Display the Provider name in all caps. Insert a new column - Provider Type - that will display "Medical Facility" if the word "hospital" is part fo the provider name, "Dental" for any provider with "dds" in the name. All other rows should be left blank. Display the provider address without the "ADDRESS1:" prefix in the column. Convert the data to proper case. Split the City and State data into separate columns. Display only the standard 5-digit zip code. Convert the Date Added column to display in the format of mm/dd/yyyy. (Be sure to take note of the different variations of this data in your formula. You may need to solve this one in multiple steps.) - Copy/Paste (values) to display the data on the worksheet named "NewTextWorksheet". - Format the data, to present a meaningful and an easy to consume report