Go to the Proposed Projects worksheet, which lists projects that were proposed in 2021. Dean suspects the Proposed Projects table has a duplicate record. Identify the duplicate as follows: 3. Clear the filter from the ProposedProjects table to display all the records. b. In the range A2:A14, 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. 7. The city of Honu Point wants to fast-track mixed-use development projects that use loans for funding. Add a column to the ProposedProjects table, and determine which projects meet the criteria as follows: a. In cell G1, type Fast Track as the column heading. b. In cell G2, enter a formula using the AND function that includes structured references to displayTRUE if a project has a [Project Type] of "Mixed Use" and a [Funding Type] of "Loan". Fill the range G3:G13 with the formula in cell G2 if Excel does not do so automatically