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. Which of the following is not an example of a value?
  2. We can save and protect the workbook by
  3. Which of the following is not a way to complete a cell entry?
  4. Which of the following is the latest version of Excel
  5. It is acceptable to let long text flow into adjacent cells on a worksheet when
  6. Which elements of worksheet can be protected from accidental modification
  7. Which of the following is not a term of MS-Excel?
  8. In a worksheet you can select
  9. Files created with Lotus 1-2-3 have an extension
  10. The Name box on to the left of formula bar
  11. Which Chart can be created in Excel?
  12. Which of the following action removes a sheet from workbook?
  13. How can you print three copies of a workbook?
  14. Each excel file is called a workbook because
  15. You can use the formula pallette to
  16. In the formula, which symbol specifies the fixed columns or rows?
  17. The Paste Special command lets you copy and paste:
  18. You can use the format painter multiple times before you turn it off by
  19. Which of the following is not a basic step in creating a worksheet?
  20. If you need to remove only the formatting done in a range (numbers and formula typed there should not…
  21. Documentation should include
  22. You can auto fit the width of column by
  23. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
  24. In Excel, the Fill Color button on the Formatting toolbar is used for what?
  25. Which of the cell pointer indicate that you can move the content to other cell?
  26. How can you find specific information in a list?
  27. Comments can be added to cells using
  28. To copy formatting from one area in a worksheet and apply it to another area you would use:
  29. Which is used to perform what if analysis?
  30. Which button do you click to add up a series of numbers?