| A | B |
|---|
| A workbook | is a file which contains one or more spreadsheets. |
| A spreadsheet | (or worksheet) is an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form. |
| Cells | individual locations on a spreadsheet. |
| The label (Text) | is used for cells that contain text or for numbers that will not be used in calculations. |
| A value (Number) | indicates that the data has the potential to be used in calculations. |
| A formula | instructs the software to perform a calculation. |
| A basic function | a shortcut for a formula Begins with = and a function word) |
| Cell reference | indicates a cell’s location and provides instructions for how cell data is copied or used in calculations. |
| Relative | cell value changes as the formula is copied |
| Absolute | cell value remains static when copied to other locations |
| Mixed | combination of an absolute and a relative cell |
| Parentheses – ( ) | control the Order of Operations |
| Sum, | for example, =Sum(C4:C18) adds the range of cells from C4 through C18 |
| Average, | for example, =Average(C4:C18) determines the average of the range of cells from C4 through C18 |
| Maximum, | for example, =Max(C4:C18) finds the highest number in the range of cells from C4 through C18 |
| Minimum, | for example, =Min(C4:C18) finds the lowest number in the range of cells from C4 through C18 |
