MO-211 practice question 34 of 35

What are the steps to remove duplicate records in Microsoft Excel?

Full set: 355 questions

Domain Insert tables, charts, SmartArt, 3D models, and media

Answer options
A: Highlight the data range, click Delete duplicates from the Home tab, choose the column(s) to search for duplicate values, and then click OK
B: Highlight the data range, click Delete duplicates from the Insert tab, choose the column(s) to search for duplicate values, and then click OK
C: Highlight the data range, click Remove duplicates from the Formulas tab, choose the column(s) to search for duplicate values, and then click OK
D: Highlight the data range, click Remove duplicates from the Data tab, choose the column(s) to search for duplicate values, and then click OK Correct answer
Correct Answer:
D. Highlight the data range, click Remove duplicates from the Data tab, choose the column(s) to search for duplicate values, and then click OK
Explanation

The "Remove Duplicates" command is a data management tool in Microsoft Excel designed to eliminate rows with identical values in specified columns. This feature is logically located on the Data tab, within the Data Tools group, alongside other data manipulation functions like Text to Columns and Data Validation. The correct procedure is to first select the cell range, navigate to the Data tab, click "Remove Duplicates," configure the columns to check in the dialog box, and then click OK to execute the removal.

Why Incorrect

A. The Home tab contains formatting, clipboard, and editing tools, not the "Remove Duplicates" command. The command name is also incorrect.
B. The Insert tab is used for adding objects like tables, charts, and pictures, not for data cleaning. The command name is also incorrect.
C. The Formulas tab is dedicated to functions, formula auditing, and calculation options, not for managing data records.

References

1. Microsoft Corporation. (n.d.). Find and remove duplicates. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/find-and-remove-duplicates-00e35321-5e50-4205-9156-90304839c7fd. (In the section "Remove duplicate values," Step 2 explicitly states: "Click Data > Remove Duplicates...").

2. University of Wisconsin-Madison. (2021). Excel 2016: The Basics. DoIT Academic Technology. In the "Managing Data" module, the guide specifies that the Data tab contains tools for data management, including "Remove Duplicates."

3. MIT Information Systems and Technology. (n.d.). Excel 2016: Getting Started with Excel. In the training documentation covering the Excel interface, the Data tab is identified as the location for tools that work with external data, sort, filter, and remove duplicates.

Scroll to Top