Excel Duplicate Removal Techniques Quiz

What is the first step in removing duplicates from a single column in Excel?

• Select the column or specific data

• Open a new Excel file

• Select the entire worksheet

• Use the 'Sort' feature

When removing duplicates from multiple columns, what should you do if your data has headers?

• Remove the headers manually

• Check the 'My data has headers' option

• Ignore the headers

• Select only the header row

How does Excel determine duplicates when using the 'Remove Duplicates' feature on multiple columns?

• By checking each cell individually

• By comparing the entire row

• By looking at combinations of selected columns

• By sorting the data first

What is the purpose of the UNIQUE formula in Excel?

• To sort data alphabetically

• To remove all duplicates permanently

• To highlight duplicate values

• To extract unique values without removing duplicates

Which parameter of the UNIQUE formula allows you to find data that appears exactly once?

• By call

• Single entry

• Unique only

• Exactly once