Latest:
LinkedIn Microsoft Excel Certification 

Column A contains a list of book titles. To ensure that no book title appears more than once, first you select column A. What should you do next?

Editorial Staff
  • Right-click the column head and select Unique
  • On the Home ribbon, click Clear > Duplicates
  • On the Data ribbon, click Remove Duplicates
  • On the Data ribbon, click **Data Validation

The correct answer is:

  • On the Data ribbon, click Remove Duplicates

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

You May Also Like

You need to determine the commission earned by each Sales Rep, based on the Sales amounts in B3:B50 and the Commission rate specified in cell A1. You want to enter a formula in C3 and copy it down to C50. Which formula should you use?

Editorial Staff 0

What is the best way to activate the Excel Help system?

Editorial Staff 0

How can you create the lower table from the top one when the tables are not linked?

Editorial Staff 0