MO-211 practice question 33 of 35

Which option is used to remove duplicates from a workbook?

Full set: 355 questions

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

Answer options
A: Review
B: Data Correct answer
C: File
D: Formulas
Correct Answer:
B. Data
Explanation

The "Remove Duplicates" command is a data cleaning tool located on the Data tab in the Microsoft Excel Ribbon. This feature is used to permanently delete rows that have identical values in one or more specified columns within a selected range or table. It is part of the "Data Tools" group, which also includes other data manipulation features like Text to Columns and Data Validation.

Why Incorrect

A. Review: The Review tab contains tools for proofing, comments, and workbook/worksheet protection, not for manipulating data content like removing duplicates.
C. File: The File tab opens the Backstage view, which is used for file-level operations such as saving, printing, and sharing, not for editing data within a worksheet.
D. Formulas: The Formulas tab is dedicated to managing functions, named ranges, and formula auditing. It does not contain tools for cleaning or removing data rows.

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-8980acd4d279.

Reference Detail: The article explicitly states in the procedural steps: "Select the range of cells that has duplicate values you want to remove. ... On the Data tab

click Remove Duplicates."

2. University of California

Berkeley. (n.d.). Data Cleaning in Excel. Data Peer Consulting

D-Lab. Retrieved from https://dlab.berkeley.edu/sites/default/files/DataCleaninginExcelD-Lab2020.pdf.

Reference Detail: On page 10

under the section "Removing Duplicates

" the instructions state: "To remove duplicates

select the data you want to check. Then

go to the Data tab and select Remove Duplicates."

3. Harvard University. (n.d.). Excel Basics for Research. Institute for Quantitative Social Science (IQSS). Retrieved from https://projects.iq.harvard.edu/files/gov2001/files/excelbasics.pdf.

Reference Detail: On page 11

the guide instructs: "To remove duplicate rows

highlight the data you want to check. Then go to the Data tab and click on the Remove Duplicates button."

Scroll to Top