Question

Apply a filter to Task Name (column D) so that only Design Tasks are shown?

Answer 1

To apply a filter to show only Design Tasks in column D, select the column range, click on the Filter button, and choose the Design option from the dropdown list.

Step-by-step explanation:

To apply a filter to the Task Name (column D) to show only Design Tasks, follow these steps:

1. Select the cell range or column header that contains the Task Name data (column D).
2. Go to the 'Data' tab in the Excel ribbon and click on the 'Filter' button.
3. A drop-down arrow will appear next to the column header. Click on it and select the 'Design' option from the dropdown list.