CompTIA Data+ (DA0-001) — Question 287

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?

Answer options

• A. Transpose
• B. Blend
• C. Concatenate
• D. Merge

Correct answer: C

Explanation

The correct answer is C, Concatenate, as it specifically refers to the process of joining two or more strings together into a single string. Options A (Transpose) and D (Merge) do not serve the purpose of combining text from multiple cells into one, and B (Blend) is not a standard operation for text concatenation.