Latest:
LinkedIn Microsoft Excel Certification 

How can you create the lower table from the top one when the tables are not linked?

Editorial Staff
  • Select Paste Special > Values.
  • Select Paste Special > Transpose.
  • Use the TRANSPOSE function
  • Click Switch Rows & Columns

The correct answer is:

  • Select Paste Special > Transpose.

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers

You May Also Like

What is the output of the formula =(8+2*3)/2?

Certificate Land 0

In the worksheet shown below, cell C6 contains the formula=VLOOKUP(A6,$F$2:$G$10,2,FALSE). What is the most likely reason that #N/A is returned in cell C6 instead of mallory’s ID (2H54)

Editorial Staff 0

You are creating a slide that shows annual rainfall in different regions of Europe. What chart type would most effectively communicate that relationship?

Editorial Staff 0