Question

Lili is working with a very large spreadsheet and wants to combine the salutation with names (such as, turn the three cells “Mr.”, “Juan”, and “Ruiz” into one cell saying “Mr. Juan Ruiz”). Why is CONCAT preferable over Merge?

(1 point)
Responses

Merge only works on empty cells; CONCAT works on any cell.

Merge only works on empty cells; CONCAT works on any cell.

Merge is for styling cells; CONCAT is for combining text.

Merge is for styling cells; CONCAT is for combining text.

Merge only works on numbers; CONCAT works on anything.

Merge only works on numbers; CONCAT works on anything.

Merge adds a space between each string; CONCAT doesn’t.

Merge adds a space between each string; CONCAT doesn’t.

Answer 1

Merge is for styling cells; CONCAT is for combining text.