| A | B |
|---|
| Formulas | allow you to perform calculations on data entered into a spreadsheet. |
| Data | Information (values or numbers; labels or text; and date/time) that is stored in a spreadsheet program. |
| A table | used to store various types of data. |
| A cell | is a basic storage unit for data in a spreadsheet, and it is the intersection point of a column and a row. Each rectangular box is referred to as a cell. |
| Rows | run horizontally and are identified by a number in the row header. |
| Columns | run vertically and are identified by a letter in the column header. |
| The cell reference | identifies the location of a cell and consists of the column letter and row number that intersect at the cell’s location. |
| Relative Cell Reference | Default for all cell references. Identifies the location of a cell and changes when the formula is copied to other cells. |
| Absolute Cell Reference | An absolute cell reference does not change when it is copied and pasted to other cells. |
| Addition | =a1+a2+a3+a4 |
| Subtraction | =a1-a4 |
| Multiply | =a1*a4 |
| Divide | =a1/a4 |
| Relative Vs. Absolute Cell References | Relative cell reference identifies the location of a cell and changes when the formula is copied and pasted to other cells. An absolute cell reference does not change. |
