Enter a nested INDEX and MATCH function in cell K7 that examines the range B6:H25 and returns the corresponding employee information based on the match values in cell J7 and cell K6. Note K6 contains a validation list that can be used to select various lookup categories. Use the Data Validation list in cell J7 to select Employee cd 31461 and select Salary in cell K6 to test the function. Hint: The INDEX and MATCH functions are located under Lookup & References on the Formulas tab in the Function Library. Create a Data Validation list in cell J7 based on the employee IDs located in the range A6:A25. Add the Input Message Select Employee ID and use the Stop Style Error Alert. Hint: Data Validation is located on the Data tab in the Data Tools group. Enter a nested INDEX and MATCH function in cell K7 that examines the range B6:H25 and returns the corresponding employee information based on the match values in cell J7 and cell K6. Note K6 contains a validation list that can be used to select various lookup categories. Use the Data Validation list in cell J7 to select Employee cd 31461 and select Salary in cell K6 to test the function. Hint: The INDEX and MATCH functions are located under Lookup & References on the Formulas tab in the Function Library. Create a Data Validation list in cell J7 based on the employee IDs located in the range A6:A25. Add the Input Message Select Employee ID and use the Stop Style Error Alert. Hint: Data Validation is located on the Data tab in the Data Tools group