Question: 11. Benicio wants to make sure that the Sales table does not contain any duplicate records, which would make any sales analysis incorrect. Identify and
11. Benicio wants to make sure that the Sales table does not contain any duplicate records, which would make any sales analysis incorrect. Identify and remove duplicate records in the Sales table as follows: a. In the range A5:A40, create a conditional formatting Highlight Cells Rule that formats Duplicate Values in Light Red Fill with Dark Red Text. b. Delete the second duplicate record from the table. (Hint: Do not delete the row from the worksheet.)
12. Benicio might want to filter the Product Details data in the range I4:M16, so he asks you to format it as a table. Format the range I4:M16 as a table using Light Gray, Table Style Medium 14 to match the Sales table.

Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
