Term | Definition |
Absolute cell reference: | Does not change when copied or moved to a new cell (EX 90). |
Formula: | The equation used to calculate values in a cell (EX 85). |
Manual calculation: | Lets you determine when Excel calculates the formulas (EX 97). |
Mixed cell reference: | Cell references that contain both relative and absolute references (EX 91). |
Operand: | A constant (text or number) or cell reference used in a formula (EX 86). |
Operator: | A symbol that indicates the type of calculation to perform on operands (EX 86). |
Order of evaluation: | The sequence used to calculate the value of a formula (EX 87). |
Point-and-click method: | Allows you to point and click each cell in a formula rather than typing cell
references (EX 92). |
Relative cell reference: | Adjusts to its new location when copied or moved (EX 90). |
Sum button: | Makes adding long columns or rows of numbers simple to do (EX 93). |
True | An operand is a constant or cell reference used in formulas. |
False | In a formula, subtraction is performed before multiplication. |
False | In a formula, operations within parentheses are performed after operations outside parentheses. |
True | An absolute reference does not change if the formula is copied or moved. |
True | Manual calculations lets you determine when Excel calculates formula results. |
How do you enter the formula =C4+B5+D2 using the point-and-click method. | To insert the formula =C4+B5+D2 using the point-and-click method, type =, click cell C4, type +, click cell B5, type +, click cell D2, and then press the Enter key. |
How do you display formulas in the worksheet cells ratherr than the formula results? | 5. You can display formulas instead of formula results by clicking the Show Formulas button in the Formula Auditing group on the Formulas tab. You can also press the Ctrl+` keys. |