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?

October 30, 2022 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