Learn Excel EasyDaily One Lesson

Quiz › Formulas & Functions › Joining text with &

Joining text with &: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

  1. A1 has Ravi and B1 has Kumar. What will this formula return?
    =A1&B1
    • A. Ravi Kumar
    • B. RaviKumar
    • C. Ravi&Kumar
    • D. An error
    Show the answerB — RaviKumar. & joins exactly what you give it. There is no space.
  2. A1 has Ravi and B1 has Kumar. What will this formula return?
    =A1&" "&B1
    • A. Ravi Kumar
    • B. An error
    • C. RaviKumar
    • D. Ravi&Kumar
    Show the answerA — Ravi Kumar. The " " in the middle adds the space.
  3. A1 = 5 and B1 = 3. What will this formula return?
    =A1&B1
    • A. An error
    • B. 8
    • C. 15
    • D. 53
    Show the answerD — 53. & joins, it does not add. 5 and 3 become 53.
  4. A1, A2, A3 have A, B, C. What will this formula return?
    =TEXTJOIN("-",TRUE,A1:A3)
    • A. A-B-C
    • B. A B C
    • C. A,B,C
    • D. ABC
    Show the answerA — A-B-C. TEXTJOIN puts - between every item: A-B-C.
  5. B1 = 50. What will this formula return?
    ="Total: "&B1
    • A. Total: 50
    • B. Total:
    • C. An error
    • D. 50
    Show the answerA — Total: 50. & joins the words and the number: Total: 50.

Want to learn this? Read the Formulas & Functions lessons →
← More Formulas & Functions topics · All quiz categories