Q. 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.
💬 Discuss
✅ Correct Answer: (D) Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.

Published by Mr. Dubey ⭐ 111.42K Points at 14-Jan-2024 12:38 pm in Microsoft Excel

You must be Logged in to update hint/solution

💬 Discussion

📊 Question Analytics

👁️
180
Total Visits
📽️
3 y ago
Published
🎖️
Mr. Dubey
Publisher
📈
82%
Success Rate