Randomization with RAND() and RANDBETWEEN

Randomization with RAND() and RANDBETWEEN

Assessment

Interactive Video

Other

10th Grade - University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial covers the basics of randomization using the Rand and RandBetween functions in spreadsheets. The Rand function generates random numbers between 0 and 1, while the RandBetween function provides random integers between specified values. Both functions recalculate when data is inserted or deleted, offering dynamic updates. Examples demonstrate how to apply these functions and observe changes in data. The tutorial emphasizes understanding and practicing these functions for effective use.

Read more

2 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

Describe the unique feature of the Rank function.

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What happens to the random numbers generated by the RandBetween function when a number is entered or deleted?

Evaluate responses using AI:

OFF