Term
|
Definition
process of using the mouse pointer to select cells while building a formula
*also called Semi-Selection |
|
|
Term
|
Definition
process of using the mouse pointer to select cells while building a formula
*also called Semi-Selection |
|
|
Term
Relative cell Reference
definition |
|
Definition
-indicate's a cell's relative location from the cell containing the formula
-cell reference changes when the formula is copied
-A1 (orientation changes |
|
|
Term
Absolute cell reference
definition |
|
Definition
-indicates a cell's specific location
-does not change when you copy the formula
-ex.) $A$1 |
|
|
Term
Mixed cell reference
definition |
|
Definition
combines an absolute cell reference with a relative cell reference in a formula
-absolute part does not change but the relative part does when you copy the formula
-ex:A$1(A changes, 1 does not[is absolute] |
|
|
Term
|
Definition
| row number or column letter will not be modified during a copy |
|
|
Term
circular reference
definition |
|
Definition
| occurs when a formula directly or indirectly refers to itself. |
|
|
Term
F4
within a cell reference(in a formula) |
|
Definition
| changes the cell reference to mixed, relative, or absolute |
|
|
Term
Function
description
format |
|
Definition
-functions are predefined formulas that performs a calculation
-begins with "=" sign, followed by cells or numbers |
|
|
Term
|
Definition
| set of rules that govern the structure and components for properly entering a function |
|
|
Term
|
Definition
-inputrequired to complete an operation
-ex:) cell reference or value |
|
|
Term
Formula AutoComplete
definition |
|
Definition
| displays a list of functions and defined names as you enter a function |
|
|
Term
Function Screen Tip
definition |
|
Definition
| -small pop-up description that displays the function arguments |
|
|
Term
|
Definition
|
|
Term
difference between : and
within a , function |
|
Definition
:=all cells between
,=individual cells entered |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| number of values in range |
|
|
Term
|
Definition
| number of non-empty cells |
|
|
Term
|
Definition
|
|
Term
|
Definition
| displays positive valuel of number |
|
|
Term
| =randbetween(bottom, top) |
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| displays current time and date |
|
|
Term
|
Definition
-logical test that is true or false
-resulting value if condition is true
-resulting value if condition is false |
|
|
Term
=if()
if A1 is greater than 80%, then you need insurance. show formula |
|
Definition
|
|
Term
Nested function
Definition |
|
Definition
| -function that contains another function embedded inside one or more of its arguments |
|
|
Term
|
Definition
-looks up a value in a vertical lookup table and returns a related result from the lookup table.
-VLOOKUP(lookup_value, table_array,col_index_number,(range_lookup) |
|
|
Term
|
Definition
| the lowest value for a specific category or series in a lookup table |
|
|
Term
|
Definition
| range that contains data for the basics of the lookup and data to be recieved |
|
|
Term
|
Definition
| reference to a cell containing a value to look up |
|
|
Term
|
Definition
range containing a lookup table
|
|
|
Term
Column index number
definition |
|
Definition
| argument in a VLOOKUP function taht identified which lookup table column from which to return a value |
|
|
Term
=HLOOKUP
definition
function |
|
Definition
-looks up a value in a horizontal lookup table where the first row contains the values to compare with the lookup value
-=HLOOKUP(lookup_value,table_array,row_index_number,{range_lookup}) |
|
|
