When using the "Delete Duplicates" function in Excel, the duplicate values in the selected range are deleted from the worksheet. Therefore, the correct answer is:
They are deleted from the worksheet.
Question 24
When using the "Delete Duplicates" function in Excel, what happens to the duplicate values in the selected range?
They are merged into a single cell.
They are replaced with blank cells.
They are deleted from the worksheet.
They are highlighted with a different colour.
1 answer