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

Which function displays row data in a column or column data in a row?Answer areaReverseNone of the aboveIndexTranspose

Consider T = [1 0 0; 0 1 0; 0 0 1; 1 1 1]. What is the output of the following command?    transpose(T)

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 is the transpose of a matrix?a.A matrix with its rows and columns swapped.b.A matrix with its diagonal elements zeroed.c.A matrix with its elements inverted.d.A matrix with its elements squared.

What does the Unpivot feature in a dataset allow you to do?Select an answer:Retrieve the underlying rows of data from a pivot tableTrim your data, such as getting rid of leading and trailing spaces.Rename a column without affecting the data source.Transpose the data so it displays longer vertically and not as wide.