| A | B |
|---|
| Merge | used to combine adjacent cell ranges or cells |
| Column width | adjusted to fit the longest entry |
| Borders and Shading | used to emphasize and organize information and can be applied to columns |
| Editing | changing the data or cell formatting such as inserting |
| Renaming | adding a descriptive identifier to the spreadsheet tab |
| Spreadsheet operations | sort |
| Spreadsheet functions | predefined formulas that perform calculations by using specific values |
| Components of a Function | cell reference |
| Basic functions | sum |
| Advanced Functions | IF statements |
| Sort | used to arrange data in alphabetical or chronological order |
| primary sort | indicates the primary sort range of data |
| secondary sort | indicates the next range |
| Freeze panes | allows the user to work in multiple areas of a large spreadsheet and focus the view on specific cell ranges |
| Fill Series | used to fill a column or row with consecutive data |
| Print | used to provide a hard copy |
| Print preview | used to validate how data is represented on paper before printing and to make adjustments to margins |
| Print a selection | used when printing only a portion of a spreadsheet |
| Linking and embedding | used to integrate spreadsheet data with other software applications |
| embedded spreadsheet | converted into a graphic image when placed in a target document and does not change to reflect edits made at the source |
