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.
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)- B4% (1)
- C89% (25)
- D7% (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.
Transpose is a function used to swap rows and columns of a data range, not to combine text within cells.
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.
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.
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
Community Discussion
No community discussion yet for this question.