nerdexam
CompTIA

DA0-001 · Question #329

An analyst is working with a data set that lists individuals' first and last names in separate columns. Which of the following processes should the analyst use to combine the first and last names into

The correct answer is C. Concatenate. To combine text from separate columns, such as first and last names, into a single spreadsheet cell, the analyst should use the concatenate process. This operation joins two or more text strings together into one longer string.

Data Analysis

Question

An analyst is working with a data set that lists individuals' first and last names in separate columns. Which of the following processes should the analyst use to combine the first and last names into a single spreadsheet cell?

Options

  • ATranspose
  • BBlend
  • CConcatenate
  • DMerges

How the community answered

(28 responses)
  • B
    4% (1)
  • C
    89% (25)
  • D
    7% (2)

Why each option

To combine text from separate columns, such as first and last names, into a single spreadsheet cell, the analyst should use the concatenate process. This operation joins two or more text strings together into one longer string.

ATranspose

Transpose is a function used to swap rows and columns of a data range, not to combine text within cells.

BBlend

Blend usually refers to combining data from multiple sources or tables, typically in a data visualization tool, not specifically joining text within a single spreadsheet row.

CConcatenateCorrect

Concatenation is the process of joining two or more text strings (or values from different cells/columns) end-to-end to form a single, longer string. In a spreadsheet, functions like CONCATENATE or the '&' operator are used to combine first and last names from separate columns into one cell.

DMerges

Merges typically refers to combining cells into one larger cell or combining datasets based on common keys, neither of which directly describes joining text strings from separate columns into a single text string.

Concept tested: Data manipulation - text concatenation

Source: https://support.microsoft.com/en-us/office/combine-text-from-two-or-more-cells-into-one-cell-85a2a220-40e8-4654-8c85-61b17a177264

Topics

#Data preparation#Text functions#Concatenation#Data manipulation

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice