Reference no: EM131093846

1. Copy the worksheet data to a new worksheet called Sort. Sort the employee list in ascending order by department, then lastname, then firstname.

2. Copy the worksheet data to a new worksheet called Autofilter. Use autofilter to to only display employees with birthdays between 1965 and 1975.

3. Copy the worksheet data to a new worksheet called Subtotal. Sort the worksheet by department, and use the subtotal function to calculate and display the salary total and average of each department.

4. Copy the worksheet data to a new worksheet called Formatting. Using the salary column, use the Conditional Formatting feature to highligh in red any salary greater than $55000.00