Microsoft Excel 2021365 - Beginner to Advanced - Using RANDARRAY and RANDBETWEEN to Randomize Data

The video tutorial introduces the Rand Array function in Excel, explaining its optional arguments and demonstrating how to generate random numbers in both decimal and integer forms. It provides a practical example of using Rand Array to assign a random order for bungee jumpers. The tutorial also covers the Rand Between function, showing how to generate random salaries and hire dates for employees, useful for creating dummy data for training purposes.

What is the primary purpose of the Rand array function in Excel?

• To sort data alphabetically

• To generate random numbers

• To calculate averages

• To create pivot tables

Which argument in the Rand array function determines if the numbers are decimals or integers?

• Minimum

• Integer

• Columns

• Rows

In the practical example, what is the purpose of using the Rand array function?

• To calculate total sales

• To assign a random jump order

• To create a chart

• To filter data

What Excel function is used to count the number of jumpers in the list?

• SUM

• AVERAGE

• COUNTA

• VLOOKUP

What are the two arguments required by the RandBetween function?

• Bottom and Top

• First and Last

• Minimum and Maximum

• Start and End

How can the RandBetween function be used in generating random salaries?

• By specifying a range of possible salaries

• By sorting existing salaries

• By averaging all salaries

• By filtering high salaries

Which function is used alongside RandBetween to generate random dates?

• TODAY

• NOW

• DATE

• TIME