Question

Celeste has created a SUM function using the following data: A, B, C, one, 2, 3. What will the
function return?
(1 point)
6
5
one
The function will return an error.

Answer 1

In the context of a SUM function which typically sums numeric values, Celeste's data includes both numbers and a text value:

- A = (text)
- B = (text)
- C = (text)
- one = (text, the word for the number 1)
- 2 = (numeric value)
- 3 = (numeric value)

The SUM function usually ignores non-numeric values and sums only the numeric ones. Therefore, it would sum the values 2 and 3 only.

So, the calculation would be:

2 + 3 = 5

Thus, the function will return **5**.