MO-211 practice question 34 of 35
What are the steps to remove duplicate records in Microsoft Excel?
Full set: 355 questionsDomain Insert tables, charts, SmartArt, 3D models, and media
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.
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.
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.
Keep practicing
Take the free MO-211 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MO-211 practice questions
- Question 1What formula can be used to calculate the sum of a range of cells in Excel?
- Question 2Which chart type is best used to display trends over time?
- Question 3What is the formula used in Excel to calculate the percentage change between two numbers?
- Question 4What is a slicer in Excel?
- Question 5What is the shortcut key to insert a new worksheet in Excel?
- Question 6What is the shortcut key for copying a formula in Excel?
