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;
15 Cards in this Set
- Front
- Back
|
Consolidate
|
to combine data from more than one worksheet or workbook.
|
|
|
3-D Reference
|
A cell reference that is made to another worksheet.
|
|
|
Outline
|
Grouping of your data.
|
|
|
Subtotals
|
Calculate subtotals and grand totals for groups of data according to the criteria you set.
|
|
|
Summary Function
|
Sum or Average
|
|
|
Scenarios
|
A set of values that Excel saves and can be substituted in your worksheet.
|
|
|
Trendline
|
A graphic representation of trends in data.
|
|
|
Polynomial Trendline
|
Cell revenues; a curved line that is used when data fluctuates.
|
|
|
Goal Seek
|
A command that lets you and the value for a variable that will make the result of a formula equal to a specified value.
|
|
|
Solver
|
Helps you solve certain kinds of problems involving changing multiple cells.
|
|
|
Contstraints
|
A limit set to control the changes made to the cell.
|
|
|
PivotTable
|
An interactive table that quickly summarizes large amounts of data from a list or table.
|
|
|
PivotChart
|
A chart based on a PivotTable. Uses the same data to display it in different ways. Can be manipulated.
|
|
|
PivotTable and PivotChart Wizard
|
Guides you through the steps to create a PivotTable or PivotChart.
|
|
|
Refresh
|
Recalculate
|
