| A | B |
|---|
| filling | copies data into the cells adjacent to the original |
| freezing | keeps row or column titles on the screen no matter where you scroll in the worksheet |
| protecting | prevents accidental changes from being made to a worksheet; worksheet data can't be added, removed or edited |
| formulas | equations that calculate a new value from values currently on a worksheet |
| operand | numbers or cell references used in calculations in the formulas of a worksheet |
| operator | tells Excel what to do with operands in a formula |
| order of evaluation | sequence of calculation in a worksheet formula |
| relative cell reference | cell reference that adjusts to a new location when copied or moved |
| absolute cell reference | cell reference that does not adjust to the new cell locator when copied or moved |
| mixed cell reference | cell reference containing both relative and absolute references |
| point-and-click method | constructs a cell formula by clicking on the cell you want to reference |
| AutoSum | adds the most logical column or row of adjacent cells |
| argument | value, cell reference, range, or text that acts as an operand in a function formula |
| formula palette | specifies the elements to be included in the function formula of a worksheet |
| mathematical and trigonometric functions | functions that manipulate quantitative data in the worksheet using logarithms, factorials, sines, cosines, tangents, and absolute values |
| statistical functions | functions used to describe large quantities of data such as average, standard deviation, or variance of a range of data |
| financial functions | functions such as future values, present values, and payment are used to analyze loans and investments |
| logical functions | may be used to display text or values if certain conditions exist |
