Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
QUESTION
Apply Your Knowledge Project 9 - Security Analysis Input boxes in tan Output boxes in yellow Given data in blue Answers in red edge ID 1009 1016 1032...
- Copy the worksheet Data to a new worksheet called Sort. Sort the employee list in ascending order by department, then by last name, then by first name.
- Copy the worksheet Data to a new worksheet called Autofilter. Using the Autofilter feature, create a custom filter that will display employees whose birth date is greater than or equal to 1/1/1965 and less than or equal to 12/31/1975.
- Copy the worksheet Data to a new worksheet called Subtotal. Using the subtotal feature create a sum of the salary for each department.
- Copy the worksheet Data to a new worksheet called Formatting. Using the salary column, change the font color to red if the cell value is greater than or equal to 55000. You must use the conditional formatting feature to complete this step.
