 |
Java Games: Flashcards, matching, concentration, and word search. |
 |
|
Functions and spreadsheet terms
|
| A | B |
|---|
| Math and Trig Functions | SQRT, ROUND, SUM |
| Financial Functions | PMT, FV, PV |
| Logical Functions | IF, AND, NOT |
| Statistical Functions | MAX, COUNTA, AVERAGE |
| Date and Time Functions | NOW, TODAY, HOUR |
| Values | Numeric data in a spreadsheet |
| Labels | Identifying words in a spreadsheet |
| Range | Connected group of cells |
| Argument | Acts as an operand in a function |
| "What If" | Term used to describe predicting ability of spreadsheet |
| Absolute Reference | Does not adjust to the new cell location in a function |
| Relative Reference | Adjusts to a new cell reference in a function |
| SUM,MIN,IF,SQRT | Operators |
| Cell references or numbers used in calculations | Operands |
| Name box | Area on a worksheet that identifies the cell reference or range |
| Function | Special formulas that do not use formulas |
| Principal | Original amount of money borrowed |
| Address | Exact location of a cell |
| Worksheet | Grid of rows and columns containing data and functions |
| Workbook | Collection of related spreadsheet pages |
| Mixed cell reference | $A2 |
| Calculated first in a function | Numbers in parentheses |
| Highest priority in order of evaluation | Exponentation |
| Display formulas | Control plus ` |
| Periods | Number of payments made |
|
|
|
|
|
|
| |
