Latest:
LinkedIn Microsoft Excel Certification 

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?

Editorial Staff
  • 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

You May Also Like

You want to be able to restrict values allowed in a cell and need to create a drop-down list of values from which users can choose. Which feature should you use?

Editorial Staff 0

Of these four chart types, which works best for summarizing time-based data?

Editorial Staff 0

To insert a new column to the left of a specific column, right-click the header containing the column’s letter and select _.

Editorial Staff 0