| A | B |
|---|
| This feature of Excel improves the accuracy of calculations made in the worksheet by waiting until you’re ready to make the calculations. | Delayed calculation |
| This feature may be used to add a long column of numbers. | AutoSum |
| This feature of Excel may be used to determine the sum of a group of numbers without inserting a formula into the worksheet. | AutoCalculation |
| You may display formulas in the worksheet rather than displaying this. | Formula results |
| This is an example of an operator in a worksheet formula. | The plus sign (+) |
| Once you have keyed a formula, you can enter it by clicking on this on the formula bar. | The check mark button |
| In a formula containing this type of cell reference, the operators stay the same, but the cell references change when the formula is copied. | Relative |
| With this method of cell referencing, you click the cell instead of keying a cell reference. | Point-and-click |
| When you choose to display formulas in cells instead of values, those cells that do not contain formulas are this. | Unchanged |
| You can change the type of calculations using options on this tab of the Options dialog box. | Calculation |
| This operation will be performed first in a formula that does not contain parentheses. | Exponentiation |
| This type of cell reference does not change when it is moved or copied to a new cell. | Absolute |
| This type of cell reference adjusts to its new location when copied or moved. | Relative |
| This type of cell reference contains both relative and absolute references. | Mixed |
| Exponentiation (^), positive (+) or negative (-), multiplication (*) or division (/), and addition (+) or subtraction (-). | Order of evaluation |
| This type of function is the most frequently used type of function formula. | Sum |
| This menu contains the command to open the Options dialog box in which you can define features, including those applied to formulas. | Tools |
| Press this on the keyboard to switch between displaying formulas and displaying values. | Ctrl + ` |
| This sign in Excel represents the action exponentiation. | ^ |
