How to add Yes No Dropdown list in Excel Worksheet?

Learn how to add a Yes or N Dropdown list in Excel worksheet. These kind of lists are used when we need to collect input from users. Using dropdown list, user can be enabled to choose the input with just mouse clicks and avoid typing errors.