Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
10 Cards in this Set
- Front
- Back
|
A worksheet reference that uses values on other sheets or workbooks, effectively creating another dimension to a workbook.
|
3-D reference
|
|
|
To combine data on multiple worksheets and display the result on another worksheet.
|
consolidate
|
|
|
A separator, such as a space, comma, or semicolon between elements in imported data.
|
delimiter
|
|
|
The exclamation point (!) used in a formula to indicate that a referenced cell is outside the active sheet.
|
external reference indicator
|
|
|
The dynamic referencing of data in the same or in other workbooks, so that when data in the other location is changed, the references in the current location are automatically updated.
|
linking
|
|
|
A formula with calculations that are based on stated conditions.
|
logical formula
|
|
|
The first part of an IF function;
if the logical test is true, then the second part of the function is applied, and if it is false, then the third part of the function is applied. |
logical test
|
|
|
In a function, used to display a result.
|
returns
Note: this term does not show up on the official Microsoft Excel website. In a Google search results, used as a verb, i.e. "Excel returns the #VALUE error, because the formula is returning a multi-cell reference, rather than one cell. |
|
|
In a named cell or range, the worksheets where the name can be used.
|
scope
|
|
|
In a logical formula, criteria you create.
|
stated conditions
|
