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. You want to track the progress of the stock market on a daily basis. Which type of chart should you…
  2. How do you display current date and time in MS Excel?
  3. Which of the following is the latest version of Excel
  4. When you link data maintained in an excel workbook to a word document
  5. Which of the following format you can decide to apply or not in AutoFormat dialog box?
  6. When a range is selected, how can you activate the previous cell?
  7. It is acceptable to let long text flow into adjacent cells on a worksheet when
  8. Which of the following is not an example of a value?
  9. In help menu of Excel, which of the following tabs are found?
  10. You can use the formula palette to
  11. When you want to insert a blank imbedded excel object in a word document you can
  12. The spelling dialog box can be involved by choosing spelling from ________ menu.
  13. Which of the following formulas is not entered correctly?
  14. Comments put in cells are called .....
  15. Which of the following is not the correct method of editing the cell content?
  16. What will be the output if you format the cell containing 5436.8 as #,##0.00'?
  17. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish…
  18. Which of the following series type is not valid for Fill Series dialog box?
  19. Which of the following is not a valid data type in excel
  20. How can you print three copies of a workbook?
  21. Files created with Lotus 1-2-3 have an extension
  22. You can convert existing excel worksheet data an charts to an HTML document by using
  23. You can copy data or formulas
  24. To copy formatting from one area in a worksheet and apply it to another area you would use:
  25. Which area in an excel window allows entering values and formulas
  26. You can activate a cell by
  27. You can use the horizontal and vertical scroll bars to
  28. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
  29. Which tool you will use to join some cells and place the content at the middle of joined cell?
  30. Which of the cell pointer indicates that you can fill series?