Spreadsheet Workbook Views & Page Setup Quiz #7

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: 14 | Attempts: 341 | 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

Spreadsheet Workbook Views and Page Setup Quiz #7 from Atomic Learning

Questions and Answers

1.

By default, what view does Micro Soft Excel open to?
- A.
  
  Print
- B.
  
  Page Break Preview
- C.
  
  Normal
- D.
  
  Web
Correct Answer
C. Normal

Explanation
Microsoft Excel opens to the "Normal" view by default. This view displays the spreadsheet in a standard layout, with rows and columns visible and all cell contents displayed. It is the most commonly used view for creating, editing, and viewing data in Excel. Other views like "Print", "Page Break Preview", and "Web" are available for specific purposes, but they are not the default view when opening Excel.

Rate this question:
2.

Page break preview is a new feature to Excel 2007.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
The given statement is true. Page break preview is indeed a new feature that was introduced in Excel 2007. This feature allows users to view and adjust page breaks in their worksheets, making it easier to control how the data is displayed when printed. Prior to Excel 2007, users had limited options for managing page breaks, but with the introduction of page break preview, it became much more convenient to customize the layout of printed worksheets.

Rate this question:
3.

Under which command tab will you find the Scale to Fit option?
- A.
  
  Home
- B.
  
  Insert
- C.
  
  Page Layout
- D.
  
  Formula
Correct Answer
C. Page Layout

Explanation
The Scale to Fit option is typically found under the Page Layout command tab. This tab includes various options for adjusting the layout and formatting of the document or spreadsheet, such as page size, margins, and scaling. The Scale to Fit option allows users to adjust the size of the content to fit within the specified page dimensions, ensuring that the entire document or spreadsheet is visible when printed or viewed.

Rate this question:
4.

Select all that Applies: The Page Layout tab includes what areas?
- A.
  
  Themes
- B.
  
  Scale to Fit
- C.
  
  Arrange
- D.
  
  Sheet Options
Correct Answer(s)
A. Themes
B. Scale to Fit
C. Arrange
D. Sheet Options

Explanation
The Page Layout tab in a document or spreadsheet editing software typically includes various areas that allow users to customize the appearance and layout of their pages. These areas may include options for selecting themes, which determine the overall visual style of the document. The tab may also include options for scaling the content to fit the page, arranging elements on the page, and adjusting sheet options specific to spreadsheets.

Rate this question:
5.

You can apply a background to your spreadsheet but when you print your spreadsheet it will not print.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
When applying a background to a spreadsheet, it is only visible on the screen and not when the spreadsheet is printed. This is because the background is considered a formatting option and is not included in the print settings. Therefore, the statement that the background will not print is true.

Rate this question:
6.

You can not control how your sheet will print using the Page Layout command tab.
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Explanation
The statement is false because the Page Layout command tab in a spreadsheet program allows users to control how their sheet will print. This tab typically includes options for adjusting page orientation, margins, scaling, and other print settings. Users can use these options to customize the appearance of their printed sheets and ensure that the content fits properly on the page.

Rate this question:
7.

The default margins for a spreadsheet are set to?
- A.
  
  0.5, 0.5, 0.5, 0.5, header 0.3, footer 0.3
- B.
  
  0.75, 0.75, 0.7, 0.7, header 0.3, footer 0.3
- C.
  
  1.75, 1.75, 0.7, 0.7, header 0.5, footer 0.5
- D.
  
  0, 0, 0.7, 0.7, header 0.0, footer 0.0
Correct Answer
B. 0.75, 0.75, 0.7, 0.7, header 0.3, footer 0.3

Explanation
The default margins for a spreadsheet are set to 0.75 inches for the top and bottom margins, 0.7 inches for the left and right margins, and 0.3 inches for both the header and footer margins.

Rate this question:
8.

There are only 3 preset options in your margins settings for your spreadsheet. They include:
- A.
  
  Normal
- B.
  
  Wide
