The function can be set up for classical probability, but it's considerably easier to just construct the formula yourself, especially for a large range of outcomes.

Excel comes with several inbuilt formulas to calculate cell values. It also provides you a Random Number Generator formula to quickly generate a random number from a range.