Spreadsheet Workbook Views & Page Setup Quiz #7

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.