Question: Your transactions data set contains more than 10,000 rows. Some rows contain the same transaction. How would you remove the rows containing the identical transactions?

1. Filter the relevant column, right-click the column head, and select **Remove Duplicates**.
2. This is possible only with Power Query.
3. With your cursors in the data range, on **Data** tab click **Remove Duplicates**.
4. This is possible only using formulas.

Answer: The correct answer of the above question is Option C:With your cursors in the data range, on **Data** tab click **Remove Duplicates**.