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. |