Recap-Sum() function

The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three.

• True

• False

If you change a value in the summed range, the formula will automatically update to show the new sum

• True

• False

Which formula is giving the same result as the one in cell A6

• =A1+A2+A3+A4+A5+A6/5

• =(A1+A2+A3+A4+A5+A6)/5

• =A1+A2+A3+A4+A5+(A6/5)

=SUM(A3:A6) and =SUM(A3,A6)

DO NOT MEAN THE SAME THING

• True

• False

In this Excel sheet these 2 formulas will give the same result

=SUM(A1:A3)

=SUM(10,25,32)

• True

• False