| A | B |
|---|
| absolute reference | A cell reference that does not change when a formula is copied to a new location. |
| filter | A feature that allows you to look at only the data that you need. |
| function | A preset formula that allows you to quickly calculate data. |
| IF | A function that checks to see if a condition is met and then has one result if it is true and another if it is false. |
| NOW | A function that displays the date and time that a worksheet is opened or used. |
| PMT | A function that calculates payments for a loan based on interest rate, number of payments, and the amount of the loan. |
| range | A group of cells. |
| relative reference | A cell reference that changes when a formula is copied to a new location. |
| sort | To put a list of data in ascending or descending order. |
| count | A function that counts the number of cells in the range that contain numbers. |
