Spreadsheets: Printing Quiz #8

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 Havroncl21

Havroncl21

Community Contributor

Quizzes Created: 9 | Total Attempts: 3,925

Questions: 9 | Attempts: 389 | Updated: Mar 18, 2023

Questions

Settings

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Play as

Quiz Flashcard

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

Spreadsheets: Printing Quiz #8 from Atomic Learning

Questions and Answers

1.

What file menu allows you to preview your worksheet before printing?
- A.
  
  Print
- B.
  
  Print Preview
- C.
  
  Page Setup
- D.
  
  Layout
Correct Answer
B. Print Preview

Explanation
The correct answer is "Print Preview" because it is the option in the file menu that allows you to see how your worksheet will look when printed. This feature is useful for checking the layout, formatting, and content of the worksheet before actually printing it, helping to avoid any mistakes or wasted paper.

Rate this question:
2.

You can print just a range by selecting the information you want to be printed.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
The given statement is true. When printing information, it is possible to select a specific range of data to be printed instead of printing the entire set of information.

Rate this question:
3.

You can print just a selection, the active sheet (s), or the entire workbook.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
The statement is explaining that when printing in Excel, you have the option to print just a selection, the active sheet(s), or the entire workbook. This means that you can choose to print only specific cells or ranges, the currently active sheet or multiple sheets, or the entire workbook with all its sheets. Therefore, the correct answer is true.

Rate this question:
4.

Setting a __________ ______ is useful when dealing with large amounts of information in a worksheet.
- A.
  
  Print Area
- B.
  
  Range
- C.
  
  Group
- D.
  
  Print
Correct Answer
A. Print Area

Explanation
Setting a print area is useful when dealing with large amounts of information in a worksheet because it allows the user to specify a specific range of cells that will be printed. By setting a print area, unnecessary or irrelevant data can be excluded from the printout, making it easier to manage and view the information on paper. This helps to save time, reduce paper wastage, and improve the overall organization and readability of the printed document.

Rate this question:
5.

The print area command is found in the ___________ ____________ group in the Page layout command tab.
- A.
  
  Print Area
- B.
  
  Page Setup
- C.
  
  Orientation Area
- D.
  
  Normal View
Correct Answer
B. Page Setup

Explanation
The print area command is found in the "Page Setup" group in the Page layout command tab. This command allows the user to specify a specific range of cells to be printed. By setting a print area, the user can control which part of the worksheet will be printed, excluding any unnecessary data. The Page Setup group in the Page layout command tab contains various options related to formatting and printing the worksheet.

Rate this question:
6.

Only one print area can be set at a time.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
This statement is true because in most software applications, including Microsoft Excel, only one print area can be set at a time. This means that you can only specify a specific range of cells to be printed on a single sheet. If you want to print different ranges of cells on separate sheets, you would need to set different print areas for each sheet.

Rate this question:
7.

The "Ignore Print Areas" option is new for Excel 2007.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
The "Ignore Print Areas" option was introduced in Excel 2007. This option allows users to ignore any print areas that have been set in the worksheet and print the entire worksheet instead. Prior to Excel 2007, there was no such option available, so this statement is true.

Rate this question:
8.

You can add information to a set print area- this can be done in?
- A.
  
  Normal View
- B.
  
  Page Layout View
- C.
  
  Print Preview
- D.
  
  Cell Mode
Correct Answer(s)
A. Normal View
B. Page Layout View

Explanation
In Normal View and Page Layout View, you can add information to a set print area. Normal View is the default view in Excel where you can enter and edit data in cells. Page Layout View allows you to see how your worksheet will look when printed and make adjustments to the layout. In Print Preview, you can only see how the worksheet will look when printed, but you cannot add information. Cell Mode is not a valid option for adding information to a set print area.

Rate this question:
9.

What command tab do you need to be in to find the Print Area button?
- A.
  
  Home
- B.
  
  Insert
- C.
  
  Page Layout
- D.
  
  View
Correct Answer
C. Page Layout

Explanation
To find the Print Area button, you need to be in the "Page Layout" tab. This tab contains various tools and options related to the layout and formatting of the document, including the Print Area button. By being in this tab, you can easily access and modify the print area of the document before printing it.

Rate this question:

Quiz Review Timeline +

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

Current Version
Mar 18, 2023

Quiz Edited by
ProProfs Editorial Team
Jan 07, 2013

Quiz Created by
Havroncl21

Spreadsheets: Printing Quiz #8

What file menu allows you to preview your worksheet before printing?

You can print just a range by selecting the information you want to be printed.

You can print just a selection, the active sheet (s), or the entire workbook.

Setting a ____ is useful when dealing with large amounts of information in a worksheet.

The print area command is found in the _ __ group in the Page layout command tab.

Only one print area can be set at a time.

The "Ignore Print Areas" option is new for Excel 2007.

You can add information to a set print area- this can be done in?

What command tab do you need to be in to find the Print Area button?

Spreadsheets: Printing Quiz #8

What file menu allows you to preview your worksheet before printing?

You can print just a range by selecting the information you want to be printed.

You can print just a selection, the active sheet (s), or the entire workbook.

Setting a __________ ______ is useful when dealing with large amounts of information in a worksheet.

The print area command is found in the ___________ ____________ group in the Page layout command tab.

Only one print area can be set at a time.

The "Ignore Print Areas" option is new for Excel 2007.

You can add information to a set print area- this can be done in?

What command tab do you need to be in to find the Print Area button?

Setting a ____ is useful when dealing with large amounts of information in a worksheet.

The print area command is found in the _ __ group in the Page layout command tab.