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.