The Department Summary table should look'up the department code and return all of the data listed. Complete the Department Summary table.In cell O$7,$ enter a formula using the XLOOKUP function to find an exact match for the department code. Look up the department code $($cell O$6)$ using an absolute reference, search the list of codes in the Employees table $($the range B$7$:B$12)$ using absolute references, and return the department name $($the range C$7$:C$12).$