Select the “Rating” column and open the data validation menu.
Create a data validation rule that uses your list of ratings
Rate all of your locations.
Remove the column heading from your data validation rule.
Attributions
"Happy Alley by Kevin MacLeod" by incompetech.com (http://incompetech.com/music/royalty-free/index.html?isrc=USUAN1100482) -- Licensed under Creative Commons: By Attribution 3.0 License (http://creativecommons.org/licenses/by/3.0/)