A systems analyst receives an error report and wants to quickly switch the rows to columns in order to match the format required for analysis. Which of the following spreadsheet functions should the…

The correct answer is C. Transpose. TRANSPOSE is the correct choice because it is specifically designed to rotate data orientation - converting rows into columns and columns into rows - which is exactly what the analyst needs to reformat the report. CONCAT (or CONCATENATE) joins multiple text strings or cell…

Troubleshooting Data Systems

Question

A systems analyst receives an error report and wants to quickly switch the rows to columns in order to match the format required for analysis. Which of the following spreadsheet functions should the analyst use to make this change?

Options

AConcat
CTranspose
DClean

How the community answered

(27 responses)

A
15% (4)
C
78% (21)
D
7% (2)

Explanation

TRANSPOSE is the correct choice because it is specifically designed to rotate data orientation - converting rows into columns and columns into rows - which is exactly what the analyst needs to reformat the report.

CONCAT (or CONCATENATE) joins multiple text strings or cell values together into one combined string; it has nothing to do with changing data layout. CLEAN removes non-printable characters from text, which is useful for data cleaning but irrelevant to restructuring row/column orientation.

Memory tip: Think of transpose from math class - transposing a matrix flips it diagonally, swapping rows and columns. Same concept, same word in spreadsheets (Excel, Google Sheets both use =TRANSPOSE()).

Topics

#spreadsheet functions#data transformation#transpose#data formatting

Community Discussion

No community discussion yet for this question.

Full DS0-001 Practice