MS Excel Module 6

What is the purpose of the CONCAT function in Excel?

• To sort data in ascending order

• To calculate the sum of numbers

• To combine data from multiple cells

• To format text in bold

What is a delimiter used for in data processing?

• To highlight text

• To separate individual pieces of data

• To encrypt data

• To merge cells

What is a hyperlink?

• A feature that takes the user to another location within the document, external file, or website

• A feature that changes text color

• A feature that saves the document

• A feature that prints the document

What does the LOWER function in Excel do?

• Converts every letter to lowercase

• Converts every letter to uppercase

• Converts numbers to text

• Converts text to numbers

What is the purpose of the PROPER function in Excel?

• Allows the first letter of every word to be capitalized

• Converts text to lowercase

• Converts text to uppercase

• Formats text as bold

What is a string in the context of data types?

• A collection of characters upon which no mathematical calculations are performed

• A collection of numbers used for calculations

• A type of musical instrument

• A sequence of images

What is the definition of text in the context of data types?

• A collection of numbers

• A collection of letters that have meaning

• A type of computer program

• A sequence of sounds

What does the TEXTJOIN function in Excel do?

• Combines data from multiple cells into a list separated by a delimiter

• Converts every letter to uppercase

• Calculates the sum of a range of cells

• Finds the average of a set of numbers

What is the purpose of the UPPER function in Excel?

• Combines data from multiple cells into a list

• Converts every letter to uppercase

• Calculates the sum of a range of cells

• Finds the average of a set of numbers