Function

Question 1

One of the text functions, to join two or more text strings into one string.

Answer 1

CONCATENATE

Question 2

Method to join two or more text strings into one string.

Answer 2

Concatena Function, Ampersand (&)

Question 3

Function that returns the first character or characters in a text string, based on the number of characters you specify.

Answer 3

LEFT

Question 4

Function that returns the last character or characters in a text string, based on the number of characters you specify.

Answer 4

RIGHT

Question 5

Function that eturns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.

Answer 5

MID

Question 6

Removes all spaces from text except for single spaces between words.

Answer 6

TRIM

Question 7

Converts all uppercase letters in a text string to lowercase.

Answer 7

LOWER

Question 8

Converts text to uppercase.

Answer 8

UPPER

Question 9

Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.

Answer 9

PROPER

Question 10

locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string.

Answer 10

FIND & SEARCH

Question 11

Difference between FIND & SEARCH

Answer 11

FIND are case sensitive unlike SEARCH

Question 12

Substitutes new_text for old_text in a text string.

Answer 12

SUBTITUTE

Question 13

replaces part of a text string, based on the number of characters you specify, with a different text string.

Answer 13

REPLACE