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
Which of the following is not a reason why you might want to “stagger” headings and sub-headings (as pictured) for an ideal layout for a financial model?
When text is positioned in adjacent cells (even diagonally), Excel sometimes forces the formatting to be consistent in all connected cells.
Spacing plus indenting makes the layout easier to read.
Leaving blank rows and columns around key elements makes it easier to navigate between them.
Don’t know
2
Beginner
If you are in a worksheet with no more entries beneath the cell you are in (for that column), what would happen if you selected the keyboard shortcut CTRL + Down Arrow?
A dialog box would appear stating “No more cells to display”.
The cursor would return to the first cell populated in that column reading down the page.
The cursor would take you to the final cell in the worksheet in that column.
Don’t know
3
Beginner
If you are in the top row of a column of contiguous (touching) cells, how do you select the entire range?
CTRL + Down Arrow
CTRL + SHIFT + Down Arrow
CTRL + 1
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement