Final answer:
To highlight duplicate values, Conditional Formatting is the correct feature to use in a spreadsheet. It allows cells with duplicate values to be easily identified via visual cues like color fills or altered text color.
Step-by-step explanation:
To highlight cells with duplicate values in a spreadsheet, you can use Conditional Formatting. Here are the steps you would typically follow:
- Select the range of cells you want to check for duplicates.
- Go to the Home tab, and click on 'Conditional Formatting'.
- Hover over the 'Highlight Cells Rules' option, and then click on 'Duplicate Values'.
- Choose a formatting style to highlight the duplicates, such as a specific color fill or text color.
- Click 'OK', and the cells with duplicate values will be highlighted in the format you selected.
The correct choice from the options given would be a) Conditional Formatting. The other options like Sort and Filter, Find and Replace, and Data Validation do not directly serve the function of highlighting duplications across cells. Conditional Formatting is a feature specifically designed for visually emphasizing cells that meet certain criteria, such as being duplicates within a specified range.