Active Cell
The cell ready for data entry.
Alignment
Placement of text: right,left,center and up,down,middle
Cell
box formed at the intersection of a row and a column and identified by a cell reference.
Cell range
A selected group of cells identified by a : colon
Cell merge
Combine two or more cells into one larger single cell.
Cell reference
The specific column letter and the row number.
Example: B12.
Column
Information arranged vertically and identified by letters that appear at the top of the spreadsheet.
Formula
The relationship between cells using arithmetic operators +, -, *, / to form an equation and always begins with =
Formula Example
#VALUE!
Function
Special formulas that do not use operators to calculate a result. . (A shortcut formula.) Begins with = and involves a cell range :
Function Example
65822204
Label
Text, symbol, date, or number not used in calculations.
Rows
Information arranged horizontally and identified by numbers on the left side of the spreadsheet.
Spreadsheet or Worksheet
A table of data that allows you to use rows and columns of data to manage, predict, and present information.
Chart
A graphic tool used to compare data in a worksheet
Value
A number entered into a spreadsheet cell that will be used for calculations.
Autofit
Automatically changes the width of a column or height of a row to fit the longest entry by double clicking between column letters or row numbers
AutoSum
A function that adds a range of cells
Relative Addressing
The change a formula makes when it is filled to other rows or columns with different data
Sort
To arrange, classify, or separate from others.
Wrap text
Text hits the right margin of a cell and automatically moves down to the next line of the same cell.
Workbook
A file that contains worksheets.
Fill handle
The box in the bottom right of an active cell that allows you to drag down or across to copy that cell information to other cells.
What is used to identify a Formula?
An = sign AND a math operator +, -, *, /
What is used to identify a Function?
An = sign AND a cell range (A2:A6)