Question

III. Explain the following functions:

1. SUM ( )

2. AVERAGE ( )​

Answer 1

Answer:

SUM

Summation, the addition of a sequence of numbers  

This Sum function will add the value of anything it finds within the specified range. 

"=SUM(A1:A20)"  - This will give us the Sum of Column A between A1 and A20.

We can also stipulate each number manually as well, for example: =SUM(12,4,6,8) would give us the value 30. The function will total the value of all reference or values within the parenthesis.

AVERAGE

Gives you the mean average of values within the specified range.  

This is not to be confused with the Mode or Median average. 

"=AVERAGE(A1:A20)"

Explanation:

hope it helps