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
Imagine that you have a spreadsheet to print, and you want all columns to fit on one page while allowing as many pages to be printed as necessary for all rows to be displayed. Which method is the best?
On the Page Layout tab, set Width to 1 page
In Print Preview, set the scaling to “Fit Sheet on One Page”
Manually scale the job until it fits the required page width
Don’t know
2
Intermediate
How do you get Excel to print the date and time of the print job in the header for each page?
Go to Print Preview and check the “Time stamp in header” option
Go to Page Layout, and then Print Titles and Custom Header, and type “Printed “ and click the date and time icons
Use the formula =NOW() in row 1, and then repeat row 1 at the top of each page to be printed
Don’t know
3
Intermediate
Suppose you want to repeat the top 5 rows of your spreadsheet on every page printed. Where do you go to configure this?
Via Print Preview
In the Print Layout tab, click the Print Titles button in Page Setup
In the Print Layout tab, click the Print Areas button in Page Setup
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement