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&" "C2 A2&" "&B2&" "C2 =CONCATENATE(A2&" "&B2&" "C2) =CONCATENATE(A2," ",B2," "C2) =CONCATENATE(A2)&" "&(B2)&" "(C2)

=CONCATENATE(A2," ",B2," "C2)

Explanation:

The concatenate function in excel can be used to combine inputs in two or more cells.

The formula =CONCATENATE(A2," ",B2," "C2) could be explained thus :

'=' All excel functions starts with the = sign

'Concatenate' the function which allows us to combine

A2 = column A row 2

B2 = column B row 2

C2 = column C row 2

" " means a space after each cell input.

genre is the best answer