1. Why is =SUM(J4:J34) usually better than writing =J4+J5+J6+ ... +J34?
It is much shorter and easier to check
It gives a more accurate total than a formula
It automatically rounds the total to a whole number
It sorts the numbers into order as it adds them