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;
19 Cards in this Set
- Front
- Back
|
(combine) data from more than one worksheet or workbook
|
consolidate
|
|
|
when a cell referance is made to another work sheet
|
3D refereance
|
|
|
If a excel worksheet is set up as a list, you can create an
|
outline
|
|
|
grand totals for groups of data according to the criteria you set
|
subtotals
|
|
|
sum or averagge
|
summary function
|
|
|
A set of values that excel saves that can be sub. in worksheet.
|
scenarios
|
|
|
forecasting
|
trendline
|
|
|
analyzing the super cells revenues
|
Poly nomial trendline
|
|
|
command that lets you find the value for a variable
|
goal seek
|
|
|
helpd solve certain criteria kinds of problems
|
solver
|
|
|
added together sum or average
|
summary function
|
|
|
can be subsittued in a worksheet
|
scenarios
|
|
|
grapgic representaion of trends in data
|
trendline
|
|
|
a curved line that is used when data fluctuates
|
polynomial trendline
|
|
|
a limit set on control the changes made to the cell
|
Constraints
|
|
|
interective table that quickly summarizes large amounts of data from a list or table
|
PivotTable
|
|
|
chart based on a pivotTable
|
PivotChart
|
|
|
guides you through steps to create a pivotTable and Chart
|
PivotTable and PivotChart Wizard
|
|
|
recalculate
|
reresh
|
