RAND function: To make the value static so that they don't keep changing when we click anywhere in the Excel sheet, use copy and then paste as ______.

Answer 1

To make the value static in Excel so that it doesn’t keep changing when you click anywhere in the sheet, use "Paste Values." After copying the cell with the RAND function, you can right-click where you want to paste it and select "Paste Special," then choose "Values." This will replace the formula with its current value.