BA10 1.03 Vocabulary Terms

A file containing one or more spreadsheets

• Spreadsheet

• Label

• Workbook

• Value

(Worksheet) Arrangement of cells in columns and rows used to organize, analyze, calculate and report information- usually numeric data

• Formula

• Spreadsheet

• Workbook

Individual locations on a spreadsheet at the intersection of a column and row

• Cell

• Label

• Value

• Function

The Column letter and the row number identifying where a cell is located

• Cell range

• Cell address

• Value

• Function

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

• Cell address

• Cell range

• Fill Series

• Spreadsheet

Classification is used for cells that contain text for numbers that will not be used in calculators.

• Label

• Function

• Value

• Formula

A classification indicates that the data has the potential to be used in calculations

• Function

• Value

• Label

• Relative

Instructions to the program to perform a calculation; begin with equal (=) sign

• Function

• Formula

• Absolute

• Label

A shortcut for a formula

• Formula

• Mixed

• Function

• Value

Cell value changes as the formula/function is copied

• Cell range

• Value

• Absolute

• Relative