Lesson 20 Vocab

Mixed cell reference

A cell reference that contains both relative and absolute references is called a mixed cell reference.

Function formula

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

Sparkline

A sparkline is a tiny chart embedded in a cell.

Embedded chart

An embedded chart is a chart created on the same sheet as the data used in the chart.

Relative cell references

By default, when you create formulas, the cell references are formatted as relative cell references, which means when the formula is copied to another cell, the cell references will be adjusted relative to the formula's new location.

Complex formulas

Formulas containing more than one operator are called complex formulas.

Mathematical functions

Mathematical functions perform calculations that you could perform using a scientific calculator.

Statistical functions

Statistical functions are functions that describe large quantities of data.

Argument

The argument is a value, a cell reference, a range, or text that acts as an operand in a function formula, and it is enclosed in parentheses after the function name.

Formula

The equation used to calculate values in a cell is known as a formula.

Operand

The operand is a number or cell reference.

Operator

The operator is a symbol that indicates the mathematical operation to perform with the operands.

Order of evaluation

The sequence used to calculate the value of a formula is called the order of evaluation.

Absolute cell reference

To create this formula, you format an absolute cell reference.

Chart

To draw conclusions from the worksheet data, you can translate the data to a chart, which is a graphic representation of your worksheet data.