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
|
cell style
|
a set of predefined formats you can apply to some of the worksheet data.
|
|
|
filter
|
a process that can be used to cut down on or eliminate most junk mail.
|
|
|
freeze
|
to lock a row or column to keep an area visible as you scroll through the worksheet.
|
|
|
header row
|
column headings or field names at the top of columns in a data source.
|
|
|
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.
|
|
|
table style
|
a set of predefined formats that you can apply to all the worksheet data.
|
|
|
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 a function formula.
|
|
|
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.
|
|
|
formula
|
equations using numbers and cell references to perform calculations such as addition, subtraction, multiplication, and division.
|
|
|
function formula
|
a special formula that names a function instead of using operators to calculate a formula.
|
|
|
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 relative to the formulas new location when a formula is copied or moved to a new location.
|
|
|
statistical functions
|
functions that describe large quantities of data.
|
