Question

To remove duplicate records from all columns of the Sales table, which option should you choose?

A) Use the Remove Duplicates feature under the Data tab.

B) Manually scan each column and delete duplicate entries.

C) Apply a filter and delete rows with duplicate values.

D) Sort the table and manually identify and delete duplicate records.

Answer 1

The best option to remove duplicate records from the Sales table is using the Remove Duplicates feature under the Data tab, as it is efficient and minimizes the risk of missing duplicates.

Step-by-step explanation:

To remove duplicate records from all columns of the Sales table, the best option would be A) Use the Remove Duplicates feature under the Data tab. This tool is designed to quickly and easily identify and eliminate duplicate rows based on the columns you select. It's efficient and ensures that you don't accidentally miss any duplicates, which can easily happen with the manual approaches listed in options B), C), and D).