Excel 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
Absolute cell reference
Absolute cell reference -Does not change when copied or moved to a new cell.
Relative cell reference
Adjusts to its new location when copied or moved
Mixed cell reference
Cell references that contain both relative and absolute references
true
In a formula multiplication is performed before subtraction
Manual calculation
Lets you determine when Excel calculates the formulas.
Sum button
Makes adding long columns or rows of numbers simple to do.
Formula
The equation used to calculate values in a cell.
Order of evaluation
The sequence used to calculate the value of a formula
=B$3+B4
Write an example of a formula that contains mixed cell reference
Manual
_________ calculations let you control when Excel calculates the formulas in a worksheet
Point and click
allows you to point and click each cell in a formula rather than typing cell references
true
an absolute reference does not change when the formula is copied or moved into another cell
False
an operator is a constant or cell reference used in cell formulas
Status Bar
default summary calculations for selected range appear in the_____
When entering the formula instead of typing what's in the so you can click the cell
explain how to enter the formula =C4+B5+D2 in cell D3 using the point and click method
Status bar
how do you display formulas instead of formulas results in a worksheet
false
in a formula , operations within parenthesis are performed after operations outside parentheses
exponents
in a worksheet formula , which operator has the highest priority in the order of evaluation
true
manual calculations lets you control when Excel calculates formula results
Relative
the cell reference D4 is an example of a ______ cell reference
Formula
the equation used to calculate values based on number entered in cells is called _________
Order of evaluation
the sequence used to calculate the value of a formula is called the _________
absolute cell reference
what type of cell reference will not adjust to its new location when it is copied or moved to another cell
