Video year 5 week 3

You are analyzing a list of employees with columns for Name, Department, and Salary. Your task is to display only employees in the "Marketing" department.

What is the quickest way to filter for employees in the "Marketing" department?

• A) Use the filter dropdown on the Department column and select "Marketing".
  

• B) Sort the Department column alphabetically and highlight rows manually.
  

• C) Apply a conditional format to highlight the "Marketing" rows.
  

• D) Use the "Find" function to search for "Marketing" and delete other rows.

You have a dataset with columns for Employee Name, Department, and Joining Date. Which type of filter would you use to:

1. Show only employees in the "Finance" department?

2. Display records where the joining date is after January 1, 2020?

• A) Text Filter for the department and Date Filter for the joining date.
  

• B) Number Filter for the department and Date Filter for the joining date.
  

• C) Text Filter for both the department and the joining date.
  

• D) Number Filter for both the department and the joining date.