Question: Go to the Proposed Projects worksheet, which lists projects that were proposed in 2 0 2 1 . Been surpects the ProposedProjects table has a
Go to the Proposed Projects worksheet, which lists projects that were proposed in Been surpects the ProposedProjects table has a dupllcate record. Identify the duplicate as follows:
B Clear the filter from the ProposedProjects table to display all the records.
b In the ranne A A create a conditional formatting Mighlight Calls 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 date accurately.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
