Question

What function would you use to add two text cells together?

Options:
Option 1: CONCATENATE
Option 2: SUM
Option 3: AVERAGE
Option 4: COUNT

Answer 1

To add two text cells together, you would use the CONCATENATE function. The SUM, AVERAGE, and COUNT functions are used for calculations with numerical values.

Step-by-step explanation:

To add two text cells together, you would use the CONCATENATE function. This function allows you to combine two or more text strings into one.

For example, if you have the text 'Hello' in cell A1 and the text 'World' in cell B1, you can use the formula =CONCATENATE(A1, B1) to get the result 'HelloWorld' in another cell.

The SUM function is used for adding numerical values, the AVERAGE function calculates the average of numbers, and the COUNT function counts the number of cells that contain a number.