click below
click below
Normal Size Small Size show me how
F19 Acct 1.03 Vocab
Vocabulary for Accounting 1.03
| Term | Definition |
|---|---|
| Workbook | A file containing one or more spreadsheets. |
| Spreadsheet | (Worksheet) Arrangement of cells in columns and rows used to organize, analyze, calculate and report information—usually numeric data. |
| Cell | Individual locations on a spreadsheet at the intersection of a column and row. |
| Cell address | The Column letter and the row number identifying where a cell is located. Ex./ B16 |
| Cell range | Refers to a group of cells, starting with the uppermost left hand corner and ending with the lower most right hand corner. A colon : is inserted between the cell addresses. Ex./ A4:A16 or B3:E11 |
| Label | Classification is used for cells that contain text or for numbers that will not be used in calculations |
| Value | A classification indicates that the data has the potential to be used in calculations |
| Formula | Instructions to the program to perform a calculation; begin with equal (=) sign. |
| Function | A shortcut for a formula. Ex./ SUM, AVERAGE |
| Relative | Cell value changes as the formula/function is copied. |
| Absolute | Cell value remains static when copied to other locations. |
| Mixed | A combination of an absolute and a relative cell reference in a formula. |
| Fill Series | Used to fill in a column or row with consecutive data. |