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