https://youtube.com/watch?v=yuckvGaFKHYAdvanced Excel Data Validation - Part 7 - Prabas MS Office. Make sure to download and use the practice file from the following path for better understanding : https://prabastech.com/downloadable-excel-supporting-files-archived-2/ #DataValidation…