| A | B |
|---|
| Alphabetical | Sorting text in ascending order from A to Z. |
| Amortization | Function that calculates the periodic payment for an installment loan. |
| Amortization table | Displays the interest and principal amounts for each payment of an installment loan. |
| Ascending | Increasing in value from low to high, such as alphabetical order. |
| CHOOSE | Function that returns a value from a list of many values. |
| Chronological | Sorting times or dates in ascending order. |
| Descending | Decreasing in value from high to low. |
| Installment loan | Loan that is repaid in a series of periodic payments. |
| Key sort column | The column that contains the values that a sort is based on. |
| Model | A spreadsheet containing data relating to a particular situation. |
| PMT | Function that calculates the periodic payments for an installment loan. |
| Principal | The amount of money owed. |
| Sorting | Placing rows of data in a specified order. |
| VLOOKUP | Function that returns a value from a table of values stored in the spreadsheet. |
| What If? Question | A question that is answered using a spreadsheet model. |
