A | B |
cell | smallest part of a spreadsheet |
left align | default format of labels |
GoTo Key | F5 |
values | numbers, formulas |
numeric labels | used for descriptive headings |
labels | simple text |
truncate | label too long to fit in a cell |
cell is too small | ##### |
Ctrl Home | moves cursor to cell A1 immediately |
formula | mathematical calucation |
formula bar | formula or cell contents appear here |
SUM | function to add values in a range |
MIN | function that indicates the lowest value in a range |
Count | totals all the non-blank cells in a range |
columns | vertical data |
average | formula the finds the average of a range of cells |
row | horizontal data |
edit key | F2 |
absolute reference key | F4 |
absolute reference | $C$20 |
mixed reference | $A10 |
relative reference | B5 |
equal sign | indicates the beginning of a formula |
greater than | > |
less than | < |
not equal to | <> |
range | defined area of cells |
argument | range of cells in a formula |
right align | default format of values |
active cell | area that is current |