easyFPSCNTSCSSPPSCMS Office & Productivity
Answer explanation
Explanation included
Practice quiz ready
Question

Which function displays row data into column or column data into row?

AHyperlink
BIndex
CTranspose
DRows

Choose an option to check yourself, or reveal the answer and explanation instantly.

Related MS Office & Productivity MCQs

View all

Test Yourself

Take a full quiz on MS Office & Productivity

Start Quiz

Exam Coverage

FPSCNTSCSSPPSC

Trust

Answer is visible after reveal
Explanation helps learning
Free topic quiz available

Subject

MS Office & Productivity

Save your progress

Create a free account to bookmark MCQs and track weak areas.

Register Free
Start QuizMore MCQs
Answer and explanation

Correct Answer: C: Transpose

Explanation: The correct answer is C: Transpose. The TRANSPOSE function in Excel converts a vertical range of cells to a horizontal range, or vice versa. This is entered as an array formula using Ctrl+Shift+Enter in older Excel versions.