| A | B |
|---|
| source range | Term used to refer to a range being used as a source. |
| destination range | Term used to refer to a range being used as a destination. |
| Flash Fill | Excel feature that looks for patterns in the data and automatically fills or formats data in remaining cells. |
| formula | Cell references, numbers, and arithmetic operators that instruct Excel to perform a calculation. |
| circular reference | Reference that occurs when one of the defining values in a cell is itself. |
| direct circular reference | Occurs when a formula refers to the same cell in which it is entered. |
| indirect circular reference | Occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell. |
| PRODUCT function | Formula that calculates the product of two or more numbers. |
| equal sign (=) | Symbol that alerts Excel that you are entering a formula or function — not text. |
| Point mode | Excel mode that allows you to select cells for use in a formula by using the pointer. |
| MAX function | Excel function that displays the highest value in a range. |
| MIN function | Excel function used to determine the lowest (minimum) number in a range. |
| AVERAGE function | Excel function that sums the numbers in a specified range and then divides the sum by the number of cells with numeric values in the range to determine the average. |
| Range Finder | Excel feature that checks which cells are referenced in the formula assigned to the active cell. |
| theme | A collection of fonts, font styles, colors, and effects to give a worksheet a consistent appearance. |
| character | A letter, number, symbol, or punctuation mark. |
| pixel | A dot on the screen that contains a color; short for picture element. |
| Best fit | Excel feature that automatically increases or decreases the width of the column so that the widest entry will fit in the column. |
| spelling checker | Excel command that checks for spelling errors by comparing words on the worksheet against words contained in its standard dictionary. |
| header | Text and graphics that print at the top of each page. |
| footer | Text and graphics that print at the bottom of each page. |
| margins | Portions of a printed page outside the main body of the printed document and always are blank when printed. |
| debugging | The process of finding and correcting errors in a worksheet. |
