| A | B |
|---|
| Range finder | used to check cells being referenced in the formula assigned to an active cell |
| Multiplication | arithmetic operation that multiplies |
| Web query | used to input data into a worksheet that is stored on a Web site |
| Currency style format | format that displays a dollar sign to the left of the number and inserts commas |
| Max function | function that displays the highest value in a range |
| Average function | sums number in a range and divides by number of values |
| Order of operation | order followed in Excel that starts with negations and ends with subtractions |
| Smart tags | identifies certain actions to be taking on specific data |
| Hiding cells | technique used to hide irrelevant or sensitive data |
| Fill color button | located on the ribbon and is used to display the color palette |
| Parentheses | used to override the order of operation |
| Arguments | the values that are used with a function |
| Comma style format | format that inserts a comma every three positions to the left of the decimal point |
| Relative reference | Excel’s process of adjusting the row and column portions of a cell reference |
| Spell checker | used to check a worksheet for spelling errors |
| Subtraction | arithmetic operator that subtracts contents of cells |
| Percentage | arithmetic operator that multiplies by .01 |
| Blank cell | cell in Excel with the numerical value of zero |
| Pixel | a dot on the screen that contains a color |
| Fixed dollar sign | displays at the far left of the cell with spaces between it and the first digit |
| Debugging | process of finding and correcting errors in a worksheet |
| Min function | displays the lowest value for a range of values |
| Equal sign | Used to indicate the start of a function |
| Trace error button | displays next to a cell in which a formula error occurs |
| Values version | worksheet version that shows the results of entered formulas |
| Formula | mathematical equation assigned to a cell that Excel uses to calculate a result |
| Landscape orientation | printout the is printed across the length of the page |
| Fill handles | small rectangles in the lower right corner of a cell that is used to copy formulas |
| Portrait orientation | printout that is printed across the width of the page |
| Best fit | condition when the width of the column is adjusted to fit the widest entry |
| Theme | a predetermined set of colors, fonts, chart styles, cell styles and fill effect |
| Formula version | worksheet version that shows the actual formulas entered in cells |
| Accounting number format | with the dollar sign to the left, inset the comma every three positions from the decimal point and displays the number to the nearest cent |
| Addition | arithmetic operator that add the contents of cells |
| Point mode | mode that allows the user to select cells to use in a formula with a mouse |
| Conditional formatting | ability to apply formatting to a cell that meets on specific conditions |
| Division | arithmetic operator that divides contents of a cell |
| Condition | composed of two values and a relationship operator are is true or false |
| Center button | button on the Ribbon used to center text in a cell |
| Floating dollar sign | displays in the far left of the cell to the left of the first digit, with no spaces |
| Exponentiation | arithmetic operator that raises to the power |
| Functions | prewritten formulas used to help compute statistics |
| Borders button | located on the ribbon and is used to display the borders gallery |
| Negation | arithmetic operator that makes numbers negative |
| Increase decimal button | instructs Excel to display additional decimal places in a cell |
