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?

  • Filter the relevant column, right-click the column head, and select Remove Duplicates.
  • This is possible only with Power Query.
  • With the data selected, on the Data tab click Remove Duplicates.
  • This is possible only using formulas.

The correct answer is:

  • With the data selected, on the Data tab click Remove Duplicates.

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock