| A | B |
|---|
| Which tab do you select when you are ready to create a new workbook? | File |
| Which new document type has already been set up to display data layout and formatting? | Template |
| Which of the following is used to switch through open workbooks? | Ctrl+Tab |
| By default in all Office applications, documents are saved to which of the following locations? | My Documents |
| Which of the following is used to save the open workbook? | Ctrl+S |
| Which command within Backstage is used to consistently display the save options? | Save As |
| Which options are available in the Save As dialog box? | Drive location, file name, new folder & file type |
| Which of the following is a cloud-based application that allows you to store your files so you can retrieve them from anywhere and share them with others? | SkyDrive |
| Which of the following extensions should be selected within the Save As dialog box to ensure compatibility with Excel 97? | .xls |
| Under which main Backstage command will you find the check compatibility option? | Info |
| The Check for issues option can be described as the command used to ________. | check compatibility with earlier versions |
| Which command on the File tab is used to save the workbook as a different file type? | Export |
| Which of the following is used to insert a copied or cut selection into a cell or range of cells? | Paste |
| Which of the following places a duplicate of the selected information on the Clipboard? | Copy |
| Where is the information on the Office Clipboard stored? | temporary memory |
| Which key do you use to move to the next row when entering data? | Enter |
| To edit a cell, you must first do what? | Select the cell |
| Pressing __________ removes the cell’s contents but does not remove any of the formatting applied to the cell. | Delete |
| The __________ bar at the top of the Excel window can be used to enter or edit cell entries or formulas. | formula |
| The __________ changes to a double-headed arrow when placed between column header buttons to change column width. | mouse pointer |
| Which keys can be used to navigate within the formula bar during edit mode? | Home, End, Left Arrow, and Right arrow |
| Where is the Select All button located in the worksheet? | above row 1 and to the left of column A |
| Which keys do you use to restore deleted text? | Ctrl+Z |
| What is a group or block of cells in a worksheet that have been selected or highlighted? | range |
| The Auto Fill tool is used for what purpose? | complete the series or copy the cell contents |
| Where is the Fill handle located? | in the right hand corner of a cell |
| Which Excel feature is used to fill cells with data that is based on data in other cells or that follows a pattern? | Auto Fill |
| Which of the following represents a natural series in a spreadsheet? | months |
| What do you do to automatically expand the column width to fit cell contents? | Double-click using the double-headed arrow. |
| __________ is like Auto Fill, but Excel does more work. | Flash Fill |
| The __________ feature works only for entries that contain text or a combination of text and numbers. | AutoComplete |
| What is the other term for numeric data entered in Excel? | labels |
| Under which Backstage option can you enable or disable the AutoComplete feature? | Options |
| Excel AutoComplete bases the list of potential entries on the text located in the ________. | rows above |
| Which of the following special characters is/are not used to identify values in Excel? | #, / |
| What term is used to describe the pointer when it is an arrow with a plus? | Copy pointer |
| In order to copy data, which key do you hold down the entire time while dragging? | Ctrl |
| Which of the following can be used to cut, copy, and paste in an Excel spreadsheet? | ribbon commands, mouse, keyboard shortcuts & Clipboard |
| The mouse becomes a move pointer when you wish to do what? | Replace existing data in the destination cells. |
| What symbol represents the move pointer? | arrow |
| The Office Clipboard can collect and store how many copied or cut items at any given time? | 24 |
| The __________ feature allows you to access the deleted data or information from the Clipboard. | cut |
| Which of the following workbook properties in Backstage Info make it easier to manage our Excel documents? | last modified by, file size, modified by, categories & date created |
| Which feature in Document Properties allows you to search for customized text within your workbooks? | Keywords |
| Which of the following consists of details that describe or identify a file, including the author? | Document properties |
| Which command is used to insert a cut or copied selection to a cell or range of cells? | Paste |
| Which of the following is a group of adjacent cells that you select to perform operations on all of the selected cells? | Range |
| Which of the following places a duplicate of a selection in the Office Clipboard? | Copy |
| To use a worksheet or workbook outside Excel, you have the option to save as which of the following? | File Format |
| Which is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series? | Fill Handle |
| Which is used to drag or double-click to change the width of a column. | Column marker |
| Which of the following is a bar near the top of the Excel window where you can enter or edit cell entries or formulas? | Formula bar |
| Which Excel feature helps you quickly enter previous data into cells? | AutoComplete |
| Which Excel feature automatically fills cells with data from another cell or range or completes a data series? | Auto Fill |
| When data is too wide for a cell, the part of the data that will not fit is automatically deleted. | FALSE |
| Using the Delete key removes both text and formats from a cell. | FALSE |
| Use Ctrl + : to enter the current date in a worksheet cell. | FALSE |
| You can assign keywords so that others can search for your documents online. | TRUE |
| To remove only the formats from a cell, you can use the Delete key. | FALSE |
| Dates can be displayed in only one way within Excel | FALSE |
| All dates in Excel are actually stored in the serial date number system. | TRUE |
| The formula bar is found at the bottom of the Excel window. | FALSE |
| Use the fill handle to create a natural series, such as the months of the year. | TRUE |
| Workbooks can be saved as web pages, PDF files, and for use in previous versions of Excel. | TRUE |
