which of the following is the formula used in cell a3 on the november 23 worksheet?\n=join(b21,c21)\n=concat(…

Brief Explanations:

In spreadsheet software like Excel, the CONCAT function is used to combine text from multiple ranges and/or strings. To combine the values of cell B21 and C21 with a space in - between, we use the CONCAT function with a space character as the delimiter. The space character is represented as a string within double - quotes. The JOIN function is not a standard Excel function for this purpose. The CONCAT(B21,C21) would combine the values without any separator. The CONCAT(B21,space,C21) is incorrect as "space" is not a recognized syntax for a space character in this context.

Answer:

=CONCAT(B21," ",C21)