Answer: D.) LEFT
Explanation: LEFT is an excel function allows users to extract a specified number of characters starting from the left. The syntax goes thus :
=LEFT(text, [num_chars])
text: the original string in which characters are to be extracted.
num_chars : takes an integer, stating the number of characters to extract.
The proper function is also an excel function which sets the first character in each word to uppercase. The mid function is also used in text extraction starting from any position in the original string based on what is specified.
The LEN function is used to get the number or length of characters in a string.
