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. The command Edit >> Fill Across Worksheet is active only when
  2. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  3. Where can you change automatic or manual calculation mode in Excel?
  4. Long text can be broken down into many lines within a cell. You can do this through
  5. Which of the following Excel screen components can NOT be turned on or off?
  6. Data can be arranged in a worksheet in a easy to understand manner using
  7. A worksheet can have a maximum of . Number of rows
  8. When you insert an excel file into a word document. The data are
  9. You can set Page Border in Excel from
  10. To create a formula, you first:
  11. In the formula, which symbol specifies the fixed columns or rows?
  12. You can activate a cell by
  13. When you copy a formula
  14. Status indicators are located on the
  15. Which is not the function of Edit, Clear command?
  16. The chart wizard term data series refers to
  17. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
  18. Which of the following methods can not be used to edit the contents of a cell?
  19. How many characters can be typed in a single cell in Excel?
  20. Which elements of a worksheet can be protected from accidental modification?
  21. Which button do you click to add up a series of numbers?
  22. To save a workbook, you:
  23. When a range is selected, how can you activate the previous cell?
  24. A numeric value can be treated as label value if ...... precedes it.
  25. While Finding and Replacing some data in Excel, which of the following statement is valid?
  26. Files created with Lotus 1-2-3 have an extension
  27. The first cell in EXCEL worksheet is labeled as
  28. The active cell:
  29. Which command will you choose to convert a column of data into row?
  30. You can copy data or formulas