Spreadsheet Workbook Views & Page Setup Quiz #7

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 Havroncl21
H
Havroncl21
Community Contributor
Quizzes Created: 9 | Total Attempts: 3,971
| Attempts: 348
SettingsSettings
Please wait...
  • 1/14 Questions

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

    • True
    • False
Please wait...
About This Quiz

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

Spreadsheet Quizzes & Trivia

Quiz Preview

  • 2. 

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

    • Print

    • Page Break Preview

    • Normal

    • Web

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

  • 3. 

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

    • True

    • False

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

  • 4. 

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

    • Home

    • Insert

    • Page Layout

    • Formula

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

  • 5. 

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

    • True

    • False

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

  • 6. 

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

    • Print title command

    • Sheet tab command

    • Page setup command

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

  • 7. 

    Page break preview is a new feature to Excel 2007.

    • True

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

  • 8. 

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

    • Normal

    • Wide

    • Narrow

    • Paper Setup

    Correct Answer(s)
    A. Normal
    A. Wide
    A. 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. 

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

    • True

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

  • 10. 

    The BREAKS command is found under what command tab?

    • Home

    • Insert

    • Page Layout

    • Data

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

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

    • Home

    • Insert

    • Page Layout

    • Data

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

  • 12. 

    The default margins for a spreadsheet are set to?

    • 0.5, 0.5, 0.5, 0.5, header 0.3, footer 0.3

    • 0.75, 0.75, 0.7, 0.7, header 0.3, footer 0.3

    • 1.75, 1.75, 0.7, 0.7, header 0.5, footer 0.5

    • 0, 0, 0.7, 0.7, header 0.0, footer 0.0

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

  • 13. 

    You are able to see page breaks in NORMAL VIEW.

    • True

    • False

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

  • 14. 

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

    • Themes

    • Scale to Fit

    • Arrange

    • Sheet Options

    Correct Answer(s)
    A. Themes
    A. Scale to Fit
    A. Arrange
    A. 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:

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

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
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.