Home

When a row of data is to be converted into columns

Share latest video status. Download from playstore now!

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

Share this question with your friends

Correct Answer : D.


Download Objective type questions of Microsoft Excel PDF

Get all objective type questions of Microsoft Excel MCQ

Related Questions

  1. You can use the drag and drop method to
  2. You can activate a cell by
  3. Which setting you must modify to print a worksheet using letterhead?
  4. How do you rearrange the data in ascending or descending order?
  5. To select an entire column in MS-EXCEL, press?
  6. Data can be arranged in a worksheet in a easy to understand manner using
  7. When you want to insert a blank imbedded excel object in a word document you can
  8. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  9. Which of the cell pointer indicates you that you can make selection?
  10. Where can you set the shading color for a range of cells in Excel?
  11. You want to track the progress of the stock market on a daily basis. Which type of chart should you…
  12. Excel probably considers the cell entry January 1, 2000 to be a
  13. What will be the output if you format the cell containing 5436.8 as #,##0.00'?
  14. Which of following is Not one of Excels what-if function?
  15. Which of the following is invalid statement?
  16. Which of the following is not the correct method of editing the cell content?
  17. Which of the following is not a worksheet design criterion?
  18. Edit >> Delete command
  19. The command Edit >> Fill Across Worksheet is active only when
  20. Which elements of a worksheet can be protected from accidental modification?
  21. Excel displays the current cell address in the ........
  22. How do you display current date only in MS Excel?
  23. You can copy data or formulas
  24. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
  25. To delete an embedded objects, first
  26. A worksheet range is a
  27. The Name box on to the left of formula bar
  28. Which key do you press to check spelling?
  29. The Chart wizard term data categories refers to;
  30. What is represented by the small, black square in the lower-right corner of an active cell or range?

Please do not use chat terms. Example: avoid using "grt" instead of "great".

Submit
Load More..

Also checkout these categories

Physical Measurement MCQ Solution MCQ MS Office MCQ Zoology MCQ H.C.F and L.C.M MCQ Cause & Effect MCQ Synthesis of Sentences MCQ Bryophyta MCQ Softwares MCQ Genital trauma MCQ Lower urinary tract trauma MCQ Mechanical Engineering MCQ