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;
16 Cards in this Set
- Front
- Back
|
Formula
|
instructs the software to perform a calculation.
|
|
|
Point & Click Method
|
similar to entering a formula manually into a cell, instead of using the formula bar.
|
|
|
Relative Cell Refernce
|
the cell value changes “relative” to the cell in which it is copied.
|
|
|
Absolute Cell Reference
|
the cell value remains constant when copied to another cell or used in a formula.
|
|
|
Function
|
a special formula that does not use arithmetic operators to calculate a result. It is also known as a shortcut formula.
|
|
|
Argument
|
a value that provides information to an action, event, method, property, function, or procedure.
|
|
|
Auto Sum
|
allows you select a set of cells relative to cell the function is located in to be added
|
|
|
Value_if_False
|
the value that you want to be returned if the logical_test argument evaluates to FALSE.
|
|
|
Logical_Test
|
any value or expression that can be evaluated to TRUE or FALSE.
|
|
|
Value_if_True
|
the value that you want to be returned if the logical_test argument evaluates to TRUE.
|
|
|
=NOW()
|
returns the current date and time format as date and time to be used in calculations rather than a label (constant).
|
|
|
=TODAY()
|
returns the current date as a date.
We will look at explanation in the Excel help menu to explain how date and time are based upon the computer system’s date and time. |
|
|
Sum
|
function that adds the values in a cell.
|
|
|
Equals
|
a symbol that starts a function or formula.
|
|
|
Average
|
a function that obtains the acerage of a group of cells.
|
|
|
3D-Formula
|
a formula that refers to the same cell or range of cells of a worksheet.
|
