[Solved] When a row of data is to be converted into columns

McqMate

Q.	When a row of data is to be converted into columns
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.
Answer» D. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.

1.7k

0

Do you find this helpful?

6

View all MCQs in

Microsoft Excel (MS Excel)

Discussion

No comments yet

Related MCQs

What function displays row data in a column or column data in a row?
To insert three columns between columns D and E you would
Which command will you choose to convert a column of data into row?
In Excel A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button
In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page?
What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.
What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.
In Excel cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is
In Excel intersection of a row and column is called :
In Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the