Format Text - MOS EXCEL16

Which function is used to format names by capitalizing the first letter in each word of a person's full name?

• UPPER

• RIGHT

• MID

• LOWER

How does the CONCATENATE function help in combining different ingredients to create a recipe?

• Counts the number of ingredients used in a recipe

• Joins various ingredients into a single mixture

• Converts ingredient names to uppercase

• Splits recipe steps into separate sections

Which function is used to extract the last few digits of a phone number?

• UPPER

• LEFT

• RIGHT

• LOWER

What is the main purpose of the PROPER function in a word processing software?

• Combines text strings into a single text string

• Extracts the left characters from a text string

• Capitalizes the first letter in each word of a text string

• Changes text to lowercase

Which function is used to convert a recipe to uppercase in a cooking app?

• UPPER

• RIGHT

• LOWER

• MID

What does the MID function do in Excel?

• Returns the characters in the middle of a text string

• Capitalizes the first letter in each word of a text string

• Returns the left characters from a text string

• Joins text strings into a single text string

Which function is used to convert all uppercase letters in a text string to lowercase?

• UPPER

• MID

• RIGHT

• LOWER

What is the purpose of the LEFT function in Excel?

• Takes characters on the left side of a string

• Joins text strings into a single text string

• Converts text to uppercase

• Returns the right characters from a text string

Which function is used to calculate the total sales amount for a specific product category?

• COUNTIF

• IF

• SUMIF

• AVERAGEIF

What does the IF function do in Excel?

• Returns the average score of students in a class

• Counts the number of students who passed the exam

• Adds the total marks obtained by students in a subject

• Decides whether to give bonus points based on attendance