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

You can do it
  1. To center worksheet titles across a range of cells, you must
  2. Which of the following you can paste selectively using Paste Special command?
  3. To view a cell comment
  4. Which is not the function of Edit, Clear command?
  5. You can use the horizontal and vertical scroll bars to
  6. Text formulas:
  7. While Finding and Replacing some data in Excel, which of the following statement is valid?
  8. What does COUNTA () function do?
  9. Documentation should include
  10. Which of the following is not a term of MS-Excel?
  11. When you copy a formula
  12. MS Excel provides the default value for step in Fill Series dialog box
  13. Ctrl + D shortcut key in Excel will
  14. How many worksheets can a workbook have?
  15. The active cell:
  16. Which language is used to create macros in Excel?
  17. How do you rearrange the data in ascending or descending order?
  18. Which of the following is not a valid data type in excel
  19. Which of the following is a correct order of precedence in formula calculation?
  20. Which area in an Excel window allows entering values and formulas?
  21. You can select a single range of cells by
  22. When you link data maintained in an excel workbook to a word document
  23. An Excel Workbook is a collection of .......
  24. When you want to insert a blank imbedded excel object in a word document you can
  25. Which of the following is not an example of a value?
  26. What symbol is used before a number to make it a label?
  27. Excel probably considers the cell entry January 1, 2000 to be a
  28. You can move a sheet from one workbook into new book by
  29. The auto calculate feature
  30. We can save and protect the workbook by