What Formula Would Produce the Value in Cell c25?

Option A: =CONCATENATE(ITEM,” “,TYPE)

Option B: =RIGHT(A25,825)

Option C: =CONCATENATE(A25,” “,B25)

Option D: =LEFT(A25,B25)

Option E: =CONCATENATE(A25,B25)

Answer: The right answer is =CONCATENATE(A25,” “,B25).

Explanation: What Formula Would Produce the Value in Cell c25?

In Excel, the Function CONCATENATE is used to join the text of two cells. For example, to join the text of A1 & B1 cell, the formula is: =CONCATENATE(A1,B1)

Here, in the C25 cell, the value is Door F. There is a space between Door & F.

To create the space we have to use two inverted commas. So the formula we need to put in the C25 cell is : =CONCATENATE(A25,” “,B25)

Take a look at the below excel video for a better understanding: