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?
Hide rows and columns from users
Draw borders around data.
Allow you to group and compress spreadsheet sections via easy to use controls
Don’t know
2
Intermediate
Assume that B24:B25 are grouped so that when you can compress them 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 the borders applied?
B25 has a top border and B27 has a top border
B25 and B26 both have bottom borders only.
Both the top and bottom border are applied on B26
Don’t know
3
Intermediate
Assuming that rows 10:12 are grouped, that rows 20:40 are grouped, and rows 25:30 are also grouped, what is the best way to show all the data rows?
Click all the little + icons
Go to the Data tab and choose Ungroup > Clear Outline
Click the 3 in the outline
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement