In MS-Excel, if you want to show unique values of a particular column, which feature can help you?

Correct option is A

In MS-Excel, the Remove Duplicates feature allows users to display only unique values in a selected column. This feature helps in cleaning data by eliminating repeated entries and retaining only one instance of each unique value.
Important Key Points:
1. Data Cleaning: The Remove Duplicates feature is widely used for data cleaning to keep unique entries only.
2. Multiple Column Support: Users can select one or more columns to remove duplicates across multiple columns.
3. No Sorting Needed: It directly removes duplicates without needing to sort the data.
Knowledge Booster:
· Remove Same: Not a feature in MS-Excel.
· Show Unique: Excel does not have a feature named “Show Unique,” although unique values can be displayed through conditional formatting.
· It is not possible: Incorrect, as MS-Excel supports showing unique values through the Remove Duplicates feature.