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.)
Reading books is a great way to learn. Here are some of the books we recommend.
Select A5 through A40. Under Styles group of Home tab, click Conditional Formatting dropdown. Select Highlight Cell Groups > Duplicate Values...
a. select "Light Red Fill with Dark Red Text" in "values with" dropdown and click Ok.
b. Second duplicate record must be column 16. Go to Table Design tab. Under Tools group click "Remove Duplicates" and then hit Ok.
If you want to watch video on this, we can go to this page and wath Capstone 5-8 -> https://taandar.com/videos/business-spreadsheet