VLOOKUP – In the Department field (column D) use the VLOOKUP function to place the appropriate department names in the Department field for each employee. Begin the table in cell H1. Dept. No. 3 is Computer; Dept. No. 2 is Sales; and Dept. No. 1 is Manufacturing.
1) CONDITIONAL FORMATTING – Add conditional formatting to the Hours Worked field data so that any hours worked greater than […]