Q. What is the purpose of the TRANSPOSE function in Excel?

A
Converts text to numbers
B
Swaps rows and columns of a range
C
Sorts data
D
Filters data
Solution:

TRANSPOSE() rotates a range of cells, swapping rows and columns.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!