USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Use the Highlight Cell Rules-Duplicate Values option to automatically delete duplicate entries on the worksheet.
|
|
|
Use the Find and Replace function to find and automatically replace duplicate entries on the worksheet.
|
|
|
Use the Remove Duplicates option in the Data Tools group to automatically delete duplicate entries on the worksheet.
|
|
|
All of the options above are correct.
|
Detailed explanation-1: -Note: The best way to remove duplicates is to remove any outlines or subtotals from your data. By selecting Data > Remove Duplicates and then checking or unchecking the columns you wish to purge, you can remove duplicate records. Then click OK.
Detailed explanation-2: -Sets, built-in functions, and iterative methods can be used to remove duplicates from a list.
Detailed explanation-3: -Use the Remove Duplicates option in the Data Tools group to automatically delete duplicate entries on the worksheet.
Detailed explanation-4: -To remove duplicate values, click Data > Data Tools > Remove Duplicates. To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.