Multiple choice technology

You can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that?

  1. & (ampersand)

  2. (space)

  3. = (equal sign)

  4. $ (Dollar sign)
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The ampersand (&) concatenates text in Excel formulas. For example, =A1&A2 combines text from both cells. This is an alternative to the CONCATENATE function for joining text strings.