Solved

Match Each of the Following Functions to Its Best Description

Question 89

Matching

Match each of the following functions to its best description:

Premises:
TRIM
SUBSTITUTE
MID
RIGHT
LEFT
Responses:
Returns the specified number of characters from the start of a text string
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
Returns the specified number of characters from the middle of a text string

Correct Answer:

TRIM
SUBSTITUTE
MID
RIGHT
LEFT
Related Questions

Q84: XML is _.<br>A)Excel's version of HTML<br>B)a method

Q85: Power Query can do all of the

Q86: Importing XML data into Excel enables you

Q87: Where can you open XML files in

Q88: _ is an Excel add-in that enables

Q90: Match each of the following concepts to

Q91: _ is an Excel add-in Business Intelligence

Q92: Which is not true about building PivotTables

Q93: Which of the following actions refreshes data

Q94: Which of the following functions is best