Which command will you choose to convert a column of data into row?

A. Cut and Paste

B. Paste Special > Transpose

C. Both of above

D. None of above

Answer: Option B

Solution(By Examveda Team)

Transpose (rotate) data from rows to columns or vice versa. To use options from the Paste Special box, click Home > Paste > Paste Special > Transpose

MS Excel mcq solution image

Join The Discussion

Comments ( 2 )

  1. Soustabh Paul
    Soustabh Paul :
    1 year ago

    Use Pivot table as well

  2. Paras Wadhwa
    Paras Wadhwa :
    4 years ago

    B is right answer

Related Questions on MS Excel