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:
Premises:
Responses:
TRIM
SUBSTITUTE
MID
RIGHT
LEFT
Premises:
TRIM
SUBSTITUTE
MID
RIGHT
LEFT
Responses:
Related Questions
Q85: Power Query is a tool to help
Q86: Power View can perform aggregate calculations, create
Q87: The true benefit of Power Query is
Q88: Match each of the following term to
Q89: Match each of the following concepts to
Q90: Match each of the following concepts to
Q92: Match each of the following functions to
Q93: Match each of the following terms to
Q94: Match each of the following terms to
Q95: Match each of the following concepts to
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents