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. When you insert an excel file into a word document. The data are
  2. You can convert existing excel worksheet data an charts to an HTML document by using
  3. The Paste Special command lets you copy and paste:
  4. How can you find specific information in a list?
  5. You can use drag-and-drop to embed excel worksheet data in a word document
  6. How can you remove borders applied in cells?ACC
  7. What will be the output if you format the cell containing 5436.8 as #,##0.00'?
  8. Edit >> Delete command
  9. In a worksheet you can select
  10. Which tool you will use to join some cells and place the content at the middle of joined cell?
  11. Tab scroll buttons are place on Excel screen
  12. When you link data maintained in an excel workbook to a word document
  13. Which of the following is a correct order of precedence in formula calculation?
  14. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
  15. Which of the following is not an example of a value?
  16. To view a cell comment
  17. MS-EXCEL is based on .........?
  18. Which key do you press to check spelling?
  19. A typical worksheet has . Number of columns
  20. When a row of data is to be converted into columns
  21. You can check the conditions against __________ when applying conditional formatting
  22. How can you show or hide the gridlines in Excel Worksheet?
  23. Ctrl + D shortcut key in Excel will
  24. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  25. Status indicators are located on the
  26. B7:B9 indicates:
  27. The auto calculate feature
  28. The Name box on to the left of formula bar
  29. Which of the following you can paste selectively using Paste Special command?
  30. Comments put in cells are called .....