Computer Applications- Microsoft Excel: Printing Spreadsheets

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Ntorok

Ntorok

Community Contributor

Quizzes Created: 9 | Total Attempts: 3,199

Questions: 6 | Attempts: 116 | Updated: Apr 18, 2023

Questions

Settings

Create your own Quiz

Questions and Answers

1.

How do you preview a worksheet you want to print?
- A.
  
  View Button and select print
- B.
  
  Data Tab and select print preview
- C.
  
  Office Button and select print preview
- D.
  
  All of the Above
Correct Answer
C. Office Button and select print preview

Explanation
To preview a worksheet before printing, you can click on the Office Button (located in the top left corner of the screen in Microsoft Office applications) and then select "Print Preview" from the options. This will allow you to see how the worksheet will look when printed, including the page layout, formatting, and any potential issues that may need to be addressed before printing. By selecting this option, you can ensure that the worksheet appears as desired before actually printing it.

Rate this question:
2.

How can you just print a selected part of a worksheet?
- A.
  
  Highlight data you want to print and select print
- B.
  
  Select data and hit the office button. Select print and choose selection option in the print what section
- C.
  
  Select data you want to print, right click and choose copy
- D.
  
  None of the Above
Correct Answer
B. Select data and hit the office button. Select print and choose selection option in the print what section

Explanation
To print a selected part of a worksheet, you need to select the data you want to print and then click on the office button. From there, select the print option and choose the selection option in the print what section. This will ensure that only the selected data is printed and not the entire worksheet.

Rate this question:
3.

How can you change the orientation of a worksheet to landscape using Print Preview?
- A.
  
  In Print Preview Mode, select page setup and click landscape
- B.
  
  In Print Preview Mode, select show margins and change landscape
- C.
  
  In Print Preview Mode, select the data you want to change orientation and select print landscape
- D.
  
  All of the Above
Correct Answer
A. In Print Preview Mode, select page setup and click landscape

Explanation
In Print Preview Mode, selecting page setup and clicking landscape allows you to change the orientation of a worksheet to landscape. This option is typically found in the page setup settings, which can be accessed in the Print Preview Mode. By selecting landscape, the worksheet will be displayed horizontally, making it wider than it is tall. This is useful when the content of the worksheet is better suited for a wider layout.

Rate this question:
4.

How can you add a header in Print Preview Mode?
- A.
  
  In Print Preview Mode, select custom footer, then rotate page 180 degrees
- B.
  
  In Print Preview Mode, select page setup and change to landscape mode
- C.
  
  In Print Preview Mode, double click on the worksheet at the top and start typing header
- D.
  
  In Print Preview Mode, select page setup, click heafer/footer tab, and click custon header
Correct Answer
D. In Print Preview Mode, select page setup, click heafer/footer tab, and click custon header

Explanation
In Print Preview Mode, you can add a header by selecting page setup, clicking on the header/footer tab, and then clicking on custom header. This allows you to customize the header for your document in Print Preview Mode.

Rate this question:
5.

How can you get a multipage worksheet to print on one page?
- A.
  
  In Print Preview Mode, click on page layout and use the size bars to manipulate the data
- B.
  
  In Print Preview Mode, click on page setup and select fit to:
- C.
  
  In Print Preview Mode, click on page setup and set boundaries in landscape mode
- D.
  
  You can't do this in Print Preview Mode
Correct Answer
B. In Print Preview Mode, click on page setup and select fit to:

Explanation
In Print Preview Mode, clicking on page setup and selecting "fit to:" allows you to adjust the scaling of the worksheet so that it fits onto one page when printed. This option automatically adjusts the size of the content on the worksheet to fit within the specified number of pages.

Rate this question:
6.

How do you get gridlines to print?
- A.
  
  In Print Preview Mode, click page setup, select the sheet tab, and check gridlines checkbox
- B.
  
  In Print Preview Mode, click page setup, select the sheet tab, and make sure that print gridlines box is unchecked
- C.
  
  In Print Preview Mode, click on page setup and select fit to:
- D.
  
  In Print Preview Mode, select page setup, click heafer/footer tab, and check gridlines box.
Correct Answer
A. In Print Preview Mode, click page setup, select the sheet tab, and check gridlines checkbox

Explanation
In order to get gridlines to print, you need to be in Print Preview Mode. From there, you should click on page setup and select the sheet tab. Finally, you need to check the gridlines checkbox. This will ensure that the gridlines are included when you print the document.

Rate this question:

Computer Applications- Microsoft Excel: Printing Spreadsheets

How do you preview a worksheet you want to print?

How can you just print a selected part of a worksheet?

How can you change the orientation of a worksheet to landscape using Print Preview?

How can you add a header in Print Preview Mode?

How can you get a multipage worksheet to print on one page?

How do you get gridlines to print?