Excel is the most used analytics software application in organizations today.Excel provides many tools for data preparation and validation. For the Excel Data Validation Assignment, you will use, at a minimum, theCONCAT,INDEX, LEFT, LEN, MATCH, MID, TRIM, VALUE, and VLOOKUP functions. You will also use the sort, filter and Pivot tables features. Pick a function or feature and explain its parameters and how it can be utilized in theExcel Data Validation Assignment to identify or isolate errors. There should be only one thread for each function or feature.