Solved

Match Each of the Following Functions to Its Best Description

Question 66

Matching

Match each of the following functions to its best description:

Premises:
SUBSTITUTE
RIGHT
LEFT
MID
TRIM
Responses:
Returns the specified number of characters from the start of a text string
Returns the specified number of characters from the middle of a text string,based on a starting position and number of characters
Removes leading and trailing spaces in a text string but maintains spaces between words in a text string
Has an optional argument that specifies which occurrence of old_text you want to replace with new_text
Returns the specified number of characters from the end of a text string

Correct Answer:

SUBSTITUTE
RIGHT
LEFT
MID
TRIM
Related Questions

Q8: Power Query is _.<br>A)installed by default<br>B)enabled in

Q16: _ is an Excel add-in that enables

Q17: Text string functions cannot be nested.

Q22: You can import text files into Excel

Q31: You cannot maintain a connection with an

Q37: Which of the following functions is not

Q54: What application could be used to create

Q61: Match each of the following term to

Q63: The _ is the area that contains

Q91: _ is an Excel add-in Business Intelligence