Which of the following symbol is used to combine the contents of two or more cells in MS Excel?

Correct option is C

In MS Excel, the ampersand symbol (&) is used to combine the contents of two or more cells into a single cell. This process is called concatenation. For example, if cell A1 contains "Hello" and cell B1 contains "World," the formula =A1 & " " & B1 will combine them into "Hello World."
Important Key Points:
1. The ampersand (&) symbol is a quick way to combine or concatenate text or numbers from different cells in Excel.
2. You can also use the CONCAT function for the same purpose, i.e., =CONCAT(A1, B1).
Knowledge Booster:
· %: Used to format numbers as percentages.
· +: Used for arithmetic addition, not for combining cell content.
· =: Used to start a formula in Excel.
· *: Used for multiplication, not concatenation.