Home › IBPS PO › Computer Awareness › Computer Awareness › In MS Excel, what does the function =SUM(A1:A10)…
In MS Excel, what does the function =SUM(A1:A10) do?
AMultiplies
BCounts
CAdds the values from cells A1 through A10
DRandom
Answer & Solution
Correct answer: C. Adds the values from cells A1 through A10
SUM: built-in function for addition. SUM(A1:A10) = A1 + A2 + ... + A10. Range notation: colon (:) means contiguous range. Other arithmetic functions: AVERAGE, MIN, MAX, COUNT, MEDIAN.
Related questions