Test Answer Key Review

Margins

which term describes the blank portions of a page that fall outside the main body of the printed document?

Orientation

Direction an image appears on the page, either portrait or landscape.

what allows the user to control the amount of space between the data and the edge Of the Paper?

Margin

Rows to repeat at the top

On multi-page worksheets, what page layout option should you choose in order to have information repeated along the top of each page and make the data easily readable?

Sheet tab

Tab at the bottom of the worksheet window that displays the name of the worksheet.

header

Text at the top of each page

Footer

Text that appears at the bottom (or foot) of every page.

Orientation

The Direction- horizontal or vertical- in which a page is laid out.

Header

The command on the Page Layout ribbon that refers to data printed on the top of each worksheet page is the:

Decrease Indent

Which command do you use to reduce the margin between the border and the text in the cell?

Select Remove Page Break from the Breaks drop-down area

Which command do you use to remove manual page breaks from a worksheet area?

Sheet Options

Which command group on the Page Layout ribbon controls the presence of gridlines and headings on a worksheet?

Print entire workbook

Which command in the print tab backstage view must be selected to print all sheets in a workbook?

Sort & Filter

Which command on the Home Ribbon do you use to organize data in ascending or descending order?

Sort & Filter

Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?

Breaks

Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?

Print titles

Which command on the Page Layout Ribbon enables a user to specify the rows or columns to repeat on each printed page of the worksheet?

Arrange

Which group on the Page Layout Ribbon contains commands used to organize objects placed in the worksheet?

Page Layout

Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?

How would a user hide a row or column from view without Permanently deleting the Information?

Choose Hide command on the Shortcut menu

How would you move sheet tabs to a new position in the workbook?

Click and drag the sheet tab to the new location

Which method is used to select non-adjacent worksheet tabs?

Click first tab, hold down CTRl key and click the next tab

If a worksheet contains data that you do not want to be viewed, what method is used to remove the data from worksheet view without permanently deleting the data?

Hide

Click on the Sheet Tab

How do you move from one worksheet to another within the same workbook?

Screenshot

Insert a picture of any program that is not limited to the taskbar

Screen Clipping

Insert a picture of part of the screen

Page Break

Inserts a page break at the insertion point. Found on the Insert tab.

Which command on the page layout ribbon enables a user to mark the exact area of the worksheet to print?

Print Area

what determines what part of a worksheet prints?

Print Area

What is the process used when copying a worksheet in one workbook and pasting it into another workbook?

Right-click the sheet tab to choose move to copy from the shortcut menu and then choose the destination workbook from the drop-down list.

How is an exact copy of a worksheet Created Within the Same Workbook?

Right-click the sheet tab, then choose Move or Copy from the Short Menu

What is the proper procedure for deleting an unwanted worksheet from a workbook?

Right-click the unwanted sheet tab and choose Delete from the shortcut menu

Freeze Panes

To keep selected rows and/or columns of the worksheet visible on the screen as the rest of the worksheet scrolls.

Arrange

What allows the user to organize multiple workbook windows so that all are visible?

Zoom to Selection

What command do you use to increase or decrease the size of a selected cell or range of cells to fill the Excel Window area for better visibility?

Header & Footer

What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page?

Advanced Filter

What command specifies complex criteria to limit which records are included in the result set of a query?

Page Setup

What is the name of the dialog box that contains the commands to center a worksheet on the page both vertically and horizontally?

Freeze Panes

What will allow a window to be frozen and edits to be made with other windows are open?