Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Beginner
What is the keyboard shortcut for summing a column of data?
ALT + Up Arrow
CTRL + =
ALT + =
Don’t know
2
Beginner
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?
The value ‘3’ is being treated as a text, rather than a numerical value.
C4:C8 is actually a range name which refers to values elsewhere on the spreadsheet, which do actually add up to 12.
The user did not press ENTER correctly.
Don’t know
3
Beginner
If we wanted to add a range of cells together what would be the function that we would use?
SUMIF
SUM
SUMPRODUCT
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement