| A | B |
|---|
| Workbook | Several spreadsheets together |
| Spreadsheet | Cells in Columns and Rows |
| Name a Cell | Column Letter followed by Row Number |
| Labels incluce | License#, Part#, Soc Sec# |
| Label | Will not be used in Calculations |
| Value | May be used in Calculations |
| = | Formula beginning |
| PEMDAS | Acronym for Mathematical Order of Operations |
| =10+7*2 | 24 |
| =(10+7)*2 | 34 |
| To best organize, clarify, and present information | Apply Formatting |
| Global Formatting | Formatting applies throughout document |
| Wrap Text | Allows text to show even when too long to fit in a cell |
| Merge | Combines multiple cells into one cell |
| Spreadsheet Tab | Used to rename the spreadsheet |
| Maximum | Selects the highest number in a range |
| Minimum | Selects the lowest number in a range |
| Average | Adds the numbers, then divides by the amount of numbers |
| Sum | Add everything in a range |
| Sort | Organizes by alphabetical or numerical order |
| Linking and Embedding | Attaches updated data into a document |
| Print Preview | Allows user to check the document before printing |
| Fill Series | Completes a pattern of data |
| Freeze Panes | Keeps some cells stationary while others adjust |
| Absolute Cell Reference | Cell reference that does not change |
| Relative Cell Reference | Cell reference that may change based on location |
| Mixed Cell Reference | Stabilizes either the column or the row |
