click below
click below
Normal Size Small Size show me how
Excel Vocab
| Question | Answer |
|---|---|
| Absolute Reference | a cell reference that does not change when a formula is copied to a new location |
| Arrange | to organize more than one window on the screen at the same time |
| AutoSum | a function used to add values in rows or columns |
| Border | a line or box that frames a cell |
| Button | a graphic item that can be clicked to perform a specific task |
| Cell Reference | the column letter and row number of a cell |
| Count | a function that counts the number of cells in the range that contain numbers |
| Fill Handle | a tool that lets you fill multiple cells with the same content by using one cell as an example |
| Filter | a feature that allows you to look at only the data that you need |
| Footer | text that appears at the bottom of the printed page |
| Formula Bar | the bar that displays the contents of a cell |
| Freeze | to keep headings in place while you scroll through a worksheet |
| Function | a list of preset formulas that are used to solve equations |
| Go to | a command that allows you to move directly to a particular cell |
| Header | text that appears at the top of the printed page |
| Horizontal Alignment | the side-to-side placement of the contents of a cell |
| 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 |
| Landscape | the orientation of a worksheet that is wider than it is tall |
| MAX | a function used to identify the largest value in a group of cells |
| MIN | a function used to identify the smallest value in a group of cells |
| NOW | a function that displays the date and time that a worksheet is opened or used |
| Page Orientation | the direction that a worksheet prints on a page (either landscape or portrait) |
| PMT | a function that calculates payments for a loan based on interest rate, number of payments and the amount of the loan |
| Portrait | the orientation of a worksheet that is taller than it is wide |
| Range | a group of cells |
| Relative Reference | a cell reference that changes when a formula is copied to a new location |
| Sheet Tab | a small flap at the bottom of a worksheet that displays the name of the worksheet, allows you to move from one worksheet to another within the same workbook |
| Sort | to put a list of data in ascending or descending order |
| Split | to divide a window into two panes that you can scroll independently |
| Style | a group of formatting traits that has been given a name |
| Text Box | a moveable, resizable rectangle that contains text |
| Toolbar | the bar that contains buttons that can be clicked to perform common tasks |