Randomization with RAND() and RANDBETWEEN

The video tutorial covers the use of the Rand and RandBetween functions in spreadsheets. The Rand function generates random numbers between 0 and 1, recalculating with any data change. The RandBetween function generates random integers between specified values, also recalculating with data changes. Examples demonstrate how to apply these functions and observe changes when data is inserted or deleted.

What is the primary purpose of the Rand function?

• To sort data in a spreadsheet

• To generate random numbers between 0 and 1

• To generate random integers between two values

• To calculate the average of a dataset

How does the Rand function behave when data is inserted or deleted?

• It recalculates and generates a new random number

• It deletes the random number

• It remains unchanged

• It sorts the data

What does the RandBetween function do?

• Sorts data in ascending order

• Generates random integers between two specified values

• Calculates the sum of a range

• Generates random numbers between 0 and 1

When does the RandBetween function recalculate?

• When the spreadsheet is closed

• When the spreadsheet is saved

• When the user logs out

• When data is inserted or deleted

What happens to the random numbers generated by RandBetween when data is modified?

• They are deleted

• They remain the same

• They are sorted alphabetically

• They change immediately