Chapter 4

Question 0

Define operand

Answer 0

A constant (text or number) or cell reference used in a formula

Question 1

Define formula

Answer 1

The equation used to calculate values based on numbers entered in cells

Question 2

Define operator

Answer 2

A symbol that indicates the type of calculation to perform on operands. (+-^*/)

Question 3

Define order of evaluation

Answer 3

The sequence used to calculate the value of a formula

Question 4

What is the order of evaluation

Answer 4

1. Contents with parenthesis
2. Exponents ^ , positive or negative, multiplication * or division /, addition + or subtraction -.
3. if 2 or more operators have the same order of evaluation, the equation is evaluated from left to right.

Question 5

What is a relative cell reference ?

Answer 5

A cell reference that adjusts to its new location when copied or moved to another cell

Question 6

What is an absolute cell reference ?

Answer 6

An absolute cell reference does not change when copied or moved to a new cell.

Question 7

How to create an absolute cell reference ?

Answer 7

To create an absolute cell reference you insert a dollar sign $ before he column letter and before the row number
Ex: =$A$3+$A$4

Question 8

What is a mixed cell reference ?

Answer 8

Cell references that contain both relative and absolute references.

When formula with mixed cell references are copied or moved to another cell, the row or column references preceded by a $ so not change; the row or column reference not preceded by $ adjust to match the cell to which they are moved.
Ex: =A$3+ A$4 would become
=B$3+B$4

Question 9

What is the purpose of manual calculation?

Answer 9

Manual calculation lets you determine when excel calculates the formulas