Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
21 Cards in this Set
- Front
- Back
|
absolute cell reference
|
A reference that does not change when the formula is copied or moved to a new location.
|
|
|
argument
|
A value, a cell reference, a range, or text that acts as an operand in function formula; it is enclosed in parentheses after the function name.
|
|
|
cell style
|
A set of predefined formats you can apply to some of the worksheet.
|
|
|
chart
|
A graphic representation of worksheet or table data.
|
|
|
complex formulas
|
Excel formulas containing more than one operator.
|
|
|
embedded chart
|
A chart created on the same sheet as the data used in the chart.
|
|
|
filter
|
To screen for data matching specified criteria.
|
|
|
formula
|
Equations using numbers and cell references to perform calculations such as addition, subtraction, multiplication, and division.
|
|
|
freeze
|
To lock a row or column to keep an area visible as you scroll through the worksheet.
|
|
|
function formula
|
A special formula that names a function instead of using operators to calculate a formula.
|
|
|
header row
|
Column headings or field names at the top of columns in a data source.
|
|
|
mathematical functions
|
Perform calculations that you could do using a scientific calculator.
|
|
|
mixed cell reference
|
A cell reference that contains both relative and absolute references.
|
|
|
operand
|
A number or cell reference.
|
|
|
operator
|
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.
|
|
|
relative cell references
|
Cell references which will be adjusted to the formula's new location when a formula is copied or moved to a new location.
|
|
|
sheet tab
|
A tab in the horizontal scroll bar to provide quick and easy access to a worksheet.
|
|
|
split
|
To divide a worksheet into two panes.
|
|
|
statistical functions
|
Functions that describe large quantities of data.
|
|
|
table split
|
To split a table.
|
