Explain in detail how pseudo-random numbers are generated in Excel. 

We can use the =Randbetween(start, end) function in excel

The function will take a start number, for example 1 & end number like 20.

The =Randbetween(1,20), will generate a random number between 1 & 20 in every cell