Here is a video I made to explain a few uses of the Random function in Excel Rand()
You basically use RAND() to get a random number between 0 and 1. From there, you can do many things with it.
You can multiply it by a number or a number in a cell. Then you would get a random number from 0 to that number.
You can use the ROUND or ROUNDUP function with it to limit the number of decimal places and get a whole number.
You can also use it then in a VLOOKUP formula to pull in a value or word from a table.
I go over all of these in the video.
I have a spreadsheet you can download to follow along with at Top Excel Functions 3