A. There are several ways in which we can deal with missing values in excel, for example: 1. Remove duplicates: You can use the "Remove Duplicates" feature in Excel to remove duplicates. 2. Highlight duplicates: You can use conditional formatting to highlight duplicates. Select the range of cells that you want to check for duplicates, then go to the "Home" tab, click on "Conditional Formatting," and select "Highlight Cells Rules" and "Duplicate Values".