Term
| In Excel, a relative cell reference |
|
Definition
| indicates a cell's relative location from the cell containing the formula; the reference changes when you copy the formula. |
|
|
Term
| In Excel, a function can be defined as a _____. |
|
Definition
| predefined formula that performs a calculation |
|
|
Term
| =$E2-G$4 contains examples of _____ cell references. |
|
Definition
|
|
Term
| Which of the following describes the SUM function? |
|
Definition
| Calculates the total of values contained in two or more cells. |
|
|
Term
| The MEDIAN function would identify the ____. |
|
Definition
| midpoint value in a range. |
|
|
Term
| The MAX function identifies the _____. |
|
Definition
| highest value in a range. |
|
|
Term
| The _____ function can be used to find an answer located in a vertical table. |
|
Definition
|
|
Term
| The _____ number is the number of the column in the lookup table that contains the return values. |
|
Definition
|
|
Term
| Arithmetic operations, cell references, and _____ can be used in Excel formulas. |
|
Definition
|
|
Term
| _____ is a word or string of characters that represent one or more cells. |
|
Definition
|
|
Term
| When calculating a PMT function, the PV is best described by which of the following? |
|
Definition
| It is the present value of the loan |
|
|
Term
| Which of the following is NOT an Excel tool used to improve productivity in developing consistently formatted workbooks? |
|
Definition
|
|
Term
| To unlock cells, click the _____ tab, then click Format in the Cells group and select Lock Cell. |
|
Definition
|
|
Term
| By default, a macro records cells as _____ references if they are selected while recording the macro. |
|
Definition
|
|
Term
| By default, Excel automatically _____ macros and displays a security warning when a file containing macros is opened. |
|
Definition
|
|
Term
| Which of the following describes the function of the Formula Bar (as it applies to Excel 2010)? |
|
Definition
| Displays the content of the active cell |
|
|
Term
| In Excel 2010, a sheet tab ________. |
|
Definition
| displays the name of a worksheet within a workbook |
|
|
Term
| If you wanted to insert the current date into an active cell, which of the following would you use? |
|
Definition
| The Ctrl and semicolon key combination |
|
|
Term
| In Excel a Formula is _______. |
|
Definition
| a combination of cell references, operators, values, and/or functions used to perform calculations |
|
|
Term
| The fill handle in Excel 2010 _______. |
|
Definition
| is a small black square at the bottom-right corner of a cell that facilitates fill operations |
|
|
Term
| Ribbon Commands with arrows indicate_____. |
|
Definition
| there are two or more sub-commands related to the command |
|
|
Term
| The three types of data that can be entered in a cell in an Excel worksheet are ________________. |
|
Definition
| text, values, and formulas |
|
|
Term
| In Excel, a border ________. |
|
Definition
| is a line that surrounds a cell or a range of cells |
|
|
Term
| A chart can be defined as ________. |
|
Definition
| a visual representation of numerical data |
|
|
Term
| Which of the following best describes a column chart? |
|
Definition
| Displays data comparisons vertically in columns |
|
|
Term
| Which of the following best describes the chart area? |
|
Definition
| Contains the entire chart and all of its elements |
|
|
Term
| Stock market or economic trends over long periods of time are frequently shown on a _________. |
|
Definition
|
|
Term
| To provide your viewers with an explanation of the representations of the colors utilized in the data series in your chart, provide a: |
|
Definition
|
|
Term
| When you select a chart, Excel displays a Chart Tools contextual tab with three specific tabs: |
|
Definition
| Design, Layout, and Format. |
|
|
Term
| Which of the following best describes a trendline? |
|
Definition
| Which of the following best describes a trendline? |
|
|
Term
| _____ column and row headings enables you to keep these headings on the screen when scrolling through a large spreadsheet. |
|
Definition
|
|
Term
| In Excel, a table is defined as _____. |
|
Definition
| an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis |
|
|
Term
| When sorting in Excel, it arranges records in a table _____. |
|
Definition
| by the value in field(s) within a table |
|
|
Term
| (TCO 4) Filtering the Cost column (field) to show only records greater than $10,000 is an application of _____. |
|
Definition
|
|
Term
| To apply a red background color to cells for employees who have sales greater than $1,000, you can use _____. |
|
Definition
|
|
Term
| Using Conditional Formatting to draw attention to cells that are blank _____. |
|
Definition
| helps locate where data may be missing |
|
|
Term
| For Subtotals to be useful and accurate, it is important that the data be _____ correctly. |
|
Definition
|
|
Term
| _____ are created to organize and summarize data in PivotTables. |
|
Definition
|
|
Term
| To begin a filter based on a particular field, you drag the desired field to which area under Drag fields between areas below? |
|
Definition
|
|
Term
| The Insert Calculated Field dialog box requires you do all the following EXCEPT _____. |
|
Definition
| enter formulas using cell references |
|
|
Term
| Data displayed in the PivotTable will be updated _____. |
|
Definition
| when you right-click a cell in the PivotTable and select Refresh |
|
|
Term
| What are the areas of a PivotTable Report where fields can be placed? |
|
Definition
| Values, Axis Fields, Legend Fields, and Report Filter |
|
|
Term
| To go to the top of your spreadsheet quickly, use the _____ key(s). |
|
Definition
|
|
Term
| After creating a PivotChart, you can sort or filter categories or subcategories in rows by clicking the _____. |
|
Definition
|
|
Term
| Which of the following will NOT delete a PivotChart? |
|
Definition
| Click and drag the PivotChart off the worksheet |
|
|
Term
| To import a text file into Excel, click ________ on the File tab. |
|
Definition
|
|
Term
| The Text Import Wizard displays when a(n) ________ file is imported. |
|
Definition
|
|
Term
| All of the following will display data range properties EXCEPT: |
|
Definition
|
|
Term
| Text to Columns command splits text in one column into separate ________. |
|
Definition
|
|
Term
| To change the text string jOHn dOE to John Doe, use the ________ function. |
|
Definition
|
|
Term
| To change the word college to university in a string of text, use the ________ function. |
|
Definition
|
|
Term
| Which of the following functions does not change the case or capitalization of text? |
|
Definition
|
|
Term
| In Microsoft Word, the commands used to perform a mail merge are found on the _________ tab of the Ribbon. |
|
Definition
|
|
Term
| In Excel, the Compare and Merge command is located on which of the following tabs? |
|
Definition
Review tab
Data tab
File tab
**None of the above |
|
|
Term
| If you have a table with city, state, and zip code merged together in column C and use the Convert Text to Columns Wizard to separate the data into three fields, you need: |
|
Definition
| empty columns to the right of column C. |
|
|
Term
| The ________ tab on the Page Setup dialog box provides options for printing comments. |
|
Definition
|
|
Term
| The command to send an Excel workbook by e-mail is located on the ________ tab. |
|
Definition
|
|
Term
| The ________ command displays additional document properties such as Company. |
|
Definition
|
|
Term
| Which function is similar to the Find and Replace feature? |
|
Definition
|
|
Term
| To encrypt a workbook with a password, click Info on the File tab, click ________, and then select Encrypt with Password. |
|
Definition
|
|
Term
| The Text Import Wizard displays when a(n) ________ file is imported. |
|
Definition
|
|
Term
| All of the following will display data range properties EXCEPT: |
|
Definition
| click Properties in the Connections Group. |
|
|
