Company XYZ is a wholesale club chain store, such as Costco or Sam's Club. You, as a data analyst, are asked to perform the following data clean up, data transformation, and data calculation tasks in Excel: Some birthday and joining date values are incorrect. Some birthday values have year value to be 17XX instead of 19XX. Some joining date values have year value to be 21XX instead of 20XX.Take appropriate actions to fix those incorrect date values. Describe the steps you take and the functionalities you used for each tool. Some gender values contain invalid special characters, such as !, or &. Take appropriate actions to remove those special characters and store correct gender values in a new field called "Gender- Data Corrected". Describe the steps you take and the functionalities you used for each tool. The zip code values given have 10 characters, such as 99999-1111. Take appropriate actions to extract only the first five characters to a new field called "5-Digit Zip", such as 99999. Describe the steps you take and the functionalities you used for each tool. Compute the age of the customer based on the birthdate and store it in a new field called "Age". Compute