Drop-down lists are one of Google Sheets' many useful features for quick data input. They are particularly useful for interactive…