Back to lesson
1. What is the keyboard shortcut for summing a column of data?
CTRL + =
ALT + Up Arrow
ALT + =
2. The numbers 1, 2, 3, 4 and 5 appear in cells C4:C8. Cell C9 sums the range but gives a value of 12 rather than 15. What might be the problem?
C4:C8 is actually a range name which refers to values elsewhere on the spreadsheet, which do actually add up to 12.
The value ‘3’ is being treated as a text, rather than a numerical value.
The user did not press ENTER correctly.
3. If we wanted to add a range of cells together what would be the function that we would use?
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement