ITGSS Certified Advanced Professional: Data Analyst Practice Exam

Highlight Cells Rules is the correct choice because it is a feature within Excel that allows users to quickly identify and format cells based on specific conditions, including duplications. When you use Highlight Cells Rules and select the option for duplicate values, Excel automatically scans the selected range and highlights any cells that contain duplicate entries. This visual cue makes it easy to spot duplicates at a glance, allowing for immediate action like correction or further analysis.

Other options, while they have their purposes, do not provide the same immediate and visual identification of duplicated data. For example, Data Cleanup refers to a broader set of tasks for improving data quality but does not have the singular function of highlighting duplicates. Filtering data is useful for viewing subsets of data but requires additional steps to isolate duplicates effectively. Sorting data can help organize information but does not inherently show duplicates without additional manual inspection.