PREMIUM
Join our WhatsApp Channel
Daily MCQs, Past Papers & Jobs for PPSC, FPSC, CSS
Daily MCQs • Past Papers • Jobs for PPSC, FPSC, CSS
Join Channel

Which Excel function displays row data as columns or column data as rows?

A. Transpose
B. Pivot
C. Filter
D. Sort
Correct Answer: A. Transpose

Correct answer: Transpose. Transpose swaps rows and columns, turning rows into columns and back.

Background: In Excel, Paste Special offers Transpose, which flips a copied range on its side.

  • Pivot: A PivotTable summarises data by grouping it, not by swapping rows and columns.
  • Filter: It hides rows that fail a condition, and changes nothing into columns.
  • Sort: It reorders rows by value, and swaps nothing.

Did you know? The TRANSPOSE function can flip a range live with a formula.

Memory trick: Transpose means turn it sideways.

0 comments

Leave a Reply

Join Our WhatsApp Channel ×