When working with the RAND and RANDBETWEEN functions, every time you enter another value in a cell anywhere on the worksheet, the random values ____.
A) automatically change
B) prompt you with a dialog box
C) prompt you with an error message
D) stay the same

Question

Quizplus · Accepted Answer

The RAND and RANDBETWEEN functions are used to generate random numbers, and their values change every time you change something on the worksheet. This is because the function is recalculated every time the worksheet is recalculated, which happens whenever a change is made. Therefore, the correct answer is A, the random values automatically change.

When Working with the RAND and RANDBETWEEN Functions, Every Time