Question
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
Posted under MS Office
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. When a row of data is to be converted into columns
Similar Questions
Discover Related MCQs
Q. Ctrl + D shortcut key in Excel will
View solution
Q. The short cut key Ctrl + R is used in Excel to
View solution
Q. The command Edit >> Fill Across Worksheet is active only when
View solution
Q. Which of the following series type is not valid for Fill Series dialog box?
View solution
Q. Which of the following you can paste selectively using Paste Special command?
View solution
Q. Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
View solution
Q. Edit >> Delete command
View solution
Q. To remove the content of selected cells you must issue ______ command
View solution
Q. The Delete key of keyboard is assigned to which command in Excel?
View solution
Q. If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
View solution
Q. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
View solution
Q. Which of the following action removes a sheet from workbook?
View solution
Q. While Finding and Replacing some data in Excel, which of the following statement is valid?
View solution
Q. Which of the following is not true about Find and Replace in Excel
View solution
Q. You can move a sheet from one workbook into new book by
View solution
Q. What is the short cut key to replace a data with another in sheet?
View solution
Q. Comments put in cells are called .....
View solution
Q. Comments can be added to cells using ......
View solution
Q. Which menu option can be used to split windows into two?
View solution
Q. Getting data from a cell located in a different sheet is called ......
View solution
Suggested Topics
Are you eager to expand your knowledge beyond MS Office? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
