You can test Excel$$s algorithm for selecting random integers with a simple experiment. Enter

$=$RANDBETWEEN$(1,2)$ into cell A$1$ and then copy it to cells A$1$:E$20.$ This creates a data block of $100$

cells containing either a one or a two. In cell G$1$ type $=$COUNTIF$($A$1$:E$20,=1)$ and in cell G$2$ type

$=$COUNTIF$($A$1$:E$20,=2).$ Highlight cells G$1$ and G$2$ and create a column chart. Click on the vertical axis

scale and set the lower limit to $0$ and upper limit to $100.$ Then hold down the F$9$ key and observe the chart.

Are you convinced that, on average, you are getting about $50$ ones and $50$ twos?