Lesson 19:Creating Formulas and Charting Data

Question 1

Absolute Cell Reference

Answer 1

A reference that does not change when the formula is copioed or move to a new location

Question 2

Arguement

Answer 2

A value, a cell reference, a range, or a text that acts as an operand in a function formula; it is enclosed in parentheses after the function name

Question 3

Chart

Answer 3

A graphic reperesentation of worksheet or table data

Question 4

Complex Formulas

Answer 4

Excel formulas containing more than one operator

Question 5

Embedded Chart

Answer 5

A chart created on the same sheet as the data used in the chart

Question 6

Formula

Answer 6

Equations using numbers and cell references to perform calculations such as additoin, subtraction, multiplication, and division

Question 7

Function Formula

Answer 7

A special formula that names a function instead of using operators to calculate a formula

Question 8

Mathematical Functions

Answer 8

perform calculations that you could do using a scientific calculator

Question 9

Mixed Cell Reference

Answer 9

A cell reference that contains both relative and absolute reference

Question 10

Operand

Answer 10

A number or cell reference

Question 11

Operator

Answer 11

A symbol that indicates the mathematical operation to perform with the operand

Question 12

Order of Evaluation

Answer 12

The sequence used to calculate the value of a formula

Question 13

Relative Cell References

Answer 13

Cell references which will be adjusted relative to the formula’s new location when a formula is copied or moved to a new location

Question 14

Statistical Functions

Answer 14

Functions that describe large quantities of data.