8
AssignmentMultiple Select

Working with Functions

Question 8 • TX-Business Information Management (BIM) I B

Which formulas would work to combine cells with first, middle, and last names from columns A through C and row 2 into a new cell? Check all that apply.=A2&“ ”&B2&“ ”C2A2&“ ”&B2&“ ”C2=CONCATENATE(A2&“ ”&B2&“ ”C2)=CONCATENATE(A2,“ ”,B2,“ ”C2)=CONCATENATE(A2)&“ ”&(B2)&“ ”(C2)

Answer
A
=A2&“ ”&B2&“ ”C2
B
A2&“ ”&B2&“ ”C2
C
=CONCATENATE(A2&“ ”&B2&“ ”C2)
D
=CONCATENATE(A2,“ ”,B2,“ ”C2)
E
=CONCATENATE(A2)&“ ”&(B2)&“ ”(C2)
Previous
Next