Which feature removes duplicate rows where all column data match?

Which feature removes duplicate rows where all column data match?

• A. Home tab, Editing group, Remove Rows
• B. Data tab, data tools group, remove duplicates
• C. Data tab, Formulas group, Remove Values
• D. Review tab, Changes group, Remove

Answer: (B)

Removing duplicate rows where every column matches is done with the Remove Duplicates command. It finds duplicates by comparing the values in the columns you choose and keeps one copy of each unique row. To use it, select your data (or the table), go to the Data tab, click Remove Duplicates in the Data Tools group, and pick which columns to compare. If you select all columns, a duplicate means a row that is identical across every column; if you select only some columns, duplicates are defined by those columns. Don’t forget to indicate whether your data has headers. After you run it, Excel removes the extra copies and leaves one row per unique combination of values.

Removing duplicate rows where every column matches is done with the Remove Duplicates command. It finds duplicates by comparing the values in the columns you choose and keeps one copy of each unique row. To use it, select your data (or the table), go to the Data tab, click Remove Duplicates in the Data Tools group, and pick which columns to compare. If you select all columns, a duplicate means a row that is identical across every column; if you select only some columns, duplicates are defined by those columns. Don’t forget to indicate whether your data has headers. After you run it, Excel removes the extra copies and leaves one row per unique combination of values.