https://youtube.com/watch?v=vOOuSe_s6pQTo make data entry easier, create a drop down list in an Excel cell, using data validation. This saves you time, and prevents errors, but has some limitations. -The font…