Celeste has created a SUM function using the following data: A, B, C, one, 2, 3. What will the

Question

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.