When using the "Delete Duplicates" function in Excel, what happens to the duplicate values in the selected range?

They are replaced with blank cells.

They are merged into a single cell.

They are deleted from the worksheet.

They are highlighted with a different colour.

They are deleted from the worksheet.

When you use the "Delete Duplicates" function in Excel, duplicate values in the selected range will be deleted from the worksheet. This means that any duplicate values found within the selected range will be completely removed from the worksheet, rather than just being replaced with blank cells or merged into a single cell.

When using the "Delete Duplicates" function in Excel, the duplicate values in the selected range are deleted from the worksheet. They are completely removed and not replaced with blank cells, merged into a single cell, or highlighted with a different color.