Which of the following is the correct formula to use in order to combine the last name and first name in this example so that the end result is what you see in Cell D2?
A. =TRANSPOSE(B2, C2)
B. =COMBINE(B2,", ",C2)
C. =CONCATENATE(B2,", ",C2)
D. =TEXT (B2:C2, PROPER)
E. I don t know the answer to this question.
This question is part of Excel 2010 Skills Assessment
Asked by Carlson
, Last updated: Dec 05, 2017