10
AssignmentMultiple Select

Introduction to Functions

Question 10 • Computer Applications - Office 2016 - EL3520 A

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