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

Correct Answer : D.


Download Objective type questions of Microsoft Excel PDF

Visit our PDF store

Get all objective type questions of Microsoft Excel MCQ

You can do it
  1. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
  2. Comments put in cells are called .....
  3. The first cell in EXCEL worksheet is labeled as
  4. Which of following is Not one of Excels what-if function?
  5. Hyperlinks can be
  6. Tab scroll buttons are place on Excel screen
  7. The autofill feature
  8. You want to track the progress of the stock market on a daily basis. Which type of chart should you…
  9. Concatenation of text can be done using
  10. You can use the drag and drop method to
  11. Text formulas:
  12. Which would you choose to create a bar diagram?
  13. Which area in an excel window allows entering values and formulas
  14. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
  15. Which symbol must all formula begin with?
  16. If you need to remove only the formatting done in a range (numbers and formula typed there should not…
  17. The auto calculate feature
  18. How can you print three copies of a workbook?
  19. Comments put in cells are called
  20. An excel workbook is a collection of
  21. It is acceptable to let long text flow into adjacent cells on a worksheet when
  22. In Excel, a Data Series is defined as what?
  23. You can auto fit the width of column by
  24. How do you wrap the text in a cell?
  25. What will be the output if you format the cell containing 5436.8 as #,##0.00'?
  26. Paste Special allows some operation while you paste to new cell. Which of the following operation is…
  27. Which of the following action removes a sheet from workbook?
  28. Which Chart can be created in Excel?
  29. Which of the following methods can not be used to edit the contents of a cell?
  30. How many worksheets can a workbook have?