| A | B |
|---|
| workbook | a file which contains one or more spreadsheets |
| spreadsheet | an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form |
| cell | individual locations on a spreadsheet |
| cell address | refers to one specific location of information on a spreadsheet |
| cell range | refers to a group of adjacent cells |
| label | classification is used for cells that contain text or for numbers that will not be used in calculations |
| value | classification indicates that the data has the potential to be used in calculations |
| formula | instructs the software to perform a calculation |
| relative cell reference | cell values change when formula is copied |
| absolute cell reference | cell value does not change when copied to other locations, remains static (the same) |
| order of operations | pemdas |
| rename | a spreadsheet adds a descriptive identifier to the spreadsheet tab |
| fill handle | continues a series |
| sort ascend | arrange information from smallest to largest |
| sort descend | arranges information from largest to smallest |
| wrap text | displays text on multiple lines in a single cell |
| column | identified by letters or the vertical arrangement of cells |
| row | identified by numbers or the horizontal arrangement of cells |
| maximum | a function that returns the largest number |
| minimum | a function that returns the smallest number |
| sum | a function that adds a range of cells |
