Respuesta :

Answer:

Option B, =CONCATENATE(A3," ",B3)

Explanation:

CONCATENATE function is used to join two or more strings together. The syntax for CONCATENATE function in Microsoft Excel is:

CONCATENATE( text1, [ text2, ... text_n ] )

Where, ext1, text2, ... text_n represents the strings that are to be joined together.  

CONCATENATE(A2," ",B2)

The above syntax is used when space is to be entered between two string values

Hence, option B is correct

fichoh

The concatenate function is used to combine two string values together. To combine values in cell A3 and B3 seperated by a space, the required function is =CONCATENATE(A3,"",B3)

  • Since the string values are already in a cell, we do not need to enclose A3 and B3 in quotes.

  • Enclosing A3 and B3 in double quotes will mean that the values A3 and B3 will be displayed as output instead of the values in their respective cells.

  • The "" in between A3 and B3 inserts a space in between the values of A3 and B3

  • The string values in cell A3 and B3 are combined.

Therefore, the appropriate formula required is =CONCATENATE(A3,"",B3)

Learn more :https://brainly.com/question/15566254

Otras preguntas