Excel review lesson 4
An operator is a constant or cell reference used in formulas
FALSE
Write an example of a formula that contains a mixed cell reference
=B$3+B$4
Operand
A constant ( text or number ) or cell reference used in a formula
Operator
A symbol that indicates the type of calculation to perform on operands
What type of cell reference will not adjust to its new location when it is copied or moved to another cell
Absolute Cell references
Relative cell Reference
Adjusts to its new location when copied or moved
Point-and-Click method
Allows you to point and click each cell in a formula rather then typing cell references
Absolute Cell reference
An absolute cell reference remains the same when the formula is copied
Formula
An equation that's performs mathematical calculation on values in a worksheet
Mixed Cell reference
Call reference that contains both relative and absolute references
In a worksheet formula, which operator has the highest priority in the order of evaluation
Exponential
In a formula, operations within parentheses are performed after operations outside Parentheses
FALSE
The equation used to calculate values based on numbers entered in cells is called a(n) _____
Formula
Sum Button
Makes adding long columns or rows of numbers simple to do
______ calculation lets you control when excel calculates the formula in a worksheet
Manual
Manual calculation
Manual calculation lets you determine when excel calculates the formulas
The sequence used to calculate the value of a formula is called the ____
Order of evaluations
The cell reference D4 is and example of a(n) ___ cell reference
Relative
Default summary calculation for a selected range appear in the _____
Status Bar
How do you display formulas instead of formula results in a worksheet
Status bar
An absolute reference does not change when the formula is copied or moved to another cell
TRUE
In a formula, multiplication is performed before subtraction
TRUE
Manila Calculation lets you control when excel calculates formula results
TRUE
Order of evaluation
The sequence used to calculate the value of a formula