Term
| A _______ name (often called a _______ name) is a word or string of characters associated with a single cell or range |
|
Definition
|
|
Term
| The ______ box displays the cell reference or the defined name of the selected cell |
|
Definition
|
|
Term
| An Excel ________ is a spreadsheet written or tailored to meet specific needs. |
|
Definition
|
|
Term
| Defined names can contain letters, numbers, periods and underscores but NOT _______ and ________ or a valid _____ ______ |
|
Definition
| symbols, spaces, cell address |
|
|
Term
| Defined names can include as many as ____ characters |
|
Definition
|
|
Term
| A ______ _______ indicates that the cell contains a comment. |
|
Definition
|
|
Term
| You can use ______ ________ to create a set of rules that determine what users can enter in a specific cell or range |
|
Definition
|
|
Term
| An _______ ________ appears when the cell becomes active, and can be used to specify the type of data the user should enter in that cell |
|
Definition
|
|
Term
| An _____ ______ appears if a user tries to enter a value in the cell that does not meet the validation rule |
|
Definition
|
|
Term
| _______ ______ limits users' ability to make changes to the workbook's structure and windows |
|
Definition
|
|
Term
| _____ _____ limits users' ability to modify the worksheet's contents, structure, or formatting |
|
Definition
|
|
Term
| A ______ is a text box that is attached to a specific cell in a worksheet in which you can enter notes |
|
Definition
|
|
Term
| Each cell can have _____ validation rule(s) |
|
Definition
|
|
Term
| The Defined Names group can be found in the _______ tab |
|
Definition
|
|
Term
| The data validation button can be found in the _____ tab |
|
Definition
|
|
Term
| The maximum number of characters allowed in the Title box is ___ |
|
Definition
|
|
Term
| To unlock cells, go to the _____ tab then click the dialog box launcher of the ____ group |
|
Definition
|
|
Term
| To protect a worksheet, go to the _____ group of the _______ tab |
|
Definition
|
|
Term
| Protect Workbook is located in the ______ group of the _______ tab |
|
Definition
|
|
Term
| The comments group is located in the _____ tab |
|
Definition
|
|
Term
(Keyboard short cut)
Current Date |
|
Definition
|
|
Term
(Keyboard short cut)
Edit mode |
|
Definition
|
|
Term
|
Definition
|
|
Term
| Header row contains ______ names |
|
Definition
|
|
Term
| Values within () are called ________ |
|
Definition
|
|
Term
|
Definition
|
|
Term
(Keyboard short cut)
Auto fill selected cells |
|
Definition
|
|
Term
(Keyboard short cut)
Go to cell A1 |
|
Definition
|
|
Term
| Pivot charts refresh __________ |
|
Definition
|
|
Term
| The fields that you use to order data are called ______ fields |
|
Definition
|
|
Term
| Each row represents a _______ |
|
Definition
|
|
Term
| To make the header row visible when scrolling you can use _______ pane |
|
Definition
|
|
Term
| The Total Row option is located... |
|
Definition
| Table Tools Design tab > Table Styles Option |
|
|
Term
| The worksheet window can be ______ into two pieces with the _______ button |
|
Definition
|
|
Term
| An interactive table used to group and summarize data into a concise, tabular format |
|
Definition
|
|
Term
| Graphical representation of the data in a PivotTable |
|
Definition
|
|
Term
| The fields used to group the values of a PivotTable |
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
| A quicker and easier way to filter a PivotTable or PivotChart is by using a |
|
Definition
|
|
Term
| You can copy a worksheet easily by holding _____ and dragging the worksheet tab to an empty spot |
|
Definition
|
|
Term
| Freeze Pane is located in the _____ tab |
|
Definition
|
|
Term
| _______ and left click to select a range of worksheets. |
|
Definition
|
|
Term
| To combine multiple cells into one big cell |
|
Definition
|
|
Term
(Keyboard short cut)
Sum Function |
|
Definition
|
|
Term
| To leave group mode, click an ________ worksheet |
|
Definition
|
|
Term
| The formula to sum the same cell from multiple worksheets |
|
Definition
| =sum('worksheet 1:worksheet 2'!B6) |
|
|
Term
| ______ click the fill handle to auto fill |
|
Definition
|
|
Term
| IF statement depends on which two variables |
|
Definition
|
|
Term
| When you start Excel, you open a file called |
|
Definition
|
|
Term
| When you select any cell, it becomes the |
|
Definition
|
|
Term
| Excel formulas always begin with a |
|
Definition
|
|
Term
| The split button is in the _____ tab |
|
Definition
|
|
Term
| [_____] appears in the title bar in group editing mode |
|
Definition
|
|
Term
| A ______ reference is a reference to the same cell or range in multiple worksheets in the same workbook |
|
Definition
|
|
Term
| The name of the active worksheet will be ______ |
|
Definition
|
|
Term
| To exit group-editing ode, click any tab _____ the the worksheet group |
|
Definition
|
|
Term
| To rename a table, go to table name located in the ________ group of the Design tab |
|
Definition
|
|
Term
| If a sheet range includes more than one sheet, you specify the first and last sheet in the range separated by a ____. |
|
Definition
|
|
Term
You can sort by:
a) Cell color
b) Cell Icon
c) Font color
d) All of the above |
|
Definition
|
|
Term
| To select a range of worksheets, hold ______ and click the range |
|
Definition
|
|
Term
True or False
Anything done to the active worksheet is automatically done to all worksheets in the worksheet group |
|
Definition
|
|
Term
| A worksheet _____ is a collection of two or more selected worksheets |
|
Definition
|
|
Term
| Increase Indent is located in the ______ group of the _______ tab |
|
Definition
| Alignment group, home tab |
|
|
Term
| Bottom border can be found in the _____ group in the _______ tab |
|
Definition
|
|
Term
|
Definition
| arranged of related data that is managed independently from data in other rows and columns in the worksheet |
|
|
Term
| Freeze Pane can be found in the ________ group of the ______ tab |
|
Definition
|
|
Term
| The Table Name is located in the _______ group of the Table Tools _______ tab |
|
Definition
| Properties group, Design Tab |
|
|
Term
| Sort A to Z can be found in the ______ group of the _______ tab |
|
Definition
| Sort & Filter group, Data |
|
|
Term
| To change a table back to normal data, click the __-___-_____ button |
|
Definition
|
|
Term
| When you split a worksheet, each resizable area is called a ________ |
|
Definition
|
|
Term
| The ______ _____ indicates the division between panes |
|
Definition
|
|
Term
| You can clear filters on a table by going to the Data tab and press the ______ button |
|
Definition
|
|
Term
True or False?
Subtotals can be done in a table? |
|
Definition
|
|
Term
| A ________ is a object used to filter a PivotTable or PivotChart |
|
Definition
|
|
Term
| You create a PivotTable using the ______ list |
|
Definition
|
|
Term
| _________ fields are the fields that group the values in a PivotTAble. |
|
Definition
|
|
Term
| Fields in the ______ Labels area are displayed as columns at the top of the PivotTable |
|
Definition
|
|
Term
| Fields in the ______ area are summarized in the Pivot Table |
|
Definition
|
|
Term
| Fields in the ______ Labels area are displayed as rows in the PivotTable |
|
Definition
|
|
Term
| Fields in the ______ field area create a filtered view of the PivotTable, showing summarized data in the report |
|
Definition
|
|
Term
| Expand Entire Field is located in the _____ ______ group of the PivotTable Tools Options tab |
|
Definition
|
|
Term
| The Summarize Values By button can be located in the ___________ group of the PivotTable Tools Options |
|
Definition
|
|
Term
| When you create a formula that references all or parts of an Excel table, you can replace a specific cell or range address with a? |
|
Definition
|
|
Term
| The _______ function is a logical function that returns a TRUE value if all of the logical conditions are true and a FALSE value if any or all of the logical conditions are false |
|
Definition
|
|
Term
| The ________ __________ dialog box makes it simpler to build an IF function with a nested AND function or a nested OR function for the logical text |
|
Definition
|
|
Term
| When a formula is entered in a cell within an Excel table, the formula is automatically copied to all cells in that column. The column is referred to as a _________ ________. |
|
Definition
|
|
Term
| To test two or more conditions and determine whether all conditions are true, you use the ______ function as the logical test of the IF function |
|
Definition
|
|
Term
| A _________ _________ is an expression such as H2 = "Y" that returns either a TRUE value or a FALSE value |
|
Definition
|
|
Term
| The ____ function is a logical function that returns a TRUE value if any of the logical conditions are true, and a FALSE value if none of the logical conditions are true |
|
Definition
|
|
Term
True or False?
Calculated columns work only in Excel tables |
|
Definition
|
|
Term
| The Insert Function button is located in the _______ ______ |
|
Definition
|
|
Term
| To select en entire column but not the header, what do you click? |
|
Definition
| Just above a cell in the header row |
|
|
Term
| What do you use to denote a structured reference? |
|
Definition
|
|
Term
| A _______ IF function is a when one IF function is placed inside another IF function to test an additional condition. |
|
Definition
|
|
Term
| The ________ value is the value you are trying to find. |
|
Definition
|
|
Term
| The _______ table is a table that organizes data that you want to retrieve into different categories. |
|
Definition
|
|
Term
| The _______ ________ are the categories for a lookup table, located in the table's first column or row |
|
Definition
|
|
Term
| When the _______ value matches a _______ value, the corresponding value from the lookup table is returned to the cell with the formula |
|
Definition
|
|
Term
| The ________ function searches vertically down the first column of the lookup table and retrieves the appropriate value from the table |
|
Definition
|
|
Term
| The _________ function can determine if a cell contains an error value and then display the message you choose rather than the default error value, such as "Invalid code" |
|
Definition
|
|
Term
| Omitting the range lookup entry makes VLOOKUP an __________ match lookup |
|
Definition
|
|
Term
| Highlighting duplicate values adds ________ to cells that have the same entry |
|
Definition
|
|
Term
| The _________ formatting button provides access to the Duplicate Values format and the Manage Rules option |
|
Definition
|
|
Term
| Each time you apply a conditional format, you are defining a conditional formatting _______ |
|
Definition
|
|
Term
| The _________ function calculates the average of values in a range that match criteria you specify. |
|
Definition
|
|
Term
| The _______ function calculates the number of cells in a range that matches criteria you specify |
|
Definition
|
|
Term
| The ______ function adds the values in a range that match criteria you specify |
|
Definition
|
|
Term
| The Conditional Formatting button is located in the _______ tab in the ________ group |
|
Definition
|
|
Term
| The ______ box displays all of the range names in the workbook |
|
Definition
|
|
Term
| The ______ function is a logical function that evaluates a condition and then returns one value if the condition is true and another value if the condition is false |
|
Definition
|
|
Term
True or false?
A space is allowed in a defined name |
|
Definition
|
|
Term
| To access Protection, click the _____ tab then the dialog box launcher of the _____ group |
|
Definition
|
|
Term
| The Name Manager is located in the _______ group of the _______ tab |
|
Definition
|
|
Term
| you can replace a specific cell or range address with a _______ ________ which is the actual table name or column header |
|
Definition
|
|
Term
| The AND function is a logical function that returns a _____value if all of the logical conditions are true, and a ______ value if any or all of the logical conditions are false |
|
Definition
|
|
Term
| The _____ function is a logical function that evaluates a condition, and then returns one value if the condition is true and a different value if the condition is false |
|
Definition
|
|
Term
| A ______ ________ is an expression such as H2 = "Y" that returns either a TRUE value or a FALSE value |
|
Definition
|
|
Term
| The ____ function is a logical function that returns a TRUE value if any of the logical conditions are true, and FALSE value if none of the logical conditions are true |
|
Definition
|
|
Term
| When a formula is entered in a cell within an Excel table, the formula is automatically copied to all cells in that column. The column is referred to as a _________ _________. |
|
Definition
|
|
Term
| To test two or more conditions and determine whether all conditions are true. you use the ______ function as the logical test of the ______ function |
|
Definition
|
|
Term
| To test two or more conditions and determine whether any conditions is true, you use the ___ function as the logical test of the ____ functions |
|
Definition
|
|
Term
True or False?
Calculated columns work only in Excel tables |
|
Definition
|
|
Term
| Approximate look ups require the look up table to be in _________ order |
|
Definition
|
|
Term
| How many conditions must be true for an IFAND statement? |
|
Definition
|
|
Term
| How many conditions must be true in an IFOR statement? |
|
Definition
|
|
