Home » Computer » MS Excel MCQ » When a row of data is to be converted into columns

When a row of data is to be converted into columns

 MCQ Question:  (Q.36)

When a row of data is to be converted into columns

Options:
A. Copy the cells in row, select the same number of cells in row and paste
B. Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
C. Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
D. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.

Correct Answer: Option D. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK. 

Leave a Reply

Your email address will not be published. Required fields are marked *

Solve : *
22 − 5 =