Question

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

Answer 1

To make the value as static so that it does not change when we click anywhere in theexcel sheet, the best method is to use simple paste.