- C.
  
  Narrow
- D.
  
  Paper Setup
Correct Answer(s)
A. Normal
B. Wide
C. Narrow

Explanation
The correct answer is Normal, Wide, Narrow. These options refer to the preset margin settings available for a spreadsheet. "Normal" is the default margin setting, "Wide" allows for wider margins, and "Narrow" allows for narrower margins. The option "Paper Setup" is not included in the preset margin settings.

Rate this question:
9.

There are several different methods to changing your margins to your spreadsheet.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
The statement is true because there are indeed multiple ways to change the margins in a spreadsheet. Users can typically adjust the margins by accessing the page setup options, using the margin settings in the toolbar or ribbon, or by utilizing keyboard shortcuts. These methods allow users to customize the margins according to their preferences and requirements.

Rate this question:
10.

The BREAKS command is found under what command tab?
- A.
  
  Home
- B.
  
  Insert
- C.
  
  Page Layout
- D.
  
  Data
Correct Answer
C. Page Layout

Explanation
The BREAKS command is found under the Page Layout command tab. This tab typically contains options related to formatting and organizing the layout of a document or spreadsheet. The BREAKS command specifically allows users to insert various types of breaks, such as page breaks or section breaks, to control the layout and formatting of a document.

Rate this question:
11.

You are able to see page breaks in NORMAL VIEW.
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Explanation
In NORMAL VIEW, you are not able to see page breaks. Page breaks are only visible in Page Break Preview or Print Layout view. In NORMAL VIEW, the document appears as a continuous flow of text without any indication of where the page breaks occur. Therefore, the correct answer is False.

Rate this question:
12.

The _______________________________ will set the titles to print on every page.
- A.
  
  Print title command
- B.
  
  Sheet tab command
- C.
  
  Page setup command
- D.
  
  Row print command
Correct Answer
A. Print title command

Explanation
The Print title command is the correct answer because it allows the user to set the titles that will be printed on every page. This command is commonly used in spreadsheet software to ensure that important information, such as column headers or row labels, is consistently displayed on each printed page. The user can specify which rows or columns should be repeated as titles on subsequent pages, improving the readability and organization of printed documents.

Rate this question:
13.

The command for header and footer can be found in what command tab?
- A.
  
  Home
- B.
  
  Insert
- C.
  
  Page Layout
- D.
  
  Data
Correct Answer
B. Insert

Explanation
The correct answer is "Insert" because the command for header and footer is typically found in the Insert tab of a software program or application. This tab contains various options for inserting different elements into a document, such as headers, footers, page numbers, and other related features. By selecting the Insert tab, users can easily access and customize the header and footer settings for their document.

Rate this question:
14.

You are not able to change the page setup on any spreadsheet you create in Micro Soft Excel.
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Explanation
In Microsoft Excel, you have the ability to change the page setup of the spreadsheet you create. This includes adjusting the page orientation, margins, paper size, and other settings to customize how the spreadsheet will be printed or displayed. Therefore, the statement that you are not able to change the page setup on any spreadsheet you create in Microsoft Excel is false.

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 08, 2013

Quiz Created by
Havroncl21

Spreadsheet Workbook Views & Page Setup Quiz #7

By default, what view does Micro Soft Excel open to?

Page break preview is a new feature to Excel 2007.

Under which command tab will you find the Scale to Fit option?

Select all that Applies: The Page Layout tab includes what areas?

You can apply a background to your spreadsheet but when you print your spreadsheet it will not print.

You can not control how your sheet will print using the Page Layout command tab.

The default margins for a spreadsheet are set to?

There are only 3 preset options in your margins settings for your spreadsheet. They include:

There are several different methods to changing your margins to your spreadsheet.

The BREAKS command is found under what command tab?

You are able to see page breaks in NORMAL VIEW.

The _______________________________ will set the titles to print on every page.

The command for header and footer can be found in what command tab?

You are not able to change the page setup on any spreadsheet you create in Micro Soft Excel.