When using Excel for simulation, it is important to freeze the random numbers used in order to compare the effectiveness of different policies. To do this, you must select the cells holding the random numbers with the mouse, click Edit/Copy at the top of the spreadsheet, and:
A) click Edit/Paste Special and select the Values option.
B) click Edit/Paste to freeze the cells.
C) click Edit/Paste Special and select the Formulas option.
D) move to a different section of the spreadsheet, then click Edit/Paste to freeze the cells.

Question

Quizplus · Accepted Answer

By selecting the Values option in Paste Special, Excel will copy the actual values of the cells instead of the formula used to generate the random numbers. This will ensure that the same numbers are used every time the simulation is run, allowing for accurate comparison of different policies.

When Using Excel for Simulation, It Is Important to Freeze