adplus-dvertising
frame-decoration

Question

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

a.

Cut and Paste

b.

Edit >> Paste Special >> Transpose

c.

Both of above

d.

None of above

Posted under MS Office

Answer: (b).Edit >> Paste Special >> Transpose

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

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

Similar Questions

Discover Related MCQs

Q. It is acceptable to let long text flow into adjacent cells on a worksheet when

Q. Which of the cell pointer indicates you that you can make selection?

Q. Which of the cell pointer indicates that you can fill series?

Q. Which of the cell pointer indicate that you can move the content to other cell?

Q. You can auto fit the width of column by

Q. Long text can be broken down into many lines within a cell. You can do this through

Q. MS Excel provides the default value for step in Fill Series dialog box

Q. When a row of data is to be converted into columns

Q. Ctrl + D shortcut key in Excel will

Q. The short cut key Ctrl + R is used in Excel to

Q. The command Edit >> Fill Across Worksheet is active only when

Q. Which of the following series type is not valid for Fill Series dialog box?

Q. Which of the following you can paste selectively using Paste Special command?

Q. Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

Q. Edit >> Delete command

Q. To remove the content of selected cells you must issue ______ command

Q. The Delete key of keyboard is assigned to which command in Excel?

Q. If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

Q. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?

Q. Which of the following action removes a sheet from workbook?