To generate 80 random numbers in an Excel simulation, the "=RAND()" function is first typed into the C2 cell on an Excel spreadsheet. C2 is then copied and pasted in a rectangular area on the spreadsheet to cover the cells:
A) C2:G13.
B) C2:J11.
C) C2:F20.
D) C2:D40.

Question

Quizplus · Accepted Answer

To generate 80 random numbers, we need to cover a rectangular area that has 8 rows and 10 columns (8 x 10 = 80). Option B, which covers cells C2 to J11, satisfies this requirement. Options A, C, and D do not cover enough cells or cover too many cells for the purpose of generating 80 random numbers.

To Generate 80 Random Numbers in an Excel Simulation, the "=RAND()