RAND function: To make the value as static so that it does not change when we click anywhere in theexcel sheet, what is the best method?

1) use simple paste
2) use Transpose
3) use values
4) use inverse