$5.$ As a contrast, Dean also wants to list the projects that are not in development.

In the CurrentProjects table, use the filter arrows to limit the table display to projects that are not in development.

$6.$ Go to the Proposed Projects worksheet, which lists projects that were proposed in $2024.$ Dean suspects the ProposedProjects table has a duplicate record. Identify the duplicate as follows:

a$.$ Clear the filter from the ProposedProjects table to display all the records.

b$.$ In the range A$2$:A$14,$ create a conditional formatting Highlight Cells Rule that displays cells with duplicate values using Light Red Fill and Dark Red Text.

c$.$ Delete the second instance of the duplicate record so that you can summarize the data accurately.