Computer Applications- Microsoft Excel: Printing Spreadsheets

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Ntorok
N
Ntorok
Community Contributor
Quizzes Created: 9 | Total Attempts: 3,311
| Attempts: 120
SettingsSettings
Please wait...
  • 1/6 Questions

    How do you preview a worksheet you want to print?

    • View Button and select print
    • Data Tab and select print preview
    • Office Button and select print preview
    • All of the Above
Please wait...
About This Quiz

This quiz focuses on printing spreadsheets in Microsoft Excel. It covers previewing worksheets, printing selected data, changing orientation, adding headers, and printing gridlines. It assesses key skills for effectively managing document output in Excel.

Computer Applications- Microsoft Excel: Printing Spreadsheets - Quiz

Quiz Preview

  • 2. 

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

    • Highlight data you want to print and select print

    • Select data and hit the office button. Select print and choose selection option in the print what section

    • Select data you want to print, right click and choose copy

    • None of the Above

    Correct Answer
    A. 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 add a header in Print Preview Mode?

    • In Print Preview Mode, select custom footer, then rotate page 180 degrees

    • In Print Preview Mode, select page setup and change to landscape mode

    • In Print Preview Mode, double click on the worksheet at the top and start typing header

    • In Print Preview Mode, select page setup, click heafer/footer tab, and click custon header

    Correct Answer
    A. 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:

  • 4. 

    How do you get gridlines to print?

    • In Print Preview Mode, click page setup, select the sheet tab, and check gridlines checkbox

    • In Print Preview Mode, click page setup, select the sheet tab, and make sure that print gridlines box is unchecked

    • In Print Preview Mode, click on page setup and select fit to:

    • 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:

  • 5. 

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

    • In Print Preview Mode, click on page layout and use the size bars to manipulate the data

    • In Print Preview Mode, click on page setup and select fit to:

    • In Print Preview Mode, click on page setup and set boundaries in landscape mode

    • You can't do this in Print Preview Mode

    Correct Answer
    A. 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 can you change the orientation of a worksheet to landscape using Print Preview?

    • In Print Preview Mode, select page setup and click landscape

    • In Print Preview Mode, select show margins and change landscape

    • In Print Preview Mode, select the data you want to change orientation and select print landscape

    • 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:

Quiz Review Timeline (Updated): Apr 18, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Apr 18, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 02, 2012
    Quiz Created by
    Ntorok
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.