Access 3 & 4

Click on the sheet tab

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

Right-click the sheet tab, choose copy from the shortcut menu

How is an exact copy of a worksheet created within the same workbook?

Choose the Hide command on the Shortcut menu

How would a user hide a row or column from view without permanently deleting the information?

Click and drag the sheet tab to the new location

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

Hide

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

Rows to repeat at 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?

Header

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

Margin

What allows the user to control the amount of space between the data and the edge of the paper

Arrange

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

Sheet tabs

What appears at the bottom of an Excel 2010 workbook to distinguish individual worksheets?

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?

Orientation

What controls the landscape or portrait print function

Print area

What determines what part of a worksheet prints?

Page Break

What do you insert into a worksheet to cause the data start on a new page when printing

Freeze Panes

What feature of Excel 2010 keeps a portion of a worksheet visible while the other portion scrolls?

Footer

What is the data printed on the bottom of each worksheet page?

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?

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

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

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

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

Freeze panes

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

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 organize data in ascending or descending order?

Screen clipping

Which command on the Insert Ribbon enables a user to insert a picture of a part of a screen into a worksheet?

Screenshot

Which command on the Insert Ribbon enables a user to insert a picture of a program window into a worksheet?

Print area

Which command on the Page Layout Ribbon enables a user to mark the exact area of the worksheet to print?

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?

Orientation

Which command on the home ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet?

Sort & Filter

Which feature in Microsoft Excel 2010 allows a user to place a restriction on and temporarily isolate specific data in a worksheet?

Arrange

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

Click first tab, hold down CTRL key and click next tab

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

Margins

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

Page Layout

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