Digital Information Technology (DIT) Practice Exam

Recognizing duplicate records is about spotting entries in a table that repeat the same information. When an Excel table contains the same combination of values in one or more columns, you end up with duplicates—two or more rows that look identical or share the same key fields. This repetition is what we mean by duplicate records. Duplicates can arise from copy-paste, merging datasets, or imports, and they can skew counts, sums, and other analyses, so cleaning them up improves data quality. In Excel you can highlight duplicates with conditional formatting and remove them with the Remove Duplicates tool. If you only want unique entries, you can use the UNIQUE function (Excel 365+) or other filtering methods. The other terms—an area copied, exporting data, or charts—don’t describe repetitive data within the table: a chart is a visual representation, not the repetition of data, exporting moves data out of the workbook, and a copy area isn’t a standard concept describing repetitive SAMPLEdata.