| A | B |
|---|
| absolute cell reference | a cell references that does not change when copied because a dollar sign has been placed in front of both the column letter and row number |
| MAX | function that displays the largest value in a range of cells |
| MIN | function that displays the smallest value in a range of cells |
| Destination | the upper-left cell of the range where data is to be pasted |
| F4 key | places dollar signs in front of the column letter and row number in a cell reference |
| IF | function that makes a decision based on a comparison |
| landscape orientation | a print orientation that prints a worksheet across the widest part of the page |
| protrait orientation | the default print orientation that allows more rows to be printed on a page |
| relational operators | used to compare two values; includes =, <,>,<=,>=, <> |
| source | selected cells that are to be copied |
| printing a worksheet in landscape orientation | fits more columns and fewer rows on a page |
| Insert Function button | a function can be entered into a formula without typing it |
| the Esc key | removes the dashed outline that indicates that data has been copied |
| reducing margins | one way to fit more rows and columns on a printout |
| newly inserted row | contains the same formatting as the cells above it |
| SUM | function that adds the values in a range of cells |
| Set Print Area command | designates a specific range of cells to be printed |
| Sort Ascending button | places selected rows of data in order from low to high based on the column that was selected first |
| AVERAGE | function that adds the values in a range of cells and then divides the result by the number of cells in the range |
| PMT | function that calculates the periodic payment for an installment loan |
| arguments | the data required by a function |
| amortization table | displays the interest and principal amounts for each payment of an installment loan |
| principal | the amount of money owed on a loan |
| static data | copied data that is not connected to the source data |
| linked data | data that is connected to the source cell and will automatically update if the source cell is changed |
| $D$4 | an absolute cell reference |
| ROUND | function that changes a value by rounding it to a specific number of decimal places |
