Excel Functions and Random Numbers

The video tutorial explains how to use Excel to generate random numbers and create random phone numbers. It introduces the random number function in Excel, demonstrates how to input and drag formulas, and explains the process of generating phone numbers with specific formats. The tutorial also covers the use of the CONCATENATE function to join text and numbers, ensuring the correct format for phone numbers.

What is one advantage of using Excel over a calculator for generating random numbers?

• Excel can generate random numbers more quickly and powerfully.

• Excel requires less memory than a calculator.

• Excel can generate random numbers without any input.

• Excel is slower but more accurate.

What does the Excel function for generating random numbers require as input?

• A single number.

• No input is required.

• Two numbers: a lower and an upper limit.

• A text string.

Why can't the number 43 be considered a valid phone number in New South Wales?

• It is an international number.

• It is not a valid number format.

• It is too short.

• It is not a recognized area code.

What is the correct format for a mobile phone number in New South Wales?

• A 6-digit number starting with 04.

• An 8-digit number starting with 04.

• A 10-digit number starting with 04.

• A 7-digit number starting with 04.

How can you ensure that a number with leading zeros is treated as text in Excel?

• By using the CONCATENATE function.

• By typing an inverted comma before the number.

• By using the SUM function.

• By formatting the cell as a number.

What is the purpose of using an inverted comma before a number in Excel?

• To convert it into a formula.

• To treat it as a date.

• To treat it as text and preserve leading zeros.

• To format it as currency.

What is the largest 8-digit number you can generate?

• 66666666

• 77777777

• 88888888

• 99999999

What is the smallest 8-digit number you can generate?

• 10000000

• 20000000

• 40000000

• 30000000

What does the CONCATENATE function do in Excel?

• It adds numbers together.

• It divides numbers.

• It joins text and numbers together.

• It multiplies numbers.

Which Excel function can be used to combine a prefix with a random number to form a phone number?

• CONCATENATE

• VLOOKUP

• AVERAGE

• SUM