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
If you wanted to add cells A1, and A4 through A6 together, which would be the best formula to use?
=SUM(A1,A4,A5,A6)
=SUM(A1,A4:A6)
=SUM(A1:A6)
Don’t know
2
Beginner
There is data in the cells B4:B15, with the following formula used to subtotal the data in B9: =SUBTOTAL(9,B5:B8). Which would be best formula to ensure that we’ve summed up all values from B4 through B15?
=SUM(B4:B15)
=SUM(B4,B9:B15)
=SUBTOTAL(9,B4:B15)
Don’t know
3
Beginner
A5 shows a value of 1234.56. Which of the following methods would you use to round the value 1235?
Select A5, go to the Home tab, and press the Decrease decimal button on the Number group twice.
=ROUND(A5,-1)
=ROUND(A5,0)
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement