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.

Question

Quizplus · Accepted Answer

The Answer of 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.

Match the Following Five Functions to Their Descriptions