| A | B |
|---|
| Alphabetical | Sorting text in ascending order form A to Z. |
| Amortization | A method for computing equal periodic payments 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 worksheet containing data relating to a particular situation. |
| PMT | Function that calculates the periodic payment for an installment loan. |
| Principal | The amount of money owed on a loan. |
| Sorting | Placing rows of data in a specified order. |
| VLOOKUP | Function that returns a value from a table of values stored in the worksheet. |
| What If? question | A question that is answered using a worksheet model. |
| Clear Print Area command | Restores the print area to the entire worksheet. Found in the Print Area submenu in the File menu. |
| Copy button | Places the selected cell(s) on the Clipboard. Found on the toolbar. Copy in the Edit menu can be used instead of the button. |
| Cut button | Removes the selected cell(s) and places them on the Clipboard. Found on the toolbar. Cut in the Edit menu can be used instead of the button. |
| E-mail button | Displays options for e-mailing the current worksheet. Found on the toolbar. |
| From File command | Displays a dialog box used to place a picture on the worksheet. Found in the Picture submenu in the Insert menu. |
| Freeze Panes command | Keeps rows and columns from scrolling off the screen. Found in the Window menu. |
| Hyperlink button | Displays a dialog box used to insert a hyperlink into the active cell. Found on the toolbar. Hyperlink in the Insert menu can be used instead of the command. |
| Paste button | Places the Clipboard contents in a worksheet starting at the selected cell. Found on the toolbar. Paste in the Edit menu can be used instead of the button. |
| Print command | Displays a dialog box used to print a worksheet. Found in the File menu. |
| Save as Web Page command | Displays a dialog box used to save a worksheet in HTML format. Found in the File menu. |
| Send this Sheet button | Sends the open worksheet as an e-mail message. Displayed after selecting the E-mail button. |
| Set Print Area command | Designates a specific range of cells to be printed. Found in the Print Area submenu in the File menu. |
| Sort Ascending button | Places selected rows of data in order from low to high based on the column that was selected first. Found on the toolbar. |
| Sort command | Displays a dialog box where options to select the key sort column and sort order can be selected. Found in the Data menu. |
| Sort Descending button | Places selected rows of data in order from high to low based on the column that was selected first. Found on the toolbar. |
| Unfreeze Panes command | Unfreezes all the cells on a worksheet. Found in the Window menu. |
