A | B |
Cell | The name of the box formed by the intersection of a row and a column? |
Active cell | The name of the area within a worksheet that is current, or ready to receive information |
<F5> | The <GoTo> key |
Values | Are used in calculations |
Numeric Labels | Used for descriptive headings such as social security numbers, telephone numbers |
Labels | Simple text |
Truncate | If the label is too long to fit in a cell entry is what |
#### | Cell is too small for value |
XLS | Extension given to all Excel files |
<Ctrl><Home> | Moves cursor to cell A1 |
Formula | An instruction to calculate a number |
Formula bar | Formula appears in the cell and in this area |
SUM | Adds all values in a range of cells |
MIN | Indicates the lowest value in a range of cells |
MAX | Indicates the highest value in a range of cells |
COUNT | Counts all the non-blank cells in a range |
COUNTA | Counts labels or numeric labels |
AVERAGE | Averages values in a range of cells |
>= | Greater than or equal to |
<= | Less than or equal to |
= | Indicates the beginning of a formula |
<> | Not equal to |
> | Greater than |
< | Less than |
MIN, MAX, SUM, AVERAGE | Samples of functions |
Range | A defined area of the worksheet such as A1:H20 |
<F2> | The edit key |
$C$20 | Absolute value |
<F5> | Go To Key |
Right align | Values are aligned right, left, or center? |
<F2> | Edit key |
MIN and MAX | Examples of Functions |
MIN min Min | Ways a function can be typed |
Numeric Labels | DOB, SS #, Telephone Numbers |