Study sets, textbooks, questions
Upgrade to remove ads
Excel Lesson 1-4
Terms in this set (58)
The area of the Microsoft Excel that contains the view and zoom buttons is known as the:
In an Excel 2010 worksheet, how do you change the width of a column so that the widest entry will fit?
Which area on the title bar contains a command that will save a workbook with changes and close the Excel Program Window?
Window Control Buttons
Which command do you use to save a new worksheet in Excel 2010?
What method is used in conjunction with the mouse to change the height of a column in Microsoft Excel 2010?
Click and drag the boundary line between rows
What item at the top of an Excel worksheet window presents information about the worksheet, the progress of current task, and controls for viewing the worksheet?
Which area of the Microsoft Excel 2010 window displays the name of the worbook that is active?
What is the insertion of a row and column in a worksheet is called?
Which function key quickly opens the Microsoft Office Excel 2010 Online Help window?
What commands are located in the upper right corner of the mMcrosoft Excel 2010 window to allow the user to minimize, maximize, or close the window?
Window Control button
What displays the cell address of the active cell in Microsoft Excel?
Where is the command to undo the last cell entry in an Excel 2010 worksheet located?
Quick Access Toolbar
Which Excel 2010 mode displays active cell entries in the formula bar and a flashing insertion point in the active cell?
Which feature is a temporary storage location for items that have been copied or cut from a worksheet?
What area contains the command used to print a worksheet in Excel 2010?
What appears at the bottom of an Excel 2010 workbook to distinguish individual worksheets?
How do you cancel out the last action in a worksheet?
Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used excel commands?
Quick Access Toolbar
What helps in navigating a worksheet?
Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?
What type of formatting appears only when the value in a cell meets conditions specified by a user?
On the Home Ribbon, what do you use to change the font face used in the worksheet?
Font dropped-down list
Which command on the Home Ribbon do you use to remove cells,rows, or columns from a worksheet or table?
Aligning data within a cell is completed by clicking on which group on the Home ribbon?
Which command is used to emphasize values in a column that satisfy certain criteria by formatting them differently in a report?
Which command enables a user to copy formats from one selection and apply them to another selection?
What command do you use to copy cell formatting from one to another in a worksheet?
what defines the color of the character in an Excel 2010 worksheet?
Which dialog box allows a user to select the first row as the table's header row?
Format as Table
Which quick number style button formats numbers to display as precentage in the worksheet?
Which command is used on the home ribbon to apply a style to selected cells in a workbook?
Why do users want to modify an existing style?
Once modified, all cells formatted with that style will be automatically updated.
Use the ________ command on the home ribbon to organize data in ascending or descending order
Sort & filter
To move from one worksheet to another within the same workbook, click on the _________.
The ______ allows the user to control the amount of space between the data & the edge of the paper.
__________ controls the landscape or portrait print function.
The _______ is the data printed on the bottom of each worksheet page.
The _______ command on the insert ribbon enables a user to insert a picture of a program window into a worksheet.
To remove manual page breaks from a worksheet area, select ______________ from the breaks drop down area.
Remove Page Breaks
The ________ group on the Page Layout Ribbon contains commands used to organize objects placed in the worksheet.
The _________ command specifies complex criteria to limit which records are included in the result set of a query.
The _____________ command in the Print tab backstage view must be selected to print all sheets in workbook.
Print Entire Workbook
The ______ appear at the bottom of an Excel workbook to distinguish individual worksheets.
The ________command on the Page Layout Ribbon enables a user to specify the rows or columns to repeat on each printed page of the worksheet.
______ describes the blank portions of a page that fall outside the main body of the printed document.
Use the __________ command on the Home Ribbon to rotate text to vertical or diagonal angle in a worksheet.
The _______ feature in excel allows a user to place a restriction on & temporarily isolate specific data in a worksheet.
Sort & Filter
To create an exact copy of a worksheet within the same workbook right-click the sheet tab the choose __________ from the shortcut menu.
Move or Copy
To move sheet tabs to a new position in a workbook, _______ the sheet tab to the new location.
Click and Drag
The ______ command on the Page Layout Ribbon enables a user to mark the exact area of the worksheet to print.
The _______ view enables a user to create or modify a worksheet while seeing how it will look in printed format.
The _____________ command group on the Page Layout ribbon controls the presence of grid-lines & heading on a worksheet.
Use the _________ command 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
________ allows the user to organize multiple workbook windows so that all are visible>
The_________ command inserts information into a worksheet that will display at the top & bottom edges of the printed page.
Header & Footer
The _________ command on the Insert Ribbon enables a user to insert a picture of a part of a screen into a workbook.
Choose the ___ command on the Shortcut Menu to hide or column from view without permanently deleting the information.
To select non-adjacent worksheet tabs, click the first tab hold down ______ and click the next tab.
Students also viewed
Digital Literacy: Productivity Programs
PPT Lesson 4-5
Other sets by this creator
Ch5-9 Health Psychology
Experimental Psychology 6-8
Other Quizlet sets
Course Review Practice 2
Computer Midterm Multiple Choice