Study sets, textbooks, questions
Upgrade to remove ads
Terms in this set (100)
on the 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?
Row to repeat at the top.
The command on the Page layout that refers to data on the top of each worksheet page is the?
Which command in the Print tab backstage view must be selected to print all sheets in a workbook?
Print entire workbook.
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?
What allow the user to control the amount of space between the data and the edge of the paper?
What controls the landscape or portrait function?
What do you insert into a worksheet to cause the data start on a new page when printing?
What determines what part of a worksheet prints?
The command on the Page Layout ribbon that refers to data printed on the top of each worksheet page is the?
What is the data printed on the bottom of each worksheet page?
Which tab do you use to display the area that contains the print command?
Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?
Which term describes the black portions of a page that fall outside the main body of the printed document?
What area contains the command used to print a worksheet in Excel 2010?
What is the name of the process of finding and correcting errors in a worksheet?
What is the quick keyboard command for converting a worksheet to formulas version so that all worksheet formulas may be seen on screen or printed?
CTRL+ (accent mark)
Which command on the Home Ribbon do you use to rotate text to vertical or diagonal angle in a worksheet?
Which command on the Home Ribbon do you use to format row height and column width, organize sheets, and protect or hide cells in a worksheet?
Which command do you use to reduce the margin between the border and the text in the cell?
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?
Zoom to Selection
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?
Which command on the Page Layout Ribbon enables a user to work the exact of the worksheet to print?
Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?
Which command on the Page Layout Ribbon enables a user to choose an image to display behind the data in a worksheet?
Which group on the Page Layout Ribbon contains commands used to organize objects placed in the worksheet?
What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page?
Header & Footer
What is the name of the dialog box that contains the commands to center a worksheet on the page both vertically and horizontally?
How would a user hide a row or column from view without permanently deleting the information?
Choose the Hide command on the Shortcut menu
Which command do you use to remove manual page breaks from a worksheet area?
Select Remove Page Break from the Breaks drop-down area
Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?
Which feature in Microsoft Excel 2010 allows a user to place a restriction on and temporarily isolate specific data in a worksheet?
Sort & Filter
What is the proper procedure for deleting an unwanted worksheet from a workbook?
Right-click the unwanted sheet tabs and choose Delete from the shortcut menu
In Microsoft Excel 2010, a single character, word or phrase is referred to as the?
Which method is used to select non-adjacent worksheet tabs?
Click first tab, hold down, CTRL key and click next tab
What will divide a worksheet into multiple panes in order to have more cells visible?
What will allow a window to be frozen and edits to be made with other windows are open?
What allow the user to organize multiple workbook windows so that all are visible?
What is the data connection between workbooks called the maintains control over critical data?
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 or copy from the shortcut menu and then choose the destination workbook from the drop-down lists
What appears at the bottom of an Excel 2010 workbook to distinguish individual worksheets?
Which command on the Home Ribbon do you use to organize in ascending or descending order?
Sort & Filter
What feature of Excel 2010 keeps a portion of a worksheet visible while the other portion scrolls?
What command will file Excel 2010 windows and all other open program windows so that they appear side by side on the screen?
Which command creates a new view of the current document in a separate window?
Which command separates a worksheet window into four individual panes?
Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, formula bar, or headings?
How would you move sheet tabs to a new position in the workbook?
Click and drag the sheet tab to the new location
How do you move from one worksheet to another within the same workbook?
Click on the sheet tab
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 Shortcut menu
Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?
Sort & Filter
What is the name of the Technique of entering a number once and copying it so that it is entered in the same cell on all selected worksheet?
Drilling an entry
What do you call it when you reference cells in other sheets in workbook formulas using the sheet name as the reference rather that the cell addresses?
What is a range that spans two or more sheets in a workbook?
Which term describes the process of creating a formula that refers to a cell in the same location but on separate sheets in a workbook?
Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?
Which is a way to qualify data by specifying a matching condition or asking a question of the data?
What technique selects data from the Internet to add to an Excel worksheet?
What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?
In Microsoft excel what is the area that contains gridlines and is made up of row and columns called?
Which area does the Microsoft excel window displays the name of the workbook that is active?
When entering into a cell which keyboard is used to remove characters to the right of the insertion point?
When saving file in Microsoft Excel, which symbol is NOT to be used in the file name?
Which Microsoft Excel features automatically inserts data into a cell that begins the same characteristics as a previous entry?
Which Microsoft feature automatically inserts words, numbers, or formulas that are a part of a series?
Which bottom appears when cells are filled with data in a series?
What method is used in conjunction with the mouse to change the height of a row in Microsoft Excel?
Click and drag the boundary line between rows
What is the proper method for adding(inserting) column into a worksheet?
Click the insert button on the Home ribbon choose the Insert Column option
What command on the Home ribbon allows the user to search for AND replace specific text in a worksheet are?
Which command appears in the lower right corner of pasted cells and enables the user to specify how to past the information?
Which features is a temporary storage location for items that have been copied or cut from a worksheet?
What commands are located in the upper right corner of the Microsoft Excel window to allow the user to minimize, maximize, or close the window?
Window control button
Where is the command to create a new folder in the user's storage device for Microsoft Excel files located?
File tab, open button
Other than using Microsoft Excel as a spreadsheet tool, what other functions can it serve?
To add visual interest to worksheets and charts, where is the command located to insert clip art images?
In Microsoft Excel, where are the most commonly used program command located?
Quick access toolbar
What displays the cell address of the active cell in Microsoft Excel?
The area of the Microsoft Excel that contains the view and zoom button is known as the?
What are the lines, vertical and horizontal, in a worksheet called?
What is the area with a thick black border in a worksheet called?
What helps in navigating a worksheet?
What is the process for selecting all information in a worksheet?
Click select all button the upper left corner of the worksheet or use the keyboard combination of CTRL + A
How do you place a cursor in a cell and edit the text?
Double-click the cell
Where is the command to save a workbook?
Which Microsoft Excel feature automatically inserts data into a cell begins with the same characteristics as a previous entry?
Which feature automatically corrects common typographical errors?
What is the black square that appears in the bottom right corner of the cell border to create a series in multiple cells?
What key will allow the user to select non-adjacent cells?
How do you use the mouse to change the width of a column in worksheets?
Click and drag the boundary line between columns
Aligning data within a cell is completed by clicking on which group on the Home ribbon?
If the data is too large for the cell and is typed into the adjacent cells where data is already located, what happens to the data?
The overlapping data is truncated
What home Ribbon contains the command used for quickly converting selected cells to a table by choosing a table style?
Which command on the Home Ribbon do you use to remove cells, rows, or columns from a worksheet or table?
What can you use to easily filter pivot tables and cube functions interactively in a worksheet?
What is an organized collection of data called?
Table or database
What are the individual data items that make up a record in a table called?
What ribbon includes the commands to apply a quick table style to a range of cells?
Which dialog box allows a user to select the first row as the table's header row?
Format as Table
How do you quickly modify a table style to meet user preferences?
Right-click on a style and choose duplicate
When sorting data in a table, which fields are selected as fields to sort by?
When a formula contains references that allow both the address to adjust and the reference to remain constant, what is this type of reference considered?
Mixed cell reference
Students also viewed
Bim review 1
Microsoft Excel Skills Project
PowerPoint 2: Fundamentals Module Test Review
Excel 2: Fundamentals
Sets found in the same folder
Excel Lesson 1
1984, Book Two, Chapters 5-7
Dynamic Crust Academic
Physical Resources Academic
Other Quizlet sets
NUTRITION CH 3
Pharmacy Law Exam 1