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:A6)
=SUM(A1,A4:A6)
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?
=SUBTOTAL(9,B4:B15)
=SUM(B4:B15)
=SUM(B4,B9:B15)
3
Beginner
A5 shows a value of 1234.56. Which of the following methods would you use to round the value 1235?
=ROUND(A5,-1)
Select A5, go to the Home tab, and press the Decrease decimal button on the Number group twice
=ROUND(A5,0)
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement