Question

Which function is used to join two or more addresses in different cells?

• A. (A) AND
• B. (B) VLOOKUP
• C. (C) IF
• D. (D) CONCATENATE

Answer 1

Answer:

D. (D) CONCATENATE

• The word concatenate is just another way of saying "to combine" or "to join together".
• The CONCATENATE function allows you to combine text from different cells into one cell.