MID, LEFT, and RIGHT FUNCTION

What do the MID, LEFT, and RIGHT functions in Excel primarily deal with?

• Date and time calculations

• Text manipulation

• Mathematical operations

• Statistical analysis

The MID function in Excel is used to:

• Find the average of a range of values

• Extract a portion of text from the middle of a cell's content

• Calculate the sum of a range of numbers

• Determine the highest value in a range

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

• MID

• RIGHT

• LEFT

• LEN

The RIGHT function in Excel is primarily used to:

• Remove spaces from a text string

• Find the position of a specific character in a text string

• Extract a specified number of characters from the end of a text string

• Count the number of words in a text string

If you want to extract the last 5 characters from the text string "ExcelRocks" using the RIGHT function, what formula should you use?

• =RIGHT("ExcelRocks", 5)

• =LEFT("ExcelRocks", 5)

• =MID("ExcelRocks", 5)

• =RIGHT("ExcelRocks", 1)

The MID function requires three arguments. What are they?

• Text, Start Number, Length

• Text, End Number, Length

• Text, Character to Find, Number of Occurrences

• Text, Find Text, Replacement Text

Which of the following functions allows you to extract a substring from the middle of a text string in Excel?

• LEFT

• RIGHT

• MID

• FIND

What does the START_NUM argument in the MID function represent?

• The position of the first character to extract

• The position of the last character to extract

• The total number of characters in the text

• The position of a specific character to find

The LEFT function in Excel is often used to:

• Calculate the average of a range of numbers

• Extract a specified number of characters from the end of a text string

• Extract a specified number of characters from the middle of a text string

• Remove spaces from a text string

What is the result of the following Excel formula: =MID("OpenAI", 3, 2)?

• "pe"

• "Ope"

• "eAI"

• "en"