Match the Following Five Functions to Their Descriptions

Multiple Choice

Match the following five functions to their descriptions:
i.Flash Fill
II.Text Function
III.LEFT
IV.CONCATENATE
v.TRIM

A) A text function that returns the specified number of characters from the beginning of a string of characters.
B) A text function that can join up to 255 strings of characters.
C) A function to combine or separate data,change case,and apply formatting to a string of characters.
D) A text function to remove extra blank spaces from a string.
E) A feature that predicts how to alter data based upon the pattern you enter into the cell at the beginning of the column.