CompTIA
DA0-001 · Question #522
As a result of using a function in a spreadsheet, an analyst received the conversion of rows into columns and columns into rows. Which of the following functions did the analyst use?
The correct answer is A. TRANSPOSE. The TRANSPOSE function switches the orientation of data by converting rows into columns and columns into rows in a spreadsheet.
Data Analysis
Question
As a result of using a function in a spreadsheet, an analyst received the conversion of rows into columns and columns into rows. Which of the following functions did the analyst use?
Options
- ATRANSPOSE
- BJOIN
- CSTDEV
- DMEDIAN
How the community answered
(22 responses)- A95% (21)
- D5% (1)
Explanation
The TRANSPOSE function switches the orientation of data by converting rows into columns and columns into rows in a spreadsheet.
Topics
#Spreadsheet functions#Data transformation#TRANSPOSE function
Community Discussion
No community discussion yet for this question.