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 save a workbook, you:
  2. You can move a sheet from one workbook into new book by
  3. Which of the following is not true regarding Conditional Formatting?
  4. Where can you change automatic or manual calculation mode in Excel?
  5. MS-EXCEL is based on .........?
  6. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
  7. Which of the following is not a worksheet design criterion?
  8. Documentation should include
  9. If you begin typing an entry into a cell and then realize that you dont want your entry placed into…
  10. Excel uniquely identifies cells within a worksheet with a cell name
  11. An excel workbook is a collection of
  12. You can use the horizontal and vertical scroll bars to
  13. Right clicking something in Excel:
  14. Which Chart can be created in Excel?
  15. Which of the following format you can decide to apply or not in AutoFormat dialog box?
  16. To view a cell comment
  17. You can enter which types of data into worksheet cells?
  18. Text formulas:
  19. You can use the formula palette to
  20. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
  21. How can you delete a record?
  22. What is the short cut key to replace a data with another in sheet?
  23. Comments can be added to cells using
  24. How can you remove borders applied in cells?ACC
  25. When a row of data is to be converted into columns
  26. To create a formula, you first:
  27. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
  28. How do you select an entire column?
  29. Which setting you must modify to print a worksheet using letterhead?
  30. Which of the following is not a way to complete a cell entry?