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

Which value is returned when you enter this function into cell G2? =IF(SUM(F2:F6)>12,”Too Many Tardy Days”,”No Tardiness Issue”)

Editorial Staff 0

To discover how many cells in a range contain values that meet a single criterion, use the ___function.

Editorial Staff 0

Which value is returned when you enter =LEN(C3) into cell F3?

Editorial Staff 0