Question

Which is a true statement concerning duplicate record removal in Excel?

a. Duplicates have to be removed manually
b. Excel will delete the bottommost duplicate record
c. The duplicate removal feature is found on the Home Tab
d. Excel will only delete exact duplicates

Answer 1

Excel will only delete exact duplicates using the duplicate removal feature on the Data tab.

Step-by-step explanation:

The correct statement is option d: Excel will only delete exact duplicates.

The duplicate removal feature can be found in Excel on the Data tab, under the Data Tools group. The feature allows you to remove duplicate records based on specific columns or criteria.

For example, if you have a dataset with a column for names and a column for ages, you can use the duplicate removal feature to delete records that have exactly the same value in both the name and age columns.