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?