Google Sheets Duplicate Removal Quiz

What is the first step to remove duplicates using the built-in method in Google Sheets?

• Select the entire spreadsheet

• Highlight the range of cells to clean

• Delete all rows manually

• Use a third-party app

What is a major drawback of the built-in duplicate removal method in Google Sheets?

• It is too slow

• It deletes all data

• It requires manual removal each time

• It only works on weekends

What does the UNIQUE function in Google Sheets do?

• It highlights duplicate values

• It extracts unique values from a range

• It sorts data alphabetically

• It merges duplicate rows

What limitation does the UNIQUE function have?

• It can only be used once per sheet

• It only works with numbers

• It requires internet access

• It considers a row duplicate only if all values are identical

Which functions are used in the advanced formula technique to remove duplicates?

• SUM, AVERAGE, COUNT

• IF, AND, OR

• SORTN, FILTER, ROWS

• VLOOKUP, HLOOKUP, INDEX

What is the purpose of creating an identifier in the advanced formula technique?

• To merge duplicate rows

• To sort data alphabetically

• To uniquely identify each row

• To color-code the data

How can pivot tables help in identifying duplicates?

• By highlighting them in red

• By automatically removing them

• By showing the count of duplicate entries

• By sorting them alphabetically

What does conditional formatting do in the context of duplicates?

• It deletes duplicate columns

• It highlights cells with duplicates

• It merges duplicate rows

• It removes duplicates automatically

What is a benefit of using apps from the Google Workspace Marketplace for duplicate removal?

• They are free for all users

• They provide automated solutions

• They are pre-installed in Google Sheets

• They work offline

What should you do if you have questions about removing duplicates in Google Sheets?

• Email the video creator

• Ask in the video comments

• Search on social media

• Contact Google support