Question

Which function can you use to abbreviate the lengthy expression, A1+A2+A3+A3...+A19+A20?  MAX COUNT SUM ROUND

Answer 1

Answer:

SUM

Explanation:

The lengthy expression, A1 + A2 + A3 + A4 + ... + A19 + A20 can be abbreviated with the function SUM. In this case, the expression is: SUM(A1:A20). As can be seen with this example, this function returns the sum of the range of cells.