(Do Now) Excel Functions Quiz

What does the RIGHT function in Excel do?

• Returns the middle characters from a text string

• Returns the characters from a text string in reverse order

• Returns the rightmost characters from a text string

• Returns the leftmost characters from a text string

What does the LEFT function in Excel do?

• Returns a specified number of characters from the beginning of a text string.

• Returns a specified number of characters from a random position in a text string.

• Returns the middle characters from a text string.

• Returns a specified number of characters from the end of a text string.

What does the MID function in Excel do?

• The MID function converts a text string to lowercase.

• The MID function calculates the average of a range of cells.

• The MID function counts the number of characters in a text string.

• The MID function extracts a substring from a text string.

What does the CONVERT function in Excel do?

• The CONVERT function is used to convert measurements in Excel.

• The CONVERT function is used to convert dates in Excel.

• The CONVERT function is used to convert formulas in Excel.

• The CONVERT function is used to convert text to numbers in Excel.

What does the RAND function in Excel do?

• Generates random whole numbers between 0 and 1.

• Generates a random date and time.

• Generates a random text string.

• Generates random decimal number between 0 and 1.

Which Excel function is used to extract a specified number of characters from the right side of a text string?

• LEFT

• MID

• SUBSTRING

• RIGHT

Which Excel function is used to extract a specified number of characters from the left side of a text string?

• RIGHT

• LEFT

• MID

• SUBSTRING

Which Excel function is used to extract a specified number of characters from the middle of a text string?

• MID

• SUBSTRING

• RIGHT

• LEFT

Which Excel function is used to convert a number from one measurement system to another?

• CHANGE

• CONVERT

• TRANSFORM

• SWITCH

Which Excel function is used to generate a random number between 0 and 1?

• RND

• RANDOM

• RANDOMIZE

• RAND