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;
20 Cards in this Set
- Front
- Back
|
cell style
|
a set of predefined formats you can apply to some of the worksheet data
|
|
|
filter
|
to screen for data matching specified criteria
|
|
|
freeze
|
to lock a row or column that names a function instead of using operators to calculate a formula
|
|
|
header row
|
column headings or feild names at the top of coumns in a data resource
|
|
|
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 panels
|
|
|
table style
|
a set of predesigned formats that you apply to all worksheets
|
|
|
argument
|
A value, a cell reference, a range, or text that acts as an operand in a function formula; it is enclosed in pararenthesis after the function name
|
|
|
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
|
|
|
mathmatical functions
|
perform calculations that you could do using a scientific calcualtor
|
|
|
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 mathmatical operation to perform with the operands
|
|
|
oreder of evaluation
|
the sequence used to calculate the value of a formula
|
|
|
relative cell references
|
cell references which will be adjusted reltive to formulas new location when a formula is copied or moved to a new location
|
|
|
statistical functions
|
functions that describe large quanities of data
|
