Concept:The Remove Duplicates feature in Excel helps you delete repeated values from a list or table quickly.
Explanation:To remove duplicate values, first select the range of cells or the entire table.
Click on the Data tab in the ribbon.
In the Data Tools group, click the Remove Duplicates button.
A dialog box appears where you can choose which columns to check for duplicates.
Click OK. Excel keeps the first occurrence and deletes all later duplicates.
Always back up your data before using this feature, as deleted rows cannot be recovered.
This method is fast, accurate, and much better than sorting or filtering for cleaning up data.
Answer:Option B – Use Remove Duplicates