DS0-001: CompTIA DataSys+Demo

By CompTIA · Question Mode

QuestionQ100

Database Fundamentals

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

  • A Concat
  • B VLookUp
  • C Transpose
  • D Clean
Explanation

The TRANSPOSE function changes the orientation of a range, converting rows to columns and columns to rows.

Community Discussion

No comments yet. Be the first to start the discussion!