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
Intermediate
What do Excel’s Outlining Tools do?
Allow spreadsheet sections to be grouped and compressed via easy-to-use controls
Hide rows and columns from users
Draw borders around data
Don’t know
2
Intermediate
Suppose cells B24:B25 are grouped so they can be compressed to show the value in B26. When expanded, B26 has a top and bottom border on the cell. When compressed the top border disappears, but the bottom one doesn’t. Where are these borders applied?
Both the top and bottom border are applied on B26
B25 and B26 both have bottom borders only
B25 has a top border and B27 has a top border
Don’t know
3
Intermediate
Suppose rows 4:9 are grouped, as are rows 10:32, 12:17, 18:24 and 25:31. Which is the best method to show all the data rows?
Go to the Data tab and choose Ungroup and then Clear Outline
Click all the little + icons
Click the 3 in the outline
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement