For which situation is the “text to columns” feature most appropriate?1 pointBreak down a cell containing a mixture of honorifics, first names, middle initials, and surnames into multiple rows D: Removing white space from a string containing first names and surnames in a cell.Combining two columns containing “<firstname>” and “<surname>” into a single column.Splitting a column containing “<firstname> <surname>” into two columns

What needs to be specified in order to split a string with the Text to Columns tool?

Show first name and last name concatinated into one column to show their full name.

Which command will you choose to convert a column of data into row?Cut and PastePaste Special > TransposeBoth of aboveNone of above

There is a "Full Name" field with last name and first name separated by a comma. How can you parse the field into "Last Name" and "First Name" fields?Select an answer:=LEFT(Full Name, 10)=Right(Full Name, 10)Text to Columns=Concat(Full Name, Full Name)

Define "columns" and provide an example with an explanation (2-3 sentences) in your document