The Excel Dynamic Array RANDARRAY function generates an range of random numbers, either a straight list or result between a specified range. The size of the resultant range is specified by rows and columns arguments. The generated results can be either decimals or whole numbers. The overall flexibility of the RANDARRAY function is a huge improvement over the legacy RAND and related functions.

The file at the link below has several hands-on exercises for both the RandArray Dynamic Array function.

RandArray.xlsx