Home

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

Correct Answer : D.


Download Objective type questions of Microsoft Excel PDF

Visit our PDF store

Get all objective type questions of Microsoft Excel MCQ

You can do it
  1. What is the short cut key to highlight the entire column?
  2. You can use the horizontal and vertical scroll bars to
  3. Which of the following you can paste selectively using Paste Special command?
  4. A numeric value can be treated as label value if ...... precedes it.
  5. How do you display current date and time in MS Excel?
  6. Which of the following options is not located in the Page Setup dialog box?
  7. The autofill feature
  8. Files created with Lotus 1-2-3 have an extension
  9. To edit in an embedded excel worksheet object in a word document
  10. How many characters can be typed in a single cell in Excel?
  11. Which of following is Not one of Excels what-if function?
  12. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
  13. How can you delete a record?
  14. Which of the following is not the correct method of editing the cell content?
  15. It is acceptable to let long text flow into adjacent cells on a worksheet when
  16. You can use drag-and-drop to embed excel worksheet data in a word document
  17. Right clicking something in Excel:
  18. How can you remove borders applied in cells?ACC
  19. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
  20. An Excel Workbook is a collection of .......
  21. In Excel, a Data Series is defined as what?
  22. Which menu option can be used to split windows into two?
  23. Concatenation of text can be done using
  24. Which is used to perform what if analysis?
  25. You can use the drag and drop method to
  26. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  27. Which symbol must all formula begin with?
  28. You can select a single range of cells by
  29. Which tool you will use to join some cells and place the content at the middle of joined cell?
  30. Getting data from a cell located in a different sheet is called ......