Which formula would you use to generate a random integer in a given range?

• A. =RAND()
• B. =NORM.INV()
• C. =RANDBETWEEN(min, max)
• D. =ROUND()

Answer: (C)

Generating a random integer in a specific inclusive range is best done with a function that returns integers directly. RANDBETWEEN(min, max) does exactly that: it picks one integer with equal probability from min through max, inclusive. That makes it the straightforward choice for this task. RAND() returns a random decimal between 0 and 1, so you'd have to transform and scale it to try to produce an integer, and the result wouldn’t be as clean or guaranteed to be within the exact range. NORM.INV() gives a value from a normal distribution for a given probability, which isn’t tied to your desired min/max and won’t automatically be an integer. ROUND() is just rounding a number to the nearest integer; it doesn’t generate randomness or enforce a range on its own. So the direct answer is to use the function that returns a random integer between two bounds.