Question | Answer |
Absolute cell reference - A cell reference that does not change when copied or moved to a new cell |
|
Argument - The value the function uses to perform a calculation, including a number, text, a cell reference, or even a formula that acts as an operand |
| Automatic page break - Excel inserts this whenever it runs out of room on what would be a printed page |
| Chart - A graphical representation of data |
| Conditional formatting - Highlights worksheet data by changing the look of cells that meet a specified condition you create |
| Fill (2nd Meaning) - Copies a cells contents (any numbers, text, or formulas) and formatting into an adjacent cell or range |
| Fill handle - The little box that appears in the lower-right corner of the active cell or range, and is used to fill cells |
| Freeze pane - Rows and/or columns you select to remain visible on the screen as the rest of the worksheet scrolls in the window |
| Function - Shorthand way to write an equation that performs a calculation. For example the SUM function is used to make adding a range easier |
| Manual calculation - Lets you determine when Excel calculates the formulas |
| Manual page break - A page break you insert manually to start a new page |
| Mixed cell reference - Cell references that contain both relative and absolute column or row references |
| Operand - A constant (text or number) or cell reference used in a formula. For example in 8 + 2, the 8 and 2 are the operands |
| Operator - A symbol that indicates the type of calculation to perform on operands. For example, in 8 + 2, the + is the operator |
| Order of evaluation - The sequence used to calculate the value of a formula – exactly the same as order of operation in math |
| Page Break Preview - View that shows where the page breaks are in a worksheet, which is helpful when you prepare a worksheet for printing |
| Point-and-click method - Allows you to point and click (or touch) each cell in a formula rather than typing out cell references |
| Print area - Consists of the cells and ranges you can designate for printing and does not have to be the entire spreadsheet |
| Print title - Rows and/or columns in a worksheet that you assign to print on each page |
| Relative cell reference - A cell reference that changes by adjusting to its new location when copied or moved |
| Scale - Enables you to resize a worksheet to print on a specific number of pages |
| Sort - Rearranging the data in a spreadsheet in a more meaningful order. For example, putting a range in alphabetical order |
| Split - Divides the worksheet window into two or four panes that you can scroll and work in independently from one another |
| Sum button - The button at the top right of the Home tab that makes using functions to write formulas much easier to do | |