Which of the following Excel functions would generate random integers from 0 to 100?
A)=RAND( )
B)=RANDBETWEEN(0, 100)
C)=SUMIF(A1:A100, 100)
D)=100*RAND( )

Question

Quizplus · Accepted Answer

The RANDBETWEEN(0, 100) function generates random integers between the two specified numbers, inclusive. Therefore, this function would generate random integers between 0 and 100, which is what is required in this scenario. Option A generates random decimals between 0 and 1, Option C adds up values in a range that meet a specific criterion, and Option D multiplies a random decimal between 0 and 1 by 100. None of these options would give random integers between 0 and 100.

Which of the Following Excel Functions Would Generate Random Integers